Methods of generating a transactions prediction model using a computer for optimizing a number of transactions associated with a database system include capturing a database workload, where the database workload includes a number of statements corresponding with the transactions over a specified period of time, where each of the statements includes a variable parameter; then generating a generalized statements from the statements by replacing the variable parameter with a constant value; then generating other generalized statements, where if two or more of the number of the generalized statements are the same grouping the generalized statements to correspond with the other generalized statements; and then creating transaction classes, where each of the transaction classes includes at least one generalized statements.