Patent ID: 9195693
Filing Date: 2015-11-24
Classification: G06F

Abstract:
1. A database system configured for creating and utilizing a plurality of transactions predictive models using a computer, the database system comprising: a database management system (DBMS) for handling a plurality of database transactions in the database system, the DBMS including a prediction component for generating the plurality of transactions predictive models; a database workload table for capturing a plurality of commands associated with the plurality of database transactions, the plurality of commands utilized for generating the plurality of transactions predictive model; database data for providing data in response to the plurality of database transactions; and a prediction model database for storing the plurality of database transactions predictive models, wherein the prediction component is configured for the database system wherein the prediction component is further configured to receive the current database transaction, to identify one of the plurality of transaction classes corresponding with the current database transaction from one of the plurality of transactions prediction models, to predict a next transaction class based on a highest transition probability of the one of the plurality of transactions prediction models, and to pre-fetch data associated with the next transaction class.