Invention Grant
- Patent Title: Subscription-based change data capture mechanism using database triggers
-
Application No.: US17244547Application Date: 2021-04-29
-
Publication No.: US11775554B2Publication Date: 2023-10-03
- Inventor: Sebastian Haase , Tobias Karpstein , Michael Haberkorn
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Sterne, Kessler, Goldstein & Fox P.L.L.C.
- Main IPC: G06F16/27
- IPC: G06F16/27 ; G06F16/23 ; G06F16/22

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.
Public/Granted literature
- US20210248159A1 Subscription-Based Change Data Capture Mechanism Using Database Triggers Public/Granted day:2021-08-12
Information query