PERBANDINGAN PERFORMA RESPON WAKTU KUERI MySQL, PostgreSQL, dan MongoDB
Abstract
Teknologi telah mempengaruhi digitalisasi pada fungsi pekerjaan pada berbagai instansi. Pekerjaan dalam setiap fungsi kerja pada instansi dapat secara mudah dilakukan dengan adanya teknologi. Penggunaan teknologi berupa aplikasi membutuhkan sistem database untuk menyimpan data-data dan informasi pada suatu instansi. DBMS pada dasarnya terbagi menjadi 2 jenis yaitu DBMS relasional dan non-relasional. Contoh dari DBMS relasional adalah MySQL dan PostgreSQL, sedangkan DBMS non-relasional adalah MongoDB. Penelitian ini mengukur waktu yang diperlukan setiap DBMS dalam mengeksekusi query. Penelitian ini melakukan eksekusi pada berbagai skenario query, yaitu INSERT (create), SELECT (read), UPDATE (update), DELETE (delete), SUM, dan COUNT. Dataset yang digunakan dalam penelitian ini berasal dari open data website kaggle yaitu data tentang permainan catur yang terdiri dari 16 kolom dan 20.058 baris data. Hasil dari penelitian ini yaitu PostgreSQL yang paling cepat waktu respon eksekusi query dibanding DBMS lain.
References
V. Ardiyansyah, S. Budiman, and F. Fadhila, “A Analisis Performa Kecepatan MySQL dan NoSQL Pada Sistem Operasi Windows dan Linux,” Jnanaloka, pp. 21–26, 2021, doi: 10.36802/jnanaloka.2021.v2-no1-21-26.
G. Kiraz and C. Toğay, “IoT Data Storage: Relational & Non-Relational Database Management Systems Performance Comparison,” 34. TBD Natl. Informatics Symp., pp. 48–52, 2017.
M. Silalahi, “Perbandingan Performansi Database Mongodb Dan Mysql Dalam Aplikasi File Multimedia Berbasis Web,” Comput. Based Inf. Syst. J., vol. 6, no. 1, p. 63, 2018, doi: 10.33884/cbis.v6i1.574.
M. S. O.M.I Tavares., Rangkoly S.M., Sarah B. D., Utami Ema., Mustafa, “Analisis Perbandingan Performansi Waktu Respons Kueri,” J. Teknol. Inf., vol. 4, no. 2, pp. 303–313, 2020.
B. M. Klimek and M. Skublewska-paszkowska, “Comparison of the performance of relational databases PostgreSQL and MySQL for desktop application Porównanie wydajności relacyjnych baz danych PostgreSQL oraz MySQL dla aplikacji desktopowej,” vol. 18, no. January, pp. 61–66, 2021.
M. Radoev, “A Comparison between Characteristics of NoSQL Databases and Traditional Databases,” Comput. Sci. Inf. Technol., vol. 5, no. 5, pp. 149–153, 2017, doi: 10.13189/csit.2017.050501.
J. Y. Seo, D. W. Lee, and H. M. Lee, “Performance comparison of CRUD operations in IoT based big data computing,” Int. J. Adv. Sci. Eng. Inf. Technol., vol. 7, no. 5, pp. 1765–1770, 2017, doi: 10.18517/ijaseit.7.5.2674.
M. S. Mahmud, J. Z. Huang, S. Salloum, T. Z. Emara, and K. Sadatdiynov, “A survey of data partitioning and sampling methods to support big data analysis,” Big Data Min. Anal., vol. 3, no. 2, pp. 85–101, 2020, doi: 10.26599/BDMA.2019.9020015.
S. Patel, S. Kumar, S. Katiyar, R. Shanmugam, and R. Chaudhary, “EasyChair Preprint MONGODB VS MYSQL: A Comparative Study of MongoDB and MySQL Based on Their Performance,” 2020.
R. Panche, B. Ilijoski, and B. Tojtovska, “Comparing Databases for Inserting and Querying,” Fac. Comput. Sci. Eng., pp. 7–8, 2019.
C. Martinez-Millana, A. Martinez-Millana, C. Fernandez-Llatas, B. V. Martinez, and V. T. Salcedo, “Comparing data base engines for building big data analytics in obesity detection,” Proc. - IEEE Symp. Comput. Med. Syst., vol. 2019-June, pp. 208–211, 2019, doi: 10.1109/CBMS.2019.00050.
M. M. Patil, A. Hanni, C. H. Tejeshwar, and P. Patil, “A qualitative analysis of the performance of MongoDB vs MySQL database based on insertion and retriewal operations using a web/android application to explore load balancing-Sharding in MongoDB and its advantages,” Proc. Int. Conf. IoT Soc. Mobile, Anal. Cloud, I-SMAC 2017, pp. 325–330, 2017, doi: 10.1109/I-SMAC.2017.8058365.
S. Chakraborty, S. Paul, and K. M. Azharul Hasan, “Performance Comparison for Data Retrieval from NoSQL and SQL Databases: A Case Study for COVID-19 Genome Sequence Dataset,” ICREST 2021 - 2nd Int. Conf. Robot. Electr. Signal Process. Tech., pp. 324–328, 2021, doi: 10.1109/ICREST51555.2021.9331044.
M. M. Eyada, W. Saber, M. M. El Genidy, and F. Amer, “Performance Evaluation of IoT Data Management Using MongoDB Versus MySQL Databases in Different Cloud Environments,” IEEE Access, vol. 8, pp. 110656–110668, 2020, doi: 10.1109/ACCESS.2020.3002164.
W. Khan, W. Ahmad, B. Luo, and E. Ahmed, “SQL database with physical database tuning technique and NoSQL graph database comparisons,” Proc. 2019 IEEE 3rd Inf. Technol. Networking, Electron. Autom. Control Conf. ITNEC 2019, no. Itnec, pp. 110–116, 2019, doi: 10.1109/ITNEC.2019.8729264.
Full Text: Vol. 15 No. 1. pp 39-48
Refbacks
- There are currently no refbacks.
