Method and system for fast recovery of a primary store database using selective recovery by data type
First Claim
1. An electronic data storage and processing system, comprising:
- nonpersistent memory for storing a database including first and second sections corresponding to first and second types of data;
first persistent memory for storing a copy of data currently stored in the first section;
second persistent memory for logging database transactions; and
a data processor copying the first type of data stored in the first section into the first persistent memory at checkpoint time periods and logging in the second persistent memory only those database transactions relating to the first type of data stored in the first section that occur after a most recent checkpoint,wherein transactions relating to the second type of data stored in the second portion are not logged.
1 Assignment
0 Petitions
Accused Products
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.
193 Citations
20 Claims
-
1. An electronic data storage and processing system, comprising:
-
nonpersistent memory for storing a database including first and second sections corresponding to first and second types of data; first persistent memory for storing a copy of data currently stored in the first section; second persistent memory for logging database transactions; and a data processor copying the first type of data stored in the first section into the first persistent memory at checkpoint time periods and logging in the second persistent memory only those database transactions relating to the first type of data stored in the first section that occur after a most recent checkpoint, wherein transactions relating to the second type of data stored in the second portion are not logged. - View Dependent Claims (2, 3, 4)
-
-
5. An electronic data storage and processing system, comprising:
-
nonpersistent memory for storing a database including first and second sections corresponding to first and second types of data; first persistent memory for storing a copy of the first type of data stored in the first memory section; a system manager copying data stored in the first section into the first persistent memory at checkpoint time periods; and a recovery processor for recovering from a system failure by copying the first type of data from the first persistent memory into the first section of the nonpersistent memory, wherein the recovery processor leaves the data in the second section of the nonpersistent memory in the state that data exists after the failure. - View Dependent Claims (6, 7, 8, 9, 10, 11)
-
-
12. A method for managing a data handling system that includes nonpersistent memory for storing a database and persistent memory, comprising the steps of:
-
storing database transactions relating to a first type of data in a first section of the non-persistent memory; storing database transactions relating to a second type of data in a second section of the non-persistent memory; copying the first type of data in the first section at predetermined checkpoint time intervals into the persistent memory; storing in the persistent memory only those database transactions affecting the first type of data stored in the first section that occur after a recent checkpoint time interval, wherein database transactions affecting the second type of data stored in the second section are not stored in the persistent memory. - View Dependent Claims (13, 14, 15)
-
-
16. A method for recovering an electronic data storage and processing system from a system failure, comprising the steps of:
-
storing in nonpersistent memory a database having first and second sections corresponding to first and second types of data; transferring the first type of data stored in the first section into a first persistent memory at checkpoint time periods; and recovering from a system failure by loading the first type of data from the first persistent memory into the first section of the database after the failure and leaving the second type of data in the second section of the database in a state that second type of data exists after the failure. - View Dependent Claims (17, 18, 19, 20)
-
Specification