Reducing Reading Of Database Logs By Persisting Long-Running Transaction Data

摘要

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.

主权项

1. 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.