Patent · US Active

Reducing reading of database logs by persisting long-running transaction data

US9244776B2 · kind B2 · utility

92Cited by

6References

7Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Phillip R. Koza · San Jose, US
James D. Spyker · Schreiber, CA

Key dates

Filing date	Sep 11, 2014
Grant date	Jan 26, 2016
Priority date	—
Expiry date	Sep 11, 2034

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/27
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

According to one embodiment of the present invention, a system reduces re-reading of database logs by persisting long running transaction data. The system processes the database log records of the database transaction log; generates a snapshot of the database log records at periodic intervals, wherein each snapshot includes database log records for pending transactions; and in response to an interruption in processing of the database log records, utilizes a snapshot to restore database log records for the pending transactions and resume processing of the database transaction log from a position succeeding the database log records of the selected snapshot.

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