Soft checkpointing system using log sequence numbers derived from stored data pages and log records for database recovery
August 27, 2008. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.Patent References 3736566 3783256 Memory hierarchy system with journaling and copy back Multi-processing system with a hierarchial memory having journaling and copyback Journal back-up storage control for a data processing system Process and apparatus for interrupting and restarting sequential list-processing operations Technique for enabling operation of a computer system with a consistent state of a linked list data structure after a main memory failure Method for assuring atomicity of multi-row update operations in a database system Method and apparatus for logging journal data using a log write ahead data set Method for refreshing multicolumn tables in a relational data base using minimal information InventorsApplicationNo. 179194 filed on 04/08/1988US Classes:707/202, Recoverability714/16Forward recovery (e.g., redoing committed action)ExaminersPrimary: Williams, Archie E. Jr.Assistant: Coleman, Eric Attorney, Agent or FirmInternational ClassesG06F 011/30G06F 009/312 G06F 012/08 AbstractFunctions MINBUFLSN and LOWTRANLSN, implemented in a computerized routine, are defined and comprise first and second components of a checkpoint. MINBUFLSN is functionally related to a first update to a first of "dirty" data pages in the RAM buffer. LOWTRANLSN is functionally related to the earliest update of a sequence in a transaction table wherein each update corresponds to an uncommitted transaction. The two components are derived during write-ahead logging and stored in the log header periodically as a function of logging activity. Upon recovery, the checkpoint is retrieved and a functional comparison between the components thereof employed in the recovery algorithm. The conventional analysis pass of the recovery log is avoided and a reduced overhead during logging is provided as well as an efficient recovery.Other References
| |
