Advertisement

DBSitter: An Intelligent Tool for Database Administration

  • Adriana Carneiro
  • Rômulo Passos
  • Rosalie Belian
  • Thiago Costa
  • Patrícia Tedesco
  • Ana Carolina Salgado
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3180)

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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Graves, M., Domsch, M., Kennedy, D.: HelpDesk A Multi Agent System – CS 367, Vanderbilt University (Spring 1998)Google Scholar
  2. 2.
    Expert Systems and Applied Artificial Intelligence, Turban, E. McMillan (1992)Google Scholar
  3. 3.
    Progress Software Corporation (1993), -2004. Last Access: 16 February 2004: http://www.progress.com/products/documentation/startffm/index.ssp
  4. 4.
    Oracle Corporation: Oracle Enterprise Manager Oracle Expert User’s Guide - Release 1.4.0 - A53653_01Google Scholar
  5. 5.
    Aamodt, A., Plaza, E.: Case-Based Reasoning: Foundational Issues, Methodological Variations, and System Approaches. AI Communications 7(1), 39–59 (1994)Google Scholar
  6. 6.
    Russel, S.J., Norvig, P.: Artificial Intelligence: A Modern Approach, 2nd edn. Prentice Hall, Englewood Cliffs (December 2002)Google Scholar
  7. 7.
    The Source for Java Technology, http://java.sun.com (Last Access: 21 September 2003)
  8. 8.
    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)CrossRefGoogle Scholar
  9. 9.
  10. 10.
    Computer Associates International (2004)Google Scholar
  11. 11.
    http://www3.ca.com/Solutions/Product.asp?ID=1357 (Last Access: 16 February 2004)
  12. 12.
    Hewlett-Packard Company (1994-2003). Last Access: 16 February 2004: http://www.openview.hp.com/products/dbpak2k/prod_dbpak2k_0003.html
  13. 13.
    BMC Software. BMC Patrol DB_Maintain (2004), http://www.bmc.com (Last Access: 19 February 2004)
  14. 14.
    Quest Software (1985-2004). Quest Central, http://www.quest.com/foglight (Last Access: 19 February 2004)
  15. 15.
    Mitchell, T.: Machine Learning. McGraw-Hill, New York (1997)zbMATHGoogle Scholar
  16. 16.
    Numerical Calculus: Theoretical and Computational Aspects. Márcia A. Gomes Ruggiero e Vera Lúcia da Rocha Lopes. Makron Books (1997) (in Portuguese)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • Adriana Carneiro
    • 1
  • Rômulo Passos
    • 1
  • Rosalie Belian
    • 1
  • Thiago Costa
    • 1
  • Patrícia Tedesco
    • 1
  • Ana Carolina Salgado
    • 1
  1. 1.Centro de InformáticaUniversidade Federal de PernambucoRecifeBrasil

Personalised recommendations