Data Warehouse Workload Management: A Review of Prediction, Optimization, and Resource Allocation Techniques
Journal of Global Research in Multidisciplinary Studies(JGRMS) · 2026
DOI: 10.67805/jgrms.v2i8.152 ↗Kurz gefasst
Fachartikel in der Zeitschrift Journal of Global Research in Multidisciplinary Studies(JGRMS), 2026. Verfasst von Dr. Abid Hussain. Die Arbeit nennt 27 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
Data warehouse workload management has become increasingly important due to the growing scale, complexity, and variability of analytical workloads. Different query patterns, varying arrival rates and execution times, huge amounts of data and different resource usage creates challenges to maintaining performance and efficient resource usage. This survey is an overview of the recent technologies used to deal with the workload of data warehouses, focusing on workload prediction, workload optimization and resource allocation. Machine learning, deep learning, and advanced temporal models-based approaches to workload prediction are discussed for workload pattern identification and workload forecasting. The review also covers query optimization, workload scheduling, task prioritization, fragmentation, and workload prediction techniques for optimization. Also studied are resource allocation strategies such as dynamic scaling, workload-aware resource management strategies and proactive allocation of computing resources in cloud-based data warehouse. Survey focuses on the main approaches and their characteristics, including their objectives, techniques, benefits, limitations, and applicability to dynamic analytical environments. Besides, prediction accuracy, workload variation, scalability, adaptability, computational overhead and cost-efficient resource utilization are discussed. Finally, new research opportunities are identified for more intelligent, adaptive, and integrated workload management frameworks, which involve prediction, optimization, and resource allocation to provide efficient data warehouse operation.
Zitieren
APA
Hussain, D. A. (2026). Data Warehouse Workload Management: A Review of Prediction, Optimization, and Resource Allocation Techniques. Journal of Global Research in Multidisciplinary Studies(JGRMS). https://doi.org/10.67805/jgrms.v2i8.152
Vancouver
Hussain DA. Data Warehouse Workload Management: A Review of Prediction, Optimization, and Resource Allocation Techniques. Journal of Global Research in Multidisciplinary Studies(JGRMS). 2026. doi:10.67805/jgrms.v2i8.152
BibTeX
@article{Hussain2026,
author = {Hussain, Dr. Abid},
title = {Data Warehouse Workload Management: A Review of Prediction, Optimization, and Resource Allocation Techniques},
journal = {Journal of Global Research in Multidisciplinary Studies(JGRMS)},
year = {2026},
doi = {10.67805/jgrms.v2i8.152}
}
EUVIMED