Improved Information Retrieval Performance on SQL Database Using Data Adapter

2nd International Conference on Innovation in Engineering and Vocational Education

工业技术;教育

Husni, M.^1 ; Djanali, S.^1 ; Ciptaningtyas, H.T.^1 ; Wicaksana, I.G.N.A.^1

Department of Informatics, Faculty of Information Technology, Institut Teknologi Sepuluh Nopember, Indonesia^1

关键词: Big data applications;    Exponential growth;    Information retrieval performance;    Memory resources;    Number of datum;    Relational Database;    Synchronization process;    WEB application;   

Others  :  https://iopscience.iop.org/article/10.1088/1757-899X/306/1/012078/pdf
DOI  :  10.1088/1757-899X/306/1/012078

来源: IOP

【 摘 要 】

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.