Systems and methods to profile transactions for end-state determination and latency reduction
First Claim
1. An automated method of categorizing an incomplete transaction and processing the incomplete 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 incomplete 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 an incomplete 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 incomplete transaction;
(d) categorizing in the computer processor the incomplete 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 incomplete transaction using the categorization of the incomplete transaction.
1 Assignment
0 Petitions
Accused Products
Abstract
Methods and apparatus are provided to categorize and process an incomplete transaction. A transaction pattern table is provided that includes a plurality of records, each record being defined by a transaction pattern identifier. Each record includes a transaction pattern and a metric of occurrence of the transaction pattern. An incomplete transaction is automatically compared to the transaction patterns in the table and a subset of transaction patterns in the table are identified that are potential candidates for matching the incomplete transaction. The incomplete transaction is categorized using the metric of occurrence of the transaction pattern for each transaction pattern in the subset. The incomplete transaction is then processed using the categorization of the incomplete transaction.
15 Citations
18 Claims
-
1. An automated method of categorizing an incomplete transaction and processing the incomplete 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 incomplete 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 an incomplete 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 incomplete transaction; (d) categorizing in the computer processor the incomplete 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 incomplete transaction using the categorization of the incomplete transaction. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A tangible computer program product for categorizing an incomplete transaction and processing the incomplete 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 incomplete transaction is incomplete in either the source or the target database, the computer program product comprising non-transitory computer-readable media encoded with instructions for execution by a processor to perform a 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 the series of one or more transaction steps or operations of an incomplete transaction to the transaction patterns in the transaction pattern table; (c) identifying, based on the automatic comparison, a subset of transaction patterns in the transaction pattern table that are potential candidates for matching the incomplete transaction; (d) categorizing the incomplete 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 the incomplete transaction using the categorization of the incomplete transaction. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. An apparatus for categorizing an incomplete transaction and processing the incomplete transaction, wherein transactions are completed within a transaction processing system, and wherein the transactions are replicated from a source database to a target database, and wherein each transaction is a series of one or more transaction steps or operations, and wherein the incomplete transaction is incomplete in either the source or the target database, the apparatus comprising:
-
(a) a transaction pattern table that includes a plurality of records, each record being defined by a unique 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) a transaction pattern identification engine configured to; (i) compare the series of one or more transaction steps or operations of an incomplete transaction to the transaction patterns in the transaction pattern table, (ii) identify, based on the comparison, a subset of transaction patterns in the transaction pattern table that are potential candidates for matching the incomplete transaction, and (iii) categorize the incomplete 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 (c) a data replication engine configured to process and replicate the incomplete transaction using the categorization of the incomplete transaction. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification