Exploring the Effectiveness, Features, and Compatibility of MongoDB and MySQL: A Comprehensive Comparison of NoSQL and Relational Databases

CHELSEA MARCHELLE SOWANDI; IVANA LEONITA; STEVEN HARTANTO PANJI ARISAPUTRA; DAVID DAVID

doi:10.26760/mindjournal.v8i2.217-229

Exploring the Effectiveness, Features, and Compatibility of MongoDB and MySQL: A Comprehensive Comparison of NoSQL and Relational Databases

CHELSEA MARCHELLE SOWANDI, IVANA LEONITA, STEVEN HARTANTO PANJI ARISAPUTRA, DAVID DAVID

Sari

Abstrak

Di era digital ini, data menjadi aset yang sangat berharga bagi bisnis dan organisasi.Â Terdapat jenis database yang umum digunakan, yaitu Database Relasional dan Database NoSQL. Perbandingkan antara kedua jenis database tersebut dibahas melalui analisis perbedaan dan dampak praktisnya. Evaluasi terhadap kedua jenis database ini dilakukan untuk menentukan platform database terbaik yang sesuai dengan kebutuhan organisasi. Penelitian ini membahas perbandingan MongoDB dengan MySQL. Analisis, kelebihan, dan keterbatasan dari masing-masing jenis database ini, serta hal yang mempengaruhi pemilihan platform database dibahas pada penelitian ini. Dengan membandingkan fitur dan kasus penggunaan kedua database ini, diharapkan dapat memberikan wawasan berharga yang dapat membantu organisasi membuat keputusan yang tepat saat memilih platformÂ database.

Kata kunci: database, Database NoSQL, MongoDB, MySQL, platform database

AbstractIn today's digital age, data has become an essential asset for businesses and organizations. Databases are used to store, manage, and update information, providing reliable and organized data that can be accessed and analyzed as needed. There are several types of databases, including Relational Databases and NoSQL Databases. This paper compares the two types of databases, analyzing their differences and practical implications. We examine the aspects of both type of database to determine the best database platform for specific organizational needs. Specifically, we compare MongoDB, a popular NoSQL Database, with MySQL, a widely used Relational Database. Our analysis considers the strengths and limitations of each type of database, and how they impact the selection of a database platform. By comparing the features and use cases of these databases, we provide valuable insights that can help organizations make informed decisions when selecting a database platform.

Keywords: databases, NoSQL Databases, MongoDB, MySQL, database platform

Teks Lengkap:

PDF (English)

Referensi

Anju, R., & Swathi, B. P. (2017). MongoDB vs. Oracle: A comparative study using classification algorithms. 2016 IEEE International Conference on Computational Intelligence and Computing Research, ICCIC 2016, 2â€“5. https://doi.org/10.1109/ICCIC.2016.7919628

Boicea, A., Radulescu, F., & Agapin, L. I. (2012). MongoDB vs Oracle - Database comparison. Proceedings - 3rd International Conference on Emerging Intelligent Data and Web Technologies, EIDWT 2012, August, 330â€“335. https://doi.org/10.1109/EIDWT.2012.32

Celesti, A., Fazio, M., Romano, A., Bramanti, A., Bramanti, P., & Villari, M. (2018). An OAIS-based hospital information system on the cloud: Analysis of a NoSQL column-oriented approach. IEEE Journal of Biomedical and Health Informatics, 22(3), 1â€“7. https://doi.org/10.1109/JBHI.2017.2681126

ÄŒereÅ¡ÅˆÃ¡k, R., & Kvet, M. (2019). Comparison of query performance in relational a non-relation databases. Transportation Research Procedia, 40, 170â€“177. https://doi.org/10.1016/j.trpro.2019.07.027

Damodaran B, D., Salim, S., & Vargese, S. M. (2016). Performance Evaluation of MySQL and MongoDB Databases. International Journal on Cybernetics & Informatics, 5(2), 387â€“394. https://doi.org/10.5121/ijci.2016.5241

Eyada, M. M., Saber, W., El Genidy, M. M., & Amer, F. (2020). Performance Evaluation of IoT Data Management Using MongoDB Versus MySQL Databases in Different Cloud Environments. IEEE Access, 8, 110656â€“110668. https://doi.org/10.1109/ACCESS.2020.3002164

Faraj, A., Rashid, B., & Shareef, T. (2013). Comparative Study of Relational and Non-Relational Database Performances Using Oracle and MongoDB Systems. International Journal of Computer Engineering and Technology (IJCET), June 2016, 323â€“329.

Gupta, A., Tyagi, S., Panwar, N., Sachdeva, S., & Saxena, U. (2018). NoSQL databases: Critical analysis and comparison. 2017 International Conference on Computing and Communication Technologies for Smart Nation, IC3TSN 2017, 2017-Octob(October 2017), 293â€“299. https://doi.org/10.1109/IC3TSN.2017.8284494

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). https://doi.org/10.3390/bdcc6020049

Ilic, M., Lazar Kopanja, Zlatkovic, D., Trajkovic, M., & Curguz, D. (2021). Microsoft SQL Server and Oracle : Comparative Performance Analysis. The 7th International Conference Knowledge Management and Informatics VrnjaÄka, 1(June), 33â€“40.

Islam, K., Ahsan, K., Bari, S. A. K., Saeed, M., & Ali, S. A. (2017). Huge and Real-Time Database Systems: A Comparative Study and Review for SQL Server 2016, Oracle 12c & MySQL 5.7 for Personal Computer. Journal of Basic & Applied Sciences, 13(21), 481â€“490.

Jose, B., & Abraham, S. (2019). Performance analysis of NoSQL and relational databases with MongoDB and MySQL. Materials Today: Proceedings, 24, 2036â€“2043. https://doi.org/10.1016/j.matpr.2020.03.634

Keshavarz, S. (2021a). Analyzing Performance Differences Between MySQL and MongoDB. March, 46. https://www.researchgate.net/publication/349764039_Analyzing_Performance_Differences_Between_MySQL_and_MongoDB

Mumtahana, H. A. (2022). Optimization of Transaction Database Design with MySQL and MongoDB. SinkrOn, 7(3), 883â€“890. https://doi.org/10.33395/sinkron.v7i3.11528

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

Sharma, V., & Dave, M. (2012). SQL and NoSQL Databases. International Journal of Advanced Research in Computer Science and Software Engineering Research, II(8), 19â€“27.

Susanti, E., Sholeh, M., Yuliana, R., & Rachmawati. (1994). Konversi Data dari Database Relational MySQL ke Database NoSQL MongoDB (Studi Kasus pada Sistem Informasi UMKM). Jurnal Gaung Informatika, 135(4).

DOI: https://doi.org/10.26760/mindjournal.v8i2.217-229