Home // DBKDA 2014, The Sixth International Conference on Advances in Databases, Knowledge, and Data Applications // View article

An Object-oriented Approach for Extending MySQL into NoSQL with Enhanced Performance and Scalability

Authors:
Hyunju Shim
YoungChul Sohn
YoulWoong Sung
Yonggoo Kang
Iljoo Kim
Ohoon Kwon

Keywords: performance, robustness, scalability, object-relational mapping, distributed query processing

Abstract:
An Object-oriented Approach for Extending MySQL into NoSQL with Enhanced Performance and Scalability Abstract: This paper introduces an object-oriented approach for extending MySQL into NoSQL for enhanced performance and scalability. Main goal of our system is to provide a database management system that handles a huge amount of data in a fast and reliable way. In designing database management API, we adopted an Object-Relational Mapping (ORM) approach that provides a mapping between objects in user code with tables in database. This mapping allows developers to handle data in database tables by manipulating the objects that are mapped to. To provide a flexible and efficient distribution of large amount of data among multiple database nodes, we designed a unique ID scheme which is optimized for the primary key lookup operations by encoding the shard key information into its data ID. In this way, queries predicated with data ID can always go directly to the target node no matter which key the data is distributed on. With our ORM approach, query predicates are composed as a combination of Java method calls and no query parsing is necessary at database layer. Having no query to be parsed, we leveraged HandlerSocket, a MySQL plugin, which bypasses the upper layer of MySQL hence improving overall performance. To evaluate our system, we performed a set of tests and proved that our system provides improved performance and linear scalability compared to the traditional MySQL approach.

Pages: 111 to 117

Copyright: Copyright (c) IARIA, 2014

Publication date: April 20, 2014

Published in: conference

ISSN: 2308-4332

ISBN: 978-1-61208-334-6

Location: Chamonix, France

Dates: from April 20, 2014 to April 24, 2014