Komparasi Database Performance Tuning Melalui Metode Object Relation Mapping pada SQL Server
DOI:
https://doi.org/10.52436/1.jpti.537Keywords:
database performance tuning, indexing, object relational mapping, table partitioningAbstract
Pada proses database performance tuning terdapat beberapa permasalahan apabila diterapkan pada sistem berbasis object relational mapping (ORM) yang menyebabkan efektivitas peningkatan kinerja tidak seefektif sebagaimana diterapkan pada relational database konvensional. Metode indexing dan table partitioning akan diterapkan dalam proses database performance tuning untuk mengukur efektivitas peningkatan kinerja database. Hasil penelitian menunjukkan bahwa database performance tuning dengan kombinasi metode indexing dan table partitioning berhasil meningkatkan kinerja database dengan peningkatan kinerja yang paling tinggi.
Downloads
References
S. J. Kamatkar, A. Kamble, A. Viloria, L. Hernández-Fernandez, and E. G. Cali, “Database Performance Tuning and Query Optimization,” in Data Mining and Big Data, Y. Tan, Y. Shi, and Q. Tang, Eds., Cham: Springer International Publishing, 2018, pp. 3–11. doi: 10.1007/978-3-319-93803-5_1.
D. Colley and C. Stanier, “Identifying New Directions in Database Performance Tuning,” Procedia Comput Sci, vol. 121, pp. 260–265, Jan. 2017, doi: 10.1016/J.PROCS.2017.11.036.
Samidi, Y. Virmansyah, R. Y. Suladi, and A. B. Lesmana, “Optimasi Database dengan Metode Index dan Partisi Tabel Database Postgresql pada Aplikasi E-Commerce. Studi pada Aplikasi Tokopintar,” Jurnal Pendidikan Tambusai, vol. 6, no. 1, pp. 2094–2102, 2022.
Samidi, D. Iskandar, M. Fachruroji, W. A. S. Wibowo, and A. A. Khaerani, “Database Tuning in Hospital Applications Using Table Indexing and Query Optimization,” Jurnal Pendidikan Tambusai, vol. 6, no. 1, pp. 1960–1967, 2022.
Samidi, D. Andharu, F. Widyarto, S. S. Syahdinullah, and S. Y. W. Eka, “Optimasi Database Menggunakan SQL Kueri Klausa IN dan EXIST pada Database Oracle 12c. Studi Kasus pada Aplikasi di Badan Nasional Pencarian dan Pertolongan (BASARNAS),” Jurnal Pendidikan Tambusai, vol. 6, no. 1, pp. 2297–2306, 2022.
K. Islam, K. Ahsan, S. Bari, M. Saeed, and S. A. Ali, “Huge and Real-Time Database Systems: A Comparative Study and Review for SQL Server 2016, Oracle 12c & MySQL 5.7 for Personal Computer,” Journal of Basic & Applied Sciences, vol. 13, pp. 481–490, Sep. 2017, doi: 10.6000/1927-5129.2017.13.79.
S. Samidi, R. Y. Suladi, and A. B. Lesmana, “Implementation of Database Distributed Sharding Horizontal Partition in MySQL. Case Study of Application of Food Serving On Kemkes,” Jurnal Sisfotek Global, vol. 12, no. 1, pp. 50–57, Mar. 2022, doi: 10.38101/sisfotek.v12i1.477.
G. Paludo Licks, J. Colleoni Couto, P. de Fátima Miehe, R. de Paris, D. Dubugras Ruiz, and F. Meneguzzi, “SmartIX: A database indexing agent based on reinforcement learning,” Applied Intelligence, vol. 50, no. 8, pp. 2575–2588, Aug. 2020, doi: 10.1007/s10489-020-01674-8.
A. Uzzaman, M. M. I. Jim, N. Nishat, and J. Nahar, “Optimizing SQL Databases for Big Data Workloads: Techniques and Best Practices,” Academic Journal on Business Administration, Innovation & Sustainability, vol. 4, no. 3, pp. 15–29, Jun. 2024, doi: 10.69593/ajbais.v4i3.78.
K. Mózsi and A. Kiss, “A Session-based Approach to Autonomous Database Tuning,” Acta Polytechnica Hungarica, vol. 17, no. 1, pp. 7–24, 2020, doi: 10.12700/APH.17.1.2020.1.1.
S. van Wouw, J. Viña, A. Iosup, and D. Epema, “An Empirical Performance Evaluation of Distributed SQL Query Engines,” in Proceedings of the 6th ACM/SPEC International Conference on Performance Engineering, New York, NY, USA: ACM, Jan. 2015, pp. 123–131. doi: 10.1145/2668930.2688053.
I. Šušter and T. Ranisavljevi?, “Optimization of MySQL Database,” Journal of Process Management and New Technologies, vol. 11, no. 1–2, pp. 141–151, Jun. 2023.
W. Khan, W. Ahmad, B. Luo, and E. Ahmed, “SQL Database with Physical Database Tuning Technique and NoSQL Graph Database Comparisons,” in Information Technology, Networking, Electronic and Automation Control Conference (ITNEC), IEEE, 2019.
R. Elmasri and S. B. Navathe, Fundamentals of Database Systems. Addison-Wesley, 2015.
S. Maesaroh, H. Gunawan, A. Lestari, M. S. A. Tsaurie, and M. Fauji, “Query Optimization In MySQL Database Using Index,” International Journal of Cyber and IT Service Management, vol. 2, no. 2, pp. 104–110, Mar. 2022, doi: 10.34306/ijcitsm.v2i2.84.
X. Zhou, C. Chai, G. Li, and J. Sun, “Database Meets Artificial Intelligence: A Survey,” IEEE Trans Knowl Data Eng, vol. 34, no. 3, pp. 1096–1116, Mar. 2022, doi: 10.1109/TKDE.2020.2994641.
M. Kvet and K. Matiasko, “Analysis of current trends in relational database indexing,” in 2020 International Conference on Smart Systems and Technologies (SST), IEEE, Oct. 2020, pp. 109–114. doi: 10.1109/SST49455.2020.9264034.
Z. Sadri, L. Gruenwald, and E. Lead, “DRLindex: Deep reinforcement learning index advisor for a cluster database,” in ACM International Conference Proceeding Series, Association for Computing Machinery, Aug. 2020. doi: 10.1145/3410566.3410603.
M. Valavala and W. Alhamdani, “Automatic Database Index Tuning Using Machine Learning,” in Proceedings of the 6th International Conference on Inventive Computation Technologies, ICICT 2021, Institute of Electrical and Electronics Engineers Inc., Jan. 2021, pp. 523–530. doi: 10.1109/ICICT50816.2021.9358646.
P. Bednarczuk, “Optimization in Very Large Databases by Partitioning Tables,” Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie ?rodowiska, vol. 10, no. 3, pp. 95–98, Sep. 2020, doi: 10.35784/iapgos.2056.
M. Olma, M. Karpathiotakis, I. Alagiannis, M. Athanassoulis, and A. Ailamaki, “Adaptive partitioning and indexing for in situ query processing,” in VLDB Journal, Springer, Jan. 2020, pp. 569–591. doi: 10.1007/s00778-019-00580-x.
R. Pamungkas, “Optimalisasi Query dalam Basis Data MySQL Menggunakan Index,” Journal of Computer, Information System, & Technology Management, vol. 1, no. 2, pp. 27–31, Apr. 2018.
