Perbandingan Response Time Penggunaan Index, Views, dan Materialized Views Database Mysql

Edi Witono(1*), P Parno(2),


(1) Universitas Budi Luhur, Indonesia
(2) Universitas Budi Luhur, Indonesia
(*) Corresponding Author

Abstract


The existence of information technology today can help the government in carrying out the task of providing services to the public that are efficient and transparent. One of them is the SisfoSPM application used by the Badan Litbang unit of the Ministry of Education and Culture's National Education and Culture Agency to verify spending budgets in the use of the State Revenue and Expenditure Budget. This web-based application has been using Mysql as its database since 2017. The amount of data from each year, makes this application run slowly, especially related to queries that display log data verification results of each employee. This study used experimental methods with employee log transaction data from 2017-2021 amounting to 780,212 records. The study uses three stages: preparation, experimentation and analysis of results. The results of this research, obtained the results of the main response time query module sisfoSPM application employee log calculation with the amount of data as much as 780,212 using the index method for 1.95 seconds, using the views method for 1.85 seconds and using the materialized views method for 0.01 seconds. With these results, researchers can draw the conclusion that the use of materialized views provides the fastest response time results

Full Text:

PDF

References


Instruksi Presiden RI, “Instruksi Presiden RI No. 3 Tahun 2003 tentang Kebijakan dan Strategi Nasional Pengembangan E-Government,” 2003.

W. D. Novan, R. F. S. T, S. T. Falahah, F. R. Industri, and U. Telkom, “Analisis Dan Penyusunan Rancangan Enterprise Architecture Sistem Pemerintahan Berbasis Elektronik Menggunakan Framework Togaf Analysis and Drafting of Enterprise Architecture System of Electronic Based Government Using Togaf Framework on Construction Serv,” e-Proceeding Eng., vol. 8, no. 2, pp. 2633–2646, 2021.

R. Pamungkas, “Optimalisasi Query Dalam Basis Data My Sql Menggunakan Index,” Res. Comput. Inf. Syst. Technol. Manag., vol. 1, no. 1, p. 27, 2018, doi: 10.25273/research.v1i1.2453.

Y. Z. Ayık and F. Kahveci, “Materialized View Effect on Query Performance,” vol. 11, no. 9, pp. 1070–1073, 2017.

R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 7th ed. Pearson, 2015.

H. Siswanto, T. Andi, and K. Kusrini, “Optimasi Query Pada Human Resource Information System (HRIS) di Universitas XYZ,” JMAI (Jurnal Multimed. Artif. Intell., vol. 2, no. 1, pp. 1–6, 2018, doi: 10.26486/jmai.v2i1.53.

P. Noviyanti, A. Deolika, S. Hartinah, C. A. Haris, T. Maryana, and N. D. Sari, “Perbandingan Query Response Time pada Model Query View dan Cross Product Comparison of Query Respone Time in the Query View and Cross Product,” e-Jurnal JUSITI, vol. 7, no. 2, pp. 131–141, 2018, [Online]. Available: https://ejurnal.dipanegara.ac.id/index.php/jusiti/article/view/248.

P. K. Safitri, W. W. Winarno, and E. Pramono, “Optimasi Query untuk Sistem Informasi Penjadwalan Mata Pelajaran Sekolah Menggunakan View ( Studi Kasus : SMK VIP Purworejo ),” vol. XIII, pp. 46–51, 2018, [Online]. Available: http://jti.respati.ac.id/index.php/jurnaljti/article/view/259.

F. S. Nugraha, F. H. Purwanto, and F. E. N. Saputro, “Optimasi Query Pada Laporan Transaksi Penjualan Menggunakan Materialized View (Kasus : Moonly café),” CCIT J., vol. 11, no. 1, pp. 1–14, 2018, doi: 10.33050/ccit.v11i1.552.

Tawar and S. Wahyuningsih, “Pembandingan Metode Backup Database MySQL antara Replikasi dan MySQLDump,” Jusi, vol. 1, no. 1, pp. 45–52, 2011.

A. Solichin, “MySQL Dari Pemula Hingga Mahir,” Univ. Budi Luhur, Jakarta, no. January 2010, pp. 1–117, 2010.




DOI: http://dx.doi.org/10.30645/j-sakti.v6i1.463

Refbacks

  • There are currently no refbacks.



J-SAKTI (Jurnal Sains Komputer & Informatika)
Published Papers Indexed/Abstracted By:


Jumlah Kunjungan :

View My Stats