Asynchronous change capture for data warehousing

Details Asynchronous change capture for data warehousing Asynchronous change capture for data warehousing

2001-05-24

2010-02-02

Alam, Hosain T (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07657576

ABSTRACT:
A method and software for change data capture are disclosed, in which change data is extracted from a recovery log and stored in a database object. The change data indicates what modification has been performed to a source object on the OLTP system. In some embodiments of the present invention, a database statement may be generated and executed to extract and load the change data, and the recovery log itself may be shipped from an OLTP system to a staging system.

REFERENCES:
patent: 5280612 (1994-01-01), Lorie et al.
patent: 5553279 (1996-09-01), Goldring
patent: 5640561 (1997-06-01), Satoh et al.
patent: 5848405 (1998-12-01), Norcott
patent: 5926819 (1999-07-01), Doo et al.
patent: 5963959 (1999-10-01), Sun et al.
patent: 6009432 (1999-12-01), Tarin
patent: 6125360 (2000-09-01), Witkowski et al.
patent: 6161103 (2000-12-01), Rauer et al.
patent: 6205451 (2001-03-01), Norcott et al.
patent: 6438538 (2002-08-01), Goldring
patent: 6567823 (2003-05-01), Rothschild
patent: 6594676 (2003-07-01), Moore
patent: 6687560 (2004-02-01), Kiser et al.
patent: 2003/0225798 (2003-12-01), Norcott
patent: 2004/0030703 (2004-02-01), Bourbonnais et al.
patent: 2005/0193024 (2005-09-01), Beyer et al.
patent: WO/02/095632 (2002-11-01), None
patent: WO/03/096227 (2003-11-01), None
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; Sigmod Record; New York, NY; USA.

Affiliated with

Also associated with

Rating

Asynchronous change capture for data warehousing does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4158127