US 11,675,809 B2
Replicating data changes using multiple storage devices and tracking records of pending data changes stored on the storage devices
Knut Stolze, Hummelshain (DE); Reinhold Geiselhart, Rottenburg-Ergenzingen (DE); Felix Beier, Haigerloch (DE); and Luis Eduardo Oliveira Lizardo, Böblingen (DE)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Mar. 2, 2021, as Appl. No. 17/189,648.
Prior Publication US 2022/0284033 A1, Sep. 8, 2022
Int. Cl. G06F 16/27 (2019.01); G06F 16/11 (2019.01); G06F 16/23 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/27 (2019.01) [G06F 16/113 (2019.01); G06F 16/2282 (2019.01); G06F 16/2358 (2019.01); G06F 16/2379 (2019.01)] 17 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
repeatedly generating log files while performing data changes of a table of a source database system, each log file including:
at least one record of data change of the table of the source database system; and
a log number specifying a total number of records of data change of the table of the source database system having been written until generation of the respective log file;
storing the log files on a first memory device, the first memory device having a first access time;
archiving a part of the log files being stored on the first memory device on a second memory device, the second memory device having a second access time, wherein the second access time is higher than the first access time;
tracking a first number of first pending data changes, first pending data changes being the data changes of the records of data change of the log files being stored on the first memory device which are not yet replicated in the table of the target database system;
tracking a second number of second pending data changes, the second pending data changes being the data changes of the records of data change of the log files being archived on the second memory device which are not yet replicated in a table of a target database system;
selecting a type of data replication from a first type of data replication and a second type of data replication based on the first number and the second number; and
replicating the data changes of the table of the source database system in the table of the target database system according to the selected type of data replication using the records of data change of the log files.