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 条
  • [21] EROC: A toolkit for building NEATO query optimizers
    McKenna, WJ
    Burger, L
    Hoang, C
    Truong, M
    PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON VERY LARGE DATA BASES, 1996, : 111 - 121
  • [22] Characterizing the Effectiveness of Query Optimizer in Spark
    Ren, Zujie
    Yun, Na
    Shi, Weisong
    Li, Youhuizi
    Wan, Jian
    Yu, Lihua
    Fan, Xinxin
    2018 IEEE WORLD CONGRESS ON SERVICES (IEEE SERVICES 2018), 2018, : 41 - 42
  • [23] AlphaQO: Robust Learned Query Optimizer
    Yu X.
    Chai C.-L.
    Zhang X.-N.
    Tang N.
    Sun J.
    Li G.-L.
    Ruan Jian Xue Bao/Journal of Software, 2022, 33 (03): : 814 - 831
  • [24] The Picasso Database Query Optimizer Visualizer
    Haritsa, Jayant R.
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2010, 3 (02): : 1517 - 1520
  • [25] A multi-query optimizer for Monet
    Manegold, S
    Pellenkoft, A
    Kersten, M
    ADVANCES IN DATABASES, 2000, 1832 : 36 - 50
  • [26] Designing Query Optimizers for Big Data Problems of The Future
    Tran, Nga
    Bodagala, Sreenath
    Dave, Jaimin
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2013, 6 (11): : 1168 - 1169
  • [27] Building Query Optimizers for Information Extraction: The SQoUT Project
    Jain, Alpa
    Ipeirotis, Panagiotis
    Gravano, Luis
    SIGMOD RECORD, 2008, 37 (04) : 28 - 34
  • [28] QO-Insight: Inspecting Steered Query Optimizers
    Anneser, Christoph
    Petruccelli, Mario
    Tatbul, Nesime
    Cohen, David
    Xu, Zhenggang
    Pandian, Prithviraj
    Laptev, Nikolay
    Marcus, Ryan
    Kemper, Alfons
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2023, 16 (12): : 3922 - 3925
  • [29] Analyzing the genetic operations of an evolutionary query optimizer
    Muntes-Mulero, Victor
    Aguilar-Saborit, Josep
    Zuzarte, Calisto
    Markl, Volker
    Larriba-Pey, Josep-L.
    FLEXIBLE AND EFFICIENT INFORMATION HANDLING, 2006, 4042 : 240 - 244
  • [30] Lero: A Learning-to-Rank Query Optimizer
    Zhu, Rong
    Chen, Wei
    Ding, Bolin
    Chen, Xingguang
    Pfadler, Andreas
    Wu, Ziniu
    Zhou, Jingren
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2023, 16 (06): : 1466 - 1479
12345