Synchronous change data capture in a relational database

Details Synchronous change data capture in a relational database Synchronous change data capture in a relational database

2006-09-19

2006-09-19

Ali, Mohammad (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07111023

ABSTRACT:
A synchronous change data capture system and methodology are described in which, for each statement of a transaction, a transaction identifier that uniquely identifies each transaction is recorded along with the change data. When the transaction is committed, the transaction identifier and a system change number for the commit is recorded in a transaction table. To identify the commit system change number for each statement in the change data, the transaction identifier in the change data is used to fetch the commit system change number from the transaction table.

REFERENCES:
patent: 5280612 (1994-01-01), Lorie et al.
patent: 5553279 (1996-09-01), Goldring
patent: 5613113 (1997-03-01), Goldring
patent: 5848405 (1998-12-01), Norcott
patent: 5926819 (1999-07-01), Doo et al.
patent: 5963959 (1999-10-01), Sun et al.
patent: 6125360 (2000-09-01), Witkowski et al.
patent: 6438538 (2002-08-01), Goldring
patent: 2003/0172091 (2003-09-01), Norcott
patent: WO/02/095632 (2002-11-01), None
patent: WO/03/096227 (2003-11-01), None
U.S. Appl. No. 09/863,419, filed May 24, 2001, Norcott.
U.S. Appl. No. 10/140,818, filed May 9, 2002, Norcott et al.
Bello R G et al; “Materialized views in Oracle”; Proceedings of the Twenty-Fourth International Conference on Very-Large Databases; New York, NY; Aug. 24-27, 1998; pp. 659-664; Kaufmann Publishers Inc; USA.
Chaudhuri S et al; “An Overview of Data Warehousing and OLAP Technology”; Mar. 1997; pp. 65-74; vol. 26, No. 1; Sigmond Record; New York, NY; USA.

Affiliated with

Also associated with

Rating

Synchronous change data capture in a relational database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Synchronous change data capture in a relational database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Synchronous change data capture in a relational database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3606044