IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

ADAM: An Autonomic Approach to Database Management

ADAM: An Autonomic Approach to Database Management
View Sample PDF
Author(s): Sunitha Ramanujam (University of Western Ontario, Canada)and Miriam Capretz (University of Western Ontario, Canada)
Copyright: 2007
Pages: 29
Source title: Application of Agents and Intelligent Information Technologies
Source Author(s)/Editor(s): Vijayan Sugumaran (Oakland University, Rochester, USA)
DOI: 10.4018/978-1-59904-265-7.ch010

Purchase

View ADAM: An Autonomic Approach to Database Management on the publisher's website for pricing and purchasing information.

Abstract

In recent years, the emergence of the Internet has resulted in a proliferation of data. This in turn has given rise to increasing demands of organizations to access accurate information swiftly and efficiently. Thus, the scope of functions for databases has expanded more than ever and the complexity of database systems has grown accordingly. Consequently, the burden on database administrators (DBAs) has increased significantly. The objective of this research is to address and propose a solution to overcome this problem of overburdened and expensive DBAs. This chapter focuses on relational database management systems in particular and proposes a novel and innovative multiagent system (MAS) that would autonomously and rationally administer and maintain databases. The proposed multi-agent system tool, ADAM (a MAS for autonomous database administration and maintenance), is in the form of a self-administering wrapper around database systems and it addresses, and offers a solution to, the problem of overburdened and expensive DBAs with the objective of making databases a cost-effective option for small/medium-sized organizations. An implementation of the agent-based system to proactively or reactively identify and resolve a small subset of DBA tasks is discussed and the GAIA methodology is used to outline the detailed analysis and design of the same. Role models describing the responsibilities, permissions, activities, and protocols of the candidate agents, and interaction models representing the links between the roles are explained. The coordinated intelligent rational agent model is used to describe the agent architecture and a brief description of the functionalities, responsibilities, and components of each agent type in the ADAM multiagent system is presented. Finally, a prototype system implementation using JADE 2.5 and Oracle 8.1.7 is presented as evidence of the feasibility of the proposed agent-based solution for the autonomous administration and maintenance of relational databases.

Related Content

Rafael Martí, Juan-José Pantrigo, Abraham Duarte, Vicente Campos, Fred Glover. © 2013. 21 pages.
Peng-Yeng Yin, Fred Glover, Manuel Laguna, Jia-Xian Zhu. © 2013. 20 pages.
Volodymyr P. Shylo, Oleg V. Shylo. © 2013. 10 pages.
Tabitha James, Cesar Rego. © 2013. 19 pages.
Gary G. Yen, Wen-Fung Leong. © 2013. 25 pages.
Shi Cheng, Yuhui Shi, Quande Qin. © 2013. 29 pages.
Xin-She Yang. © 2013. 12 pages.
Body Bottom