Uma ferramenta para detecção e análise de impactos na evolução de esquemas de Dados em SGBDs relacionais

Abstract

One of the main activities related to the construction and maintenance of information systems is the artifacts adjustment due to changes that occur over time. A particular type of change that directly affects the application code is the evolution of database schemas. Modifying a schema implies modifying systems that rely on the database. For this, it is necessary to evaluate the impact of the evolution of a scheme, in other words, identify all system locations that may be affected by every change in the scheme, to adapt them to the new reality. Manually performing the detection of impacts is a difficult task that takes time and costs and can cause damage. In this paper, we propose a tool to aid the detection and analysis of impacts in the evolution of data schemas in relational DBMSs. Through a systematic approach to relate artifacts and schema objects, the tool evaluates, by comparing baselines, the impact that changes in a data schema may cause in the environment of an information system.