Look-Ahead Staging for Accelerated Data Extraction

    公开(公告)号:US20220188294A1

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

    申请号:US17118770

    申请日:2020-12-11

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for utilizing look-ahead-staging (LAS) to accelerate data extraction from a source system to a target system. An embodiment operates receiving a data change for a data extraction from a producer job at the source system. The embodiment stores the data change in a staging area of a persistent storage together with a respective sequence identifier. The embodiment receives a request for a next package of data changes in the staging area from a consumer job at the target system. The embodiment generates the next package from the staging area. The embodiment transmits the next package to the consumer job. The embodiment receives a commit notification for the next package from the consumer job. The embodiment then removes the data changes in the next package from the staging area in response to receiving the commit notification.

    DATA REPLICATION SYSTEM
    2.
    发明申请

    公开(公告)号:US20230034941A1

    公开(公告)日:2023-02-02

    申请号:US17386225

    申请日:2021-07-27

    Applicant: SAP SE

    Abstract: Disclosed herein are various embodiments for a data replication system. An embodiment operates by determining that a plurality of records of a source table are copied from a source system to a target table of a target system. It is determined that a change table, of the source system, associated with the source table is populated with a plurality of changes occurring to at least a subset of records of the plurality of records while the plurality of records are being copied from the source table of the source system to the target table of the target system. It is determined that the plurality of changes are copied to a shadow table of the target system. It is determined that the target table includes the plurality of records from the source table. The plurality of changes of the shadow table are merged with the target table.

    Subscription-based change data capture mechanism using database triggers

    公开(公告)号:US11775554B2

    公开(公告)日:2023-10-03

    申请号:US17244547

    申请日:2021-04-29

    Applicant: SAP SE

    CPC classification number: G06F16/27 G06F16/2282 G06F16/2379

    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.

    Zero downtime upgrade of systems with database-side replication

    公开(公告)号:US11232126B2

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

    申请号:US16197888

    申请日:2018-11-21

    Applicant: SAP SE

    Abstract: Implementations include providing, by a deploy tool, clone data components in the first database system, each clone data component being a copy of a data component, defining, by the deploy tool, a source-side green access schema in the first database system, the green access schema providing views to the clone data components, providing, by a replication system and based on statements received from the deploy tool, consumer-side clone data components in the first database system, each consumer-side clone data component being a copy of a respective data component, defining, by a replication system and based on statements received from the deploy tool, a consumer-side green access schema in the first database system, the green access schema providing views to the source-side clone data components, and, during execution of the upgrade, replicating, by a handler of the replication system, data from at least one source-side data component to a consumer-side component.

    Multiple subscriber data extraction for a change data capture (CDC)

    公开(公告)号:US12153597B1

    公开(公告)日:2024-11-26

    申请号:US18221978

    申请日:2023-07-14

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for accessing a semantic change data capture (CDC). An embodiment operates by receiving a request for changes made to a source system from a consumer at a target system. The embodiment determines a high watermark stored in a consumer registration table based on the consumer. The embodiment further determines a set of open transactions on an enhanced data table. The embodiment then determines a set of changes made to the source system based on the high watermark and the set of open transactions. The embodiment transmits the set of changes to the consumer at the target system. The embodiment then receives a confirmation from the consumer at the target system that the set of changes were committed to the target system. The embodiment then updates the high watermark in the consumer registration table based on the confirmation.

    Automatically generating events
    6.
    发明授权

    公开(公告)号:US11853814B2

    公开(公告)日:2023-12-26

    申请号:US17481967

    申请日:2021-09-22

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for automatically generating events. In some embodiments, a server receives a request to subscribe to an event type for an application. The server identifies an entity in a data model corresponding to the event type. The entity is associated with application data of the application. Furthermore, the server subscribes to receive alerts associated with any change to the entity in the data model. The server receives an alert indicating a change to the entity in the data model. The alert includes the change to the entity. Moreover, the server generates an event corresponding to the event type based on the change to the entity and transmits the event to an event infrastructure.

    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.

    ZERO DOWNTIME UPGRADE OF SYSTEMS WITH DATABASE-SIDE REPLICATION

    公开(公告)号:US20200159852A1

    公开(公告)日:2020-05-21

    申请号:US16197888

    申请日:2018-11-21

    Applicant: SAP SE

    Abstract: Implementations include providing, by a deploy tool, clone data components in the first database system, each clone data component being a copy of a data component, defining, by the deploy tool, a source-side green access schema in the first database system, the green access schema providing views to the clone data components, providing, by a replication system and based on statements received from the deploy tool, consumer-side clone data components in the first database system, each consumer-side clone data component being a copy of a respective data component, defining, by a replication system and based on statements received from the deploy tool, a consumer-side green access schema in the first database system, the green access schema providing views to the source-side clone data components, and, during execution of the upgrade, replicating, by a handler of the replication system, data from at least one source-side data component to a consumer-side component.

    VIRTUAL MACHINE FOR ETL TRANSFORMATIONS
    9.
    发明公开

    公开(公告)号:US20240160637A1

    公开(公告)日:2024-05-16

    申请号:US17987961

    申请日:2022-11-16

    Applicant: SAP SE

    CPC classification number: G06F16/254 G06F8/447 G06F9/30101 G06F9/45504

    Abstract: Provided are systems and methods for transforming data from a format of a source system into a format of a target system based on a dedicated virtual machine. In one example, a method may include storing programming code which comprises logic for transforming data from a source system to a target format of a target system, compiling the programming code into bytecode, generating a work order which includes a payload of data from the source system and the bytecode, reading the work order via a virtual machine and executing the bytecode on the payload of data via the virtual machine, wherein the virtual machine transforms the payload of data from the source format to the target format based on the bytecode, and loading the transformed payload of data into the target system.

    Data replication system
    10.
    发明授权

    公开(公告)号:US11640411B2

    公开(公告)日:2023-05-02

    申请号:US17386225

    申请日:2021-07-27

    Applicant: SAP SE

    Abstract: Disclosed herein are various embodiments for a data replication system. An embodiment operates by determining that a plurality of records of a source table are copied from a source system to a target table of a target system. It is determined that a change table, of the source system, associated with the source table is populated with a plurality of changes occurring to at least a subset of records of the plurality of records while the plurality of records are being copied from the source table of the source system to the target table of the target system. It is determined that the plurality of changes are copied to a shadow table of the target system. It is determined that the target table includes the plurality of records from the source table. The plurality of changes of the shadow table are merged with the target table.

Patent Agency Ranking