DATABASE OPTIMIZATION BASED ON FORECASTING HARDWARE STATISTICS USING DATA MINING TECHNIQUES

摘要

A method and system to optimize future performance of a database management system is provided. When a request to prepare a structured language query statement is received, historical hardware statistics data of operating parameters of a database management system is analyzed for optimization of the structured language query statement. The computer determines whether a prediction module of the computer is enabled to create a prediction of future hardware statistics data of the operating parameters of a database management system for a scheduled execution time using a predetermined data mining technique that analyzes historical statistics data. A prediction is created of the future hardware statistics data for the scheduled execution time, and a structured language query execution plan is generated using the future hardware statistics data. The structured language query statement is executed according to the structured language query execution plan at the scheduled execution time.