Interactive physical design tuning

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2010, Pages 1161-1164

  Bruno, Nicolas ^a   Chaudhuri, Surajit ^a  

^a MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

PARADIGM SHIFTS; PHYSICAL DESIGN; PHYSICAL DESIGN TUNING;

TUNING;

DESIGN;

EID: 77952750837     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2010.5447800     Document Type: Conference Paper

References (18)

1. 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.
2. S. Agrawal, E. Chu, and V. Narasayya. Automatic physical design tuning: workload as a sequence. In Proceedings of the ACM International Conference on Management of Data (SIGMOD), 2006.
3. S. Agrawal et al. Database Tuning Advisor for Microsoft SQL Server 2005. In Proceedings of the International Conference on Very Large Databases (VLDB), 2004.
4. S. Agrawal, V. Narasayya, and B. Yang. Integrating vertical and horizontal partitioning into automated physical database design. In Proceedings of the ACM International Conference on Management of Data (SIGMOD), 2004.
5. 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.
6. N. Bruno and S. Chaudhuri. Physical design refinement: The "Merge-Reduce" approach. In International Conference on Extending Database Technology (EDBT), 2006.
7. 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.
8. N. Bruno and S. Chaudhuri. Constrained physical design tuning. In Proceedings of the International Conference on Very Large Databases (VLDB), 2008.
9. 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.
10. 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.
11. S. Chaudhuri and V. Narasayya. Autoadmin 'What-if' index analysis utility. In Proceedings of the ACM International Conference on Management of Data (SIGMOD), 1998.
12. S. Chaudhuri and V. Narasayya. Index merging. In Proceedings of the International Conference on Data Engineering (ICDE), 1999.
13. 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.
14. Microsoft. Windows Powershell, 2006. Accessible at http://www.microsoft. com/windowsserver2003/-technologies/management/powershell/default.mspx.
15. S. Papadomanolakis and A. Ailamaki. An integer linear programming approach to database design. In Workshop on Self-Managing Database Systems, 2007.
16. 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.
17. D. Zilio et al. DB2 design advisor: Integrated automatic physical database design. In Proceedings of the International Conference on Very Large Databases (VLDB), 2004.
18. 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.