Isolation anomaly quantification through heuristical pattern detection

US10649977B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Thomas H. Gnech · Eppelheim, DE
• Steffen Koenig · Heidelberg, DE
• Philipp A. Tölle · Zürich, CH

Key dates

• Filing date: Nov 2, 2017
• Grant date: May 12, 2020
• Expiry date: May 11, 2038

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/2365
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

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.