CERN Accelerating science

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

Date published: 
Monday, 1 September, 2014
Document type: 
Summer student report
Author(s): 
A. Asko
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.