PERBANDINGAN PERFORMANSI ANTARA MONGODB DAN MARIADB

Penulis

  • Dibyo Sudarsono Magister Teknik Informatika Universitas AMIKOM Yogyakarta Penulis
  • Mutiara Dwi Anggraini Magister Teknik Informatika Universitas AMIKOM Yogyakarta Penulis
  • Christina Andriyani Magister Teknik Informatika Universitas AMIKOM Yogyakarta Penulis
  • Mukhadimah Magister Teknik Informatika Universitas AMIKOM Yogyakarta Penulis
  • Agun Nurul Widiyanto Magister Teknik Informatika Universitas AMIKOM Yogyakarta Penulis
  • Fahmi Ilmawan Magister Teknik Informatika Universitas AMIKOM Yogyakarta Penulis
  • Ema Utami Magister Teknik Informatika Universitas AMIKOM Yogyakarta Penulis

DOI:

https://doi.org/10.61805/fahma.v19i2.54

Kata Kunci:

NoSQL, Response Time, Query, MongoDB, MariaDB

Abstrak

 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

Data unduhan tidak tersedia.

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

Unduhan

Diterbitkan

03-06-2021

Terbitan

Bagian

Artikel

Cara Mengutip

PERBANDINGAN PERFORMANSI ANTARA MONGODB DAN MARIADB. (2021). Jurnal Informatika Komputer, Bisnis Dan Manajemen, 19(2), 1-11. https://doi.org/10.61805/fahma.v19i2.54

Artikel Serupa

1-10 dari 21

Anda juga bisa Mulai pencarian similarity tingkat lanjut untuk artikel ini.

Artikel paling banyak dibaca berdasarkan penulis yang sama