Benchmarking MySQL and NoSQL Databases on Egovbench Application
DOI:
https://doi.org/10.30818/jitu.2.1.2080Abstract
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.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-
Downloads
Published
Issue
Section
License
The proposed policy for journals that offer open access
Authors who publish with this journal agree to the following terms:
- Copyright on any article is retained by the author(s).
- Author grant the journal, right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work’s authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal’s published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
- The article and any associated published material is distributed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License
