Elevating Database Performance: Current Caching and Prefetching Strategies for Online Databases in Nigeria


연구 분야: Databases



학회: International Visual Informatics Conference


초록

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.


Author Profile
Olatunji Austine Kehinde

Department of Library and Information Science Kulliyyah of Information and Communication Technology International Islamic University Malaysia Kuala Lumpur Malaysia

Andorra
Author Profile
Zahidah Zulkifli

Department of Information Systems Kulliyyah of Information and Communication Technology International Islamic University Malaysia Kuala Lumpur Malaysia

Andorra
Author Profile
Ely Salwana Mat Surin

Institute of Visual Informatics Universiti Kebangsaan Malaysia Bangi Malaysia

Malaysia

📄 논문 정보

발행 연도 2023년
인용수 0
출판 국가 Malaysia, Andorra
사이트 Springer
좋아요 수 0

연관 논문 목록 (402건)