Back to results
US 11,768,853 B2Granted
System to copy database client data
AssigneeSap SE
InventorDominik Ofenloch
Life of this patent
Estimating the term…
Abstract
Systems and methods to copy a plurality of source data records of a source client to a target client include deletion of a first set of target data records of a plurality of target data records associated with the target client, each of the first set associated with a key which is not identical to any key of a plurality of source data records, insertion of a second set of source data records into the plurality of target data records, each of the second set of source data records associated with a key which is not identical to any key of the plurality of target data records, and update of a third set of target data records associated with a key which matches a key of one of the fourth set of source data records and which is different from one of the fourth set of source data records.
Claims13
A system comprising:
- a memory storing processor-executable program code;
- and
- a processing unit to execute the processor-executable program code in order to cause the system to:
- receive a first instruction to copy source data records of a first source database to a target database;
- in response to the first instruction, determine that a most-recent copy operation to the target database was to copy source data records of a second source database to the target database;
- in response to the determination that a most-recent copy operation to the target database was to copy source data records of a second source database to the target database:
- delete a plurality of target data records of the target database and copy the source data records of the first source database to the target database;
- receive a second instruction to copy source data records of the first source database to the target database;
- in response to the second instruction, determine that a most-recent copy operation to the target database was to copy source data records from the first source database to the target database;
- in response to the determination that a most-recent copy operation to the target database was to copy source data records from the first source database to the target database:
- delete a first set of target data records of the plurality of target data records of the target database, each of the first set of target data records associated with a key which is not identical to any key of the source data records associated with the first source database;
- insert a second set of source data records of the source data records into the plurality of target data records, each of the second set of source data records associated with a key which is not identical to any key of the plurality of target data records;
- and
- update a third set of target data records of the plurality of target data records based on a fourth set of the source data records, each of the third set of target data records associated with a key which matches a key of one of the fourth set of source data records and with at least one non-key field value which is different from a corresponding non-key field value of the one of the fourth set of source data records.
11 more elements
A computer-implemented method comprising:
- receiving a first instruction to copy source data records of a first source database to a target database;
- in response to the first instruction, determining that a most-recent copy operation to the target database was to copy source data records of a second source database to the target database;
- in response to the determination that a most-recent copy operation to the target database was to copy source data records of a second source database to the target database:
- deleting a plurality of target data records of the target database and copying the source data records of the first source database to the target database;
- receiving a second instruction to copy source data records of the first source database to the target database;
- in response to the second instruction, determine that a most-recent copy operation to the target database was to copy source data records from the first source database to the target database;
- in response to the determination that a most-recent copy operation to the target database was to copy source data records from the first source database to the target database:
- deleting a first set of target data records of the plurality of target data records associated with the target database, each of the first set of target data records associated with a key which is not identical to any key of the source data records of the first source database;
- inserting a second set of source data records of the source data records into the plurality of target data records, each of the second set of source data records associated with a key which is not identical to any key of the plurality of target data records;
- and
- updating a third set of target data records of the plurality of target data records based on a fourth set of source data records, each of the third set of target data records associated with a key which matches a key of one of the fourth set of source data records and with at least one non-key field value which is different from a corresponding non-key field value of the one of the fourth set of source data records.
8 more elements
A non-transitory medium storing processor-executable program code, the program code executable by a computing system to cause the computing system to:
- receive a first instruction to copy source data records of a first source database to a target database;
- in response to the first instruction, determine that a most-recent copy operation to the target database was to copy source data records of a second source database to the target database;
- in response to the determination that a most-recent copy operation to the target database was to copy source data records of a second source database to the target database:
- delete a plurality of target data records of the target database and copy the source data records of the first source database to the target database;
- receive a second instruction to copy source data records of the first source database to the target database;
- in response to the second instruction, determine that a most-recent copy operation to the target database was to copy source data records from the first source database to the target database;
- in response to the determination that a most-recent copy operation to the target database was to copy source data records from the first source database to the target database:
- delete a first set of target data records of the plurality of target data records of the target database, each of the first set of target data records associated with a key which is not identical to any key of the source data records associated with the first source database;
- insert a second set of source data records of the source data records into the plurality of target data records, each of the second set of source data records associated with a key which is not identical to any key of the plurality of target data records;
- and
- update a third set of target data records of the plurality of target data records based on a fourth set of source data records, each of the third set of target data records associated with a key which matches a key of one of the fourth set of source data records and with at least one non-key field value which is different from a corresponding non-key field value of the one of the fourth set of source data records.
8 more elements
Dependencies are inferred from the claim text.