An online approach to physical design tuning

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2007, Pages 826-835

  Bruno, Nicolas ^a   Chaudhuri, Surajit ^a  

^a MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; CONSTRAINT THEORY; DATABASE SYSTEMS; PROBLEM SOLVING; QUERY PROCESSING;

OFFLINE INVOCATIONS; PHYSICAL DESIGN TUNING; STORAGE CONSTRAINTS; TUNING TOOL;

ONLINE SYSTEMS;

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

References (11)

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 30th International Conference on Very Large Databases (VLDB), 2004.
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 32th International Conference on Very Large Databases, 2006.
7. 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 (VLDB), 1997.
8. B. Dageville et al. Automatic SQL Tuning in Oracle 10g. In Proceedings of the 30th International. Conference on Very Large Databases (VLDB), 2004.
9. K.-U. Sattler, I. Geist, and E. Schallehn. Quiet: Continuous query-driven index tuning. In Proceedings of the International Conference on Very Large Databases (VLDB), 2003.
10. K. Schnaitter et al. Colt: continuous on-line tuning. In Proceedings of the ACM International Conference on Management of Data (SIGMOD), 2006.
11. D. Zilio et al. DB2 design advisor: Integrated automatic physical database design. In Proceedings of the 30th International Conference on Very Large Databases (VLDB), 2004.