Handling of data archiving events in a replication system

    公开(公告)号:US11422970B2

    公开(公告)日:2022-08-23

    申请号:US16871242

    申请日:2020-05-11

    Applicant: SAP SE

    Abstract: Systems and methods include detection of deletion of a record of a database table due to a database transaction, creation of a log entry including one or more key field values of the record of the database table, an identifier of a user associated with the database transaction, and an indicator of a delete operation, determination of whether the identifier identifies an archiving user, and, in a case that the identifier identifies an archiving user, change the indicator to an indicator of an archive operation to create a changed log entry.

    Reload procedure to retain data in target system

    公开(公告)号:US11487784B2

    公开(公告)日:2022-11-01

    申请号:US16851271

    申请日:2020-04-17

    Applicant: SAP SE

    Abstract: Systems and methods include creation of a first target table in a target system, the first target table having a structure of a first source table and loaded with data of the first source table, creation of a view in the target system, the view having a name of the first source table and configured to select from the first target table, reception of a request to reload a current version of the first source table into the target system, and, in response to the request, creation of a second target table in the target system, the second target table having a structure of the current version of the first source table, copying of data of the current version of the first source table to the second target table while the view is configured to select from the first target table, and, after copying of the data of the current version of the first source table to the second target table is complete, modification of the view to select from the second target table.

    HANDLING OF DATA ARCHIVING EVENTS IN A REPLICATION SYSTEM

    公开(公告)号:US20210349849A1

    公开(公告)日:2021-11-11

    申请号:US16871242

    申请日:2020-05-11

    Applicant: SAP SE

    Abstract: Systems and methods include detection of deletion of a record of a database table due to a database transaction, creation of a log entry including one or more key field values of the record of the database table, an identifier of a user associated with the database transaction, and an indicator of a delete operation, determination of whether the identifier identifies an archiving user, and, in a case that the identifier identifies an archiving user, change the indicator to an indicator of an archive operation to create a changed log entry.

    Generic factory class
    4.
    发明授权

    公开(公告)号:US11947931B2

    公开(公告)日:2024-04-02

    申请号:US17499158

    申请日:2021-10-12

    Applicant: SAP SE

    CPC classification number: G06F8/24 G06F8/315 G06F8/42

    Abstract: Systems and methods provide a generic factory class to determine one or more classes implementing an interface and/or derived from a base class in response to a call from an application factory class by retrieving a list of the one or more classes implementing the interface or derived from the based class, determining properties of each of the one or more classes, and return, based on the properties, a name of each of one or more of the one or more classes.

    Maintenance events in a data replication system

    公开(公告)号:US11947565B2

    公开(公告)日:2024-04-02

    申请号:US17871344

    申请日:2022-07-22

    Applicant: SAP SE

    CPC classification number: G06F16/27

    Abstract: Systems and methods include detection of changes to data of a plurality of source objects of a source system, replicating the data changes to corresponding ones of the plurality of target objects, and, during the detection of changes to data and the replication of the data changes: detecting a first change to a first source object, identifying a first maintenance event based on the detected first change; determining a first one or more solutions to resolve the first maintenance event; presenting the first maintenance event and the first one or more solutions to resolve the first maintenance event to a user; receiving an indication from the user of a first solution of the first one or more solutions to resolve the first maintenance event; and, in response to the indication, executing the first solution.

    Replication of complex augmented views

    公开(公告)号:US11372885B2

    公开(公告)日:2022-06-28

    申请号:US15930584

    申请日:2020-05-13

    Applicant: SAP SE

    Abstract: Systems and methods include determination of an augmented view of a source system to be created in a target system, the augmented view including a structured query language view and annotations, and the augmented view associated with an object hierarchy, determination of a structured query language statement to create the augmented view in the source system, conversion of the structured query language statement to include augmented view names and augmented view field names, modification of one or more session context variables of the converted structured query language statement, creation of a target augmented view in the target system using the converted and modified structure query language statement, and creation of each object of the object hierarchy which is not an augmented view in the target system.

    Subscription-based change data capture mechanism using database triggers

    公开(公告)号:US10997206B2

    公开(公告)日:2021-05-04

    申请号:US16443362

    申请日:2019-06-17

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for replicating data from a source database table to a target database table. An embodiment operates by maintaining a master logging table in communication with a source database table and a subscriber logging table. Thereafter, a copy of a first modification of data of the source database table is provided to the master logging table as a record, where the first record includes the copy of the first modification of data. Subsequently, upon determining that the first record in the master logging table is committed, a copy of the first record is provided to the subscriber logging table. And after identifying a first target database associated with the master logging table, the first record is sent to the first target database.

    REPLICATION OF COMPLEX AUGMENTED VIEWS

    公开(公告)号:US20210357424A1

    公开(公告)日:2021-11-18

    申请号:US15930584

    申请日:2020-05-13

    Applicant: SAP SE

    Abstract: Systems and methods include determination of an augmented view of a source system to be created in a target system, the augmented view including a structured query language view and annotations, and the augmented view associated with an object hierarchy, determination of a structured query language statement to create the augmented view in the source system, conversion of the structured query language statement to include augmented view names and augmented view field names, modification of one or more session context variables of the converted structured query language statement, creation of a target augmented view in the target system using the converted and modified structure query language statement, and creation of each object of the object hierarchy which is not an augmented view in the target system.

    MAINTENANCE EVENTS IN A DATA REPLICATION SYSTEM

    公开(公告)号:US20210334290A1

    公开(公告)日:2021-10-28

    申请号:US16860257

    申请日:2020-04-28

    Applicant: SAP SE

    Abstract: Systems and methods include detection of changes to data of a plurality of source objects of a source system, replicating the data changes to corresponding ones of the plurality of target objects, and, during the detection of changes to data and the replication of the data changes: detecting a first change to a first source object, identifying a first maintenance event based on the detected first change; determining a first one or more solutions to resolve the first maintenance event; presenting the first maintenance event and the first one or more solutions to resolve the first maintenance event to a user; receiving an indication from the user of a first solution of the first one or more solutions to resolve the first maintenance event; and, in response to the indication, executing the first solution.

    RELOAD PROCEDURE TO RETAIN DATA IN TARGET SYSTEM

    公开(公告)号:US20210326351A1

    公开(公告)日:2021-10-21

    申请号:US16851271

    申请日:2020-04-17

    Applicant: SAP SE

    Abstract: Systems and methods include creation of a first target table in a target system, the first target table having a structure of a first source table and loaded with data of the first source table, creation of a view in the target system, the view having a name of the first source table and configured to select from the first target table, reception of a request to reload a current version of the first source table into the target system, and, in response to the request, creation of a second target table in the target system, the second target table having a structure of the current version of the first source table, copying of data of the current version of the first source table to the second target table while the view is configured to select from the first target table, and, after copying of the data of the current version of the first source table to the second target table is complete, modification of the view to select from the second target table.

Patent Agency Ranking