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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Ajala, O.: Design and implementation of an improved electronic document management system being a submitted dessertation in partial fulfillment of higher degree (2015). https://www.academia.edu/34539436/
Akinola, A., Shorunke, O., Ajayi, S. A.: Awareness and use of electronic database by postgraduates in University of Ibadan (2018). https://www.researchgate.net/publication/329556980
Baba, M.A., Yusuf, A., Maijama’a, L., Ahmad, A.: Performance analysis of the encryption algorithms as solution to cloud database security. Int. J. Comput. Appl. 99(14), 21–31 (2014)
Cucchiara, et al.: Temporal analysis of cache prefetching strategies for multimedia applications (2001). https://www.researchgate.net/publication/3895113
Daniel, G., Sunyé, G., Cabot, J.: PrefetchML: a framework for prefetching and caching models (2017). https://hal.science/hal-01362149/document
Dar, S.A., Sharma, R., Srivastava, V., Sakalle, U.K.: Investigation on the electronic structure, optical, elastic, mechanical, thermodynamic and thermoelectric properties of wide band gap semiconductor double perovskite Ba2InTaO6. RSC Adv. 9(17), 9522–9532 (2019)
Lilja, D.J.: Cache coherence in large-scale shared memory multiprocessors: issues and comparisons. ACM Comput. Surv. 25(3), 303–338 (1993)
Lilja, D.J., Marcovitz, D.M., Yew, P.-C.: Memory Referencing Behavior and a Cache Performance Metric in a Shared Memory Multiprocessor, Center for Supercomputing Research and Development Report No. 836, University of Illinois, Urbana (1989)
Deepmala, A.K.U., Sharma, P.K.: Online data bases: a review of literature. Ilkogretim Online 19(4), 7111–7123 (2020)
Delagi, B.A., Glasco, D.B., Flynn, M.J.: Update-based cache coherence protocols for scalable shared-memory multiprocessors (1993). https://www.researchgate.net/publication/2575854
Diao, Y., et al.: Comparative studies of load balancing with control and optimization techniques (2005)
Gustafsson, E., Nilbert, B.: Cache coherence in parallel Multiprocessors, Uppsala 24th February 1997, Department of Computer Science, Uppsala University (1997)
Enteriscloud: Cloud database vs Traditional Database (2023). https://enteriscloud.com/cloud-database-vs-traditional-database/
Fang, J., Xu, Y., Kong, H., Cai, M.: A prefetch control strategy based on improved hill-climbing method in asymmetric multi-core architecture. J. Supercomput. 79(10), 10570–10588 (2023). https://doi.org/10.1007/s11227-023-05078-6
Fortinet: What is Catching Data? (2023). https://www.fortinet.com/resources/cyberglossary/caching#:~:text=Caching%20Data%20is%20a%20process,they%20can%20be%20accessed%20faster
Pfister, F., et al.: The IBM research parallel processor prototype (RP3): introduction and architecture. In: International Conference on Parallel Processing, pp. 764–771 (1985)
Hakan, G., Per. S.: An adaptive update-based cache coherence protocol for reduction of miss rate and traffic (2005). https://www.researchgate.net/publication/220759002
Hamdeni, C., Hamrouni, T., Charrada, F.B.: Adaptive measurement method for data popularity in distributive systems (2016). https://www.researchgate.net/publication/308278613
Hasslinger, G., Okhovatzadeh, M., Ntougias, K., Hasslinger, F., Hohlfeld, O.: An overview of analysis methods and evaluation results for caching strategies. Comput. Netw. 228, 109583 (2023)
Hourcade, J.P., Bederson, B.B., Druin, A., Rose, A., Farber, A., Takayama, Y.: The international children’s digital library: viewing digital books online. Interact. Comput. 15(2), 151–167 (2003)
Hennessy, J., Patterson, D.: Computer Architecture: A Quantitative Approach, 5th edn. Morgan Kaufmann (2011)
Keycdn, N.D.: What is Prefetching and Why Use It (2023). https://www.keycdn.com/support/prefetching
Khan, M.: Optimizing performance in highly utilized multicores with intelligent prefetching. In: Digital Comprehensive Summaries of Uppsala Dissertations from the Faculty of Science and Technology 1335, 54 p. Acta Universitatis Upsaliensis, Uppsala (2016). ISBN 978-91-554-9450-6
Lesk, M.: Understanding Digital Libraries. Elsevier (2005)
Marcelo, F.: Data access patterns: the features of the main data access patterns applied in software industry (2019). https://medium.com/mastering-software-engineering/data-access-patterns-the-features-of-the-main-data-access-patterns-applied-in-software-industry-6eff86906b4e
Marty, M.R.: Cache Coherence Techniques For Multicore Processors being a dissertation submitted in partial fulfilment of the requirements for the degree of Doctor of Philosophy (Computer Sciences) (2008). https://research.cs.wisc.edu/multifacet/theses
Dubois, M., Scheurich, C., Briggs, F.A.: Synchronization, coherence, and event ordering in multiprocessors. Computer 21(2), 9–21 (1988)
Naeem, M.A., Rehmat, M.A., Kim, B.: A comparative performance analysis of popularity-based caching strategies in named data networking (2020). https://ieeexplore.ieee.org/stamp/stamp.jsp?arnumber=9034036
Nwokedi, V.C., Nwokedi, G.I., Chollom, K.M., Adah, J.E.: Assessment of online usage patterns of Elsevier database amongst academics of Environmental Sciences, University of Jos (2017)
Nworgu, B.G.: Research design, population sampling and data collection (1991). https://www.cram.com/essay/Research-Design-Population-Sampling-And-Data-Collection/FJPCYAK46R
Nyholm, G.: Evaluation of memory prefetching techniques for modem applications. Master of Science Thesis, Electrical Engineering Department, Linköping University (2022)
Oliver, R.L., Teller, P.J.: Dynamic and adaptive cache prefetch policies (2000)
Patterson, R.H, Gibson, G.A., Ginting, E., Stodolsky, D., Zelenka, J.: Informed prefetching and caching. In: Advanced Prefetching and Caching of Models with PrefetchML, vol. 35 (1995)
Payami, M.: Instruction prefetching techniques for ultra low-power multicore architectures. Master Thesis, Alma Mater Studiorum - Università Di Bologna (2016)
PhoenixNAP: What is distributed database? (2021). https://phoenixnap.com/kb/distributed-database
Biswas, P.: What is the cache coherence problem in distributed systems? How can it be overcome? (2023). https://www.quora.com/What-is-the-cache-coherence-problem-in-distributed-systems-How-can-it-be-overcome
Ramadan, E., Babaie, P., Zhang, Z.-L.: Performance estimation and evaluation framework for caching policies in hierarchical caches. J. Comput. Commun. 144, 44–56 (2019). https://www.sciencedirect.com/science/article/abs/pii/S0140366419303524
Roland, L.L.: The effectiveness of caches and data prefetch buffers in large-scale shared memory multiprocessors (1987). Abstract retrieved from https://dl.acm.org/doi/10.5555/913856
Roy, P., Kumar, S., Satija, M.P.: Problems in searching online databases: a case study of select central university libraries in India. DESIDOC J. Libr. Inf. Technol. 32(1), 59–63 (2012)
Podlipnig, S., Böszörmenyi, L.: A survey of web cache replacement strategies. ACM Comput. Surv. 35(4), 374–398 (2003)
Waleed, A., Siti, M.S., Abudul, S.I.: A survey of web caching and prefetching a survey of web caching and prefetching (2011). https://www.researchgate.net/publication/265986051
The web largest resources for definitions and translations (2023): Definitions retrieved from https://www.definitions.net/definition/online+database
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2024 The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Kehinde, O.A., Zulkifli, Z., Surin, E.S.M., Junurham, N.L.N.P., Mahmud, M. (2024). Elevating Database Performance: Current Caching and Prefetching Strategies for Online Databases in Nigeria. In: Badioze Zaman, H., et al. Advances in Visual Informatics. IVIC 2023. Lecture Notes in Computer Science, vol 14322. Springer, Singapore. https://doi.org/10.1007/978-981-99-7339-2_27
Download citation
DOI: https://doi.org/10.1007/978-981-99-7339-2_27
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-99-7338-5
Online ISBN: 978-981-99-7339-2
eBook Packages: Computer ScienceComputer Science (R0)