Constrained physical design tuning

Proceedings of the VLDB Endowment

Volumn 1, Issue 1, 2008, Pages 4-15

  Bruno, Nicolas ^a   Chaudhuri, Surajit ^a  

^a MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

CONSTRAINT LANGUAGE; EXECUTION COSTS; PHYSICAL DESIGN; PHYSICAL DESIGN TUNING; REAL WORLD SITUATIONS; SEARCH SPACES; STORAGE CONSTRAINTS; TRANSFORMATION BASED;

EID: 79951611880     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/1453856.1453863     Document Type: Article

References (20)

1. S. Agrawal, S. Chaudhuri, L. Kollar, A. Marathe, V. Narasayya, and M. Syamala. Database Tuning Advisor for Microsoft SQL Server 2005. In Proceedings of the International Conference on Very Large Databases (VLDB), 2004.
2. S. Agrawal, S. Chaudhuri, and V. Narasayya. Automated selection of materialized views and indexes in SQL databases. In Proceedings of the International Conference on Very Large Databases (VLDB), 2000.
3. S. Borzsonyi, D. Kossmann, and K. Stocker. The skyline operator. In Proceedings of the International Conference on Data Engineering (ICDE), 2001.
4. 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.
5. N. Bruno and S. Chaudhuri. Physical design refinement: The "Merge-Reduce" approach. In International Conference on Extending Database Technology (EDBT), 2006.
6. 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.
7. N. Bruno and R. Nehme. Configuration-parametric query optimization for physical design tuning. In Proceedings of the ACM International Conference on Management of Data (SIGMOD), 2008.
8. 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.
9. S. Chaudhuri and V. Narasayya. Autoadmin 'What-if' index analysis utility. In Proceedings of the ACM International Conference on Management of Data (SIGMOD), 1998.
10. S. Chaudhuri and V. Narasayya. Index merging. In Proceedings of the International Conference on Data Engineering (ICDE), 1999.
11. A. R. Conn, N. I. M. Gould, and P. L. Toint. Large-scale nonlinear constrained optimization: a current survey. In Algorithms for continuous optimization: the state of the art, 1994.
12. B. Dageville, D. Das, K. Dias, K. Yagoub, M. Zait, and M. Ziauddin. Automatic SQL Tuning in Oracle 10g. In Proceedings of the International Conference on Very Large Databases (VLDB), 2004.
13. B. Duncan. Deadlock Troubleshooting (Part 3). Accessible at http://blogs.msdn.com/bartd/archive/2006/09/25/deadlock-troubleshooting-part-3.aspx.
14. C. M. Fonseca and P. J. Fleming. Genetic algorithms for multiobjective optimization: Formulation, discussion and generalization. In Proceedings of the Conference on Genetic Algorithms, 1993.
15. S. Papadomanolakis and A. Ailamaki. An integer linear programming approach to database design. In Workshop on Self-Managing Database Systems, 2007.
16. G. P. Shapiro. The optimal selection of secondary indices is NP-Complete. In SIGMOD Record 13(2), 1983.
17. P. D. Surry, N. J. Radcliffe, and I. D. Boyd. A Multi-Objective Approach to Constrained Optimisation of Gas Supply Networks: The COMOGA Method. In Evolutionary Computing. AISB, 1995.
18. 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.
19. D. Zilio, J. Rao, S. Lightstone, G. Lohman, A. Storm, C. Garcia-Arellano, and S. Fadden. DB2 design advisor: Integrated automatic physical database design. In Proceedings of the International Conference on Very Large Databases (VLDB), 2004.
20. D. Zilio, C. Zuzarte, S. Lightstone, W. Ma, G. Lohman, R. Cochrane, H. Pirahesh, L. Colby, J. Gryz, E. Alton, D. Liang, and G. Valentin. Recommending materialized views and indexes with IBM DB2 design advisor. In International Conference on Autonomic Computing, 2004