PERBANDINGAN PERFORMANSI ANTARA MONGODB DAN MARIADB
DOI:
https://doi.org/10.61805/fahma.v19i2.54Kata Kunci:
NoSQL, Response Time, Query, MongoDB, MariaDBAbstrak
Along with the use of information technology in almost all sectors of life, making databases has a very important role in being able to store and process large amounts of data effectively, and high performance is required when processing the database. The Nosql database is widely used in managing very large amounts of data besides that it is also an open source database, but so far many still use the mysql database which is an open source DBMS and has many communities. This paper will compare the performance between a relational database that stores structured data (Sql) and a database with a dynamic and unstructured schema (Nosql). Specifically the database being compared between MariaDB and MongoDB. An experiment will be carried out by performing a query insert, update, delete on the two databases, with the number of records of 500, 1000, 5000, 7500 and 10000, besides that, it is also tested for a select query without criteria, with 1 criterion and 2 criteria. And from the experiments conducted it can be concluded that for insert, update and delete queries on a single NoSQL table has a much better response time. Whereas the select query without NoSQL criteria also has a better response time, but to display all data with criteria, especially the two database criteria, the SQL version has a better response time than NoSQL.
Unduhan
Referensi
Connolly, Thomas dan Beg, Carolyn, 2010, Database Systems A Practical Approach to Design, Implementation, and Management, Ed. 5, Pearson Education, Boston
Donald, D., Chamberlin dan R.,F.,Boyce, 1974, SEQUEL : A Structured English query Language, Proceeding of the 1974 ACM SIGFIDET (SIGMO) Workshop on Data Description, Access and Control, Michigan, May.
Gunawan, Rohmat, 2018, Pengukuran Query Respon Time pada NoSQL Database Berbasis Document Stored, Jurnal Siliwangi Seri Sains dan Teknologi, vol. 4, hal 100-103.
Mohan, C., 2013, History Repeats ItSelf : Sensible and NonsenSQL Aspects of the NoSQL Hoopla, 16th International Conference on Extending Database Technology, Italy, March.
Junaidi, Apri, 2017, Studi Perbandingan Performansi antar MongoDB dan MySQL Menggunakan PHP dalam Lingkup Big Data, Seminar Nasional Teknologi Informasi dan Multimedia, ISSN:2302-3805, hal 2.2.49-2.2.53.
Bhaswara, F.A, Sarno, R, dan Sunaryono, D, 2017, Perbandingan Kemampuan Database NoSQL dan SQL dalam Kasus ERP Retail, Jurnal Teknik ITS, vol. 6, hal A510-A514.
Daroini, A., A., S., Yustanti, W., 2016, Perbandingan Penggunaan NoSQL MongoDB dan MySQL pada Basis Data Forum Komunikasi, Jurnal Manajemen Informatika, vol. 6, hal 134-142.
Silalahi, M., 2018, Perbandingan Performansi Database MongoDB dan MySQL dalam Aplikasi Multimedia berbasis Web, Computer Based Information System Journal, vol 6, hal 63-78
Warman, 2018, Analisis Perbandingan Kinerja Query DBMS antara Mysql 5.7.16 dengan Mariadb 10.1, Jurnal Teknoif, Vol.6