Analisis Perbandingan Performansi Waktu Respons Kueri antara MySQL PHP 7.2.27 dan NoSQL MongoDB

Olivia Maria Inacio Tavares; Sartje Mala Rangkoly; Sarah Bunda Desy Bawan; Ema Utami; Muhammad Syukri Mustafa

doi:10.36294/jurti.v4i2.1695

Analisis Perbandingan Performansi Waktu Respons Kueri antara MySQL PHP 7.2.27 dan NoSQL MongoDB

Olivia Maria Inacio Tavares, Sartje Mala Rangkoly, Sarah Bunda Desy Bawan, Ema Utami, Muhammad Syukri Mustafa

Abstract

Abstract – Currently now, every function of the governmental and private agencies are required to manage the system work properly, effectively, and certainly efficient in terms of both time and system flexibility. Not a few have used the use of basic management data to help maximize the work system that is being run. This research will be carried out by examining the performance when answering queries between 2 commonly used management database systems, namely the My Structured Query Language (MySQL) relational database and Not-Only SQL (NoSQL) MongoDB non-relational database tested on the Aspiration and Information Service System of Oebufu Village (SELMA) with the number of data records (50, 100, 500, 1000, 5000, 10000, 100000). The examiner is carried out on the Data Manipulation Language (DML) query, which is inserting, update, delete, and select functions in adding, modifying, and displaying data in the database. Testing is also carried out on the agreement function, namely Counting (COUNT), Total in 1 table (SUM), Average (AVG )functions as well as the AND OR liaison operator as well as testing data import and export. The research aims to provide the results of a performance comparison analysis between MySQL and MongoDB NoSQL query respond database to find out which one is more good for use. The results can be proven that the two databases have different speeds in response performance comparisons in each model test, where NoSQL MongoDB is proven to be superior in every transaction tested model, starting from DML queries and function aggregate testing, import-export of data tables, and intermediate operator function, but weak in comparing select queries to display data with a runtime difference of 1.95.

Keywords: Database, Query Respond Time, MySQL, NoSQL, MongoDB.

Abstrak - Saat ini, setiap fungsi kerja instansi kepemerintahan maupun swasta dituntut untuk dapat mengelola sistem kerja secara tepat, efektif dan tentunya efisien baik dari segi waktu maupun flexibilitas sistem. Tidak sedikit yang telah menggunakan pemanfaatan manajemen basis data dalam membantu memaksimalkan sistem kerja yang tengah dijalankan. Penelitian ini akan dilakukan pengujian kinerja waktu respond query diantara 2 sistem manajemen basis data yang telah umum digunakan yaitu database relasional My Structured Query Language (MySQL) dan database non-relasional Not-Only SQL (NoSQL) MongoDB yang diujikan pada Sistem Layanan Aspirasi dan Informasi Kelurahan Oebufu (SELMA) dengan banyak record data (50, 100, 500, 1000, 5000, 10000, 100000). Adapun pengujian dilakukan pada query Data Manipulation Language (DML) yaitu pada fungsi insert, update, delete dan select dalam menambah, mengubah, menghapus serta menampilkan data pada database. Pengujian juga dilakukan terhadap agregat fuction yaitu pada fungsi Counting (COUNT), Total dalam 1 tabel (SUM), Average (AVG) juga pada operator penghubung AND OR serta pengujian import dan export data. Penelitian bertujuan memberikan hasil analisis perbandingan kinerja waktu respond query diantara MySQL dan NoSQL MongoDB untuk mengetahui basis data mana yang lebih unggul untuk digunakan. Hasilnya dapat dibuktikan bahwa kedua database tersebut memiliki kecepatan waktu yang berbeda dalam perbandingan kinerja respon kueri pada setiap model pengujian, dimana NoSQL MongoDB terbukti lebih unggul, mulai dari pengujian query DML, pengujian agregat fuction, impor-export data serta fungsi operator penghubung, namun lemah dalam pemrosesan query select untuk menampilkan data dengan jumlah selisih waktu respon 1,95s.

