US 10,649,977 B2 · Isolation anomaly quantification through heuristical pattern detection

Abstract

In an approach for calculating a probability of a consistency violation of a transaction in a database management system, a processor receives a plurality of transactions within a predetermined time period. A processor identifies a first pattern in a first transaction of the plurality of transactions based on at least an isolation level of the transaction. A processor identifies a second pattern, wherein the second pattern is the cooperation between the first transaction and the second transaction. A processor determines that the first pattern of the first transaction substantially matches a preexisting pattern, wherein the preexisting pattern corresponds to values for a mathematical model for estimating a percentage of transactions in violation of consistency criteria. A processor extracts values from the first transaction based on the determined preexisting pattern. A processor calculates the mathematical model using the values from the first transaction and the values from the preexisting pattern.

Claims20

Dependent claims

A method for calculating a probability of a consistency violation of a transaction in a database management system, the method comprising:

receiving, by one or more processors, a plurality of transactions within a predetermined time period;
identifying, by one or more processors, a first pattern in a first transaction of the plurality of transactions based on an isolation level of the transaction;
determining, by one or more processors, that the first pattern of the first transaction matches a preexisting pattern, wherein the preexisting pattern corresponds to values for a mathematical model for estimating a percentage of transactions in violation of consistency criteria;
extracting, by one or more processors, values from the first transaction based on the determined preexisting pattern;
and
calculating, by one or more processors, the mathematical model using the values from the first transaction and the values from the preexisting pattern.

3 more elements

A computer program product for calculating a probability of a consistency violation of a transaction in a database management system, the computer program product comprising:

one or more computer readable storage media and program instructions stored on the one or more computer readable storage media, the program instructions comprising:
program instructions to receive a plurality of transactions within a predetermined time period;
program instructions to identify a first pattern in a first transaction of the plurality of transactions based on an isolation level of the transaction;
program instructions to determine that the first pattern of the first transaction matches a preexisting pattern, wherein the preexisting pattern corresponds to values for a mathematical model for estimating a percentage of transactions in violation of consistency criteria;
program instructions to extract values from the first transaction based on the determined preexisting pattern;
and
program instructions to calculate the mathematical model using the values from the first transaction and the values from the preexisting pattern.

4 more elements

A computer system for calculating a probability of a consistency violation of a transaction in a database management system, the computer system comprising:

one or more computer processors, one or more computer readable storage media, and program instructions stored on the computer readable storage media for execution by at least one of the one or more processors, the program instructions comprising:
program instructions to receive a plurality of transactions within a predetermined time period;
program instructions to identify a first pattern in a first transaction of the plurality of transactions based on an isolation level of the transaction;
program instructions to determine that the first pattern of the first transaction matches a preexisting pattern, wherein the preexisting pattern corresponds to values for a mathematical model for estimating a percentage of transactions in violation of consistency criteria;
program instructions to extract values from the first transaction based on the determined preexisting pattern;
and
program instructions to calculate the mathematical model using the values from the first transaction and the values from the preexisting pattern.

4 more elements

Dependencies are inferred from the claim text.

Isolation anomaly quantification through heuristical pattern detection

Life of this patent

Isolation anomaly quantification through heuristical pattern detection

Life of this patent

Abstract

Claims20