CPC G06F 16/27 (2019.01) [G06F 16/2386 (2019.01)] | 18 Claims |
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.
|