Kata kunci: Basis Data, Query Respond Time, MySQL, NoSQL, MongoDB

Keywords

Database, Query Respond Time, MySQL, NoSQL, MongoDB

Full Text:

PDF

References

O. M. I Tavares, “Analisis dan Perancangan Layanan Aspirasi dan Informasi Pada Kelurahan Oebufu,” Jurnal Teknologi Terpadu (JTT), vol. 5, pp. 2477-0043, 2019.

F Febryan, 2019, “Aplikasi Pengukur Tingkat Efektifitas Kerusakan Baja Jadi Menggunakan Metode Naïve Bayes,” Doctoral dissertation, Universitas Buddhi Dharma.

A. M. Bhugul, “Comparative Study of SQL & NOSQL Databases,” Int. J. Sci. Res. Dev, vol. 3, no. 2, pp. 1496–1498, 2015.

D. Damodaran, B. Salim, S. Vargese, S. Marium, “Performance Evaluation of MySQL and MongoDB Databases,” International Journal on Cybernetics & Informatics (IJCI), vol, 5 no. 2, pp. 10.5121, 2016.

Junaidi. A. “Studi Perbandingan Performansi Antara MongoDB dan MySQL Dalam Lingkungan Big Data,” In Annual Research Seminar (ARS), vol. 2, no. 1, pp. 460-465. 2017.

Silalahi. M, “Perbandingan Performansi Database Mongodb Dan Mysql Dalam Aplikasi File Multimedia Berbasis Web,” Computer Based Information System Journal, vol. 6 no. pp. 2337-8794, 2018.

Bhaswara, F. Anugrah, S. Riyanarto S. Dwo, “Perbandingan Kemampuan Database NoSQL dan SQL dalam Kasus ERP Retail,” Jurnal Teknik (ITS), vol 6 no. 2, pp. A511-A514, 2017.

A. S. Daroini, Akhmad, “Perbandingan Penggunaan Nosql Mongodb Dan Mysql Pada Basis Data Forum Komunikasi,”. Jurnal Manajemen Informatika, vol 6 no.1, pp. 134-142. 2017.

E. Sutanta, “Basis Data dalam Tinjauan Konseptual”, CV: Andi Offset, Yogyakarta. 2011.

C. Thomas, B. Carolyn, “Database Systems A Practical Approach to Design, Implementation and Management” Fifth Edition: Pearson Education, Boston. 2010.

Saputra A, “Manajemen Basis Data Mysql Pada Situs FTP Lapan Bandung,” Berita Dirgantara, vol 13 no 4, pp. 155-162, 2012.

Komputer W, “Panduan Belajar MySQL Database Server,” Mediakita, Jakarta. 2010.

Priyanto R, “Belajar Sendiri: Menguasai MySQL 5, Elex Media Komputindo, Jakarta, 2013.

Tambunan, D. D, 2016, “Perbandingan Analisis Aplikasi Database NoSQL Redis dan SQL MySQL,” Doctoral dissertation, Universitas Widyatama.

M. Milan, D. Dalibor, P. Ivana, “Example of Iot Platform Usage for Wireless Video Surveillance With Support of NoSQL And Cloud Systems,” On Proceedings Of The 6th International Conference Applied Internet And Information Technologies, pp. 9989-870-75-6, 2016.

Y. Li & S. Manoharan, A Performance Comparison of SQL and NoSQL Databases. In 2013 IEEE Pacific Rim Conference on Communications, Computers and Signal Processing (PACRIM), pp. 15 19, 2013.

Győrödi. C, Győrödi. R, Pecherle. G, Olah A. A Comparative Study: MongoDB vs. MySQL, In 2015 13th The International Conference on Engineering of Modern Electric Systems (EMES) (pp. 1-6), IEEE, 2015 l., vol. 3, no. 1, p. 73, 2017.

DOI: https://doi.org/10.36294/jurti.v4i2.1695