Upscaling Current Data Caching and Prefetching Strategies for Online Databases in Nigeria

Olatunji Austine Kehinde (1), Zahidah Zulkifli (2), Ely Salwana (3), Nur Leyni Nilam Putri Junurham (4), Murni Mahmud (5), Salem Bahmaid (6)
(1) Department of Library and Information Science, Kulliyyah of Information and Communication Technology, International Islamic University Malaysia, Kuala Lumpur, Malaysia
(2) Department of Information Systems, Kulliyyah of Information and Communication Technology, International Islamic University Malaysia, Kuala Lumpur, Malaysia
(3) Institute of Visual Informatics, Universiti Kebangsaan Malaysia, Bangi, Malaysia
(4) Department of Library and Information Science, Kulliyyah of Information and Communication Technology, International Islamic University Malaysia, Kuala Lumpur, Malaysia
(5) Department of Information Systems, Kulliyyah of Information and Communication Technology, International Islamic University Malaysia, Kuala Lumpur, Malaysia
(6) Faculty of Computer Studies, Arab Open University, Riyadh, Saudi Arabia
Fulltext View | Download
How to cite (IJASEIT) :
Kehinde, Olatunji Austine, et al. “Upscaling Current Data Caching and Prefetching Strategies for Online Databases in Nigeria”. International Journal on Advanced Science, Engineering and Information Technology, vol. 14, no. 4, Aug. 2024, pp. 1443-8, doi:10.18517/ijaseit.14.4.17497.
This study investigated upscaling current data caching and prefetching strategies for online databases in Nigeria, with a focus on practical implications. The research design adopted for this study was the descriptive survey. The population comprised of all undergraduate’s library students in public tertiary institutions in Ekiti State. A simple random sampling technique was adopted to select 200 library students from Ekiti State University 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 databases. The instrument was both face and content validated by two experts from the department of Library studies in Ekiti State University, Ado-Ekiti State.  The reliability of the instrument was ensured using Pearson Product Moment Correlation formula which yielded a coefficient of 0.99.  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, with a clear emphasis on the practical implications. In addition, caching and perfecting have come under fire for focusing mostly on computer science.

J. Fang, Y. Xu, H. Kong, and M. Cai, “A prefetch control strategy based on improved hill-climbing method in asymmetric multi-core architecture,” The Journal of Supercomputing, vol. 79, no. 10, pp. 10570–10588, Feb. 2023, doi: 10.1007/s11227-023-05078-6.

K. A. Eiriemiokhale, “Frequency of Use and Awareness of Electronic Databases by University Lecturers in South-West, Nigeria,” Library Philosophy & Practice, 2020.

J. A. Liasu, & S. F. Bakrin, “The Impact of Electronic Information Resources On The Reading Habits Of Library Users At Osun State University, Nigeria,” Library Philosophy & Practice, 2022.

N. Gupta, P. Zhang, R. Kannan, and V. Prasanna, “PaCKD: Pattern-Clustered Knowledge Distillation for Compressing Memory Access Prediction Models,” 2023 IEEE High Performance Extreme Computing Conference (HPEC), Sep. 2023, doi:10.1109/hpec58863.2023.10363610.

M. K. Faeq and S. S. Omran, “Cache coherency controller for MESI protocol based on FPGA,” International Journal of Electrical and Computer Engineering (IJECE), vol. 11, no. 2, p. 1043, Apr. 2021, doi: 10.11591/ijece.v11i2.pp1043-1052.

O. A. Kehinde, Z. Zulkifli, E. S. M. Surin, N. L. N. P. Junurham, and M. Mahmud, “Elevating Database Performance: Current Caching and Prefetching Strategies for Online Databases in Nigeria,” Advances in Visual Informatics, pp. 314–327, Oct. 2023, doi: 10.1007/978-981-99-7339-2_27.

W. H. W. Ishak and N. F. Ismail, “Recommender System for Multiple Databases Based on Web Log Mining,” Annals of Emerging Technologies in Computing, vol. 5, no. 5, pp. 187–193, Mar. 2021, doi: 10.33166/aetic.2021.05.023.

J. K. Opele., “Inter-professional collaboration and knowledge management practices among clinical workforce in Federal Tertiary Hospitals in Nigeria,” Knowledge Management & E-Learning: An International Journal, pp. 329–343, Sep. 2022, doi:10.34105/j.kmel.2022.14.018.

Fortinet. What is Catching Data? Retrieved from https://www.fortinet.com/resources/cyberglossary/what-is-caching. 2023.

A. Awad, R. Salem, H. Abdelkader, and M. A. Salam, “A Novel Intelligent Approach for Dynamic Data Replication in Cloud Environment,” IEEE Access, vol. 9, pp. 40240–40254, 2021, doi:10.1109/access.2021.3064917.

G. Hasslinger, M. Okhovatzadeh, K. Ntougias, F. Hasslinger, and O. Hohlfeld, “An overview of analysis methods and evaluation results for caching strategies,” Computer Networks, vol. 228, p. 109583, Jun. 2023, doi: 10.1016/j.comnet.2023.109583.

