Failure recovery and error correction techniques for data...

Details Failure recovery and error correction techniques for data... Failure recovery and error correction techniques for data...

2007-06-07

2010-06-15

McCarthy, Christopher S (Department: 2113)

Error detection/correction and fault detection/recovery

Data processing system error or fault handling

Reliability and availability

C707S793000

Reexamination Certificate

active

07739547

ABSTRACT:
A method of data loading for large information warehouses includes performing checkpointing concurrently with data loading into an information warehouse, the checkpointing ensuring consistency among multiple tables; and recovering from a failure in the data loading using the checkpointing. A method is also disclosed for performing versioning concurrently with data loading into an information warehouse. The versioning method enables processing undo and redo operations of the data loading between a later version and a previous version. Data load failure recovery is performed without starting a data load from the beginning but rather from a latest checkpoint for data loading at an information warehouse level using a checkpoint process characterized by a state transition diagram having a multiplicity of states; and tracking state transitions among the states using a system state table.

REFERENCES:
patent: 5933593 (1999-08-01), Arun et al.
patent: 5996088 (1999-11-01), Frank et al.
patent: 6343299 (2002-01-01), Huang et al.
patent: 6351754 (2002-02-01), Bridge et al.
patent: 6490657 (2002-12-01), Masubuchi et al.
patent: 6584476 (2003-06-01), Chatterjee et al.
patent: 6598059 (2003-07-01), Vasudevan et al.
patent: 6678704 (2004-01-01), Bridge et al.
patent: 6728867 (2004-04-01), Kling
patent: 6834358 (2004-12-01), Korenevsky et al.
patent: 6941489 (2005-09-01), DeLano
patent: 7003560 (2006-02-01), Mullen et al.
patent: 7017076 (2006-03-01), Ohno et al.
patent: 7127475 (2006-10-01), Gotz et al.
patent: 7149761 (2006-12-01), Cooke et al.
patent: 7526513 (2009-04-01), Lees et al.
patent: 2006/0085679 (2006-04-01), Neary et al.
patent: 2006/0218563 (2006-09-01), Grnistein et al.
patent: 2008/0307011 (2008-12-01), Chen et al.
Amer-Yahia et al., “A declarative approach to optimize bulk loading into databases”, ACM Transactions on Database Systems (TODS), vol. 29, Issue 2 (Jun. 2004), pp. 233-281; USA.

Affiliated with

Also associated with

Rating

Failure recovery and error correction techniques for data... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Failure recovery and error correction techniques for data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Failure recovery and error correction techniques for data... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4250655