SLA-Aware Cloud Query Processing with Reinforcement Learning-based Multi-Objective Re-Optimization - Inria - Institut national de recherche en sciences et technologies du numérique
Communication Dans Un Congrès Année : 2022

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

Résumé

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
Origine Fichiers produits par l'(les) auteur(s)

Dates et versions

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

Identifiants

  • HAL Id : hal-03925654 , version 1

Citer

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⟩
98 Consultations
71 Téléchargements

Partager

More