Benchmarking MYSQL and NOSQL database on Egovbench application

Nur, Aini Rakhmawati and Muhammad, Zuhri and Radityo, Prasetianto Wibowo and Anwar, Romadhon and Herdy, Ardiansyah and Olive, Khoirul (2019) Benchmarking MYSQL and NOSQL database on Egovbench application. Journal of Information Technology and Its Utilization, 2 (1): 4. ISSN e-ISSN 2654-802X

[thumbnail of 2_1_2019_18-23_2654-802X-4.pdf]

Download (309kB) | Preview


Egovbench application monitors websites or social media of Indonesia local governments daily. The process of crawling done by Egovbench produces extensive data, which reduced performance in the 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.

Item Type: Article
Uncontrolled Keywords: Benchmark, Database, Crawling, E-government
Subjects: Computers, Control & Information Theory
Depositing User: - siti Elly
Date Deposited: 08 Dec 2022 11:58
Last Modified: 08 Dec 2022 11:58

Actions (login required)

View Item
View Item