Skip to content
Open access

Energy-Aware Query Scheduling in Cloud-Based Relational Database Systems

Jul 2026 · International Journal of Creative and Open Research in Engineering and Management · Vol 02, pp. 1-9 · 0 citations

TL;DR

An Energy-Driven Adaptive Scheduling (EDAS) algorithm is proposed that dynamically prioritizes queries based on estimated CPU utilization, disk I/O costs, and historical energy profiles without requiring modifications to the underlying database engine.

Abstract

Energy consumption in cloud-based relational database management systems (RDBMS) has emerged as a critical challenge facing modern data centers, with operational energy costs accounting for up to 40% of total infrastructure expenditure. Traditional query scheduling strategies, including First-Come-First-Served (FCFS) and Shortest-Job-First (SJF), prioritize performance optimization while neglecting explicit energy consumption considerations. This study proposes an Energy-Driven Adaptive Scheduling (EDAS) algorithm that dynamically prioritizes queries based on estimated CPU utilization, disk I/O costs, and historical energy profiles without requiring modifications to the underlying database engine. Experimental evaluation was conducted on a cloud-based MySQL 8.0 system deployed on Amazon Web Services (AWS) EC2 instances using light (50 queries), medium (150 queries), and heavy (300 queries) workloads derived from Sakila and TPC-H benchmarks. Results demonstrate that energy-aware scheduling exhibits workload-dependent performance characteristics: SJF achieves optimal energy efficiency under light and medium workloads with 14.2% and 16.0% savings respectively, while EDAS achieves measurable energy savings of 10.4%, 12.3%, and 20.5% under heavy workloads compared to FCFS, SJF, and baseline scheduling approaches. EDAS demonstrates greater resilience under CPU throttling conditions, maintaining 15.8% energy reduction when processor frequency drops from 2.5 GHz to 1.8 GHz. The energy-delay product (EDP) improves by 18.7% under heavy workloads, indicating superior energy-performance trade-offs. This study establishes the importance of workload-aware query scheduling for improving cloud database energy efficiency and provides practical guidelines for implementing energy-conscious scheduling in production RDBMS environments. The proposed approach reduces operational costs by approximately $1,247 annually per mid-sized database instance while maintaining ACID compliance and query performance guarantees. Keywords: energy-aware computing, query scheduling, cloud database, green computing, energy efficiency, adaptive scheduling, TPC-H benchmark, energy-delay product

Read PDF

Similar papers

Conference Aug 2026

Optimized Energy Efficient Resource Management in Cloud Datacenters using GreenCloud Sim

The current invention outlines a Java-driven framework for efficient resource management in cloud data centres using the CloudSim simulation environment. The framework presents a predictive auto-scaling mechanism that examines historical traffic patterns to forecast future workload requirements, allowing for predictive Virtual Machine (VM) al- location rather than traditional fixed threshold-based techniques. Prior to VM migration, the system assesses a Service Level Agreement (SLA) risk factor to avoid performance degradation and potential SLA violations through intelligent power management. A specific Green Scheduler Algorithm dynamically consolidates Virtual Machines by allocating workloads to optimally loaded physical machines based on fore- casted workload conditions. Machines with low utilization are automatically migrated across different power-saving states, such as idle, sleep, and deep sleep modes. This comprehensive framework strikes a balance between energy savings and the preservation of service reliability and Quality of Service (QoS). Simulation results demonstrate the effectiveness of energy savings, improved resource utilization, and SLA compliance, making it suitable for scalable and ecofriendly cloud resource management.

S. Divya, P. Venkadesh, G. Vasunthraa et al. · 0 citations
Preprint Jul 2026

AutoSLO: Practical Latency SLOs on Cloud Data Warehouses -- Extended Version

Modern cloud data warehouses decouple compute from storage, making it easy for organizations to access the same underlying data with multiple compute clusters. This flexibility is often used for performance isolation among diverse workloads, so that each workload meets its latency service-level objective (SLO) more reliably. For example, interactive dashboards, ad hoc analysis, and batch jobs can each run on separate clusters. However, this dedicated-cluster approach requires each compute cluster to be continuously scaled to adapt to workload evolution, with over-provisioning wasting resources and under-provisioning risking SLO violations. We present AutoSLO, a latency-SLO-aware workload management framework for multi-cluster cloud data warehouses. AutoSLO operates across three timescales through three key components. First, a periodic Policy Tuner plans proactive cluster scaling actions and tunes configuration parameters, using simulations of history-derived workload forecasts. Second, an SLO-aware reactive Autoscaler adjusts the active cluster set when recent workload behavior deviates from the forecast. Third, an online Query Router reacts to live load when placing each query, using a concurrency-aware latency predictor to avoid SLO violations. On realistic Redbench workloads, AutoSLO successfully meets latency SLOs of varying strictness, reducing cost by a mean of 26.4% compared to the per-scenario next-best baseline. Component-level evaluations show that the Query Router and Autoscaler respectively reduce SLO violation rates by a mean of 47.8% and 93.7%, relative to their corresponding alternatives. Finally, we show that the Policy Tuner can reduce the SLO violation rate by a mean of 44.6% using a single day of workload history, and that each component is efficient given its intended operating timescale.

