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 条
  • [41] Building Disclosure Risk Aware Query Optimizers for Relational Databases
    Canim, Mustafa
    Kantarcioglu, Murat
    Hore, Bijit
    Mehrotra, Sharad
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2010, 3 (01): : 13 - 24
  • [42] A review of different cost-based distributed query optimizers
    Sharma, Manik
    Singh, Gurvinder
    Singh, Rajinder
    PROGRESS IN ARTIFICIAL INTELLIGENCE, 2019, 8 (01) : 45 - 62
  • [43] A review of different cost-based distributed query optimizers
    Manik Sharma
    Gurvinder Singh
    Rajinder Singh
    Progress in Artificial Intelligence, 2019, 8 : 45 - 62
  • [44] Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection
    Yu, Xiang
    Chai, Chengliang
    Li, Guoliang
    Liu, Jiabin
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2022, 15 (13): : 3924 - 3936
  • [45] Design and analysis of stochastic DSS query optimizers in a distributed database system
    Sharma, Manik
    Singh, Gurvinder
    Singh, Rajinder
    EGYPTIAN INFORMATICS JOURNAL, 2016, 17 (02) : 161 - 173
  • [46] Incorporating Super-Operators in Big-Data Query Optimizers
    Leeka, Jyoti
    Rajan, Kaushik
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2019, 13 (03): : 348 - 361
  • [47] A Cause-Focused Query Optimizer Alert System
    Ye, Runfan
    Liang, Zibo
    Chen, Xu
    Liu, Shuncheng
    Zheng, Kai
    PROCEEDINGS OF THE 33RD ACM INTERNATIONAL CONFERENCE ON INFORMATION AND KNOWLEDGE MANAGEMENT, CIKM 2024, 2024, : 2981 - 2990
  • [48] Orca: A Modular Query Optimizer Architecture for Big Data
    Soliman, Mohamed A.
    Antova, Lyublena
    Raghavan, Venkatesh
    El-Helw, Amr
    Gu, Zhongxian
    Shen, Entong
    Caragea, George C.
    Garcia-Alvarado, Carlos
    Rahman, Foyzur
    Petropoulos, Michalis
    Waas, Florian
    Narayanan, Sivaramakrishnan
    Krikellas, Konstantinos
    Baldwin, Rhonda
    SIGMOD'14: PROCEEDINGS OF THE 2014 ACM SIGMOD INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2014, : 337 - 348
  • [49] Design and Analysis of Stochastic Query Optimizer for Biobank Databases
    Sharma, Manik
    Singh, Gurvinder
    Singh, Rajinder
    Singh, Jasbir
    2015 15TH INTERNATIONAL CONFERENCE ON COMPUTATIONAL SCIENCE AND ITS APPLICATIONS (ICCSA), 2015, : 47 - 51
  • [50] Balsa: Learning a Query Optimizer Without Expert Demonstrations
    Yang, Zongheng
    Chiang, Wei-Lin
    Luan, Sifei
    Mittal, Gautam
    Luo, Michael
    Stoica, Ion
    PROCEEDINGS OF THE 2022 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA (SIGMOD '22), 2022, : 931 - 944
12345