Conference Papers Year : 2022

SLA-Aware Cloud Query Processing with Reinforcement Learning-based Multi-Objective Re-Optimization

Abstract

Query processing on cloud database systems is a challenging problem due to the dynamic cloud environment. In cloud database systems, besides query execution time, users also consider the monetary cost to be paid to the cloud provider for executing queries. Moreover, a Service Level Agreement (SLA) is signed between users and cloud providers before any service is provided. Thus, from the profit-oriented perspective for the cloud providers, query re-optimization is multi-objective optimization that minimizes not only query execution time and monetary cost but also SLA violations. In this paper, we introduce ReOptRL and SLAReOptRL, two novel query re-optimization algorithms based on deep reinforcement learning. Experiments show that both algorithms improve query execution time and query execution monetary cost by 50% over existing algorithms, and SLAReOptRL has the lowest SLA violation rate among all the algorithms.
Fichier principal
Vignette du fichier
2022dawak.pdf (395.05 Ko) Télécharger le fichier
Origin Files produced by the author(s)

Dates and versions

hal-03925654 , version 1 (05-01-2023)

Identifiers

  • HAL Id : hal-03925654 , version 1

Cite

Chenxiao Wang, Le Gruenwald, Laurent d'Orazio. SLA-Aware Cloud Query Processing with Reinforcement Learning-based Multi-Objective Re-Optimization. DAWAK 2022 - International Conference on Data Warehousing and Knowledge Discovery, Aug 2022, Vienna, Austria. ⟨hal-03925654⟩
105 View
78 Download

Share

More