Ferramenta para visualização das dependências entre objetos em um banco de dados e simulação de alterações nos objetos.

Abstract

In the context of database systems, both the development and the maintenance are process that dictates changings in its models. These changings have consequences in the entire system. The physic, logic and conceptual models owns versions that vary as the system evolves. The way as the development team or database administrators (DBA’s) visualizes the system, more specifically the relationships between the objects of the system, have direct effects in the management of the system. Therefore, it was developed a web application that allows the visualization of those relationships and shows to the user the objects that would have any side effect if any other object of the system changes. For this work’s scope, it was only considered side effects from the DROP operation over any object of the database management system Oracle Autonomous Data Warehouse, from Oracle Cloud service. This tool show itself fundamentally useful in the database systems maintenance.