Replicação entre bases de dados oracle e os métodos de resolução de conflitos: caso prático da Mozal

Abstract

MOZAL is equipped with a very complex and modern technology and information systems infrastructure to respond to your need for information processing for the management of your aluminum production processes. Several database servers are installed at various locations in the company, exchanging data with each other via the computer network. This data exchange is guaranteed by the data replication mechanisms provided by the Database Management Systems installed on each server. Oracle presents different solutions for data replication that are presented throughout the work. Replication is the process of copying and maintaining objects from one database schema to another schema in multiple databases. The replication environment is more typical in asynchronous data transmission, in this case probable related conflicts can occur, thus, it is necessary to take respective conflict resolution methods. The importance of conflict resolution lies in ensuring data consistency. Once a conflict is detected, its resolution should be brief in order to avoid the cascading inconsistency effect, that is, conflicts can generate other conflicts and so on. MOZAL's information systems are divided into levels, according to their functionalities, namely level 0, I, II, III system. This classification is in accordance with Mozal's own convention used in the group of metal smelting companies belonging to Billiton. In this work, the support infrastructures for each level of systems and the interfaces between systems of the same level and of different levels are presented. It is in some of these interfaces that the data replication mechanisms are implemented. This work evaluates the aquetectura or model of the replication mechanisms and conflict resolution methods implemented in the interfaces between the data propagation systems and we propose to change the mechanisms as more suitable.