Paper Info
Title
Autonomic Computing in SQL Server
Abstract
With the growing size of enterprise data, the task of managing a database is becoming more and more complex as well as time-consuming. A database administrator spends most of his time in activities that can be made automatic. Also, scarcity of skilled database administrators have motivated the database industry to develop Autonomic Database Management Systems (ADBMS) which can alleviate many of the database administrators’ problems. These ADBMS may have one or more autonomic properties. In this paper, autonomic characteristics of Microsoft SQL Server are presented and analyzed to illustrate how self-managing behaviour of an ADBMS can reduce the workload of a DBA significantly. It has also been discussed which components of SQL Server are not fully autonomic and require Human Intervention. This provides the motivation for devising algorithms to further reduce the degree of human intervention still required in ADBMS.
Year
DOI
Venue
2008
10.1109/ICIS.2008.111
ACIS-ICIS
Keywords
Field
DocType
autonomic computing,skilled database administrator,database industry,devising algorithm,autonomic property,autonomic database management systems,microsoft sql server,sql server,database administrator,autonomic characteristic,human intervention,database management system,technology management,information science,sql,information analysis,high performance computing,database systems,design optimization,optimization,pattern recognition,database management systems
SQL,Autonomic computing,Sql server,Scarcity,Workload,Computer science,Database administrator,Enterprise data management,Database
Conference
Citations 
PageRank 
References 
6
0.45
7
Authors
4
Name
Order
Citations
PageRank
Abdul Mateen1195.79
Basit Raza24310.67
Tauqeer Hussain3214.15
M. M. Awais4162.08