Benchmarking MySQL and NoSQL Databases on Egovbench Application

Nur Aini Rakhmawati, Muhammad Zuhri, Radityo Prasetianto Wibowo, Anwar Romadhon, Herdy Ardiansyah, Olive Khoirul

Abstract

E-Government is a result of technological advances in the government field. E-government assessment is needed to encourage the development of e-government in a better direction. The e-Government assessment can be measured using the Egovbench application. Egovbench performs crawling to obtain information from related websites or social media. The process of crawling done by Egovbench produces extensive data, which reduced performance in data processing. Therefore, there is a need for a database solution that has the best performance such as high processing speed and small database size. This study examined the comparison between relational databases and non-relational databases based on selected metrics to obtain the most suitable database solution for Egovbench. The results show that the MySQL database has the advantage of complex query processing and the use of the database with the smallest storage space. MongoDB database has the advantage of low data transfer volumes. Couchbase database has the advantage of short and straightforward query processing with a high number. The evaluation results show that MySQL is more suitable for Egovbench needs, which is the best response time and query per second. MySQL outperformed the other two databases on backup and storage file sizes testing.

Full Text:

PDF

References

Shaqiri, B.A. Impact of Information Technology and Internet in Businesses. (2015) Academic Journal of Business, Administration, Law and Social Sciences Vol 1 No 1

Fang, J., Wu, J., & Tian, W. (2017). On the Relationship between Internet and Traditional Communication Industry, 1–6.

Bughin et. al.. The impact of Internet technologies: Search. McKinsey Company .July 2011

Asosiasi Penyelenggara Jasa Internet Indonesia. Penetrasi & Perilaku Pengguna Internet Indonesia. Asosiasi Penyelenggara Jasa Internet Indonesia (APJII), Nov 2016.

Almarabeh.T. AbuAli (2010). A General Framework for E-Government: Definition Maturity Challenges, Opportunities, and Success. European Journal of Scientific Research ISSN 1450-216X Vol.39 No.1 (2010), pp.29-42

Fang, Z. (2002) E-Government in Digital Era: Concept, Practice, and Development

Laboratorium ADDI ITS. Egov Bench [Online] Available: http://egovbench.addi.is.its.ac.id

Liao, Y. T., Zhou, J., Lu, C. H., Chen, S. C., Hsu, C. H., Chen, W., … Chung, Y. C. (2016). Data adapter for querying and transformation between SQL and NoSQL database. Future Generation Computer Systems, 65, 111–121.

González-Aparicio, M. T., Younas, M., Tuya, J., & Casado, R. (2018). Testing of transactional services in NoSQL key-value databases. Future Generation Computer Systems, 80, 384–399.

C. Győrödi, R. Győrödi, G. Pecherle, A. Olah, (2015). A comparative study: MongoDB vs. MySQL", 13th International Conference on Engineering of Modern Electric Systems (EMES), Oradea, Romania, pag. 1-6, ISBN 978-1-4799-7650-8.

Organização das Nações unidas. (2014). E-Government Survey: e-Government for the Future We Want. United Nations. https://doi.org/10.1016/S1369-7021(02)00629-6

Yunhua Gu, Shu Shen, and Guansheng Zheng. Application of nosql database in web crawling. International Journal of Digital Content Technology and its Applications, 5(6):261–266, 2011.

Datastax. (2013). Benchmarking Top NoSQL Databases, (February), 11. Retrieved from http://www.datastax.com/wp-content/uploads/2013/02/WP-Benchmarking-Top-NoSQL-Databases.pdf

Majkic, Z. (2014). Intensional RDB Manifesto: a Unifying NewSQL Model for Flexible Big Data, 29. Retrieved from http://arxiv.org/abs/1403.0017

Gupta, S., & Narsimha, G. (2017). Efficient Query Analysis and Performance Evaluation of the NoSQL Data Store for Big Data. In Proceedings of the First International Conference on Computational Intelligence and Informatics (pp. 549-558). Springer Singapore.

Robert M Fifer. Cost benchmarking functions in the value chain. Planning Review, 17(3):18–19, 1989.

Cudr´e-Mauroux1, P., Enchev1, I., Fundatureanu2, S., Groth2, P., Haque3, A., Harth4, A., … and Marcin Wylot1. (n.d.). NoSQL database for RDF: An Empirical Evaluation, 310–311. Retrieved from http://ribs.csres.utexas.edu/nosqlrdf/nosqlrdf_iswc2013.pdf

Lourenço, J. R., Cabral, B., Carreiro, P., Vieira, M., & Bernardino, J. (2015). Choosing the right NoSQL database for the job: a quality attribute evaluation. Journal of Big Data, 2(1), 1–26. https://doi.org/10.1186/s40537-015-0025-




DOI: http://dx.doi.org/10.30818/jitu.2.1.2080

Refbacks

  • There are currently no refbacks.


Copyright (c) 2019 Journal of Information Technology and Its Utilization