Autonomous management of soft indexes

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2007, Pages 450-458

  Lühring, Martin ^a   Sattler, Kai Uwe ^a   Schmidt, Karsten ^b   Schallehn, Eike ^c  

^a ILMENAU UNIVERSITY OF TECHNOLOGY   (Germany)

^b France   (Germany)

^c OTTO VON GUERICKE UNIVERSITY   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

INTERNET; INTERNET SERVICE PROVIDERS; PRODUCT DEVELOPMENT; PROJECT MANAGEMENT; QUERY PROCESSING; TECHNOLOGY;

CORE SYSTEMS; DATA ENGINEERING; DATABASE DESIGNS; INDEX GENERATION; INDEX SELECTION; INDEX TUNING; INTERNATIONAL CONFERENCES; ON-THE-FLY; OPTIMIZER; POSTGRESQL;

DATABASE SYSTEMS;

EID: 48349108204     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDEW.2007.4401028     Document Type: Conference Paper

References (19)

1. S. Agrawal, S. Chaudhuri, L. Kollár, A. P. Marathe, V. R. Narasayya, and M. Syamala. Database Tuning Advisor for Microsoft SQL Server 2005. In Proc. 30th VLDB Conference 2004, pages 1110-1121, 2004.
2. S. Agrawal, E. Chu, and V. R. Narasayya. Automatic Physical Design Tuning: Workload as a Sequence. In Proc. ACM SIGMOD Conference 2006, pages 683-694, 2006.
3. N. Bruno and S. Chaudhuri. Automatic Physical Database Tuning: a Relaxation-based Approach. In Proc. ACM SIGMOD Conference 2005, pages 227-238, 2005.
4. N. Bruno and S. Chaudhuri. To Tune or not to Tune? A Lightweight Physical Design Alerter. In Proc. 32nd VLDB Conference 2006, pages 499-510, 2006.
5. N. Bruno and S. Chaudhuri. An Online Approach to Physical Design Tuning. In Proc. Int. Conf. on Data Engineering (ICDE 2007), 2007. To appear.
6. A. Caprara, M. Fischetti, and D. Maio. Exact and Approximate Algorithms for the Index Selection Problem in Physical Database Design. IEEE Transactions on Knowledge and Data Engineering, 7(6):955-967, 1995.
7. S. Chaudhuri, M. Datar, and V. Narasayya. Index Selection for Databases: A Hardness Study and a Principled Heuristic Solution. IEEE Transactions on Knowledge and Data Engineering, 16(11): 1313-1323, 2004.
8. R. Cole and G. Graefe. Optimization of Dynamic Query Evaluation Plans. In ACM SIGMOD Conference 1994, pages 150-160, 1994.
9. D. Comer. The Difficulty of Optimum Index Selection. ACM Transactions on Database Systems, 3(4):440-445, 1978.
10. G. Graefe. Dynamic Query Evaluation Plans: Some Course Corrections? Bulletin of the Technical Committee on Data Engineering, 23(2):3-6, June 2000.
11. G. Graefe and K. Ward. Dynamic Query Evaluation Plans. In Proc ACM SIGMOD Conference 1989, pages 358-366, 1989.
12. H. Kellerer, U. Pferschy, and D. Pisinger. Knapsack Problems. Springer-Verlag, Berlin, Heidelberg. 2004.
13. J. O. Kephart and D. M. Chess. The Vision of Autonomic Computing. IEEE Computer, 36(1):41-50, 2003.
14. K. Sattler. I. Geist, and E. Schallehn. QUIET: Continuous Query-driven Index Tuning. In Proc. 29th VLDB Conference 2003, pages 1129-1132, 2003.
15. K. Sattler, E. Schallehn, and I. Geist. Autonomous Query-driven Index Tuning. In Proc Int. Database Engineering and Applications Symposium (IDEAS 2004). Coimbra, Portugal, pages 439-448, July 2004.
16. K. Schnaitter, S. Abiteboul, T Milo, and N. Polyzotis. COLT: Continuous On-line Tuning. In Proc ACM SIGMOD Conference 2006, pages 793-795, 2006.
17. G. Valentin, M. Zuliani, D. Zilio, G. Lohman, and A. Skelley. DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes. In Proc Int. Conference on Data Engineering (ICDE 2000), pages 101-110, 2000.
18. G. Weikum, C. Hasse, A. Moenkeberg, and P. Zabback. The COMFORT Automatic Tuning Project, Invited Project Review. Information Systems, 19(5):381-432, 1994.
19. D. C. Zilio, J. Rao, S. Lightstone, G. M. Lohman, A. Storm, C. Garcia-Arellano, and S. Fadden. DB2 Design Advisor: Integrated Automatic Physical Database Design. In Proc. 30th VLDB Conference 2004, pages 1087-1097, 2004.