ANALISIS PERBANDINGAN PERFORMA DATABASE SQL DB ORACLE DENGAN NOSQL DB MONGODB
Keywords:
Performance, SQLDB, NoSQLDB, Oracle, MongoDBAbstract
Databases have become an essential component of data management systems. In the ever-evolving information age, information and technology professionals are faced with the question of choosing a database that suits their diverse business and application needs. DBMS is divided into two types, namely relational database (SQL DB) and non-relational database (NoSQL DB). This research uses Oracle as a relational database and MongoDB as a non-relational database. The mechanism of data processing and storage is the difference between SQL DB and NoSQL DB. To find out the differences, especially in the query response from both, testing is needed. The database uses the gravity_book database from the cust_order table with a total data of 7550 rows and consists of 5 columns. Testing is done by applying four DML command operations in order to access and manipulate data from the cust_order table, namely by SELECT (reading data), UPDATE (updating data), INSERT (adding data), DELETE (deleting data) by limiting the number of different data records (750, 1500, 2550, 3000). This research aims to analyze the performance comparison between SQL DB Oracle and NoSQL DB MongoDB from the resulting query speed. The results show that the fastest response time for all test query commands is Oracle, while MongoDB ranks second after Oracle.
Downloads
References
DB-Engines Ranking. (2025, 10 8). Retrieved from DB-ENGINES: https://db-engines.com/en/ranking
Fadli, A., Zulfa, M. I., Nugraha, A. W., Taryana, A., & Aliim, M. S. (2020). Analisis Perbandingan Unjuk Kerja Database SQL dan Database NoSQL Untuk Mendukung Era Big Data. Jurnal Nasional Teknik Elektro.
Hartanto, B., Ardiansyah, A., & Kurniasih, M. (2024). PENGENALAN DATABASE NOSQL DAN PERBANDINGANNYA DENGAN DATABASE RELASIONAL. IPSIKOM .
Hartono, N., & Masyhur, Z. (2023). Optimizing transaction data performance in database management systems. Matrix : Jurnal Manajemen Teknologi Dan Informatika.
Maukar, A. L., Marisa, F., Vitianingsih, A. V., & Puspitarini, E. W. (2022). MODEL QUERY REALTIME DATABASE. President University.
Okman, L., Gal-Oz, N., Gonen, Y., Gudes, E., & Abramov, J. (2011). Security Issues in NoSQL Databases. 2011IEEE 10th International Conference on Trust.
Selviana, R., & Roji, M. F. (2023). SISTEM BASIS DATA PART 1. Tahta Media.
Tavares, Inacio, O. M., Rangkoly, S. M., & Sarah Bunda Desy Bawan, E. U. (2020). Analisis Perbandingan Performansi Waktu Respons Kueri antara MySQL PHP 7.2. 27 dan NoSQL MongoDB. Jurnal Teknologi Informasi .
Zhang, H., Chen, G., Ooi, B. C., Tan, K.-L., & Zhang, M. (2015). In-Memory Big Data Management and Processing: A Survey. IEEE Transactions on Knowledge and Data Engineering.
