A Review of Data Caching and Query Acceleration Techniques in Modern Data Warehouse Systems
Main Article Content
Abstract
Data warehouse systems face increasing challenges in processing large-scale analytical queries efficiently due to growing data volumes, complex workloads, and resource constraints. Various data caching and query acceleration methods are presented that may be useful to decrease query latency, reduce redundant computation, and improve resource utilization. This paper briefly summarizes the major techniques like query-result caching, materialized views, in-memory caching, indexing, data partitioning, parallel processing, and hardware-assisted acceleration. It also explores workload-aware caching, adaptive query execution, reinforcement learning query optimization, and integrated cache-execution management in the cloud and distributed data warehouse settings. The analyzed papers demonstrate the advantages of GPU acceleration, distributed caching, cost-aware query processing, and adaptive cache replacement to enhance analytical throughput and query execution efficiency. The comparative analysis also points to some key challenges such as cache consistency, data freshness, dynamic workload adaptation, scalability, heterogeneous infrastructure, and infrastructure cost. The results highlight the importance of integrating cache management with query optimization and resource management for effective analytical processing. Based on this review, the following research gaps are identified that can be addressed through building integrated, workload-aware systems that satisfy the requirements of query performance, cache efficiency, data freshness, and operational cost for modern data warehouse systems.
Downloads
Article Details
Section

