Implementing change data capture by interpreting published events as a database recovery log
First Claim
1. A computer system for implementing a change capture system using an event publishing system as a database recovery log, the computer system comprising:
- one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage medium, and program instructions stored on at least one of the one or more tangible storage medium for execution by at least one of the one or more processors via at least one of the one or more memories, wherein the computer system is capable of performing a method comprising;
determining a set of data based on a description of events, wherein the set of data comprises a plurality of data for which change capture is possible;
selecting at least one item of data from within the determined set of data, wherein the at least one item of data requires change capture to be performed;
identifying at least one published event based on the at least one selected item of data, wherein the at least one published event is produced by the event publishing system, and wherein the at least one published event is a person event where a plurality of information related to a customer is changed in a source database;
instructing the event publishing system to deliver the at least one identified published event to the change capture system;
receiving, by the change capture system, the at least one identified published event;
extracting the at least one identified published event from a persisted store, wherein the at least one identified published event is extracted from the persisted store using an algorithm that provides log dependency information for a source database;
analyzing a plurality of information contained within the at least one identified published event;
identifying a change associated with the at least one item of selected data; and
recording the identified change to the at least one item of selected data to a repository.
1 Assignment
0 Petitions
Accused Products
Abstract
A method for implementing a change capture system using an event publishing system as a database recovery log is provided. The method may include determining a set of data based on a description of events for which change capture is possible. The method may also include selecting at least one item of data from within the determined set of data, wherein the at least one item of data requires change capture to be performed. Additionally, the method may include identifying at least one published event, wherein the at least one published event is produced by the event publishing system. The method may include instructing the event publishing system to deliver the at least one identified published event to the change capture system. Furthermore, the method may include receiving the at least one identified published event. The method may also include processing the at least one published event.
-
Citations
10 Claims
-
1. A computer system for implementing a change capture system using an event publishing system as a database recovery log, the computer system comprising:
-
one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage medium, and program instructions stored on at least one of the one or more tangible storage medium for execution by at least one of the one or more processors via at least one of the one or more memories, wherein the computer system is capable of performing a method comprising; determining a set of data based on a description of events, wherein the set of data comprises a plurality of data for which change capture is possible; selecting at least one item of data from within the determined set of data, wherein the at least one item of data requires change capture to be performed; identifying at least one published event based on the at least one selected item of data, wherein the at least one published event is produced by the event publishing system, and wherein the at least one published event is a person event where a plurality of information related to a customer is changed in a source database; instructing the event publishing system to deliver the at least one identified published event to the change capture system; receiving, by the change capture system, the at least one identified published event; extracting the at least one identified published event from a persisted store, wherein the at least one identified published event is extracted from the persisted store using an algorithm that provides log dependency information for a source database; analyzing a plurality of information contained within the at least one identified published event; identifying a change associated with the at least one item of selected data; and recording the identified change to the at least one item of selected data to a repository. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A computer program product for implementing a change capture system using an event publishing system as a database recovery log, the computer program product comprising:
-
one or more computer-readable tangible storage medium and program instructions stored on at least one of the one or more tangible storage medium, the program instructions executable by a processor, the program instructions comprising; program instructions to determine a set of data based on a description of events, wherein the set of data comprises a plurality of data for which change capture is possible; program instructions to select at least one item of data from within the determined set of data, wherein the at least one item of data requires change capture to be performed; program instructions to identify at least one published event based on the at least one selected item of data, wherein the at least one published event is produced by the event publishing system, and wherein the at least one published event is a person event where a plurality of information related to a customer is changed in a source database; program instructions to instruct the event publishing system to deliver the at least one identified published event to the change capture system; program instructions to receive, by the change capture system, the at least one identified published event; program instructions to extract the at least one identified published event from a persisted store, wherein the at least one identified published event is extracted from the persisted store using an algorithm that provides log dependency information for a source database; program instructions to analyze a plurality of information contained within the at least one identified published event; program instructions to identify a change associated with the at least one item of selected data; and program instructions to record the identified change to the at least one item of selected data to a repository. - View Dependent Claims (7, 8, 9, 10)
-
Specification