A Review of Data Caching and Query Acceleration Techniques in Modern Data Warehouse Systems
Journal of Global Research in Multidisciplinary Studies(JGRMS) · 30.10.2026 · 2 (10) · 22-29
DOI: 10.67805/jgrms.v2i10.160 ↗Kurz gefasst
Fachartikel in der Zeitschrift Journal of Global Research in Multidisciplinary Studies(JGRMS), online erschienen am 30.10.2026. Verfasst von Kapil Ahir. Die Arbeit nennt 31 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
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.
Zitieren
APA
Ahir, K. (2026). A Review of Data Caching and Query Acceleration Techniques in Modern Data Warehouse Systems. Journal of Global Research in Multidisciplinary Studies(JGRMS), 2(10), 22-29. https://doi.org/10.67805/jgrms.v2i10.160
Vancouver
Ahir K. A Review of Data Caching and Query Acceleration Techniques in Modern Data Warehouse Systems. Journal of Global Research in Multidisciplinary Studies(JGRMS). 2026;2(10):22-29. doi:10.67805/jgrms.v2i10.160
BibTeX
@article{Ahir2026,
author = {Ahir, Kapil},
title = {A Review of Data Caching and Query Acceleration Techniques in Modern Data Warehouse Systems},
journal = {Journal of Global Research in Multidisciplinary Studies(JGRMS)},
year = {2026},
volume = {2},
number = {10},
pages = {22--29},
doi = {10.67805/jgrms.v2i10.160}
}
EUVIMED