Designing query optimizers for big data problems of the future

Authors:
Nga Tran;Sreenath Bodagala;Jaimin Dave
Affiliations:
HP, Vertica, Cambridge, MA;HP, Vertica, Cambridge, MA;HP, Vertica, Cambridge, MA
Venue:
Proceedings of the VLDB Endowment
Year:
2013

Citing 4
Cited 0

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Partial join order optimization in the paraccel analytic database

Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Query optimization in microsoft SQL server PDW

SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data
The vertica analytic database: C-store 7 years later

Proceedings of the VLDB Endowment

Quantified Score

Hi-index	0.00

Visualization

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 implementation, support the case that the full power of novel database systems can be realized only with a custom Query Optimizer, carefully crafted exclusively for the system in which it operates.