Analisis Perbandingan Unjuk Kerja Database SQL dan Database NoSQL Untuk Mendukung Era Big Data

Main Article Content

Ari Fadli
Mulki Indana Zulfa
Azis Wisnu Widhi Nugraha
Acep Taryana
Muhammad Syaiful Aliim

Keywords

Abstract

Recently, the development of data in the digital world has produced new challenges. The challenge is increasing number and complexity of data and variations in data (structured and unstructured). Conventional database management system (RDBMS) is not able to answer these challenges effectively because in RDBMS uses a related structured table approach to store information. Currently present, a database management system called NoSQL. This NoSQL system was introduced to provide quick scalability (amount and complexity) and unstructured data. In this study, we present the performance analysis of RDBMS and NoSQL database management systems in the case of increasing the number of data. We use the simple php page to test database systems, experiments are done with use four data sets of different sizes from academic information systems. The database NoSQL approach is used by Redis and the SQL database approach is used by MySQL. The results show that the noSql database has a execution time better than the MySQL database, there is an increase in the speed of the execution time by 87.58% in the create operation, 85.53% in the update operation, and in the delete operation by 86.40% and while in the read operation the increase in execution time speed is obtained by 57.09%, so that on average the Redis database has a show work better than the MySQL database at 79.15%..

Keywords : MySql Database, Redis Database, PHP Programming

 

Abstrak

Baru-baru ini, perkembangan data di dunia digital telah menghasilkan tantangan baru. Tantangannya adalah meningkatnya jumlah dan kompleksitas data dan variasi data (terstruktur dan tidak terstruktur). Sistem manajemen basis data konvensional (RDBMS) tidak dapat menjawab tantangan ini secara efektif karena dalam hal ini RDBMS menggunakan pendekatan tabel terstruktur sebagai konsep dalam menyimpan informasi. Saat ini, telah hadir sistem manajemen basis data yang disebut NoSQL, Sistem NoSQL memiliki kemampuan menangani data yang tidak terstruktur yang jumlah dan kompleksitas terus meningkat. Dalam penelitian ini, kami menyajikan hasil analisis perbandingan unjuk kerja Sistem Manajemen Basis Data konvensional (RDBMS) dengan NoSQL pada kemampuannya dalam menangani pertumbuhan data yang terus meningkat. Metode yang digunakan dalam melakukan analisis perbandingan unjuk kerja RDBMS dengan NoSQL adalah waktu eksekusi yang dibutuhkan untuk melakukan operasi dasar pada sistem basis data yaitu create, read, delete dan update. RDMBS yang digunakan pada penelitian kali ini adalah MySQL sedangkan pada sistem NoSQL digunakan oleh Redis Database. Hasil penelitian menunjukkan bahwa Redis Database memiliki waktu eksekusi yang lebih baik daripada MySQL Database, terdapat peningkatan kecepatan waktu eksekusi tersebut sebesar 87.58% pada operasi create, 85.53% pada operasi update, dan pada operasi delete sebesar 86.40% dan sedangkan pada operasi read penigkatan kecepatan waktu eksekusi yang diperoleh sebesar 57.09%, sehingga secara rata-rata database Redis memiliki unjuk kerja yang lebih baik dari database MySQL yaitu sebesar 79.15%.

Kata Kunci : MySql Database, Redis Database, Pemgoramaman PHP

References

N. Prokofyeva and V. Boltunova, “Analysis and Practical Application of PHP Frameworks in Development of Web Information Systems,” Procedia Comput. Sci., vol. 104, no. December 2016, pp. 51–56, 2016, doi: 10.1016/j.procs.2017.01.059.

A. Mishra, “Critical Comparison Of PHP And ASP . NET For Web Development,” Int. J. Sci. Technol. Res., vol. 3, no. 7, pp. 331–333, 2014.

W.-M. Chen and Y.-C. Chen, “Web design and implementation for remote control. In Intelligent Control and Automation (WCICA),” IEEE, p. 2012, 2012.

S. Gabarro, The Different Approaches of Web Programming. In Web Application Design and Implementation:Apache 2, PHP5, MySQL, JavaScript, and Linux/UNIX. 1st ed. 2007.

Fadli, A., Sugiyanto, G. Zulfa, M.I. "Upaya Mereduksi Jumlah Kecelakaan Lalu Lintas Melalui Penggunaan Sistem Informasi Geografis", Jurnal Warta LPM, 23(2) September 2020.

