Performance evaluation of relational embedded databases: an empirical study

  • Hassan B. Hassan Software Engineering and Embedded Systems (SEES) Research Group, University of Duhok, Duhok, Kurdistan Region, Iraq https://orcid.org/0000-0003-2141-0909
  • Qusay I. Sarham Software Engineering and Embedded Systems (SEES) Research Group, Department of Computer Science, College of Science, University of Duhok, Duhok, Kurdistan Region, Iraq https://orcid.org/0000-0001-8708-0063

Resumen

Introduction: With the rapid deployment of embedded databases across a wide range of embedded devices such as mobile devices, Internet of Things (IoT) devices, etc., the amount of data generated by such devices is also growing increasingly. For this reason, the performance is considered as a crucial criterion in the process of selecting the most suitable embedded database management system to be used to store/retrieve data of these devices. Currently, many embedded databases are available to be utilized in this context. Materials and Methods: In this paper, four popular open-source relational embedded databases; namely, H2, HSQLDB, Apache Derby, and SQLite have been compared experimentally with each other to evaluate their operational performance in terms of creating database tables, retrieving data, inserting data, updating data, deleting data. Results and Discussion: The experimental results of this paper have been illustrated in Table 4. Conclusions: The experimental results and analysis showed that HSQLDB outperformed other databases in most evaluation scenarios.

Citas

Mingyao X, Xiongfei L. Embedded database query optimization algorithm based on particle swarm optimization. Proceedings of the 7th International Conference on Measuring Technology and Mechatronics Automation; 2015 June 13-14; Nanchang, China; IEEE; 2015. p. 429-432.

Oh G, Kim S, Lee SW, Moon B. SQLite optimization with phase change memory for mobile applications. Proc. VLDB Endow. 2015; 8(12): 1454-65.

Kang W, Son SH, Stankovic JA. Design, implementation, and evaluation of a QoS-aware real-time embedded database. IEEE Transactions on Computers. 2012; 61(1): 45-59.

H2 Database Engine (redirect) [Internet]. H2database.com. [cited 1 October 2018]. Available from: https://www.h2database.com

HSQLDB [Internet]. Hsqldb.org. [cited 1 October 2018]. Available from: http://hsqldb.org/

Apache Derby [Internet]. Db.apache.org. [cited 1 October 2018]. Available from: https://db.apache.org/derby/

SQLite Home Page [Internet]. Sqlite.org. [cited 1 October 2018]. Available from: https://sqlite.org/index.html

Ray S, Simion B, Brown AD. Jackpine: A benchmark to evaluate spatial database performance. Proceedings of the 27th International Conference on Data Engineering; 2011 April 11-16; Hannover, Germany; IEEE; 2011. p. 1139-1150.

Kabakus AT, Kara R. A performance evaluation of in-memory databases. Journal of King Saud University-Computer and Information Sciences. 2017; 29(4): 520-5.

Song W, Tao T, Gao T. Performance optimization for flash memory database in mobile embedded system. Proceedings of the 2nd International Workshop on Education Technology and Computer Science; 2010 March 6-7; Wuhan, China; IEEE; 2010. p. 35-39.

Olson MA. Selecting and implementing an embedded database system. Computer. 2000; 33(9): 27-34.

Li Y, Manoharan S. A performance comparison of SQL and NoSQL databases. Proceedings of the IEEE Pacific Rim Conference on Communications, Computers and Signal Processing (PACRIM); 2013 August 27-29; Victoria, BC, Canada; IEEE; 2013. p. 15-19.

Patchigolla VN, Springer J, Lutes K. Embedded database management performance. Proceedings of the 8th International Conference on Information Technology: New Generations; 2011 April 11-13; Las Vegas, NV, USA; IEEE; 2011. p. 998-1001.

Tonghui Q, Yang Q, Limin C, Zili S, Xiaowu C, Dehua L. The design of embedded database management system for mobile computing. Proceedings of the International Conference on Computer Science and Information Processing (CSIP); 2012 August 24-26; Xi'an, Shaanxi, China; IEEE; 2012. p. 1454-1457.

Batra R. A Primer on SQL. 3rd ed. Leanpub; 2015.

Sarhan QI, Gawdan IS. Web Applications and Web Services: A Comparative Study. Science Journal of University of Zakho. 2018; 6(1): 35-41.

Sarhan QI. Internet of things: a survey of challenges and issues. International Journal of Internet of Things and Cyber-Assurance. 2018; 1(1): 40-75.

Sarhan QI, Gawdan IS. Java Message Service Based Performance Comparison of Apache ActiveMQ and Apache Apollo Brokers. Science Journal of University of Zakho. 2017; 5(4): 307-12.

Publicado
2018-12-28
Cómo citar
Hassan, H. B., & Sarham, Q. I. (2018). Performance evaluation of relational embedded databases: an empirical study. INNOVACIENCIA, 6(1), 1-8. https://doi.org/10.15649/2346075X.468
Sección
Artículo de investigación científica y tecnológica