Abstract
Database administration routines involve manual or semi-automatic methods for monitoring the environment and solving problems that arise. In this work, we propose a novel alternative approac h to this task, which unifies two Artificial Intelligence techniques: Case Based Reasoning and Intelligent Agents. Our prototype, DBSitter, consists of a Multi-agent system for automatic monitoring and fault correcting in a relational DBMS, where problems are represented as Cases. In searching for better solutions, the system can also interact with the Database Administrator. The main functionalities provided are failure prediction and adaptation of problem – solving capabilities through the chosen learning mechanism.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Graves, M., Domsch, M., Kennedy, D.: HelpDesk A Multi Agent System – CS 367, Vanderbilt University (Spring 1998)
Expert Systems and Applied Artificial Intelligence, Turban, E. McMillan (1992)
Progress Software Corporation (1993), -2004. Last Access: 16 February 2004: http://www.progress.com/products/documentation/startffm/index.ssp
Oracle Corporation: Oracle Enterprise Manager Oracle Expert User’s Guide - Release 1.4.0 - A53653_01
Aamodt, A., Plaza, E.: Case-Based Reasoning: Foundational Issues, Methodological Variations, and System Approaches. AI Communications 7(1), 39–59 (1994)
Russel, S.J., Norvig, P.: Artificial Intelligence: A Modern Approach, 2nd edn. Prentice Hall, Englewood Cliffs (December 2002)
The Source for Java Technology, http://java.sun.com (Last Access: 21 September 2003)
Figueira Filho, C., Ramalho, G.: JEOPS – Java Embedded Object Production System. In: Monard, M.C., Sichman, J.S. (eds.) SBIA 2000 and IBERAMIA 2000. LNCS (LNAI), vol. 1952, pp. 53–62. Springer, Heidelberg (2000)
IBM (2004), http://www.ibm.com/br/products/software/tivoli/products/monitor-db/ (Last Access: 16 February 2004)
Computer Associates International (2004)
http://www3.ca.com/Solutions/Product.asp?ID=1357 (Last Access: 16 February 2004)
Hewlett-Packard Company (1994-2003). Last Access: 16 February 2004: http://www.openview.hp.com/products/dbpak2k/prod_dbpak2k_0003.html
BMC Software. BMC Patrol DB_Maintain (2004), http://www.bmc.com (Last Access: 19 February 2004)
Quest Software (1985-2004). Quest Central, http://www.quest.com/foglight (Last Access: 19 February 2004)
Mitchell, T.: Machine Learning. McGraw-Hill, New York (1997)
Numerical Calculus: Theoretical and Computational Aspects. Márcia A. Gomes Ruggiero e Vera Lúcia da Rocha Lopes. Makron Books (1997) (in Portuguese)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Carneiro, A., Passos, R., Belian, R., Costa, T., Tedesco, P., Salgado, A.C. (2004). DBSitter: An Intelligent Tool for Database Administration. In: Galindo, F., Takizawa, M., Traunmüller, R. (eds) Database and Expert Systems Applications. DEXA 2004. Lecture Notes in Computer Science, vol 3180. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30075-5_17
Download citation
DOI: https://doi.org/10.1007/978-3-540-30075-5_17
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22936-0
Online ISBN: 978-3-540-30075-5
eBook Packages: Springer Book Archive