-
公开(公告)号:US20220188294A1
公开(公告)日:2022-06-16
申请号:US17118770
申请日:2020-12-11
Applicant: SAP SE
Inventor: Daniel Bos , Nico Gaertner , Tobias Karpstein
IPC: G06F16/23 , G06F16/22 , G06F16/25 , G06F16/2457
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.
-
公开(公告)号:US20230034941A1
公开(公告)日:2023-02-02
申请号:US17386225
申请日:2021-07-27
Applicant: SAP SE
Inventor: Daniel Bos , Joao Pedro Duro Reis , Tobias Karpstein
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.
-
公开(公告)号:US11775554B2
公开(公告)日:2023-10-03
申请号:US17244547
申请日:2021-04-29
Applicant: SAP SE
Inventor: Sebastian Haase , Tobias Karpstein , Michael Haberkorn
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.
-
公开(公告)号:US11232126B2
公开(公告)日:2022-01-25
申请号:US16197888
申请日:2018-11-21
Applicant: SAP SE
Inventor: Steffen Meissner , Volker Driesen , Tobias Karpstein , Martin Mayer , Thomas Saelinger , Thomas Ullrich
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.
-
公开(公告)号:US12153597B1
公开(公告)日:2024-11-26
申请号:US18221978
申请日:2023-07-14
Applicant: SAP SE
Inventor: Florian Maier , Daniel Bos , Peter Schoenau , Tobias Karpstein
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.
-
公开(公告)号:US11853814B2
公开(公告)日:2023-12-26
申请号:US17481967
申请日:2021-09-22
Applicant: SAP SE
Inventor: Daniel Bos , Marcus Roland Schwarz , Tobias Karpstein
CPC classification number: G06F9/542 , G06F16/2291 , G06F16/2358 , G06F16/2379 , G06F16/258
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.
-
公开(公告)号:US10997206B2
公开(公告)日:2021-05-04
申请号:US16443362
申请日:2019-06-17
Applicant: SAP SE
Inventor: Sebastian Haase , Tobias Karpstein , Michael Haberkorn
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.
-
公开(公告)号:US20200159852A1
公开(公告)日:2020-05-21
申请号:US16197888
申请日:2018-11-21
Applicant: SAP SE
Inventor: Steffen Meissner , Volker Driesen , Tobias Karpstein , Martin Mayer , Thomas Saelinger , Thomas Ullrich
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.
-
公开(公告)号:US20240160637A1
公开(公告)日:2024-05-16
申请号:US17987961
申请日:2022-11-16
Applicant: SAP SE
Inventor: Daniel Bos , Qing Liu , Tobias Karpstein
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.
-
公开(公告)号:US11640411B2
公开(公告)日:2023-05-02
申请号:US17386225
申请日:2021-07-27
Applicant: SAP SE
Inventor: Daniel Bos , Joao Pedro Duro Reis , Tobias Karpstein
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.
-
-
-
-
-
-
-
-
-