US 11,860,894 B2
Database management system data replication
Michael Jory, North York (CA); and Dirk Alexander Seelemann, II, Thornhill (CA)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Aug. 24, 2020, as Appl. No. 17/001,664.
Prior Publication US 2022/0058207 A1, Feb. 24, 2022
Int. Cl. G06F 16/27 (2019.01); G06F 16/23 (2019.01); G06F 16/28 (2019.01); G06F 16/245 (2019.01)
CPC G06F 16/273 (2019.01) [G06F 16/2358 (2019.01); G06F 16/2379 (2019.01); G06F 16/245 (2019.01); G06F 16/284 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
enabling replication of an application data table of a database management system (DBMS) via a default amount of logging of a system table that corresponds to the application data table of the DBMS, wherein the default amount of logging includes a partial after image for update operations and does not include before images for delete operations, by:
identifying a delete operation as recorded in a roll-forward recovery log for the DBMS, wherein the delete operation relates to the system table that corresponds to the application data table;
identifying, using an identifier of the delete operation as stored within the roll-forward recovery log, a row of the system table that corresponds to the application data table, wherein the row is associated with the delete operation;
querying entries of the system table that correspond to the application data table; and
generating, by encoding values of the entries, a new before image of the system table that corresponds to the application data table, wherein the new before image reflects the application data table before the delete operation.