N. D. Keycdn, “What is Prefetching and Why Use it”. Retrieved from https://www.keycdn.com/support/prefetching. 2023

Y. Al Moaiad, Z. A. Bakar, A. M. E. Diab, N. Zamin, and Y. Yahya, “Cloud Service Provider Cost for Online University: Amazon Web Services versus Oracle Cloud Infrastructure,” Advances in Visual Informatics, pp. 302–313, Oct. 2023, doi: 10.1007/978-981-99-7339-2_26.

PhoenixNAP. What is Distributed Database? Retrieved from https://phoenixnap.com/kb/distributed-database. 2021.

A. K. U. Deepmala, & P. K. Sharma, “Online Data Bases: A Review of Literature,” Ilkogretim Online, vol.19, no. 4, pp. 7111-7123, 2020.

S. D. Adhikari, E. R. Van Teijlingen, P. R. Regmi, P. Mahato, B. Simkhada, and P. P. Simkhada, “The Presentation of Academic Self in The Digital Age: The Role of Electronic Databases,” International Journal of Social Sciences and Management, vol. 7, no. 1, pp. 38–41, Jan. 2020, doi: 10.3126/ijssm.v7i1.27405.

A. K. Sandhu, “Big data with cloud computing: Discussions and challenges,” Big Data Mining and Analytics, vol. 5, no. 1, pp. 32–40, Mar. 2022, doi: 10.26599/bdma.2021.9020016.

H. Shukur, S. Zeebaree, R. Zebari, O. Ahmed, L. Haji, and D. Abdulqader, “Cache Coherence Protocols in Distributed Systems,” Journal of Applied Science and Technology Trends, vol. 1, no. 2, pp. 92–97, Jun. 2020, doi: 10.38094/jastt1329.

H. Adeli and P. R. Vishnubhotla, “Parallel Processing and Parallel Machines,” Parallel Processing in Computational Mechanics, pp. 1–20, Aug. 2020, doi: 10.1201/9781003066750-1.

A. Thomasian, “Storage Systems: Organization, Performance, Coding, Reliability, and Their Data Processing,” ACM SIGKDD Explorations Newsletter, vol. 25, no. 2, pp. 22–24, Mar. 2024, doi:10.1145/3655103.3655107.

M. Forsell, J. Roivainen, V. Leppänen, and J. L. Träff, “Realizing multioperations and multiprefixes in Thick Control Flow processors,” Microprocessors and Microsystems, vol. 98, p. 104807, Apr. 2023, doi: 10.1016/j.micpro.2023.104807.

M. F. Plauth, “Improving the Accessibility of Heterogeneous System Resources for Application Developers using Programming Abstractions,” Doctoral dissertation, Universität Potsdam, 2022.

H.-J. Yang, J. Fang, M. Cai, and Z. Cai, “A Prefetch-Adaptive Intelligent Cache Replacement Policy Based on Machine Learning,” Journal of Computer Science and Technology, vol. 38, no. 2, pp. 391–404, Mar. 2023, doi: 10.1007/s11390-022-1573-3.

L. Rui, X. Huang, S. Song, Y. Kang, C. Wang, and J. Wang, “Time Series Representation for Visualization in Apache IoTDB,” Proceedings of the ACM on Management of Data, vol. 2, no. 1, pp. 1–26, Mar. 2024, doi: 10.1145/3639290.

G. Ayers, H. Litz, C. Kozyrakis, and P. Ranganathan, “Classifying Memory Access Patterns for Prefetching,” Proceedings of the Twenty-Fifth International Conference on Architectural Support for Programming Languages and Operating Systems, Mar. 2020, doi:10.1145/3373376.3378498.

G. F. Oliveira et al., “DAMOV: A New Methodology and Benchmark Suite for Evaluating Data Movement Bottlenecks,” IEEE Access, vol. 9, pp. 134457–134502, 2021, doi: 10.1109/access.2021.3110993.

A. Naithani, J. Roelandts, S. Ainsworth, T. M. Jones, and L. Eeckhout, “Decoupled Vector Runahead,” 56th Annual IEEE/ACM International Symposium on Microarchitecture, Oct. 2023, doi:10.1145/3613424.3614255.

R. Coe, M. Waring, L. V. Hedges, & L. D. Ashley, (Eds.), Research methods and methodologies in education. Sage, 2021.

M. M. Adam, L. Zhao, K. Wang, and Z. Han, “Beyond 5G networks: Integration of communication, computing, caching, and control,” China Communications, vol. 20, no. 7, pp. 137–174, Jul. 2023, doi:10.23919/jcc.2023.00.039.

M. Mahbub and R. M. Shubair, “Contemporary advances in multi-access edge computing: A survey of fundamentals, architecture, technologies, deployment cases, security, challenges, and directions,” Journal of Network and Computer Applications, vol. 219, p. 103726, Oct. 2023, doi: 10.1016/j.jnca.2023.103726.

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Authors who publish with this journal agree to the following terms:

    1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
    2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
    3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).