Autonomic Success in Database Management Systems

One of the primary uses of computer is to reduce cost and manage complexity with increase in efficiency and performance. Now system complexity is reaching a level that is beyond human ability. With the development of technology, people want to manage complex systems in an efficient and reliable manner. Development of raw computing power and proliferation of computer devices and usage of internet has grown up to exponential rates. This growth and unprecedented levels of complexity is leading towards new direction - Autonomic Computing. Autonomic features in system increase speed, efficiency, reliability and accuracy with less or no human interaction, ultimately providing error free environment. These autonomic capabilities are important in Database Management Systems (DBMSs). The DBMSs which have the capability to manage and maintain themselves are called Autonomic Database Management Systems (ADBMS). The ADBMSs are evolving from last many years. At present most of the activities in DBMS are performed autonomically and have achieved certain level of autonomicity. The paper identified some autonomic shortcomings in commercial DBMSs up to 2002. We made a survey on achievements of autonomic computing against these shortcomings in current DBMSs. For this purpose, we have studied and analyzed IBM DB2, Oracle and Microsoft SQL Server.

[1]  Surajit Chaudhuri,et al.  Database tuning advisor for microsoft SQL server 2005: demo , 2005, SIGMOD '05.

[2]  Said Elnaffar,et al.  Today's DBMSs: how autonomic are they , 2003, 14th International Workshop on Database and Expert Systems Applications, 2003. Proceedings..

[3]  Benoît Dageville,et al.  Self-Tuning for SQL Performance in Oracle Database 11g , 2009, 2009 IEEE 25th International Conference on Data Engineering.

[4]  Peter J. Haas,et al.  Automated Statistics Collection in DB2 UDB , 2004, VLDB.

[5]  Sam Lightstone,et al.  DB2 Design Advisor: Integrated Automatic Physical Database Design , 2004, VLDB.

[6]  Surajit Chaudhuri,et al.  Database Tuning Advisor for Microsoft SQL Server 2005 , 2004, VLDB.

[7]  Richard Murch,et al.  Autonomic Computing , 2004 .

[8]  Erhard Rahm,et al.  An online bibliography on schema evolution , 2006, SGMD.

[9]  Marc Holze,et al.  Towards workload shift detection and prediction for autonomic databases , 2007, PIKM '07.

[10]  Yun Wang.  DB2 Query Parallelism: Staging and Implementation , 1995, VLDB.

[11]  M. Dobson,et al.  The ATLAS DAQ System Online Configurations Database Service Challenge , 2007, 2007 15th IEEE-NPSS Real-Time Conference.

[12]  Jana Koehler,et al.  On Autonomic Computing Architectures , 2003 .

[13]  Mian M. Awais,et al.  Autonomic Computing in SQL Server , 2008, Seventh IEEE/ACIS International Conference on Computer and Information Science (icis 2008).

[14]  Matthias Jarke,et al.  Query Optimization in Database Systems , 1984, CSUR.

[15]  Farokh B. Bastani,et al.  Introducing the New Editor-in-Chief of the IEEE Transactions on Knowledge and Data Engineering , 2001, IEEE Trans. Knowl. Data Eng..

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

[17]  Said Elnaffar,et al.  Towards workload-aware dbmss: identifying workload type and predicting its change , 2004 .

[18]  Sam Lightstone,et al.  Automatic Database Configuration for DB2 Universal Database: Compressing Years of Performance Expertise into Seconds of Execution , 2003, BTW.

[19]  Sam Lightstone,et al.  Adaptive self-tuning memory in DB2 , 2006, VLDB.

[20]  Petr Jan Horn,et al.  Autonomic Computing: IBM's Perspective on the State of Information Technology , 2001 .

[21]  Hausi A. Müller,et al.  Bits of History, Challenges for the Future and Autonomic Computing Technology , 2006, 2006 13th Working Conference on Reverse Engineering.

[22]  David L. Cohn,et al.  Autonomic Computing , 2003, ISADS.

[23]  Said Elnaffar,et al.  Workload Models for Autonomic Database Management Systems , 2006, International Conference on Autonomic and Autonomous Systems (ICAS'06).

[24]  Benoît Dageville,et al.  Automatic SQL Tuning in Oracle 10g , 2004, VLDB.

[25]  Sam Lightstone,et al.  Toward autonomic computing with DB2 universal database , 2002, SGMD.

[26]  Patrick Martin,et al.  Workload adaptation in autonomic DBMSs , 2006, CASCON.

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

[28]  Jeffrey O. Kephart,et al.  An architectural approach to autonomic computing , 2004, International Conference on Autonomic Computing, 2004. Proceedings..