Fadli A., “Konsep Dasar In Memory Database,” pp. 1–6, 2019.

M. E. Davis and J. A. Phillips, Learning PHP & MySQL: Step-by-Step Guide to Creating DatabaseDriven Web Sites 2nd ed. O’REILLY, 2007.

H. Zhang, G. Chen, B. C. Ooi, K. L. Tan, and M. Zhang, “In-memory big data management and processing: A survey. IEEE Transactions on Knowledge and Data Engineering,” vol. 27, no. 7, pp. 1920–1948, 2015, doi: 10.1590/s1809-98232013000400007.

M. A. Mohamed, M. A. Mohamed, O. G. Altrafi, and M. O. Ismail, “Relational Vs. NoSQL databases: A survey,” Int. J. Comput. Inf. Technol., vol. 03, no. 03, pp. 2279–0764, 2014.

A. Fadli, M. I. Zulfa, and Y. Ramadhani, “Performance Comparison of Data Mining Classification Algorithms for Early Warning System of Students Graduation Timeliness,” J. Teknol. dan Sist. Komput., vol. 6, no. 4, p. 158, 2018, doi: 10.14710/jtsiskom.6.4.2018.158-163.

M. I. Zulfa, A. Fadli, and Y. Ramadhani, “Classification model for graduation on time study using data mining techniques with SVM algorithm,” AIP Conf. Proc., vol. 2094, 2019, doi: 10.1063/1.5097475.

V. D. Jogi and A. Sinha, “Performance evaluation of MySQL, Cassandra and HBase for heavy write operation.,” Recent Adv. Inf. Technol., p. 2016, 2016.

and J. A. L. Okman, N. Gal-Oz, Y. Gonen, E. Gudes, “Security issues in NoSQL databases,” Proc. 10th IEEE Int. Conf. Trust. Secur. Priv. Comput. Commun. Trust. 2011, 8th IEEE Int. Conf. Embed. Softw. Syst. ICESS 2011, 6th Int. Conf. FCST 2011, vol. 541–547, p. 2011, 2011.

S. Heripracoyo and K. R., “Big Data Analysis with MongoDB for Decision Support System,” TELKOMNIKA (Telecommunication Comput. Electron. Control., vol. 14, no. 3, 2016, doi: https://doi.org/10.3929/ethz-b-000238666.

A. B. M. Moniruzzaman and S. A. Hossain, “NoSQL Database: New Era of Databases for Big data Analytics - Classification, Characteristics and Comparison,” vol. 6, no. 4, pp. 1–13, 2013.

J. L. Carlson, Redis in Action. 2013.

R. Lubis and A. Sagala, “Multithread performance on a single thread in-memory database.,” in Information Technology and Electrical Engineering (ICITEE), 7th International Conference on IEEE., 2015, pp. 571–575.

E. Sahafizadeh and M. A. Nematbakhsh, “A Survey on Security Issues in Big Data and NoSQL,” Adv. Comput. Sci. an Int. J., vol. 4, no. 4, pp. 68–72, 2015.

Y. Li and S. Manoharan, “A performance comparison of SQL and NoSQL databases,” IEEE Pacific RIM Conf. Commun. Comput. Signal Process. - Proc., no. November, pp. 15–19, 2013, doi: 10.1109/PACRIM.2013.6625441.

A. Raje and A. Jagdale, “Sql Vs NoSql : NewSql The Solution For Big Data,” pp. 45–51.

C. Győrödi, R. Gyorodi, G. Pecherle, and A. Olah, “A Comparative Study: MongoDB vs. MySQL Energetical sustainability of a local community using air flows View project Convergence of university practical training for integration with success in the labor market View project,” no. June, 2015, doi: 10.13140/RG.2.1.1226.7685.

V. N. Gudivada, D. Rao, and V. V. Raghavan, “NoSQL Systems for Big Data Management,” 2014 IEEE World Congr. Serv., pp. 190–197, 2014, doi: 10.1109/SERVICES.2014.42.

T. Patel and T. Eltaieb, “Relational Database vs NoSQL,” J. Multidiscip. Eng. Sci. Technol., vol. 2, no. 4, pp. 3159–40, 2015.

Bakar, M. A., Ismail, S., Idris, S., & Shukur, Z. seMeja API Design Based on CRUD+N Concept. Selangor, Malaysia, 2015.