International Business Machines Corporation
REPLICATING DATA CHANGES OF A SOURCE DATABASE IN A TARGET DATABASE USING DATA CHANGE RECORDS AND RUNTIME STATISTICS OF THE SOURCE DATABASE

Abstract:

The present disclosure relates to a computer implemented method for replicating data changes of a source table in a target table. Methods, computer program products, and/or systems are provided that perform the following operations: loading first runtime statistics about processing the data changes of the source table at a first point of time; repeatedly generating data change records while performing the data changes of the source table, the data change records comprising information about the data changes of the source table; storing the data change records on a storage device; loading second runtime statistics about processing the data changes of the source table at a second point of time; and selecting a type of data replication from a first type of data replication and a second type of data replication depending on the first runtime statistics and the second runtime statistics.