Title
The Vertica Query Optimizer: The case for specialized query optimizers
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.
Year
DOI
Venue
2014
10.1109/ICDE.2014.6816727
ICDE
Keywords
Field
DocType
vertica analytic database,specialized query optimizers,novel database systems,vertica sql query optimizer,query processing,sql,dictionaries,optimization,encoding,engines,data models,indexes
Query optimization,SQL,Data modeling,Data mining,Web search query,Query expansion,Information retrieval,Computer science,Sargable,View,Query by Example,Database
Conference
ISSN
Citations 
PageRank 
1084-4627
2
0.35
References 
Authors
16
5
Name
Order
Citations
PageRank
Nga Tran165642.46
Andrew Lamb220.35
Lakshmikant Shrinivas3101.85
Sreenath Bodagala411711.70
Jaimin Dave5122.25