Virtual transaction queues for database replication

A computer usable program product for data replication, the computer program product comprising one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable by a processor to cause the processor to perform operations comprising:

• extracting, at the end of 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;
• generating, responsive to extracting the recovery data at the end of the first specified time interval, index data for a progress record associated with the first time interval, wherein 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, wherein the first subset of database operations are associated with a first transaction;
• detecting, responsive to generating the index data, a commit operation in the first subset of database operations that committed the first transaction;
• and
• recovering, responsive to detecting the commit operation, 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.

A computer system comprising a processor and one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable by the processor to cause the processor to perform operations comprising:

• extracting, at the end of 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;
• generating, responsive to extracting the recovery data at the end of the first specified time interval, index data for a progress record associated with the first time interval, wherein 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, wherein the first subset of database operations are associated with a first transaction;
• detecting, responsive to generating the index data, a commit operation in the first subset of database operations that committed the first transaction;
• and
• recovering, responsive to detecting the commit operation, 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.