Method and system for fast recovery of a primary store database

Details Method and system for fast recovery of a primary store database Method and system for fast recovery of a primary store database

1996-02-06

1998-02-24

Amsbury, Wayne

395619, G06F 1730

Patent

active

057219184

ABSTRACT:
The present invention provides an electronic data storage and processing system where non-persistent memory such as random access memory (RAM) stores a database with a first memory section storing semi-permanent data and a second memory section storing transient types of data. A third memory section in RAM may be used to buffer database transactions relating to the semi-permanent data stored in the first memory section of RAM. At periodic and appropriate checkpoint time intervals, the semi-permanent data currently stored in the first section of RAM are copied or "dumped" onto persistent (disk) memory. Only those database transactions that affect the semi-permanent data stored in the first section of RAM occurring after the most recent checkpoint "dump" are logged onto persistent memory. Database transactions affecting the transient type of data stored in the second portion of RAM are not logged. A recovery processor recovers from a system failure by reloading semi-permanent data is from the persistent memory into the first section of RAM and executing the log. However, in one embodiment, the recovery processor may leave the data in the second section of RAM in the state in which that data exists after the system failure. Considerable time is saved by not logging transient database transactions or executing a log for those transactions when recovering from a system failure.

REFERENCES:
patent: 4498145 (1985-02-01), Baker et al.
patent: 4507751 (1985-03-01), Gawlilck et al.
patent: 4648031 (1987-03-01), Jenner
patent: 4868744 (1989-09-01), Reinsch et al.
patent: 5043866 (1991-08-01), Myre, Jr. et al.
patent: 5274802 (1993-12-01), Altine
patent: 5278982 (1994-01-01), Daniels et al.
patent: 5287496 (1994-02-01), Chen et al.
patent: 5297189 (1994-03-01), Chabernaud
patent: 5303286 (1994-04-01), Wiedeman
patent: 5333303 (1994-07-01), Mohan
patent: 5375251 (1994-12-01), Pfundstein
patent: 5386554 (1995-01-01), Nozaki
patent: 5414840 (1995-05-01), Rengarajan et al.
patent: 5457796 (1995-10-01), Thompson
patent: 5485608 (1996-01-01), Lomet et al.
patent: 5561795 (1996-10-01), Sarkar
patent: 5577246 (1996-11-01), Priddy et al.
patent: 5581750 (1996-12-01), Haderle et al.
patent: 5594942 (1997-01-01), Antic et al.
Proceedings of the International Conference on Data Engineering, Kobe, Japan, Apr. 8-12, 1991, Institute of Electrical and Electronics Engineers, pp. 436-443, XP000325905, Vijay et al., "Performance Measurement of Some Main Memory Database Recovery Algorithms".

Affiliated with

Also associated with

Rating

Method and system for fast recovery of a primary store 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 Method and system for fast recovery of a primary store database , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for fast recovery of a primary store database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1881829