Configuration-parametric query optimization for physical design tuning

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2008, Pages 941-952

  Bruno, Nicolas ^a   Nehme, Rimma V ^b  

^a MICROSOFT RESEARCH   (United States)

^b PURDUE UNIVERSITY   (United States)

Author keywords

Parametric optimization; Physical design tuning

Indexed keywords

ACTIVE AREAS; COMPACT REPRESENTATIONS; EXECUTION PLANS; FEASIBLE SOLUTIONS; GENERAL APPROACHES; OPTIMIZATION STRATEGIES; OPTIMIZER; PARAMETRIC OPTIMIZATION; PHYSICAL DESIGN TUNING; PHYSICAL DESIGNS; QUERY OPTIMIZATIONS; RESEARCH AND DEVELOPMENTS;

DATABASE SYSTEMS; ELECTRIC NETWORK PARAMETERS; TUNING;

OPTIMIZATION;

EID: 57149131084     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1376616.1376710     Document Type: Conference Paper

References (15)

1. S. Agrawal et al. Database Tuning Advisor for Microsoft SQL Server 2005. In Proceedings of the International Conference on Very Large Databases (VLDB), 2004.
2. K. Billings. A TPC-D Model for Database Query Optimization in Cascades. Ms. thesis, Portland State University, 1996.
3. N. Bruno and S. Chaudhuri. Automatic physical database tuning: A relaxation-based approach. In Proceedings of the ACM International Conference on Management of Data (SIGMOD), 2005.
4. N. Bruno and S. Chaudhuri. To tune or not to tune? A Lightweight Physical Design Alerter. In Proceedings of the International Conference on Very Large Databases (VLDB), 2006.
5. P. Celis. The Query Optimizer in Tandem's new ServerWare SQL Product. In Proceedings of the International Conference on Very Large Databases (VLDB), 1996.
6. S. Chaudhuri and V. Narasayya. An efficient cost-driven index selection tool for Microsoft SQL Server. In Proceedings of the International Conference on Very Large Databases (VLDB), 1997.
7. S. Chaudhuri and V. Narasayya. Autoadmin 'What-if index analysis utility. In Proceedings of the ACM International Conference on Management of Data (SIGMOD), 1998.
8. B. Dageville et al. Automatic SQL Tuning in Oracle l0g. In Proceedings of the International Conference on Very Large Databases (VLDB), 2004.
9. G. Graefe. The Cascades framework for query optimization. Data Engineering Bulletin, 18(3), 1995.
10. G. Graefe. The Microsoft Relational Engine. In Proceedings of the International Conference on Data Engineering (ICDE), 1996.
11. Y. Ioannidis, R. Ng, K. Shim, and T. Sellis. Parametric query optimization. In Proceedings of the International Conference on Very-Large Databases (VLDB), 1992.
12. S. Papadomanolakis, D. Dash, and A. Ailamaki. Efficient use of the query optimizer for automated physical design. In Proceedings of the International Conference on Very Large Databases (VLDB), 2007.
13. L. Shapiro et al. Exploiting upper and lower bounds in top-down query optimization. In Proceedings of IDEAS, 2001.
14. G. Valentin, M. Zuliani, D. Zilio, G. Lohman, and A. Skelley. DB2 advisor: An optimizer smart enough to recommend its own indexes. In Proceedings of the International Conference on Data Engineering (ICDE), 2000.
15. D. Zilio et al. DB2 design advisor: Integrated automatic physical database design. In Proceedings of the International Conference on Very Large Databases (VLDB), 2004.