Title :
The Vertica Query Optimizer: The case for specialized query optimizers
Author :
Nga Tran ; Lamb, Andrew ; Shrinivas, L. ; Bodagala, S. ; Dave, Jaimin
Author_Institution :
HP Vertica, Cambirdge, MA, USA
fDate :
March 31 2014-April 4 2014
Abstract :
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.
Keywords :
SQL; query processing; novel database systems; specialized query optimizers; vertica SQL query optimizer; vertica analytic database; Data models; Dictionaries; Encoding; Engines; Indexes; Optimization;
Conference_Titel :
Data Engineering (ICDE), 2014 IEEE 30th International Conference on
Conference_Location :
Chicago, IL
DOI :
10.1109/ICDE.2014.6816727
