Sap Se

Dominik Ofenloch

Wulf Kruempelmann

Thomas Vogt

Various examples are directed to systems and methods for copying a source database client to a target database client and exit runtime system may execute a first plurality of exits in a database access trace mode. This may generate first exit trace data describing accesses by the first plurality of exits to at least one of the source database client or the target database client. The system may determine, using the first exit trace data, that a first table of the source database client is accessed by a first exit of the first plurality of exits and a second exit of the first plurality of exits. Based on the determining, the system may modify at least one of the first exit, the second exit, or first execution order data describing an order for executing the first plurality of exits.

Database client parallel copy systems and methods

One or more applications access a first set of database tables via a first projection view mapping from a first name to a second name. At a given point in time, the one or more applications may detect an indication of a modification operation targeting the first set of database tables. In response to detecting the indication of the modification operation, the one or more applications may create a second set of database tables for storing results of the modification operation. In response to detecting a completion of the modification operation, the first projection view may be remapped from the first name to a third name, where the third name is associated with the second set of database tables. Then, the one or more applications may access the second set of database tables via the first projection view mapping from the first name to the third name.

Deployment of configuration data in parallel to active test usage

Arrangements for dynamic selection of delta client copy strategies are provided. An intelligent client copy computing platform may determine whether a database table of a source client is empty. If not, the copy computing platform may determine whether the database table has changed. If not, the computing platform may determine whether the database table has been copied from a same source client of a last copy operation. If so, the computing platform may determine whether a record count of the source client is the same as the record count of a target client. If not, the computing platform may apply a delta copy algorithm. The algorithm may select records of the source client, deduct records of the target client from those records, insert records that are in the source but not in the target client, and delete records that are in the target but not in the source client.

Dynamic selection of delta client copy strategies

Arrangements for an intelligent client copy tool are provided. In a client copy procedure, access to a target client may be locked and all target data associated with the target client may be deleted. A before trigger for execution before a modifying operation on a database table may be defined. The trigger may be executed and, based on the trigger identifying a query associated with the modifying operation, access to the database table may be locked and an insert operation may be executed. Then, the trigger may be deleted. Thereafter, the modifying operation on the target client may be performed and access to the database table unlocked. A database view of the database table, including pointers to the source client, may be generated. Nonstatic data may be copied from the source client to the target client using the insert operation. After the copying, the target client may be unlocked.

Intelligent client copy tool

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.

System to copy database client data

The present disclosure relates to computer-implemented methods, software, and systems for generating a hierarchy of metadata tables for a database comprising containers including tables. The tables are identified by table names and assigned to containers. A first table is assigned to two containers and may define two table instances of the first table. The hierarchy of metadata tables includes a first metadata table defining mappings between container identifiers, table names, table sections, and unique identifiers for corresponding data within table sections of table instances defined with the table names mapped to the container identifiers. In response to receiving a request to generate a replication of table content, a second metadata table is generated to identify a unique set of table instances from the set of the containers based on evaluating the first metadata table. The unique set of table instances comprises data from the database storage without repetition.

Container storage management system

The present disclosure relates to computer-implemented methods, software, and systems for managing data replication between different source sections and target sections in response to received copy instructions associated with copy profiles. In response to evaluating statistical metadata identifying whether data records in relation to at least one client are included for a table from a first set of tables, a first subset of tables from the first set of tables is determined. In response to evaluating update metadata defining latest updates of tables from the first subset of tables, a second subset of tables from the first subset of tables is determined that defines tables that include updated data records relevant for copying. The second subset tables are iteratively evaluated to define corresponding operations to be performed for tables at the target section and at the source section in the database in relation to the requested copy operation.

Growing community of inventors

Lampertheim, Germany

Dominik Ofenloch