IJAIT (International Journal of Applied Information Technology)
Vol 05 No 02 (November 2021)

Application of Index for Optimization Query Data in Graduate Information Systems

Agus Sifaunajah (Dept. of Information System, KH. A Wahab Hasbullah University, Jombang, East Java, Indonesia)
Rosa Tarbiyatul Khusna (Dept. of Informatic, KH. A Wahab Hasbullah University, Jombang, East Java, Indonesia)



Article Info

Publish Date
25 Jun 2022

Abstract

Graduates from educational institutions within the foundation of the Bahrul Ulum Islamic Boarding School each year can be more than 1000 people. The potential for this critical data has not been supported by good data collection. The data collection process is still done manually. Therefore, the level of accuracy is still fragile. In this study, an index is applied to perform query optimization. The object of this research is the database of the graduate data information system at the Bahrul Ulum Islamic Boarding School Foundation. Data collection method using literature study and interviews. The experimental stage of this research is done by determining the target output by compiling query commands. Each query command is executed ten times to find the average execution time and runs on two different hardware platforms to determine the effect of hardware on the query process. The study results show that the index can be used for data query optimization but only if it is supported by good hardware specifications so that the command execution time is optimal. When only using the index application, the average difference in execution time is 0.5 seconds.

Copyrights © 2021






Journal Info

Abbrev

ijait

Publisher

Subject

Computer Science & IT

Description

International Journal of Applied Information Technology covers a broad range of research topics in information technology. The topics include, but are not limited to avionics, bio medical instrumentation, biometric, computer network design, cryptography, data compression, digital signal processing, ...