Patent · US Expired

Method and apparatus for block-level auditing and database recovery in a transaction processing system

US5682527A · kind A · utility

24Cited by
7References
21Claims
0Family size

Assignee

Inventors

Key dates

Filing dateDec 22, 1994
Grant dateOct 28, 1997
Priority date
Expiry dateDec 22, 2014

Classification

  • Technology area (CPC Y)Emerging Cross-Sectional Technologies
  • CPC primaryY10S707/99953
  • WIPO fieldComputer technology
  • WIPO sectorElectrical engineering

Abstract

A transaction processing audit and recovery system is disclosed. After processing a transaction, an audit manager logs in audit records only changed blocks of data of a segment of a database. Upon failure of database backing storage, a prior copy of the database is reloaded to database backing storage that is available and a recovery manager reads the audit records and copies the changed blocks back to the database backing storage. An outboard file cache system is used in conjunction with the recovery manager to recover the database. The outboard file cache provides cache storage for segments of the database and writes non-contiguous blocks of one or more segments as directed in a single input/output request initiated from the recovery manager.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.