QO-Insight: Inspecting Steered Query Optimizers

Christoph Anneser; Mario Petruccelli; Nesime Tatbul; David Cohen; Zhenggang Xu; Prithviraj Pandian; Nikolay Laptev; Ryan Marcus; Alfons Kemper

doi:10.14778/3611540.3611586

QO-Insight: Inspecting Steered Query Optimizers

Christoph Anneser, Mario Petruccelli, Nesime Tatbul, David Cohen, Zhenggang Xu, Prithviraj Pandian, Nikolay Laptev, Ryan Marcus, Alfons Kemper

Informatik 3 - Lehrstuhl für Datenbanksysteme

Publikation: Beitrag in Fachzeitschrift › Konferenzartikel › Begutachtung

1 Zitat (Scopus)

Abstract

Steered query optimizers address the planning mistakes of traditional query optimizers by providing them with hints on a per-query basis, thereby guiding them in the right direction. This paper introduces QO-Insight, a visual tool designed for exploring query execution traces of such steered query optimizers. Although steered query optimizers are typically perceived as black boxes, QO-Insight empowers database administrators and experts to gain qualitative insights and enhance their performance through visual inspection and analysis.

Originalsprache	Englisch
Seiten (von - bis)	3922-3925
Seitenumfang	4
Fachzeitschrift	Proceedings of the VLDB Endowment
Jahrgang	16
Ausgabenummer	12
DOIs	https://doi.org/10.14778/3611540.3611586
Publikationsstatus	Veröffentlicht - 2023
Veranstaltung	49th International Conference on Very Large Data Bases, VLDB 2023 - Vancouver, Kanada Dauer: 28 Aug. 2023 → 1 Sept. 2023

Zugriff auf Dokument

10.14778/3611540.3611586

Andere Dateien und Links

Verknüpfung zur Publikation in Scopus

Dieses zitieren

@article{4c39794073fc4ad192b7743cb871b53f,

title = "QO-Insight: Inspecting Steered Query Optimizers",

abstract = "Steered query optimizers address the planning mistakes of traditional query optimizers by providing them with hints on a per-query basis, thereby guiding them in the right direction. This paper introduces QO-Insight, a visual tool designed for exploring query execution traces of such steered query optimizers. Although steered query optimizers are typically perceived as black boxes, QO-Insight empowers database administrators and experts to gain qualitative insights and enhance their performance through visual inspection and analysis.",

author = "Christoph Anneser and Mario Petruccelli and Nesime Tatbul and David Cohen and Zhenggang Xu and Prithviraj Pandian and Nikolay Laptev and Ryan Marcus and Alfons Kemper",

note = "Publisher Copyright: {\textcopyright} 2023, VLDB Endowment. All rights reserved.; 49th International Conference on Very Large Data Bases, VLDB 2023 ; Conference date: 28-08-2023 Through 01-09-2023",

year = "2023",

doi = "10.14778/3611540.3611586",

language = "English",

volume = "16",

pages = "3922--3925",

journal = "Proceedings of the VLDB Endowment",

issn = "2150-8097",

publisher = "Very Large Data Base Endowment Inc.",

number = "12",

}

TY - JOUR

T1 - QO-Insight

T2 - 49th International Conference on Very Large Data Bases, VLDB 2023

AU - Anneser, Christoph

AU - Petruccelli, Mario

AU - Tatbul, Nesime

AU - Cohen, David

AU - Xu, Zhenggang

AU - Pandian, Prithviraj

AU - Laptev, Nikolay

AU - Marcus, Ryan

AU - Kemper, Alfons

PY - 2023

Y1 - 2023

N2 - Steered query optimizers address the planning mistakes of traditional query optimizers by providing them with hints on a per-query basis, thereby guiding them in the right direction. This paper introduces QO-Insight, a visual tool designed for exploring query execution traces of such steered query optimizers. Although steered query optimizers are typically perceived as black boxes, QO-Insight empowers database administrators and experts to gain qualitative insights and enhance their performance through visual inspection and analysis.

AB - Steered query optimizers address the planning mistakes of traditional query optimizers by providing them with hints on a per-query basis, thereby guiding them in the right direction. This paper introduces QO-Insight, a visual tool designed for exploring query execution traces of such steered query optimizers. Although steered query optimizers are typically perceived as black boxes, QO-Insight empowers database administrators and experts to gain qualitative insights and enhance their performance through visual inspection and analysis.

UR - http://www.scopus.com/inward/record.url?scp=85174522350&partnerID=8YFLogxK

U2 - 10.14778/3611540.3611586

DO - 10.14778/3611540.3611586

M3 - Conference article

AN - SCOPUS:85174522350

SN - 2150-8097

VL - 16

SP - 3922

EP - 3925

JO - Proceedings of the VLDB Endowment

JF - Proceedings of the VLDB Endowment

IS - 12

Y2 - 28 August 2023 through 1 September 2023

ER -

QO-Insight: Inspecting Steered Query Optimizers

Abstract

Zugriff auf Dokument

Andere Dateien und Links

Fingerprint

Dieses zitieren