US 12,287,780 B1
Apparatus, method, and computer program product for reducing commit latency of pending transactions
Paul J. Holenstein, Downingtown, PA (US); Bruce D. Holenstein, Media, PA (US); and John R. Hoffmann, Kennett Square, PA (US)
Assigned to GRAVIC, INC., Malvern, PA (US)
Filed by Gravic, Inc., Malvern, PA (US)
Filed on Aug. 6, 2024, as Appl. No. 18/795,638.
Application 18/795,638 is a continuation of application No. 18/480,193, filed on Oct. 3, 2023, granted, now 12,072,872.
Application 18/480,193 is a continuation of application No. 18/316,961, filed on May 12, 2023, granted, now 11,782,908, issued on Oct. 10, 2023.
Application 18/316,961 is a continuation of application No. 16/904,687, filed on Jun. 18, 2020, granted, now 11,681,686, issued on Jun. 20, 2023.
Application 16/904,687 is a continuation of application No. 14/619,804, filed on Feb. 11, 2015, granted, now 10,706,041, issued on Jul. 7, 2020.
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/23 (2019.01); G06F 16/25 (2019.01); G06F 16/27 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/2379 (2019.01) [G06F 16/27 (2019.01); G06F 16/283 (2019.01)] 26 Claims
OG exemplary drawing
 
1. An automated method of reducing commit latency for a pending transaction, wherein transactions are completed within a transaction processing system, and wherein the transactions are replicated from a source database to a target database by a replication engine, and wherein each transaction is a series of one or more transaction steps or operations, and wherein the pending transaction is incomplete in either the source or the target database, the method comprising:
(a) providing a transaction pattern table that includes a plurality of records, each record being defined by a transaction pattern identifier, each record including:
(i) a transaction pattern, wherein each completed transaction is the series of one or more transaction steps or operations, and the transaction pattern is the series of one or more transaction steps or operations of the completed transaction, and
(ii) a metric of occurrence of the transaction pattern;
(b) automatically comparing in a computer processor the series of one or more transaction steps or operations of a pending transaction to the transaction patterns in the transaction pattern table;
(c) identifying in the computer processor, based on the automatic comparison, a subset of transaction patterns in the transaction pattern table that are potential candidates for matching the pending transaction;
(d) categorizing in the computer processor the pending transaction using the metric of occurrence of the transaction pattern for each transaction pattern in the subset of transaction patterns, wherein the categorizing predicts when all of the series of one or more transaction steps or operations which have completed in the source database have been replicated, and wherein the metric of occurrence of the transaction pattern for each record of the transaction pattern table is:
(i) a count that is continuously updated based on completed transactions that match the transaction pattern, or
(ii) a prepopulated probability of occurrence of the transaction pattern, or
(iii) derived from historical data of the transaction pattern; and
(e) processing in the computer processor the pending transaction using the categorization of the pending transaction.