Improved Information Retrieval Performance on SQL Database Using Data Adapter

M. Husni*, S. Djanali, H. T. Ciptaningtyas, I. G.N.A. Wicaksana

*Corresponding author for this work

Research output: Contribution to journalConference articlepeer-review


The NoSQL databases, short for Not Only SQL, are increasingly being used as the number of big data applications increases. Most systems still use relational databases (RDBs), but as the number of data increases each year, the system handles big data with NoSQL databases to analyze and access data more quickly. NoSQL emerged as a result of the exponential growth of the internet and the development of web applications. The query syntax in the NoSQL database differs from the SQL database, therefore requiring code changes in the application. Data adapter allow applications to not change their SQL query syntax. Data adapters provide methods that can synchronize SQL databases with NotSQL databases. In addition, the data adapter provides an interface which is application can access to run SQL queries. Hence, this research applied data adapter system to synchronize data between MySQL database and Apache HBase using direct access query approach, where system allows application to accept query while synchronization process in progress. From the test performed using data adapter, the results obtained that the data adapter can synchronize between SQL databases, MySQL, and NoSQL database, Apache HBase. This system spends the percentage of memory resources in the range of 40% to 60%, and the percentage of processor moving from 10% to 90%. In addition, from this system also obtained the performance of database NoSQL better than SQL database.

Original languageEnglish
Article number012078
JournalIOP Conference Series: Materials Science and Engineering
Issue number1
Publication statusPublished - 22 Feb 2018
Event2nd International Conference on Innovation in Engineering and Vocational Education, ICIEVE 2017 - Manado, North Sulawesi, Indonesia
Duration: 25 Oct 201726 Oct 2017


Dive into the research topics of 'Improved Information Retrieval Performance on SQL Database Using Data Adapter'. Together they form a unique fingerprint.

Cite this