US 12,254,024 B2
Conditional replication of data
Reinhold Geiselhart, Rottenburg-Ergenzingen (DE); Frank Küster, Großbottwar (DE); Juergen Schimpf, Schoenaich (DE); and Rene Blath, Weil im Schoenbuch (DE)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Jun. 15, 2022, as Appl. No. 17/806,963.
Prior Publication US 2023/0409594 A1, Dec. 21, 2023
Int. Cl. G06F 16/30 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/27 (2019.01) 15 Claims
OG exemplary drawing
 
1. A computer implemented method for synchronizing a first database with a second database, the first database comprising a set of attributes stored in a table with corresponding attribute values, the computer implemented method comprising a replication method comprising:
reading a first log entry in a transaction log that indicates a first attribute value change within the table of the first database;
determining that the first attribute value change of a selected attribute of the set of attributes in the first database fulfils a defined tolerance range based on the first attribute value change within the table of the first database;
preventing replication of the first attribute value change to the second database in response to determining that the first attribute value change fulfils the tolerance range;
reading a second log entry in the transaction log that indicates a second attribute value change within the table of the first database;
determining that the second attribute value change of the selected attribute in the first database does not fulfil the defined tolerance range based on the second attribute value change within the table of the first database;
replicating the second attribute value change to the second database in response to determining that the second attribute value change does not fulfil the tolerance range; and
selecting a subset of the attributes of the set of attributes based on data sources of the attributes;
wherein the selected attribute is part of the subset of attributes, wherein the computer implemented method further comprises a logging method, wherein, for each received attribute value change, the logging method comprises:
determining that the first attribute value change involves one or more attributes of the subset of attributes;
adding the first log entry indicating the first attribute value change and log metadata of a first type to the transaction log in response to determining that the first attribute value change involves one or more attributes of the subset of attributes; and
adding the second log entry indicating the first attribute value change and log metadata of a second type to the transaction log in response to determining that the first attribute value change does not involve one or more attributes of the subset of attributes;
wherein the replication method further comprises:
sequentially reading each log entry of a current non-read set of log entries;
wherein detecting the first attribute value change of the selected attribute of the set of attributes comprises determining that the log metadata of the first or second log entry is of the first type.