Today's DBMSs: how autonomic are they

The increasing complexity of database management systems (DBMSs) and the dearth of their experienced administrators make an urgent call for an autonomic DBMS that is capable of managing and maintaining itself. In this paper, we examine the characteristics that a DBMS should have in order to be considered autonomic and assess the position of today's commercial DBMSs such as DB2, SQL Server, and Oracle.

[1]  Julie A. McCann,et al.  The Database Machine: Old Story, New Slant? , 2003, CIDR.

[2]  Daniel C. Zilio,et al.  DB2 advisor: an optimizer smart enough to recommend its own indexes , 2000, Proceedings of 16th International Conference on Data Engineering (Cat. No.00CB37073).

[3]  Carl E. Landwehr,et al.  Formal Models for Computer Security , 1981, CSUR.

[4]  Surajit Chaudhuri,et al.  Self-tuning histograms: building histograms without looking at data , 1999, SIGMOD '99.

[5]  Hamid Pirahesh,et al.  A rule engine for query transformation in Starburst and IBM DB2 C/S DBMS , 1997, Proceedings 13th International Conference on Data Engineering.

[6]  Volker Markl,et al.  LEO - DB2's LEarning Optimizer , 2001, VLDB.

[7]  Surajit Chaudhuri,et al.  Automated Selection of Materialized Views and Indexes in SQL Databases , 2000, VLDB.

[8]  Ramakrishnan Srikant,et al.  Hippocratic Databases , 2002, VLDB.

[9]  Guy M. Lohman,et al.  Query Optimization in the IBM DB2 Family. , 1993 .

[10]  Gary Valentin,et al.  DB2 Universal Database Performance Tuning , 1999, IEEE Data Eng. Bull..

[11]  Thomas A. Corbi,et al.  The dawning of the autonomic computing era , 2003, IBM Syst. J..

[12]  Gerhard Weikum,et al.  Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering , 2002, VLDB.

[13]  Anastasia Ailamaki,et al.  A Case for Staged Database Systems , 2003, CIDR.

[14]  Eva Kwan,et al.  Automatic Configuration for IBM ® DB2 Universal , 2002 .

[15]  Said Elnaffar,et al.  Characterizing Computer Systems' Workloads , 2002 .

[16]  Sam Lightstone,et al.  SMART: Making DB2 (More) Autonomic , 2002, VLDB.

[17]  Silvana Castano,et al.  Database Security , 1997, IFIP Advances in Information and Communication Technology.

[18]  Said Elnaffar,et al.  Automatically classifying database workloads , 2002, CIKM '02.

[19]  Chun Zhang,et al.  Automating physical database design in a parallel database , 2002, SIGMOD '02.

[20]  Surajit Chaudhuri,et al.  Automating Statistics Management for Query Optimizers , 2001, IEEE Trans. Knowl. Data Eng..

[21]  Philip A. Bernstein,et al.  Applying Model Management to Classical Meta Data Problems , 2003, CIDR.

[22]  Hamid Pirahesh,et al.  Extensible/rule based query rewrite optimization in Starburst , 1992, SIGMOD '92.

[23]  Said Elnaffar,et al.  A methodology for auto-recognizing DBMS workloads , 2002, CASCON.