Desenvolvimento de protótipo para gestão de replicação entre bases de dados remotas

Abstract

Data availability is a highly relevant topic, especially regarding its high quality for various applications, which often require immediate access. In distributed systems, data may be located in places different from where applications are executed, making it necessary to develop efficient management techniques to ensure the availability and access to such data. This work conducts research on the characteristics of relational and distributed Database Management Systems (DBMS), focusing primarily on the native replication techniques present in the most widely used DBMSs on the market. Informix is a relational DBMS that supports data replication but under the management of a Database Administrator (DBA). The objective of this work is to develop a middleware prototype accessed in a WEB environment, divided into backend and frontend, integrated with an Enterprise Resource Planning (ERP) system of Informix, to serve as a complementary tool for centralizing maintenance involving replication structures within a company. The prototype provides a data visualization interface for specific developers responsible for each work team, aiming to monitor the processes. The developed prototype is already being used in the company and is currently undergoing approval testing. [resumo fornecido pelo autor]