Investigation on Oracle GoldenGate Veridata for Data Consistency in WLCG Distributed Database Environment

Abstract

In the distributed database environment, the data divergence can be an important problem: if it is not discovered and correctly identified, incorrect data can lead to poor decision making, errors in the service and in the operative errors. Oracle GoldenGate Veridata is a product to compare two sets of data and identify and report on data that is out of synchronization. IT DB is providing a replication service between databases at CERN and other computer centers worldwide as a part of the WLCG project. One of the important and difficult tasks in provisioning of a reliable replication service is to measure and ensure consistency of data between databases. Oracle Veridata appears to be a promising solution for this challenge. The aim of the project is to evaluate the Oracle Veridata framework in the context of the WLCG database replication environment, to provide a study and feedback regarding functionality, usability and performance of the software for data consistency measuring between remote databases.