Elevating database performance: current caching and prefetching strategies for online databases in Nigeria

• Main Authors: Kehinde, Olatunji Austine, Zulkifli, Zahidah, Mat Surin, Ely Salwana, Junurham, Nur Leyni Nilam Putri, Mahmud, Murni
• Format: Proceeding Paper
• Language: English; English
• Published: Springer 2024
• Subjects: TK7885 Computer engineering
• Online Access: http://irep.iium.edu.my/108300/1/108300_Elevating%20database%20performance.pdf; http://irep.iium.edu.my/108300/2/108300_Elevating%20database%20performance_SCOPUS.pdf; http://irep.iium.edu.my/108300/; https://link.springer.com/chapter/10.1007/978-981-99-7339-2_27

This study investigated caching and prefetching techniques to improve data access performance in online databases, considering factors like data popularity, access patterns, and cache coherence. The research design adopted for this study was the descriptive survey. The population comprised of 1387 undergraduates computer science students in public tertiary institutions in Ekiti State. Simple random sampling technique was adopted to select 150 computer science students from three public tertiary institutions in the study area. The instrument used for data collection was a structured 4 Likert type questionnaire. The questionnaire was distributed to the respondents to find out the effectiveness of caching and prefetching techniques on online database. The instrument was both face and content validated by two experts from department of computer science in Bamidele Olumilua University of Education Science and Technology, Ikere-Ekiti, Ekiti State. The reliability of the instrument was ensured using Pearson Product Moment Correlation formula which yielded a coefficient of 0.97. The data collected were analyzed using descriptive statistics such as mean and standard deviation. The result showed that the current caching and prefetching techniques employed in online databases are highly effective; the different access patterns have effect on the effectiveness of caching and prefetching techniques in online databases and there are impacts of cache coherence mechanisms on the efficiency of caching and prefetching techniques in online databases. It was therefore recommended that the inclusion of caching and prefetching in curriculum is important across all educational level in Nigeria. In addition, caching and perfecting has come under fire for focusing mostly on computer science.