QO-Insight: Inspecting Steered Query Optimizers

被引：0

作者：

Anneser, Christoph ^{[1
]}

Petruccelli, Mario ^{[1
]}

Tatbul, Nesime ^{[2
,3
]}

Cohen, David ^{[4
]}

Xu, Zhenggang ^{[5
]}

Pandian, Prithviraj ^{[5
]}

Laptev, Nikolay ^{[5
]}

Marcus, Ryan ^{[6
]}

Kemper, Alfons ^{[1
]}

机构：

[1] TUM, Munich, Germany

[2] Intel Labs, Hillsboro, OR USA

[3] MIT, Cambridge, MA 02139 USA

[4] Intel, Santa Clara, CA USA

[5] Meta, Menlo Pk, CA USA

[6] Univ Penn, Philadelphia, PA 19104 USA

来源：

PROCEEDINGS OF THE VLDB ENDOWMENT | 2023年 / 16卷 / 12期

关键词：

OPTIMIZATION;

D O I：

10.14778/3611540.3611586

中图分类号：

TP [自动化技术、计算机技术];

学科分类号：

0812 ;

摘要：

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.

引用

页码：3922 / 3925

页数：4

共 50 条

[31] Re-Engineering Compiler Transformations to Outperform Database Query Optimizers
Rietveld, Kristian F. D.
Wijshoff, Harry A. G.
LANGUAGES AND COMPILERS FOR PARALLEL COMPUTING (LCPC 2014), 2015, 8967 : 300 - 314
[32] Data-induced predicates for sideways information passing in query optimizers
Srikanth Kandula
Laurel Orr
Surajit Chaudhuri
The VLDB Journal, 2022, 31 : 1263 - 1290
[33] Corpus-Steered Query Expansion with Large Language Models
Lei, Yibin
Cao, Yu
Zhou, Tianyi
Shen, Tao
Yates, Andrew
PROCEEDINGS OF THE 18TH CONFERENCE OF THE EUROPEAN CHAPTER OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, VOL 2: SHORT PAPERS, 2024, : 393 - 401
[34] Think big, start small: a good initiative to design green query optimizers
Simon Pierre Dembele
Ladjel Bellatreche
Carlos Ordonez
Amine Roukh
Cluster Computing, 2020, 23 : 2323 - 2345
[35] Automating statistics management for query optimizers (vol 13, pg 7, 2001)
Chaudhuri, S
Narasayya, V
IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2001, 13 (03) : 526 - 526
[36] Think big, start small: a good initiative to design green query optimizers
Dembele, Simon Pierre
Bellatreche, Ladjel
Ordonez, Carlos
Roukh, Amine
CLUSTER COMPUTING-THE JOURNAL OF NETWORKS SOFTWARE TOOLS AND APPLICATIONS, 2020, 23 (03): : 2323 - 2345
[37] QUERY - ACTION-INSIGHT EXERCISE
HAZELL, JW
SMALL GROUP BEHAVIOR, 1975, 6 (04): : 494 - 500
[38] An empirical assessment of autonomicity for autonomic query optimizers using fuzzy-AHP technique
Dehraj, Pooja
Sharma, Arun
APPLIED SOFT COMPUTING, 2020, 90
[39] Using adaptive steered molecular dynamics to gain insight on the energetics of small peptides
Bureau, Hailey R.
Merz, Dale
Hershkovits, Eliezer
Quirk, Stephen
Hernandez, Rigoberto
ABSTRACTS OF PAPERS OF THE AMERICAN CHEMICAL SOCIETY, 2014, 248
[40] The inhibitor DBMIB provides insight into the functional architecture of the qo site in the cytochrome b6f complex
Roberts, AG
Bowman, MK
Kramer, DM
BIOCHEMISTRY, 2004, 43 (24) : 7707 - 7716

← 1 2 3 4 5 →