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 条
  • [31] Extreme Visualisation of Query Optimizer Search Spaces
    Nica, Anisoara
    Brotherston, Daniel Scott
    Hillis, David William
    ACM SIGMOD/PODS 2009 CONFERENCE, 2009, : 1067 - 1069
  • [32] Using MDE for Teaching Database Query Optimizer
    Ouared, Abdelkader
    Chadli, Abdelhafid
    ENASE: PROCEEDINGS OF THE 16TH INTERNATIONAL CONFERENCE ON EVALUATION OF NOVEL APPROACHES TO SOFTWARE ENGINEERING, 2021, : 529 - 536
  • [33] Global semantic query optimizer in multidatabase systems
    Rachburi, Nachirat
    Chittayasothorn, Suphamit
    WMSCI 2006: 10TH WORLD MULTI-CONFERENCE ON SYSTEMICS, CYBERNETICS AND INFORMATICS, VOL I, PROCEEDINGS, 2006, : 81 - +
  • [34] Exact Cardinality Query Optimization for Optimizer Testing
    Chaudhuri, Surajit
    Narasayya, Vivek
    Ramamurthy, Ravi
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2009, 2 (01):
  • [35] Developing a query optimizer for a Federated Database System
    Yu, ZP
    Egyhazy, C
    INTELLIGENT INFORMATION SYSTEMS, (IIS'97) PROCEEDINGS, 1997, : 420 - 427
  • [36] Optimizing Join Enumeration in Transformation-based Query Optimizers
    Shanbhag, Anil
    Sudarshan, S.
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2014, 7 (12): : 1243 - 1254
  • [37] Deploying a Steered Query Optimizer in Production at Microsoft
    Zhang, Wangda
    Interlandi, Matteo
    Mineiro, Paul
    Qiao, Shi
    Ghazanfari, Nasim
    Lie, Karlen
    Friedman, Marc
    Hosn, Rafah
    Patel, Hiren
    Jindal, Alekh
    PROCEEDINGS OF THE 2022 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA (SIGMOD '22), 2022, : 2299 - 2311
  • [38] Efficiently Approximating Query Optimizer Plan Diagrams
    Dey, Atreyee
    Bhaumik, Sourjya
    Harish, D.
    Haritsa, Jayant R.
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2008, 1 (02): : 1325 - 1336
  • [39] Learned Distributed Query Optimizer:Architecture and Challenges
    GAO Jun
    HAN Yinjun
    LIN Yang
    MIAO Hao
    XU Mo
    ZTE Communications, 2024, 22 (02) : 49 - 54
  • [40] Steering Query Optimizers: A Practical Take on Big Data Workloads
    Negi, Parimarjan
    Interlandi, Matteo
    Marcus, Ryan
    Alizadeh, Mohammad
    Kraska, Tim
    Friedman, Marc
    Jindal, Alekh
    SIGMOD '21: PROCEEDINGS OF THE 2021 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2021, : 2557 - 2569
12345