IMPLEMENTING CHANGE DATA CAPTURE BY INTERPRETING PUBLISHED EVENTS AS A DATABASE RECOVERY LOG

• US 20160132399A1
• Filed: 06/04/2015
• Published: 05/12/2016
• Est. Priority Date: 11/11/2014
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Cadarette, Paul M., Spyker, James D.
• Granted Patent: US 9,910,737 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: G06F 16/162 Delete operations erasing in storage systems G06F3/0652
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence

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.

Claims

1. A method for implementing a change capture system using an event publishing system as a database recovery log, the 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;

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; and

processing the at least one published event received by the change capture system.

2. The method of claim 1, further comprising:

extracting the at least one identified published event from a persisted store;

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.

3. The method of claim 2, wherein the recording of the identified change comprises recording a plurality of contextual information regarding the identified change to the at least one item of selected data, wherein the plurality of contextual information comprises a timestamp of the identified change to the at least one item of selected data and a plurality of user information.

4. The method of claim 1, wherein the selected at least one item of data is selected by a graphical user interface (GUI) comprising a list of a plurality of table data and a plurality of column data.

5. The method of claim 1, wherein the determined set of data comprises a plurality of tables and a plurality of columns within the plurality of tables.

6. The method of claim 2, wherein the identified change to the at least one item of selected data comprises at least one of an insertion of a plurality of information to a source database;

an update to a plurality of information in the source database; and

a deletion of a plurality of information in the source database.

7. The method of claim 1, wherein the at least one published event comprises at least one of a plurality of person events and a plurality of product events.