Evolution of autonomic Database Management Systems

The evolution of computer is started from human dependent to self-management. With the development of technology, people want to manage the complex systems in an efficient and reliable manner. Database Management Systems (DBMSs) started from the single user with limited operations; and with the passage of time more functionality is added to meet the need of the users. Maximum number of operations, huge volume and multi-user environment also increased the complexity. Due to complexity and heterogeneity, job of DBAs become difficult and laborious. The solution to these DBMS´s problems is self-managing or autonomic DBMS (ADBMS). An ADBMS have the ability to adopt changes according to the environment and available resources without or with less human intervention. This paper examines the three commercial leading DBMSs, IBM´s DB2, Oracle by Oracle Corporation and Microsoft SQL Server with respect to autonomic characteristics. On the basis of analysis and other parameters autonomic computing (AC) maturity value is assigned to each autonomic component of three DBMSs. At the end, the evolving status of AC in DBMSs is presented.