Skip to main content
SpringerLink
Log in

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

  • Conference paper
  • First Online:
Advances in Visual Informatics (IVIC 2023)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 14322))

Included in the following conference series:

  • 295 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 79.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 99.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

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

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

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

    Google Scholar 

  4. Cucchiara, et al.: Temporal analysis of cache prefetching strategies for multimedia applications (2001). https://www.researchgate.net/publication/3895113

  5. Daniel, G., Sunyé, G., Cabot, J.: PrefetchML: a framework for prefetching and caching models (2017). https://hal.science/hal-01362149/document

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

    Article  Google Scholar 

  7. Lilja, D.J.: Cache coherence in large-scale shared memory multiprocessors: issues and comparisons. ACM Comput. Surv. 25(3), 303–338 (1993)

    Article  Google Scholar 

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

    Google Scholar 

  9. Deepmala, A.K.U., Sharma, P.K.: Online data bases: a review of literature. Ilkogretim Online 19(4), 7111–7123 (2020)

    Google Scholar 

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

  11. Diao, Y., et al.: Comparative studies of load balancing with control and optimization techniques (2005)

    Google Scholar 

  12. Gustafsson, E., Nilbert, B.: Cache coherence in parallel Multiprocessors, Uppsala 24th February 1997, Department of Computer Science, Uppsala University (1997)

    Google Scholar 

  13. Enteriscloud: Cloud database vs Traditional Database (2023). https://enteriscloud.com/cloud-database-vs-traditional-database/

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

    Article  Google Scholar 

  15. Fortinet: What is Catching Data? (2023). https://www.fortinet.com/resources/cyberglossary/caching#:~:text=Caching%20Data%20is%20a%20process,they%20can%20be%20accessed%20faster

  16. Pfister, F., et al.: The IBM research parallel processor prototype (RP3): introduction and architecture. In: International Conference on Parallel Processing, pp. 764–771 (1985)

    Google Scholar 

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

  18. Hamdeni, C., Hamrouni, T., Charrada, F.B.: Adaptive measurement method for data popularity in distributive systems (2016). https://www.researchgate.net/publication/308278613

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

    Article  Google Scholar 

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

    Article  Google Scholar 

  21. Hennessy, J., Patterson, D.: Computer Architecture: A Quantitative Approach, 5th edn. Morgan Kaufmann (2011)

    Google Scholar 

  22. Keycdn, N.D.: What is Prefetching and Why Use It (2023). https://www.keycdn.com/support/prefetching

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

    Google Scholar 

  24. Lesk, M.: Understanding Digital Libraries. Elsevier (2005)

    Google Scholar 

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

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

  27. Dubois, M., Scheurich, C., Briggs, F.A.: Synchronization, coherence, and event ordering in multiprocessors. Computer 21(2), 9–21 (1988)

    Article  Google Scholar 

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

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

    Google Scholar 

  30. Nworgu, B.G.: Research design, population sampling and data collection (1991). https://www.cram.com/essay/Research-Design-Population-Sampling-And-Data-Collection/FJPCYAK46R

  31. Nyholm, G.: Evaluation of memory prefetching techniques for modem applications. Master of Science Thesis, Electrical Engineering Department, Linköping University (2022)

    Google Scholar 

  32. Oliver, R.L., Teller, P.J.: Dynamic and adaptive cache prefetch policies (2000)

    Google Scholar 

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

    Google Scholar 

  34. Payami, M.: Instruction prefetching techniques for ultra low-power multicore architectures. Master Thesis, Alma Mater Studiorum - Università Di Bologna (2016)

    Google Scholar 

  35. PhoenixNAP: What is distributed database? (2021). https://phoenixnap.com/kb/distributed-database

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

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

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

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

    Article  Google Scholar 

  40. Podlipnig, S., Böszörmenyi, L.: A survey of web cache replacement strategies. ACM Comput. Surv. 35(4), 374–398 (2003)

    Article  Google Scholar 

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

  42. The web largest resources for definitions and translations (2023): Definitions retrieved from https://www.definitions.net/definition/online+database

Download references

Author information

Authors and Affiliations

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

    Olatunji Austine Kehinde & Nur Leyni Nilam Putri Junurham

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

    Zahidah Zulkifli & Murni Mahmud

  3. Institute of Visual Informatics, Universiti Kebangsaan Malaysia, Bangi, Malaysia

    Ely Salwana Mat Surin

Authors
  1. Olatunji Austine Kehinde
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Zahidah Zulkifli
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Ely Salwana Mat Surin
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Nur Leyni Nilam Putri Junurham
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Murni Mahmud
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Zahidah Zulkifli .

Editor information

Editors and Affiliations

  1. Universiti Tenaga Nasional, Kajang, Selangor, Malaysia

    Halimah Badioze Zaman

  2. University of Cambridge, Cambridge, UK

    Peter Robinson

  3. Dublin City University, Dublin, Ireland

    Alan F. Smeaton

  4. MIT Sloan School of Management, Asia School of Business, Cambridge, MA, USA

    Renato Lima De Oliveira

  5. University of Southern Denmark, Odense, Denmark

    Bo Nørregaard Jørgensen

  6. National Central University, Jhongli, Taiwan

    Timothy K. Shih

  7. Universiti Kebangsaan Malaysia, Bangi, Selangor, Malaysia

    Rabiah Abdul Kadir

  8. Universiti Kebangsaan Malaysia, Bangi, Selangor, Malaysia

    Ummul Hanan Mohamad

  9. Universiti Kebangsaan Malaysia, Bangi, Selangor, Malaysia

    Mohammad Nazir Ahmad

Rights and permissions

Reprints and permissions

Copyright information

© 2024 The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

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)

Publish with us

Policies and ethics

Search

Navigation