US 11,704,335 B2
Data synchronization in a data analysis system
Felix Beier, Haigerloch (DE); Dennis Butterstein, Stuttgart (DE); Sabine Perathoner-Tschaffler, Nufringen (DE); and Einar Lueck, Filderstadt (DE)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Nov. 13, 2020, as Appl. No. 17/97,848.
Prior Publication US 2022/0156277 A1, May 19, 2022
Int. Cl. G06F 16/00 (2019.01); G06F 16/27 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/27 (2019.01) [G06F 16/2386 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A computer implemented method for data synchronization in a data analysis system, the method comprising
receiving at least one log record, the log record describing an operation performed in a source database system of the data analysis system;
determining, based on the log record, a type of operation performed in the source database system;
based on the type of operation, selecting an update strategy from a set of pre-defined update strategies, the update strategy specifying a sequence of replication operations to be performed in order to apply changes described in the at least one log record to a target database system of the data analysis system; and
determining a class of a change record of the log record, wherein the class is determinable as being a regular class, a structural change class, and a utility action class;
wherein the update strategy uses:
a regular record add, delete, or update operation for the class determined to be a regular class;
a bulk load of the target database system with data originating from the source database system for the class determined to be a structural change class; and
a suspension operation for suspending modifications of a certain table of the target database system for the class determined to be a utility action class.