EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Data Warehouse Workload Management: A Review of Prediction, Optimization, and Resource Allocation Techniques

Dr. Abid Hussain

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

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →