Query Load Balancing in Parallel Database Systems - Inria - Institut national de recherche en sciences et technologies du numérique
Chapitre D'ouvrage Année : 2017

Query Load Balancing in Parallel Database Systems

Luc Bouganim

Résumé

Definition : The goal of parallel query execution is minimizing query response time using inter- and intraoperator parallelism. Interoperator parallelism assigns different operators of a query execution plan to distinct (sets of) processors, while intraoperator parallelism uses several processors for the execution of a single operator, thanks to data partitioning. Conceptually, parallelizing a query amounts to divide the query work in small pieces or tasks assigned to different processors. The response time of a set of parallel tasks being that of the longest one, the main difficulty is to produce and execute these tasks such that the query load is evenly balanced within the processors. This is made more complex by the existence of dependencies between tasks (e.g., pipeline parallelism) and synchronizations points. Query load balancing relates to static and/or dynamic techniques and algorithms to balance the query load within the processors so that the response time is minimized.
Fichier principal
Vignette du fichier
B1.pdf (429.29 Ko) Télécharger le fichier
Origine Fichiers produits par l'(les) auteur(s)
Loading...

Dates et versions

hal-01660649 , version 1 (26-09-2008)
hal-01660649 , version 2 (11-12-2017)

Identifiants

Citer

Luc Bouganim. Query Load Balancing in Parallel Database Systems. L. Liu; M.T. Özsu. Encyclopedia of Database Systems (2nd edition), Springer, pp.2268-2272, 2017, 978-0-387-35544-3. ⟨10.1007/978-1-4899-7993-3_1080-2⟩. ⟨hal-01660649v2⟩
304 Consultations
1188 Téléchargements

Altmetric

Partager

More