发明名称 |
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. |
申请公布号 |
US9244776(B2) |
申请公布日期 |
2016.01.26 |
申请号 |
US201414483731 |
申请日期 |
2014.09.11 |
申请人 |
International Business Machines Corporation |
发明人 |
Koza Phillip R.;Spyker James D. |
分类号 |
G06F7/02;G06F17/30;G06F11/14 |
主分类号 |
G06F7/02 |
代理机构 |
Edell, Shapiro & Finnan, LLC |
代理人 |
Murray Susan;Edell, Shapiro & Finnan, LLC |
主权项 |
1. A computer-implemented method of processing database log records of a database transaction log comprising:
receiving database log records of the database transaction log and processing at least some of the received records; generating snapshots of the database log records, wherein each snapshot includes database log records for pending transactions, and a transaction is pending when at least one of the log records for the transaction remains to be processed; and in response to an interruption in processing of the database log records, utilizing a selected 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. |
地址 |
Armonk NY US |