Automatic physical design tuning: Workload as a sequence

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2006, Pages 683-694

  Agrawal, Sanjay ^a   Chu, Eric ^b   Narasayya, Vivek ^a  

^a MICROSOFT RESEARCH   (United States)

^b University of Wisconsin Madison   (United States)

Author keywords

Physical design; Sequence; Tuning; Workload

Indexed keywords

COMPUTER AIDED SOFTWARE ENGINEERING; COST REDUCTION; OPTIMIZATION; SOFTWARE DESIGN; TUNING;

DATABASE VENDORS; PHYSICAL DATABASE; PHYSICAL DESIGN; SQL STATEMENTS;

DATABASE SYSTEMS;

EID: 34250634497     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1142473.1142549     Document Type: Conference Paper

References (16)

1. Agrawal, S., Chaudhuri S., Kollar L., Marathe A., Narasayya V., and Syamala M. Database Tuning Advisor for Microsoft SQL Server 2005. In Proceedings of VLDB (2004). 1110-1121.
2. Agrawal, S., Narasayya, V., and Yang, B. Integrating Vertical and Horizontal Partitioning Into Automated Physical Database Design. In Proceedings of ACM SIGMOD (2004). 359-370.
3. Bruno N., and Chaudhuri S. Automatic Physical Design Tuning: A Relaxation Based Approach. In Proceedings of ACM SIGMOD (2005). 227-238.
4. Chaudhuri, S., König, A., and Narasayya, V. SQLCM: A Continuous Monitoring Framework for Relational Database Engines. In Proceedings of ICDE (2004). 473-485.
5. Chaudhuri, S., and Narasayya, V. An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server. In Proceedings of VLDB (1997). 146-155..
6. Cormen, T., Leiserson C., and Rivest R. Introduction to Algorithms. MIT Press Edition. Twenty-third printing, 1999. 536-537.
7. Dageville B., Das D., Dias K., Yagoub K., Zait M., and Ziauddin M. Automatic SQL Tuning in Oracle 10g. In Proceedings of VLDB (2004). 1098-1109.
8. Gupta H., Harinarayan V., Rajaramana A., and Ullman J.D. Index Selection for OLAP. In Proceedings of ICDE (1997). 208-219.
9. Hammer M, and Chan A. Index selection in a self-adaptive data base management system. In Proceedings of ACM SIGMOD (1976). 1-8.
10. Oracle Tuning Pack, www.oracle.com/technology/products/manageability/ database/pdf/ds/tuning_pack_ds_10grl.pdf.
11. Rao J., Zhang C., Meggido N., and Lohman G. Automating Physical Database Design in a Parallel Database. In Proceedings of ACM SIGMOD (2002). 558-569.
12. Rozen S. Automating Physical Database Design; An extensible approach, PhD Thesis, New York Univ. (1993).
13. Sattler K.,Geist I., and Schallen E. QUIET: Continuous Query-driven Index Tuning. In Proceedings of VLDB (2003). 1129-1132.
14. TPC Benchmark H. Decision Support, http://www.tpc.org.
15. Valentin, G., Zuliani, M., Zilio, D., and Lohman, G. DB2 Advisor: An Optimizer That is Smart Enough to Recommend Its Own Indexes. In Proceedings of ICDE (2000). 101-110.
16. Zilio, D., Rao J., Lightstone S., Lohman G., Storm A., Garcia-Arellano C., and Fadden S. DB2 Design Advisor. Integrated Automatic Physical Database Design. In Proceedings of VLDB (2004). 1087-1097.