This work is licensed under a Creative Commons Attribution 4.0 International License.
This work is licensed under a Creative Commons Attribution 4.0 International (CC BY 4.0) License. Authors retain the copyright of their work and grant the Journal of Global Research in Multidisciplinary Studies (JGRMS) the right of first publication. This license permits unrestricted use, distribution, adaptation, and reproduction in any medium or format, provided the original author(s), source, and publication are properly credited. Users may copy, redistribute, remix, transform, and build upon the published material for any purpose, including commercial use, in accordance with the terms of the CC BY 4.0 License.
How to Cite
References
[1] A. A. Harby and F. Zulkernine, “Data Lakehouse: A survey and experimental study,” Inf. Syst., vol. 127, no. 102460, p. 102460, Jan. 2025, doi: 10.1016/j.is.2024.102460. DOI: https://doi.org/10.1016/j.is.2024.102460
[2] C. Liu, A. Pavlenko, M. Interlandi, and B. Haynes, “Data formats in analytical DBMSs: performance trade-offs and future directions,” VLDB J., vol. 34, no. 3, p. 30, 2025, doi: 10.1007/s00778-025-00911-1. DOI: https://doi.org/10.1007/s00778-025-00911-1
[3] P. Koukaras, “Data Integration and Storage Strategies in Heterogeneous Analytical Systems: Architectures, Methods, and Interoperability Challenges,” Information, vol. 16, no. 11, pp. 1–38, 2025, doi: 10.3390/info16110932. DOI: https://doi.org/10.3390/info16110932
[4] B. Gurumurthy, V. R. Bidarkar, D. Broneske, T. Pionteck, and G. Saake, “Exploiting Shared Sub-Expression and Materialized View Reuse for Multi-Query Optimization,” Inf. Syst. Front., vol. 28, no. 3, pp. 941–956, Jun. 2026, doi: 10.1007/s10796-024-10506-w. DOI: https://doi.org/10.1007/s10796-024-10506-w
[5] Y. Liu, S. Tang, Y. Hui, H. Zhou, and H. Zhang, “Selective Late Materialization in Modern Analytical Databases,” Proc. VLDB Endow., vol. 18, no. 11, pp. 4616–4628, Jul. 2025, doi: 10.14778/3749646.3749717. DOI: https://doi.org/10.14778/3749646.3749717
[6] D. P. Dasepalli, “Secure and Smart Supply Chain Management Systems Using AI-Driven Big Data Analytics and Cloud-Integrated Computing,” in 6th International Conference on Computing and Communication Networks (ICCCNet-2026), 2026.
[7] R. Ghazali and D. G. Down, “A Systematic Overview of Caching Mechanisms to Improve Hadoop Performance,” Concurr. Comput. Pract. Exp., vol. 37, no. 25–26, pp. 1–22, Nov. 2025, doi: 10.1002/cpe.70337. DOI: https://doi.org/10.1002/cpe.70337
[8] L. Bindschaedler, “Semantic Caching for OLAP via LLM-Based Query Canonicalization (Extended Version),” Feb. 2026. doi: 10.48550/arXiv.2602.19811.
[9] J. You et al., “SOC : A Succinct Adaptive Semantic OLAP Caching,” Data Sci. Eng., vol. 10, no. 4, pp. 665–680, 2025, doi: 10.1007/s41019-025-00290-1. DOI: https://doi.org/10.1007/s41019-025-00290-1
[10] X. Hu and Z. Miao, “Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting,” arXiv, vol. 19, no. 11, pp. 01–22, Jul. 2026, doi: 10.14778/3836663.3836724. DOI: https://doi.org/10.14778/3836663.3836724
[11] S. Kilaru, V. S. R. Yarlagadda, and M. B. Nagaraja, “AI-Augmented Block-Sketch Hybrid Compression: Enabling Semantic Query Processing on Compressed Data,” in 2026 IEEE 16th Annual Computing and Communication Workshop and Conference (CCWC), Las Vegas, NV, USA: IEEE, 2026, pp. 0966–0972, Jan. doi: 10.1109/CCWC67433.2026.11393750. DOI: https://doi.org/10.1109/CCWC67433.2026.11393750
[12] Y. Zhao, F. Liu, and G. Chen, “PUSHtap : PIM-based In-Memory HTAP with Unified Data Storage Format,” Proc. 30th ACM Int. Conf. Archit. Support Program. Lang. Oper. Syst. Vol. 3 (ASPLOS ’25), March 30-April 3, 2025, Rotterdam, Netherlands, vol. 1, no. 1, pp. 01–16, 2025, doi: 10.1145/3676642.3736120. DOI: https://doi.org/10.1145/3676642.3736120
[13] K. Gandhi, M. Bhise, and M. Kamdar, “DQP: Dynamic Query Processing for Varying Workload,” in 2026 IEEE Region 10 Symposium (TENSYMP), Penang, Malaysia: IEEE, Jun. 2026, pp. 1–5. doi: 10.1109/TENSYMP68909.2026.11704059. DOI: https://doi.org/10.1109/TENSYMP68909.2026.11704059
[14] S. Park, M. Jeong, and H. Han, “CCA: Cost-Capacity-Aware Caching for In-Memory Data Analytics Frameworks,” Sensors, vol. 21, no. 7, p. 2321, Mar. 2021, doi: 10.3390/s21072321. DOI: https://doi.org/10.3390/s21072321
[15] J. H. Lubis, S. Handayani, H. Mawengkang, and F. M. A. Napitupulu, “Performance Optimization of ERD Designs Using Cost-Based Optimization for Large-Scale Query Processing,” J. Tek. Inform., vol. 6, no. 3, pp. 1457–1468, Jun. 2025, doi: 10.52436/1.jutif.2025.6.3.4523. DOI: https://doi.org/10.52436/1.jutif.2025.6.3.4523
[16] A. Abbas and K. Ahmad, “An Integrated Indexing Approach to Improve Query Processing,” in 2021 International Conference on Electrical Engineering and Informatics (ICEEI), IEEE, Oct. 2021, pp. 1–6. doi: 10.1109/ICEEI52609.2021.9611104. DOI: https://doi.org/10.1109/ICEEI52609.2021.9611104
[17] E. Azhir, M. Hosseinzadeh, F. Khan, and A. Mosavi, “Performance Evaluation of Query Plan Recommendation with Apache Hadoop and Apache Spark,” Mathematics, vol. 10, no. 19, p. 3517, Sep. 2022, doi: 10.3390/math10193517. DOI: https://doi.org/10.3390/math10193517
[18] M. Abbasi, M. V Bernardo, P. Váz, J. Silva, and P. Martins, “Revisiting Database Indexing for Parallel and Accelerated Computing: A Comprehensive Study and Novel Approaches,” Information, vol. 15, no. 8, p. 429, Jul. 2024, doi: 10.3390/info15080429. DOI: https://doi.org/10.3390/info15080429
[19] P. Jinka, “Data Warehouse Optimization Techniques: A Survey Of Query Processing, Storage, And Performance Enhancement Methods,”,” World J. Adv. Eng. Technol. Sci., vol. 20, no. 2, pp. 216–226, Aug. 2026, doi: 10.30574/wjaets.2026.20.2.0408. DOI: https://doi.org/10.30574/wjaets.2026.20.2.0408
[20] J. Oliveira e Sá, R. Gonçalves, and C. Kaldeich, “Benchmark of Market Cloud Data Warehouse Technologies,” Procedia Comput. Sci., vol. 239, pp. 1212–1219, 2024, doi: 10.1016/j.procs.2024.06.289. DOI: https://doi.org/10.1016/j.procs.2024.06.289
[21] H. Nicholson, P. Chrysogelos, and A. Ailamaki, “HPCache: memory-efficient OLAP through proportional caching revisited,” VLDB J., vol. 33, no. 6, pp. 1775–1791, 2023, doi: 10.1007/s00778-023-00828-7. DOI: https://doi.org/10.1007/s00778-023-00828-7
[22] P. Sundaramoorthy, M. Parikh, S. R. Keshireddy, A. K. Penumatcha, and K. Jayabalan, “Adaptive Resource Management in Cloud-Native Databases: A Study of Autonomous Scaling and Query Optimization,” in 2025 10th International Conference on Communication and Electronics Systems (ICCES), IEEE, Oct. 2025, pp. 1506–1512. doi: 10.1109/ICCES67310.2025.11336962. DOI: https://doi.org/10.1109/ICCES67310.2025.11336962
[23] Z. Tong et al., “ORION: Optimizing OLAP Query Execution with Proactive Caching and Separate Operators,” in Proceedings of the 39th ACM International Conference on Supercomputing, in ICS ’25. New York, NY, USA, NY, USA: ACM, Jun. 2025, pp. 868–883. doi: 10.1145/3721145.3725752. DOI: https://doi.org/10.1145/3721145.3725752
[24] M. Hentschel, J. Dees, F. Funke, M. Heimel, and I. Oukid, “Building a Data Management System for the Cloud: Lessons Learned and Future Directions,” Datenbank-Spektrum, vol. 25, no. 1, pp. 17–28, 2025, doi: 10.1007/s13222-025-00494-9. DOI: https://doi.org/10.1007/s13222-025-00494-9
[25] H. Zhang, Y. Liu, and J. Yan, “Cost-Intelligent Data Analytics in the Cloud,” Aug. 2023. doi: 10.48550/arXiv.2308.09569.
[26] X. Wang, C. Xie, J. Ding, B. Xu, J. Li, and W. Huang, “Performance Optimization of Distributed Data Processing in Centralized Control System Based on Spark and GPU Collaboration,” Information, vol. 17, no. 7, p. 625, Jun. 2026, doi: 10.3390/info17070625. DOI: https://doi.org/10.3390/info17070625
[27] C. Gómez-Pantoja, D. Baeza-Rocha, and A. Inostrosa-Psijas, “A Behavior-Aware Caching Architecture for Web Applications Using Static, Dynamic, and Burst Segmentation,” Futur. Internet, vol. 17, no. 9, p. 429, Sep. 2025, doi: 10.3390/fi17090429. DOI: https://doi.org/10.3390/fi17090429
[28] N. Sassi and W. Jaziri, “Efficient AI-Driven Query Optimization in Large-Scale Databases: A Reinforcement Learning and Graph-Based Approach,” Mathematics, vol. 13, no. 11, p. 1700, May 2025, doi: 10.3390/math13111700. DOI: https://doi.org/10.3390/math13111700
[29] J. Lim, B. Kim, H. Lee, D. Choi, K. Bok, and J. Yoo, “An Efficient Distributed SPARQL Query Processing Scheme Considering Communication Costs in Spark Environments,” Appl. Sci., vol. 12, no. 1, 2022, doi: 10.3390/app12010122. DOI: https://doi.org/10.3390/app12010122
[30] C. Tang et al., “Data Caching for Enterprise-Grade Petabyte-Scale OLAP,” Jun. 2024. doi: 10.48550/arXiv.2406.05962.
[31] C. A. U. Hassan et al., “Optimizing the Performance of Data Warehouse by Query Cache Mechanism,” IEEE Access, vol. 10, pp. 13472–13480, 2022, doi: 10.1109/ACCESS.2022.3148131. DOI: https://doi.org/10.1109/ACCESS.2022.3148131