ANALYSIS OF QUERY RESTRUCTURIZATION MODELS IN OPTIMIZING DATA EXECUTION RESPONSE TIME ON MYSQL PHP 7.2.27 RELATIONAL DATABASES

Main Article Content

Olivia Maria Inacio Tavares
Sartje Mala Rangkoly
Sarah Bunda Desi Bawan
Khifni Beyk Ahmad
Ema Utami
Muhammad Syukri Mustafa

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.


 

Article Details

How to Cite
[1]
O. Tavares, S. Rangkoly, S. Bawan, K. Ahmad, E. Utami, and M. Mustafa, “ANALYSIS OF QUERY RESTRUCTURIZATION MODELS IN OPTIMIZING DATA EXECUTION RESPONSE TIME ON MYSQL PHP 7.2.27 RELATIONAL DATABASES”, jicon, vol. 9, no. 1, pp. 1-10, Feb. 2021.
Section
Articles
Author Biographies

Olivia Maria Inacio Tavares, Universitas AMIKOM Yogyakarta

Mahasiswa Magister Teknik Informatika Universitas Amikom Yogyakarta (PENULIS 1)

Sartje Mala Rangkoly, Universitas AMIKOM Yogyakarta

Mahasiswa Magister Teknik Informatika Universitas Amikom Yogyakarta (PENULIS 2)

Sarah Bunda Desi Bawan, Universitas AMIKOM Yogyakarta

Mahasiswa Magister Teknik Informatika Universitas Amikom Yogyakarta (PENULIS 3)

Khifni Beyk Ahmad, Universitas AMIKOM Yogyakarta

Mahasiswa Magister Teknik Informatika Universitas Amikom Yogyakarta (PENULIS 4)

Ema Utami, Universitas AMIKOM Yogyakarta

Vice Director Universitas AMIKOM Yogyakarta (Dosen Utama Pengampu Mata Kuliah Database Management System)  PENULIS 5

Muhammad Syukri Mustafa, STMIK Dipanegara Makassar

Tutor Universitas AMIKOM Yogyakarta (Tutor Pengampu Mata Kuliah Database Management System)  PENULIS 6

References

[1] 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.
[2] 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.
[3] 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.
[4] 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/.
[5] 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.
[6] 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.
[7] 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.
[8] 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.
[9] 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.
[10] 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.

Most read articles by the same author(s)

Obs.: This plugin requires at least one statistics/report plugin to be enabled. If your statistics plugins provide more than one metric then please also select a main metric on the admin's site settings page and/or on the journal manager's settings pages.