Autonomous query-driven index tuning

Proceedings of the International Database Engineering and Applications Symposium, IDEAS

Volumn , Issue , 2004, Pages 439-448

  Sattler, Kai Uwe ^a   Schallehn, Eike ^b   Geist, Ingolf ^b  

^a ILMENAU UNIVERSITY OF TECHNOLOGY   (Germany)

^b OTTO VON GUERICKE UNIVERSITY   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

AD-HOC QUERIES; EXECUTION TIMES; INDEX TUNING; MAINTENANCE COSTS;

AUTOMATION; COMPUTER SCIENCE; COMPUTER SOFTWARE MAINTENANCE; DATA ACQUISITION; DATA STRUCTURES; INDEXING (OF INFORMATION); OPTIMIZATION; PROBLEM SOLVING; STRUCTURED PROGRAMMING;

QUERY LANGUAGES;

EID: 5444239855     PISSN: 10988068     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/IDEAS.2004.1319819     Document Type: Conference Paper

References (19)

1. Oracle9i Database Online Documentation, Release 2 (9.2), 2002.
2. S. Chaudhuri and V. R. Narasayya. An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server. In VLDB'1997, pages 146-155, 1997.
3. S. Choenni, H. M. Blanken, and T. Chang. On the Selection of Secondary Indices in Relational Databases. DKE, 11(3):207-234, December 1993.
4. R. L. Cole and G. Graefe. Optimization of Dynamic Query Evaluation Plans. In SIGMOD'1994, pages 150-160, 1994.
5. S. J. Finkelstein, M. Schkolnick, and P. Tiberio. Physical Database Design for Relational Databases. TODS, 13(1):91-128, 1988.
6. G. Graefe. Dynamic Query Evaluation Plans: Some Course Corrections? Bulletin of the Technical Committee on Data Engineering, 23(2):3-6, June 2000.
7. H. Gupta, V. Harinarayan, A. Rajaraman, and J. D. Ullman. Index Selection for OLAP. In ICDE'1997, pages 208-219, 1997.
8. M. Hammer and A. Chan. Index Selection in a Self-Adaptive Data Base Management System. In SIGMOD'1976, pages 1-8, 1976.
9. V. Harinarayan, A. Rajaraman, and J. D. Ullman. Implementing Data Cubes Efficiently. In SIGMOD'1996, pages 205-216, 1996.
10. IEEE. Bulletin of the Technical Committee on Data Engineering, volume 22, June 1999.
11. N. Kabra and D. J. DeWitt. Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans. In SIGMOD'1998, pages 106-117, 1998.
12. T. Kraft, H. Schwarz, R. Rantzau, and B. Mitschang. Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences. In VLDB'2003, pages 488-499, 2003.
13. W. Labio, D. Quass, and B. Adelberg. Physical Database Design for Data Warehouses. In ICDE'1997, pages 277-288, 1997.
14. E. J. O'Neil, P. E. O'Neil, and G. Weikum. The LRU-K Page Replacement Algorithm For Database Disk Buffering. In SIGMOD'1993, pages 297-306, 1993.
15. S. Rozen and D. Shasha. A Framework for Automating Physical Database Design. In VLDB'1991, pages 401-411, 1991.
16. K. Sattler, I. Geist, and E. Schallehn. QUIET: Continuous Query-driven Index Tuning (Software Demonstration). In VLDB'2003, pages 1129-1132, 2003.
17. B. Schiefer and G. Valentin. DB2 universal Database Performance Tuning. Bulletin of the Technical Committee on Data Engineering, 22(2): 12-19, June 1999.
18. G. Valentin, M. Zuliani, D. Zilio, G. Lohman, and A. Skelley. DB2 Advisor An Optimizer Smart Enough to Recommend Its Own Indexes. In ICDE'2000, pages 101-110, Mar. 2000.
19. G. Weikum, A. Mönkeberg, C. Hasse, and P. Zabback. Self-tuning Database Technology and Information Services: From Wishful Thinking to Viable Engineering. In VLDB'2002, pages 20-31, 2002.