ANALYSIS OF QUERY RESTRUCTURIZATION MODELS IN OPTIMIZING DATA EXECUTION RESPONSE TIME ON MYSQL PHP 7.2.27 RELATIONAL DATABASES
-
Olivia Maria Inacio Tavares(1*)
Universitas AMIKOM Yogyakarta
-
Sartje Mala Rangkoly(2)
Universitas AMIKOM Yogyakarta
-
Sarah Bunda Desi Bawan(3)
Universitas AMIKOM Yogyakarta
-
Khifni Beyk Ahmad(4)
Universitas AMIKOM Yogyakarta
-
Ema Utami(5)
Universitas AMIKOM Yogyakarta
-
Muhammad Syukri Mustafa(6)
STMIK Dipanegara Makassar
(*) Corresponding Author
Abstract
Database is a collection of data that forming an information that useful for managers in an organization to facilitate data management process to become more effective and safely guarantee. A good database has fast and accurate response time performance in data execution processing. To manage the database, it requires a special language or query known as Structure Query Language (SQL). Increase need for fast information, will need a proper SQL as well. Therefore, through this research, a test analysis will be used to optimize the query response time in database management system commonly used today, namely the My Structured Query Language (MySQL) using PHP version of 7.2.27 relational database which will be tested on the Oebufu Village Aspiration and Information Service System (SELMA) that acessed from localhost panels with a total of 1000 test data records. The test is devoted to the effectiveness of using SELECT queries in calling and displaying data through restructuring the use of clauses. This study aims to help improve data management by providing the results of the comparative analysis of response times between the general query model and the optimized query results in order to determine the correct and efficient query structure. The result is proven by doing query optimization, it is found that the presentation of time optimization is significant, which is 78% much faster than the initial query, through this test it can be concluded that optimization plays an important role in streamlining the response time of database queries.
Downloads
References
O.M.I Tavares., Rangkoly S.M., Sarah B. D., Utami Ema., Mustafa, “Analisis Perbandingan Performansi Waktu Respons Kueri,” Jurnal Teknologi Informasi., vol. 4, no. 2, hal. 303–313, 2020, [Daring]. Tersedia pada: http://jurnal.una.ac.id/index.php/jurti/article/view/1695.
O.M.I. Tavares., “Analisis dan Perancangan Layanan Aspirasi Dan Informasi Pada Kelurahan Oebufu,” Jurnal Teknologi Terpadu., vol. 5, no. 2, hal. 303–313, 2019, [Daring]. Tersedia pada: https://journal.nurulfikri.ac.id/index.php/jtt/article/download/226/157/777.
R. Gunawan, “Pengukuran Query Respon Time pada NoSQL Database Berbasis Document Stored,” Jurnal Siliwangi., vol. 4, no. 2, hal. 100–103, 2018, [Daring]. Tersedia pada: http://jurnal.unsil.ac.id/index.php/jssainstek/article/view/609.
M. Saputro, “Pengoptimalisasian Query Pada Study Kasus Sistem Informasi Penjualan Kue Di Toko Wien,” STMIK AKAKOM Yogyakarta, vol. 489, no. 20. eprints.akakom., Yogyakarta, hal. 313–335, 2018, [Daring]. Tersedia pada: https://eprints.akakom.ac.id/6885/.
P. Noviyanti, A. Deolika, S. Hartinah, C. A. Haris, T. Maryana, dan N. D. Sari, “Perbandingan Query Response Time pada Model Query View dan Cross Product,” e-Jurnal JUSITI., vol. 7, no. 2, hal. 131 141, 2018, [Daring]. Tersedia pada: https://ejurnal.dipanegara.ac.id/index.php/jusiti/article/view/248.
S. Suhartati dan Y. Dwi Atma, “Optimasi Query Sederhana Guna Kecepatan Query Pada Database Server,” Metik Journal., vol. 1, no. 1, hal. 13–17, 2017, [Daring]. Tersedia pada: http://jurnal.stmikbpn.ac.id/index.php/metik1/article/view/5.
H. Siswanto, T. Andi, dan K. Kusrini, “Optimasi Query Pada Human Resource Information System (HRIS) di Universitas XYZ,” JMAI (Jurnal Multimedia)., Artif. Intell., vol. 2, no. 1, hal. 1–6, 2018, doi: 10.26486/jmai.v2i1.53.
I. Wasiso, A. Nugroho, D. Yulianto, dan K. Kusrini, “Optimasi Basis Data Spasial Untuk Mengidentifikasi Lampu Apill Di Kabupaten Sleman,” RESEARCH: Computer, Information System & Technology Management., vol. 3, hal. 31, 2020, doi: 10.25273/research.v3i1.5799.
R. Pamungkas, “Optimalisasi Query Dalam Basis Data My SQL Menggunakan Index,” RESEARCH : Computer, Information System & Technology Management., vol. 1, no. 1, hal. 27, 2018, doi: 10.25273/research.v1i1.2453.
J. H. Lubis, “Analisa Performansi Query Pada Database Smell,” Jurnal Manajemen dan Informasi Pelita Nusantara., vol. 21, no. 1, hal. 42–49, 2017, [Daring]. Tersedia pada: http://e-jurnal.pelitanusantara.ac.id/index.php/mantik/article/view/188/105.
Copyright (c) 2021 J-Icon : Jurnal Komputer dan Informatika
This work is licensed under a Creative Commons Attribution 4.0 International License.
The author submitting the manuscript must understand and agree that if accepted for publication, authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution (CC-BY) 4.0 License that allows others to share the work with an acknowledgment of the work’s authorship and initial publication in this journal.
