The Vertica Query Optimizer: The Case for Specialized Query Optimizers

被引：0
|
作者：
Tran, Nga [1 ]
Lamb, Andrew [2 ]
Shrinivas, Lakshmikant [2 ]
Bodagala, Sreenath [1 ]
Dave, Jaimin [1 ]
机构：
[1] HP Vert, Cambridge, MA 02140 USA
[2] Nutonian, Cambirdge, MA USA
来源：
2014 IEEE 30TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE) | 2014年
关键词：
D O I：
暂无
中图分类号：
TP [自动化技术、计算机技术];
学科分类号：
0812 ;
摘要：
The Vertica SQL Query Optimizer was written from the ground up for the Vertica Analytic Database. Its design and the tradeoffs we encountered during its implementation argue that the full power of novel database systems can only be realized with a carefully crafted custom Query Optimizer written specifically for the system in which it operates.
引用
收藏
页码：1108 / 1119
页数：12
相关论文
共 50 条
  • [1] VQA: Vertica Query Analyzer
    Simitsis, Alkis
    Wilkinson, Kevin
    Blais, Jason
    Walsh, Joe
    SIGMOD'14: PROCEEDINGS OF THE 2014 ACM SIGMOD INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2014, : 701 - 704
  • [2] Learned Query Optimizers
    Ding, Bolin
    Zhu, Rong
    Zhou, Jingren
    FOUNDATIONS AND TRENDS IN DATABASES, 2024, 13 (04): : 250 - 310
  • [3] Parallelizing Extensible Query Optimizers
    Waas, Florian M.
    Hellerstein, Joseph M.
    ACM SIGMOD/PODS 2009 CONFERENCE, 2009, : 871 - 878
  • [4] A Variability Model for Query Optimizers
    Soffner, Michael
    Siegmund, Norbert
    Rosenmueller, Marko
    Siegmund, Janet
    Leich, Thomas
    Saake, Gunter
    DATABASES AND INFORMATION SYSTEMS VII, 2013, 249 : 15 - +
  • [5] Extensible Query Optimizers in Practice
    Ding, Bailu
    Narasayya, Vivek
    Chaudhuri, Surajit
    FOUNDATIONS AND TRENDS IN DATABASES, 2024, 14 (3-4):
  • [6] Automating statistics management for query optimizers
    Chaudhuri, S
    Narasayya, V
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2001, 13 (01) : 7 - 20
  • [7] Have query optimizers hit the wall?
    Richard T. Snodgrass
    Sabah Currim
    Young-Kyoon Suh
    The VLDB Journal, 2022, 31 : 181 - 200
  • [8] Grid query optimizer to improve query processing in grids
    Liu, Shuo
    Karimi, Hassan A.
    FUTURE GENERATION COMPUTER SYSTEMS-THE INTERNATIONAL JOURNAL OF ESCIENCE, 2008, 24 (05): : 342 - 353
  • [9] Have query optimizers hit the wall?
    Snodgrass, Richard T.
    Currim, Sabah
    Suh, Young-Kyoon
    VLDB JOURNAL, 2022, 31 (01): : 181 - 200
  • [10] Learned Query Optimizers: Evaluation and Improvement
    Mikhaylov, Artem
    Mazyavkina, Nina S.
    Salnikov, Mikhail
    Trofimov, Ilya
    Qiang, Fu
    Burnaev, Evgeny
    IEEE ACCESS, 2022, 10 : 75205 - 75218
12345