Markos Markakis, T. Kraska · 0 citations
Open access Jul 2026

SPES: A Stochastic Predictive Energy-Aware Scheduling Approach for Efficient Multi-Region Cloud Computing

Cloud computing has transformed the delivery of modern applications and services by providing scalable, flexible, and cost-effective access to computing resources. One of the most critical challenges in cloud environments is the efficient distribution of dynamic workloads across heterogeneous resources, commonly addressed through load balancing and task scheduling techniques. Efficient scheduling plays a vital role in maximizing resource utilization, minimizing response time, and maintaining acceptable Quality of Service (QoS), particularly under dynamic and large-scale workloads. Despite the progress achieved by traditional heuristics such as Min-Min and metaheuristic approaches like the Improved Sparrow Search Algorithm (ISSA), challenges related to scalability, adaptability, and computational overhead remain. Metaheuristic-based approaches often involve iterative optimization processes that may limit their efficiency in real-time scheduling scenarios. In this paper, we propose a lightweight Stochastic Predictive Energy-Aware Scheduling (SPES) algorithm that integrates predictive execution estimation, multi-resource awareness, and stochastic decision-making. Unlike deterministic scheduling strategies, SPES employs a Top K candidate selection mechanism combined with probabilistic weighting and epsilon-greedy exploration to enhance adaptability and avoid suboptimal resource allocation. The proposed method considers CPU, memory, and I/O demands to achieve balanced utilization across heterogeneous hosts while implicitly addressing energy efficiency through utilization-based modeling. The proposed algorithm is implemented and evaluated using the CloudSim 5.0 simulation framework under heterogeneous multi-region cloud environments with varying workload sizes. Experimental results demonstrate that SPES consistently outperforms ISSA and achieves makespan reductions of up to 23.8% while improving scalability, resource utilization, and scheduling efficiency under dynamic cloud workloads. These results indicate that SPES provides an effective lightweight scheduling solution for large-scale and energy-aware cloud computing environments and supports green computing objectives through improved resource efficiency.

M. Yacoub, Ahmed E. Abdel Raouf, Walaa K. Gad et al. · 0 citations
Conference Jul 2026

ACAVES: Adaptive Carbon-Aware Virtualized Energy-Efficient Scheduling Framework for Sustainable Cloud Computing

The rapid expansion of cloud computing and large-scale data centers has significantly increased energy consumption and carbon emissions, creating critical sustainability concerns for modern computing infrastructures. This paper proposes the Adaptive Carbon-Aware Virtualized Energy-efficient Scheduling (ACAVES) framework to improve resource utilization and reduce environmental impact in cloud environments. The framework combines workload monitoring, task classification, virtual machine consolidation, carbon-aware scheduling, and energy optimization within an integrated architecture. An adaptive scheduling mechanism allocates workloads according to utilization patterns, energy requirements, and carbon emission estimates. Experimental evaluation was performed using heterogeneous workloads containing 10,000 tasks executed over 50 physical servers and 200 virtual machines. Results demonstrate that the proposed ACAVES framework reduced energy consumption from 520 kWh to 385 kWh and carbon emissions from 310 kgCO2 to 215 kgCO2. Additionally, server utilization improved from 68% to 87%, while average task completion time decreased from 820 ms to 670 ms, confirming the effectiveness and scalability of the proposed sustainable scheduling framework.

S. K, Kishore Bitra, Usha Desai · 0 citations
Open access May 2026

A Resource-Centric Analysis and Optimization of NoSQL Workloads using Distressed Resource Volume Metric

This work proposes and develops an open-source policy simulation framework, LoadStar, which forms a reusable benchmark pipeline for validating policies for resource-centric NoSQL workloads, and defines a resource optimization problem for placing Cosmos DB replicas onto VM nodes, and develops the Luna model for forecasting future load distributions.

Gunika Verma, Aashutosh A, Pooja Srinivas et al. · 0 citations