Automatic physical database tuning: A relaxation-based approach

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2005, Pages 227-238

  Bruno, Nicolas ^a   Chaudhuri, Surajit ^a  

^a MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTER ARCHITECTURE; DATA STRUCTURES; HEURISTIC PROGRAMMING; INPUT OUTPUT PROGRAMS; PROBLEM SOLVING; RELAXATION PROCESSES;

AUTOMATIC PHYSICAL DATABASE TUNING; PHYSICAL DESIGN; RELAXATION-BASED APPROACH;

DATABASE SYSTEMS;

EID: 29844447140     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1066157.1066184     Document Type: Conference Paper

References (12)

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 30th International Conference on Very Large Databases, 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, 2000.
3. S. Chaudhuri, R. Motwani, and V. Narasayya. On random sampling over joins. In Proceedings of the ACM International Conference on Management of Data, 1999.
4. S. Chaudhuri and V. Narasayya. An efficient cost-driven index selection tool for Microsoft SQL Server. In Proceedings of the 23rd International Conference on Very Large Databases, 1997.
5. S. Chaudhuri and V. Narasayya. Autoadmin 'What-if' index analysis utility. In Proceedings ACM SIGMOD International Conference on Management of Data, 1998.
6. S. Chaudhuri and V. Narasayya. Index merging. In Proceedings of the International Conference on Data Engineering, 1999.
7. B. Dageville, D. Das, K. Dias, K. Yagoub, M. Zait, and M. Ziauddin. Automatic SQL Tuning in Oracle 10g. In Proceedings of the 30th International Conference on Very Large Databases, 2004.
8. G. Graefe. The Cascades framework for query optimization. Data Engineering Bulletin, 18(3), 1995.
9. P. G. Selinger, M. M. Astrahan, D. D. Chamberlin, R. A. Lorie, and T. G. Price. Access path selection in a relational database management system. In Proceedings of the ACM International Conference on Management of Data, 1979.
10. 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, 2000.
11. 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 30th International Conference on Very Large Databases, 2004.
12. 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.