Perbandingan Kecepatan Pencarian Data SQL dan NOSQL

Muhammad Firdaus Abdi; Agung Susanto; Kusnawi Kusnawi

doi:10.36294/jurti.v5i1.1696

Perbandingan Kecepatan Pencarian Data SQL dan NOSQL

Muhammad Firdaus Abdi, Agung Susanto, Kusnawi Kusnawi

Abstract

Abstract - The development of database technology requires a quality of data, where a database is needed in various applications that support the performance of a company or office, so that the database is said to be good, it must be managed appropriately, efficiently in terms of speed or time. For this reason, the use of this database is still the prima donna used in running a system. In this study, testing a database to determine the query response time from a Structured Query Language (SQL) and NoSQL (Non-SQL) system which was tested with a sales or sales database where the data records were (100,500,1000,100000, 2279879). Testing focused on data search includes queries displaying all data, one of the data, AND, OR, AND and OR, Order By (asc), and Order By (desc). The purpose of this research is to produce a comparative analysis of the query response time between SQL and NoSQL so that it is known which database is superior in a data search for use. The results of this study indicate that NoSQL is superior in searching for a database, but there are certain NoSQL searches that are slower than the SQL search process.

Keywords - NoSQL, SQL, Response Time, Search Data, Comparison Base Data.

Abstrak – Perkembangan teknologi basis data dituntut sebuah kualitas sebuah data, yang dimana sebuah basis data sangat diperlukan di berbagai aplikasi penunjang kinerja sebuah perusahaan atau kantor, untuk itu agar basis data dikatakan baik harus dikelola dengan tepat, efesien dari segi kecepatan atau waktu. Untuk itu penggunaan basis data ini masih menjadi primadona digunakan dalam menjalankan sebuah sistem. Pada penelitian ini melakukan pengujian sebuah database untuk menentukan waktu query response dari sebuah sistem Structured Query Language (SQL) dan NoSQL(Non SQL) yang diujikan dengan database sales atau penjualan yang dimana record data (100,500,1000,100000, 2279879). Pengujian terfokus pada pencarian data meliputi query tampil seluruh data, salah satu data, AND, OR, AND dan OR, Order By (asc), dan Order By (desc). Tujuan penelitian ini menghasilkan analisis perbandingan waktu query response antara SQL dan NoSQL agar diketahui basis data yang lebih unggul dalam sebuah pencarian data untuk digunakan. Hasil penelitian ini didapat bahwa NoSQL lebih unggul dalam pencarian sebuah datam namun ada pencarian tertentu NoSQL lebih lambat dari proses pencarian SQL.

Kata Kunci - NoSQL,SQL, Response Time,Pecarian Data,Perbandingan Basis Data.

Keywords

NoSQL,SQL, Response Time,Pecarian Data,Perbandingan Basis Data

Full Text:

PDF

References

A. AAN SAID DAROINI, “PERBANDINGAN PENGGUNAAN NOSQL MONGODB DAN MYSQL PADA BASIS DATA FORUM KOMUNIKASI,” J. Manaj. Inform., 2016.

K. Agarwal, Sarthak and Rajan, “Analyzing the performance of NoSQL vs. SQL databases for Spatial and Aggregate queries,” Free Open Source Softw. Geospatial Conf. Proc., 2017, doi: https://doi.org/10.7275/R5736P26.

P. P. Srivastava, S. Goyal, and A. Kumar, “Analysis of various NoSql database,” 2016, doi: 10.1109/ICGCIoT.2015.7380523.

S. Venkatraman, K. F. S. Kaspi, and R. Venkatraman, “SQL Versus NoSQL Movement with Big Data Analytics,” Int. J. Inf. Technol. Comput. Sci., 2016, doi: 10.5815/ijitcs.2016.12.07.

Y. L. Choi, W. S. Jeon, and S. H. Yoon, “Improving database system performance by applying NoSQL,” J. Inf. Process. Syst., 2014, doi: 10.3745/JIPS.04.0006.

N. A. Rakhmawati, M. Zuhri, R. P. Wibowo, A. Romadhon, H. Ardiansyah, and O. Khoirul, “Benchmarking MySQL and NoSQL Databases on Egovbench Application,” J. Inf. Technol. Its Util., 2019, doi: 10.30818/jitu.2.1.2080.

C. Bazar, C., & Losif, “The Transition from RDBMS to NoSQL. A Comparative Analysis of Three Popular Non-Relational Solutions: Cassandra, MongoDB and Couchbase,” Database Syst. J., 2014.

A. K. Suman and M. Gyanchandani, “Improved Performance of Hive Using Index-Based Operation on Big Data,” in 2018 Second International Conference on Intelligent Computing and Control Systems (ICICCS), 2018, pp. 1974–1978, doi: 10.1109/ICCONS.2018.8663095.

A. Parssian, W. Yeoh, and M. S. Ee, “Quality-Based SQL: Specifying Information Quality in Relational Database Queries,” Computer (Long. Beach. Calif)., vol. 48, no. 9, pp. 69–74, 2015, doi: 10.1109/MC.2015.264.

S. S. Nyati, S. Pawar, and R. Ingle, “Performance evaluation of unstructured NoSQL data over distributed framework,” 2013, doi: 10.1109/ICACCI.2013.6637424.

M. Silalahi, “PERBANDINGAN PERFORMANSI DATABASE MONGODB DAN MYSQL DALAM APLIKASI FILE MULTIMEDIA BERBASIS WEB,” Comput. Based Inf. Syst. J., 2018, doi: 10.33884/cbis.v6i1.574.

J. S. Van Der Veen, B. Van Der Waaij, and R. J. Meijer, “Sensor data storage performance: SQL or NoSQL, physical or virtual,” 2012, doi: 10.1109/CLOUD.2012.18.

DOI: https://doi.org/10.36294/jurti.v5i1.1696