Efficient use of the query optimizer for automated physical design

33rd International Conference on Very Large Data Bases, VLDB 2007 - Conference Proceedings

Volumn , Issue , 2007, Pages 1093-1104

  Papadomanolakis, Stratos ^a   Dash, Debabrata ^a   Ailamaki, Anastasia ^a  

^a CARNEGIE MELLON UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COSTS; OPTIMIZATION; QUERY PROCESSING;

COST ESTIMATIONS; DATABASE DESIGN TOOLS; PERFORMANCE LIMITATIONS; PHYSICAL DESIGN ALGORITHMS; PHYSICAL-DESIGN TOOLS; QUERY COST ESTIMATION; QUERY OPTIMIZATION; THREE ORDERS OF MAGNITUDE;

COST ESTIMATING;

EID: 85011105577     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (17)

1. Sanjay Agrawal, Surajit Chaudhuri, and Vivek R. Narasayya. Automated selection of materialized views and indexes in SQL databases. In Proceedings of the VLDB Conference, 2000.
2. Sanjay Agrawal, Vivek Narasayya, and Beverly Yang. Integrating vertical and horizontal partitioning into automated physical database design. In Proceedings of the SIGMOD Conference, 2004.
3. Nicolas Bruno and Surajit Chaudhuri. Automatic physical database tuning: a relaxation-based approach. In Proceedings of the SIGMOD Conference, 2005.
4. Nicolas Bruno and Surajit Chaudhuri. To tune or not to tune? a lightweight physical design alerter. In Proceedings of the VLDB Conference, 2006.
5. Surajit Chaudhuri, Mayur Datar, and Vivek Narasayya. Index selection for databases: A hardness study and a principled heuristic solution. IEEE Transactions on Knowledge and Data Engineering, 16(11):1313-1323, 2004.
6. Surajit Chaudhuri and Vivek R. Narasayya. An efficient cost-driven index selection tool for Microsoft SQL server. In Proceedings of the VLDB Conference, 1997.
7. Surajit Chaudhuri and Vivek R. Narasayya. Index merging. In Proceedings of the ICDE Conference, 1999.
8. Mariano P. Consens, Denilson Barbosa, Adrian Teisanu, and Laurent Mignet. Goals and benchmarks for autonomic configuration recommenders. In Proceedings of the SIGMOD Conference, 2005.
9. A. Ghosh, J. Parikh, V. Sengar, and J. Haritsa. Plan selection based on query clustering. In VLDB, 2002.
10. G. Valentin, M. Zuliani, D. Zilio, and G. Lohman. DB2 advisor: An optimizer smart enough to recommend its own indexes. In Proceedings of the ICDE Conference, 2000.
11. Arvind Hulgeri and S. Sudarshan. Parametric query optimization for linear and piecewise linear cost functions. In VLDB, 2002.
12. Arvind Hulgeri and S. Sudarshan. AniPQO: Almost non-intrusive parametric query optimization for nonlinear cost functions. In Proceedings of the VLDB Conference, 2003.
13. Stratos Papadomanolakis and Anastassia Ailamaki. An integer linear programming approach to database design. In ICDE Workshop on Self-Managing Databases, 2007.
14. Jun Rao, Chun Zhang, Nimrod Megiddo, and Guy Lohman. Automating physical database design in a parallel database. In Proceedings of the SIGMOD Conference, 2002.
15. Naveen Reddy and Jayant R. Haritsa. Analyzing plan diagrams of database query optimizers. In Proceedings of VLDB, 2005.
16. P. Selinger, M. Astrahan, D. Chamberlin, R. Lorie, and T. Price. Access path selection in a relational database management system. In SIGMOD 1979.
17. Daniel C. Zilio, Jun Rao, Sam Lightstone, Guy M. Lohman, Adam Storm, Christian Garcia-Arellano, and Scott Fadden. DB2 design advisor: Integrated automatic physical database design. In VLDB, 2004.