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

Kehinde, Olatunji Austine and Zulkifli, Zahidah and Mat Surin, Ely Salwana and Junurham, Nur Leyni Nilam Putri and Mahmud, Murni (2022) Elevating database performance: current caching and prefetching strategies for online databases in Nigeria. In: 8th International Visual Informatics Conference (IVIC 2023), 15th -17th November 2023, Bangi, Selangor, Malaysia.

	PDF (Full Paper) - Published Version Restricted to Registered users only Download (538kB) | Request a copy
Preview	PDF (Scopus) - Supplemental Material Download (208kB) | Preview

Abstract

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.

Item Type:	Proceeding Paper (Plenary Papers)
Uncontrolled Keywords:	Caching Prefetching Online Database Online Database Performance
Subjects:	T Technology > TK Electrical engineering. Electronics Nuclear engineering > TK7800 Electronics. Computer engineering. Computer hardware. Photoelectronic devices > TK7885 Computer engineering
Kulliyyahs/Centres/Divisions/Institutes (Can select more than one option. Press CONTROL button):	Kulliyyah of Information and Communication Technology Kulliyyah of Information and Communication Technology Kulliyyah of Information and Communication Technology > Department of Information System Kulliyyah of Information and Communication Technology > Department of Information System Kulliyyah of Information and Communication Technology > Department of Library & Information Science Kulliyyah of Information and Communication Technology > Department of Library & Information Science
Depositing User:	Dr Zahidah Zulkifli
Date Deposited:	22 Nov 2023 15:40
Last Modified:	23 Nov 2023 09:16
URI:	http://irep.iium.edu.my/id/eprint/108300

Actions (login required)

View Item