DBSitter: An Intelligent Tool for Database Administration

Carneiro, Adriana; Passos, Romulo; Belian, Rosalie Barreto; Costa, Thiago V.; Tedesco, Patrícia; Salgado, Ana Carolina

doi:10.1007/978-3-540-30075-5_17

Cited by 6 publications

(3 citation statements)

References 2 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The main principle of these systems is to suggest solutions to correct detected failures based on information already stored in a Knowledge Base. Some solutions exist with a learning mechanism to suggest the most adequate solution to each detected problem like in DBSitter which is based on the combination of two methods: (1) Case Based Reasoning (CBR) to adapt known solutions and enrich the Knowledge Base (2) Mutli-Agent where a set of intelligent agents is used to monitor the Database environment and actuate on it [9]. Other recent research works uses Policy-based computing to implement autonomic administration capabilities into a database for enforcing policies to control and decide which changes are allowed and which ones are not.…”

Section: Related Workmentioning

confidence: 99%

Procedure contextualization based on collaborative database administration

Tahir¹,

Brézillon²

2011

Proceedings of the 2011 15th International Conference on Computer Supported Cooperative Work in Design (CSCWD)

View full text Add to dashboard Cite

Database administration tasks often involve several actors within the organization. The main actor is the database administrator (DBA) who interacts with other DBAs and with other actors. Thus, sharing knowledge among them is crucial. This knowledge relies on each member's skills, experiences and background, and also on the common activities, conditions, facts, and situations faced during the administration of the database and the setting of the environment. Exchanging knowledge between the DBA and the other actors can only be effective if there is a common interpretive focus and a shared context where they can understand each other and exchange their experiences. The concept of context plays an important role in collaboration, especially in communication, interaction and knowledge sharing. In addition, and under temporal and financial pressures, this can help a DBA in avoiding misunderstandings and accidents such asdestroying each other's work or imposed system downtime. The paper presents how collaboration improves the contextualization of DBA procedures and the development of the DBA practices. Our work focuses on collaboration between actors with different roles according to an internal observation that is to say from the point of view of the main actor (i.e. DBA) to help him achieve his objective. This is a key element in the building of a support system for DBA acting as a real context-based intelligent assistant system based on a collaborative work. Contextual Graphs are used to illustrate the collaborative approach to database administration tasks.

show abstract

Section: Related Workmentioning

confidence: 99%

Procedure contextualization based on collaborative database administration

Tahir¹,

Brézillon²

2011

Proceedings of the 2011 15th International Conference on Computer Supported Cooperative Work in Design (CSCWD)

View full text Add to dashboard Cite

show abstract

“…Multi-agent system is another approach that has been used to build tools for database administrators (i.e. DBSitter as in [8]) and to support the design process involving many actors [14]. Moraes et al [16] proposed a software tool called AutonomousDB that supports the task of schema evolution in heterogeneous multi-database environments where there are replicated schemas.…”

Section: Related Workmentioning

confidence: 99%

Shared Context for Improving Collaboration in Database Administration

Tahir¹,

Brézillon²

2013

IJDMS

View full text Add to dashboard Cite

show abstract

“…Carneiro et al [4] propose the DBSitter approach that uses a multi-agent framework to collect data on the operational status of a DBMS. The data is analysed by a reasoning agent and the problems are either corrected automatically or presented to the DBA with a set of possible options.…”

Section: Introductionmentioning

confidence: 99%