Optimization of Transaction Database Design with MySQL and MongoDB

Authors

  • Hani Atun Mumtahana Universitas PGRI Madiun, Indonesia

DOI:

10.33395/sinkron.v7i3.11528

Keywords:

database, MySQL, MongoDB, NoSQL, RDBMS

Abstract

Database is one of the most important parts in running an application. Databases can be used to store data. However, in running an application, the selection of an appropriate database needs to be considered, so that the resulting information can be in accordance with user needs. In developing applications, more people use RDBMS design which has a very structured nature, but technological developments have introduced NoSQL as a database development method. In this research, MySQL and MongoDB databases will be tested in transaction processing. The tests carried out include comparisons of database designs, comparisons of defining table structures, comparisons of running time in the insert, update, delete, search processes. The test results show that MongoDB has a simpler table description structure than MySQL. The results of the running time test show that MongoDB has a faster running time difference than MySQL. In the insert process there is a time difference of 0.005625 sec, update 0.001688 sec, delete 0.00075 sec and search 0.006875 sec.

GS Cited Analysis

Downloads

Download data is not yet available.

References

Bhaswara, F. A., Sarno, R., & Sunaryono, D. (2017). Perbandingan Kemampuan Database NoSQL dan SQL dalam Kasus ERP Retail. Jurnal Teknik ITS, 6(2), 510–514. https://doi.org/10.12962/j23373539.v6i2.24031

Connolly, T., & Begg, C. (2015). Database Systems.

Deari, R., Zenuni, X., Ajdari, J., Ismaili, F., & Raufi, B. (2018). Analysis and comparision of document-based databases with relational databases: MongoDB vs MySQL. 2018 International Conference on Information Technologies, InfoTech 2018 - Proceedings, September, 20–21. https://doi.org/10.1109/InfoTech.2018.8510719

Győrödi, C. A., Dumşe-Burescu, D. V., Zmaranda, D. R., & Győrödi, R. Ş. (2022). A Comparative Study of MongoDB and Document-Based MySQL for Big Data Application Data Management. Big Data and Cognitive Computing, 6(2), 49. https://doi.org/10.3390/bdcc6020049

Halimi, A., Sudarmanto, A., Utami, E., & Kusnawi. (2021). ANALISIS PERBANDINGAN KINERJA WAKTU RESPON MYSQL 8.0 DAN NOSQL MONGODB MENGUNAKAN RESTAPI NODEJS PADA STUDI KASUS KELAS ONLINE. Informatika Wicida, 10(1), 26–33.

Heal. (2016). Perkembangan Database – Heal ur program. Syifasalsabyla.Wordpress.Com.

Masa Depan Teknologi Basis Data | Hypernet. (2018). Hypernet.Co.Id.

Moniruzzaman, A. B. M., & Hossain, S. A. (2013). NoSQL Database: New Era of Databases for Big data Analytics - Classification, Characteristics and Comparison.

Mumtahana, H. A. (2021). Basis Data (Teori dan Praktek dengan Query SQL). In Unipma Pers (Vol. 1). https://www.academia.edu/8558159/Basis_Data

Nahrun, H., Kurniadi, W., & Kasma, S. (2017). OPTIMASI JOIN QUERY PADA BASIS DATA (STUDI KASUS : BASIS DATA SISTEM INFORMASI MANAJEMEN UNIVERSITAS COKROAMINOTO PALOPO). PROSIDING SEMANTIK 2017, 209–215.

Nance, C., Losser, T., Iype, R., & Harmon, G. (2013). NOSQL VS RDBMS-WHY THERE IS ROOM FOR BOTH. Proceedings of the Southern Association for Information System Conference, 111–116.

Palanisamy, S., & Suvithavani, P. (2020). A survey on RDBMS and NoSQL Databases MySQL vs MongoDB. 2020 International Conference on Computer Communication and Informatics, ICCCI 2020. https://doi.org/10.1109/ICCCI48352.2020.9104047

Putra, R. A., Alauddin, M. F., Alam, I. N., & Yaqin, M. A. (2020). Pengembangan Arsitektur Data Sistem Informasi Sekolah. Jurasik (Jurnal Riset Sistem Informasi Dan Teknik Informatika), 5(2), 175. https://doi.org/10.30645/jurasik.v5i2.203

Ramzan, S., Bajwa, I. S., Ramzan, B., & Anwar, W. (2019). Intelligent Data Engineering for Migration to NoSQL Based Secure Environments. IEEE Access. https://doi.org/10.1109/ACCESS.2019.2916912

Raut Professor, A. B. (2017). NOSQL Database and Its Comparison with RDBMS. International Journal of Computational Intelligence Research, 13(7), 1645–1651. http://www.ripublication.com

Susena, E., Utami, E., & Sunyoto, A. (2015). PERENCANAAN STRATEGIS SISTEM INFORMASI SMART CAMPUS UNTUK MENINGKATKAN PELAYANAN DI POLITEKNIK INDONUSA SURAKARTA. In Jurnal Sainstech Politeknik Indonusa Surakarta (Vol. 1).

Susilo, G. (2017). KEAMANAN BASIS DATA PADA SISTEM INFORMASI DI ERA GLOBAL. JURNAL TRANSFORMASI, 12(2).

Downloads


Crossmark Updates

How to Cite

Mumtahana, H. A. . (2022). Optimization of Transaction Database Design with MySQL and MongoDB. Sinkron : Jurnal Dan Penelitian Teknik Informatika, 6(3), 883-890. https://doi.org/10.33395/sinkron.v7i3.11528

Issue

Vol. 6 No. 3 (2022): Article Research Volume 6 Number 3, July 2022

Section

Articles

License

Copyright (c) 2022 Hani Atun Mumtahana

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Crossref
Scopus
Google Scholar
Europe PMC