Invention Grant
- Patent Title: Virtual transaction queues for database replication
-
Application No.: US16858967Application Date: 2020-04-27
-
Publication No.: US11256713B2Publication Date: 2022-02-22
- Inventor: Dirk Alexander Seelemann, II , Dzmitry Lepniakou , Michael Jory
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Garg Law Firm, PLLC
- Agent Rakesh Garg; William Hartwell
- Main IPC: G06F16/27
- IPC: G06F16/27 ; G06F16/22 ; G06F16/23

Abstract:
An embodiment includes extracting, after a first specified time interval, recovery data from a recovery log for a data table corresponding to a set of database operations on the data table that occurred during the first specified time interval. The embodiment also generates index data for a progress record associated with the first time interval. The progress record includes a first data field for storing data representative of a first net change to the data table resulting from a first subset of the set of database operations. The first subset of database operations are associated with a first transaction. The embodiment also detects a commit operation in the first subset of database operations that committed the first transaction. The embodiment also recovers the first transaction in a target data table using the recovery log and the first net change data associated with the first transaction in the progress record.
Public/Granted literature
- US20210334246A1 VIRTUAL TRANSACTION QUEUES FOR DATABASE REPLICATION Public/Granted day:2021-10-28
Information query