An integrated approach to performance monitoring for autonomous tuning

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2009, Pages 1671-1678

  Thiem, Alexander ^a   Sattler, Kai Uwe ^b  

^a Ingres Germany GmbH   (Germany)

^b ILMENAU UNIVERSITY OF TECHNOLOGY   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

AUTOMATED PROCESS; COST FACTORS; DATA RESOLUTIONS; DATA VOLUME; INTEGRATED APPROACH; PERFORMANCE MONITORING; PERFORMANCE TUNING; PHYSICAL DATABASE; PROBLEM IDENTIFICATION; RELATIONAL DATABASE MANAGEMENT SYSTEMS; USAGE SCENARIOS; WORK-FLOWS;

AUTOMATION; FREQUENCY ALLOCATION; MANAGEMENT INFORMATION SYSTEMS; TUNING;

RELATIONAL DATABASE SYSTEMS;

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

References (18)

1. M. Stonebraker, Ed., The INGRES Papers: Anatomy of a Relational Database System. Addison-Wesley, 1986.
2. E. F. Codd, "A Relational Model of Data for Large Shared Data Banks," Commun. ACM, vol. 13, no. 6, pp. 377-387, 1970.
3. J. Peel, "Ingres: Re-Opened, Innovating and in Business," Datenbank- Spektrum, vol. 7, no. 22, pp. 13-19, 2007.
4. A. Skelley, "DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes," in ICDE '00: Proceedings of the 16th International Conference on Data Engineering. Washington, DC, USA: IEEE Computer Society, 2000, p. 101.
5. S. Agrawal, S. Chaudhuri, and V. R. Narasayya, "Automated Selection of Materialized Views and Indexes in SQL Databases," in VLDB '00: Proceedings of the 26th International Conference on Very Large Data Bases. San Francisco, CA, USA: Morgan Kaufmann Publishers Inc., 2000, pp. 496-505.
6. D. C. Zilio, J. Rao, S. Lightstone, G. Lohman, A. Storm, C. Garcia- Arellano, and S. Fadden, "DB2 design advisor: integrated automatic physical database design," in VLDB '04: Proceedings of the Thirtieth international conference on Very large data bases. VLDB Endowment, 2004, pp. 1087-1097.
7. N. Bruno and S. Chaudhuri, "To tune or not to tune?: a lightweight physical design alerter," in VLDB '06: Proceedings of the 32nd international conference on Very large data bases. VLDB Endowment, 2006, pp. 499-510.
8. S. Chaudhuri and N. Bruno, "An Online Approach to Physical Design Tuning," in ICDE '07: Proceedings of the 23rd International Conference on Data Engineering. Washington, DC, USA: IEEE Computer Society, 2007, pp. 826-835.
9. K. Schnaitter, S. Abiteboul, T. Milo, and N. Polyzotis, "Colt: continuous on-line tuning," in SIGMOD '06: Proceedings of the 2006 ACM SIGMOD international conference on Management of data. New York, NY, USA: ACM, 2006, pp. 793-795.
10. K. Sattler, I. Geist, and E. Schallehn, "QUIET: Continuous Query-driven Index Tuning," in Proceedings of 29th International Conference on Very Large Data Bases (VLDB), Berlin, Germany, 2003, pp. 1129-1132.
11. K. Dias, M. Ramacher, U. Shaft, V. Venkataramani, and G. Wood, "Automatic Performance Diagnosis and Tuning in Oracle." in CIDR, 2005, pp. 84-94.
12. W.-J. Chen, U. Baumbach, M. Miskimen, and W. Wicke, DB2 Performance Expert for Multiplatforms V2.2 (IBM Redbooks). IBM Press, 2004.
13. S. Chaudhuri, A. C. König, and V. Narasayya, "SQLCM: A Continuous Monitoring Framework for Relational Database Engines," in ICDE '04: Proceedings of the 20th International Conference on Data Engineering. Washington, DC, USA: IEEE Computer Society, 2004, p. 473.
14. S. Chaudhuri and V. Narasayya, "AutoAdmin "what-if" index analysis utility," SIGMOD Rec., vol. 27, no. 2, pp. 367-378, 1998.
15. G. Graefe, "Dynamic Query Evaluation Plans: Some Course Corrections?" Bulletin of the Technical Committee on Data Enigneering, vol. 23, no. 2, pp. 3-6, 2000.
16. S. Idreos, M. L. Kersten, and S. Manegold, "Database Cracking," in Proceedings of the Biennial Conference on Innovative Data Systems Research (CIDR), Asilomar, CA, USA, January 2007.
17. M. P. Consens, D. Barbosa, A. Teisanu, and L. Mignet, "Goals and benchmarks for autonomic configuration recommenders," in SIGMOD '05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data. New York, NY, USA: ACM, 2005, pp. 239- 250, http://www.cs.toronto.edu/ consens/tab/. Link visited 30 Apr 2008.
18. G. Haber, "Economic Impact of the Austrian Software Industry," 2003, http://www.econ.uni-klu.ac.at/eis2003a/, summary of the study, page 4. Link visited 16 Aug 2008.