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

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...

全面介紹

Saved in:
書目詳細資料
Main Authors: Kehinde, Olatunji Austine, Zulkifli, Zahidah, Mat Surin, Ely Salwana, Junurham, Nur Leyni Nilam Putri, Mahmud, Murni
格式: Proceeding Paper
語言:English
English
出版: Springer 2024
主題:
在線閱讀: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.