AutonomousDB: uma ferramenta para propagaÃÃo autÃnoma de atualizaÃÃes de esquemas de dados

AUTOR(ES)
DATA DE PUBLICAÇÃO

2009

RESUMO

One of the biggest challenge of building and maintaining applications with long life cycles is dealing with the inevitable changes in requirements that occur over time. Many of these applications depend on DBMS that most often suffer direct consequences in their databases schemas due to changes in the reality that they model. This changes must be controlled because any bad managed evolution can cause serious concistency problems for schemas or data. In this work, we propose a new alternative for decreasing schema evolution problems in distributed environments. It uses concepts of Autonomic Computing in DBMS to propagate updates in schemas replicated within the same environment, thus ensuring their consistency. The prototype includes a flexible architecture and a Multi-Agent System, which executes events for updating schemas in the target DBMS. The distributed environment may have several databases in different platforms. Thus, repetitive tasks which are performed by DBA to ensure the evolution in all copies of a specific changed schema are thus eliminated. This will free the DBA to do other tasks that are more important, such as: analysis, database design and strategic management of data, decreasing the probability of human failures

ASSUNTO(S)

schema evolution evoluÃÃo de esquemas sistemas autÃnomos update propagation propagaÃÃo de atualizaÃÃes banco de dados autonomic systems

Documentos Relacionados