Patent Document ID: 8224845
Application ID: 12353926
Patent Flag: 1

Claim One:
1. A method of generating a transactions prediction model using a computer for optimizing a plurality of transactions associated with a database system, the method comprising: causing the computer to capture a database workload, wherein the database workload includes a plurality of statements corresponding with the transactions over a specified period of time, wherein each of the plurality of statements includes at least one variable parameter, and wherein each of the plurality of statements includes a database command; causing the computer to generate a plurality of first generalized statements from the plurality of statements by replacing the at least one variable parameter with a constant value; causing the computer to generate a plurality of second generalized statements, wherein two or more of the plurality of first generalized statements are the same grouping the two or more of the plurality of first generalized statements to correspond with the plurality of second generalized statements; causing the computer to create a plurality of transactions classes, wherein each of the plurality of transaction classes includes at least one of the plurality of first generalized statements, and wherein each of the plurality of transaction classes represents a common sequence of transactions; causing the computer to identify a plurality of possible sequences between the plurality of transaction classes, wherein the plurality of transaction classes correspond with the database workload; causing the computer to calculate a probability of the possible sequences between the plurality of transaction classes to generate the transactions prediction model; causing the computer to receive a current transaction; causing the computer to identify one of the plurality of transaction classes corresponding with the current transaction from the transactions prediction model; causing the computer to predict a next transaction class based on a highest probability of the transactions prediction model; and causing the computer to pre-fetch data associated with the next transaction class.