A Cost-Effective Query Optimizer for Multi-tenant Parallel DBMSs - Archive ouverte HAL Accéder directement au contenu
Communication Dans Un Congrès Année : 2023

A Cost-Effective Query Optimizer for Multi-tenant Parallel DBMSs

Résumé

For a multi-tenant DBMS, at any point in time, a tenant may submit an SQL query associated with a performance SLO (Service-Level Objective). Any violation in the SLO requires the provider to pay penalties. As such, the DBMS which is in charge of the provider’s long-term benefit, should find a fair compromise between the financial costs brought on by resource consumption and the SLO satisfactions that affect the provider’s income. Such compromises should be carefully considered due to the instability of multi-tenant query workload. In this paper, we propose an execution plan selection strategy which changes the optimization objective in response to the query workload. This latter information is provided by the queue manager, a new component of our extended optimizer, which controls the selected execution plans’ scheduling as well as resource allocation. Experimental results showed that it proved successful in terms of the provider’s long-term profit despite variations in the multi-tenant workload.
Fichier non déposé

Dates et versions

hal-04200855 , version 1 (08-09-2023)

Identifiants

Citer

Mira El Danaoui, Shaoyi Yin, Abdelkader Hameurlain, Franck Morvan. A Cost-Effective Query Optimizer for Multi-tenant Parallel DBMSs. European Conference on Advances in Databases and Information Systems (ADBIS 2023), Sep 2023, Barcelona, Spain. pp.25-34, ⟨10.1007/978-3-031-42941-5_3⟩. ⟨hal-04200855⟩
34 Consultations
0 Téléchargements

Altmetric

Partager

Gmail Facebook X LinkedIn More