Computerized method and system for replicating a database using

Details Computerized method and system for replicating a database using Computerized method and system for replicating a database using

1995-06-06

1997-06-17

Black, Thomas G.

39518213, 39518214, 395607, G06F 1730

Patent

active

056405618

ABSTRACT:
A method and system are provided for continuously maintaining replicas of an active database in a backup system for disaster recovery purposes. Redo records transmitted from an active system are received into a dataspace work area in a backup system memory. Redo records in the work area for an uncommitted database transaction are grouped together. When a transaction becomes a committed transaction, the redo records for the transaction are sorted with redo records from other committed transactions according to database, block number within a database, offset location within a block, and sequence of occurrence. A plurality of update blocks from a backup database are read into a buffer in the backup system memory. The sorted redo records are sequentially applied to corresponding data records in the update blocks. The update blocks are then immediately written back to the database.

REFERENCES:
patent: 4357635 (1982-11-01), Hasegawa
patent: 4853843 (1989-08-01), Ecklund
patent: 4945474 (1990-07-01), Elliot et al.
patent: 5043866 (1991-08-01), Myre, Jr. et al.
patent: 5155678 (1992-10-01), Fukumoto et al.
patent: 5170480 (1992-12-01), Mohan et al.
patent: 5274803 (1993-12-01), Dubin et al.
patent: 5280611 (1994-01-01), Mohan et al.
patent: 5369757 (1994-11-01), Spiro et al.
Zurek, Bob, "Help My Server Failed!", Data Based Advisor, vol. 9, Issue No. M10, Oct., 1991, pp. 90-93.
Schaffhauser, Dian, "Managing Very Large Databases", Data Based Advisor, vol. V9, Issue No. N11, Nov. 1991, pp. 112-120.

Affiliated with

Also associated with

Rating

Computerized method and system for replicating a database using does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Computerized method and system for replicating a database using , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Computerized method and system for replicating a database using will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2165652