Reducing Reading Of Database Logs By Persisting Long-Running Transaction Data
AssigneeInternational Business Machines Corporation
InventorsPhillip R. Koza, James D. Spyker
Life of this patent
Estimating the term…
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.
Claims21
A computer-implemented method of processing database log records of a database transaction log comprising:
- processing the database log records of the database transaction log;
- generating a snapshot of the database log records at first 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, utilizing a snapshot to restore database log records for the pending transactions and resuming processing of the database transaction log from a position succeeding the database log records of the selected snapshot.
A system for processing database log records of a database transaction log comprising:
- at least one processor configured to:
- process the database log records of the database transaction log;
- generate a snapshot of the database log records at first 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, utilize 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.
A computer program product for processing database log records of a database transaction log comprising:
- a computer readable storage medium having computer readable program code embodied therewith for execution on a first processing system, the computer readable program code comprising computer readable program code configured to:
- process the database log records of the database transaction log;
- generate a snapshot of the database log records at first 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, utilize 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.
Dependencies are inferred from the claim text.