US 12,430,362 B2
Dynamic selection of delta client copy strategies
Wulf Kruempelmann, Altlussheim (DE); and Dominik Ofenloch, Lampertheim (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Nov. 30, 2023, as Appl. No. 18/524,372.
Prior Publication US 2025/0181605 A1, Jun. 5, 2025
Int. Cl. G06F 7/00 (2006.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/275 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2358 (2019.01)] 12 Claims
OG exemplary drawing
 
1. A system, comprising:
at least one data processor; and
at least one memory storing instructions, which when executed by the at least one data processor, result in operations comprising:
determining, based on database statistics, whether a database table of a source client is populated, wherein the database statistics includes statistical data collected for the database table;
responsive to determining that the database table of the source client is populated, determining, based on the database statistics and a client copy log, that the database table has changed, wherein the database statistics indicate a last update of a record in the database table, and wherein the client copy log which identifies a chronological order of previously executed copy operations;
responsive to determining that the database table of the source client is not populated, skipping a copy operation on the database table;
determining, based on the database statistics and the client copy log, whether the database table is unchanged;
responsive to determining that the database table is unchanged, skipping a copy operation on the database table;
responsive to determining that the database table has changed, determining whether the database table has been copied from a same source client of a last client copy operation, wherein in response to the database table not being copied from the same source client of the last client copy operation, a delete and copy operation is performed to delete data of a target client and then copying data of the source client to the database table of the target client using an insert operation;
responsive to determining that the database table has been copied from the same source client of the last client copy operation, identify a record count in each of the source client and the target client;
responsive to determining that the record count of the source client is different from the record count of the target client, apply a delta copy algorithm; and
responsive to determining that the record count of the source client is the same to the record count of the target client, applying the delta copy algorithm, when the data is different in the source client and the target client, and skipping the delta copy algorithm, when the data is the same.