Database Tuning in Hospital Applications Using Table Indexing and Query Optimization

Authors

  • Samidi Samidi Fakultas Teknologi Informasi, Universitas Budi Luhur, Indonesia
  • Daniel Iskandar Fakultas Teknologi Informasi, Universitas Budi Luhur, Indonesia
  • Muhamad Fachruroji Fakultas Teknologi Informasi, Universitas Budi Luhur, Indonesia
  • Wahyu Adi Septyo Wibowo Fakultas Teknologi Informasi, Universitas Budi Luhur, Indonesia
  • Afifah Khaerani A Fakultas Teknologi Informasi, Universitas Budi Luhur, Indonesia

DOI:

https://doi.org/10.31004/jptam.v6i1.3241

Keywords:

RDBMS, Penyetelan Basis Data, Pengindeksan Tabel, Pengoptimalan Kueri, SQL

Abstract

RDBMS telah menjadi kebutuhan mendasar bagi semua perusahaan dan diharapkan dapat memberikan informasi secara tepat waktu, akurat, dan andal. Sayangnya, pertumbuhan data yang eksponensial biasanya menyebabkan masalah kinerja database, yaitu waktu eksekusi kueri yang lambat sebagai salah satu masalah utama. Pilihan untuk meningkatkan kinerja database adalah dengan melakukan penyetelan database menggunakan pengindeksan tabel dan optimisasi kueri. Tujuan utama dari penelitian eksperimental ini adalah untuk membandingkan waktu respon database sebelum dan sesudah proses tuning database. Kami memilih Sistem Informasi Rumah Sakit sebagai objek kami di mana kami mengerjakan jutaan data dan mengeksekusi beberapa kueri SQL untuk melihat perbedaan waktu respons sebelum dan sesudah penyetelan basis data. Akibatnya, untuk mengambil 1.039.852 baris data Patient Care dibutuhkan 743 detik sebelum penyetelan, dan hanya 46 detik setelah penyetelan.

References

Moura et. al, “Management and Ownership: A Data Strategy in the Industry 4.0 Context”, Conference Paper, BDIOT, 2019.

Khushairi et. al, “Database Performance Tuning Methods for Manufacturing Execution System”, World Applied Sciences Journal 30, 2014.

Bajaj, PL, “A Survey on Query Performance Optimization by Index Recommendation”, International Journal of Computer Applications (0975 – 8887) Volume 113 – No. 19, 2015.

Rahman, et. Al, “Analyze Database Optimization Techniques“, IJCSNS International Journal of Computer Science and Network Security, VOL.10 No.8, 2010.

Hidayat et. al, “Genetic Algorithm for Relational Database Optimization in Reducing Query Execution Time”, Scientific Journal of Informatics Vol. 5, No. 1, 2018.

Bachav et. al, “Query Optimization for Databases in Cloud Environment: A Survey”, International Journal of Database Theory and Application, Vol.10, No.6 ISSN: 2005-4270 IJDTA, 2017.

Abbas et. al, “Query Performance in Database Operation”, PS-FTSM-2020-045, 2020.

Elmasri and Navathe, “Fundamental Of Database Systems Seventh Edition”, ISBN-13: 978-0-13-397077-7, Pearson, 2016.

Patel and Patel, “A Review Paper on Different Approaches for Query Optimization using Schema Object base View”, International Journal of Computer Applications (0975 – 8887) Volume 114 – No. 4, 2015.

Balasubramanian et. al, “Dynamic Integrated Database Index Management”, United States Patent No. 8489565 B2, 2013.

Guzun, “Hybrid Query Optimization For Hard-To-Compress Bit-Vectors”, The VLDB Journal DOI: 10.1007/s00778-015-0419-9, 2016.

Medina et. al, “Evaluation of indexing strategies for possibilistic queries based on indexing techniques available in traditional RDBMS”, International Journal of Intelligent Systems Vol. 31 Issue 12, 2016.

Yu et. al, “Two Birds, One Stone: A Fast, yet Lightweight, Indexing Scheme for Modern Database Systems”, Proceedings of the VLDB Endowment, Vol. 10, No. 4, 2016.

Chopade et. al, “MongoDB Indexing For Performance Improvement”, ICT System and Sustainability Proceedings of ICT4SD Vol. 1, 2019.

Ortiz et. al, “Learning State Representations for Query Optimization with Deep Reinforcement Learning”, DEEM 18, https://doi.org/10.1145/3209889.3209890, 2018.

Moszi et. al, “A Session-based Approach to Autonomous Database Tuning”, Acta Polytechnica Hungarica, Vol. 17, No. 1, 2020.

Fuentes et. al, “Database Tuning With Partial Indexes”, Conference Paper SBBD 33rd, https://www.researchgate.net/publication/336497706_Database_Tuning_with_Partial_Indexes, 2018

Downloads

Published

28-02-2022

How to Cite

Samidi, S., Iskandar, D. ., Fachruroji, M. ., Septyo Wibowo, W. A. ., & Khaerani A, A. . (2022). Database Tuning in Hospital Applications Using Table Indexing and Query Optimization. Jurnal Pendidikan Tambusai, 6(1), 1960–1967. https://doi.org/10.31004/jptam.v6i1.3241

Issue

Vol. 6 No. 1 (2022): April 2022

Section

Articles of Research

Citation Check

License

Copyright (c) 2022 Samidi Samidi, Daniel Iskandar, Muhamad Fachruroji, Wahyu Adi Septyo Wibowo, Afifah Khaerani A

Creative Commons License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Authors who publish with this journal agree to the following terms:

  • Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work’s authorship and initial publication in this journal.
  • Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal’s published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
  • Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).