Invention Grant
- Patent Title: Database optimization based on forecasting hardware statistics using data mining techniques
-
Application No.: US15418881Application Date: 2017-01-30
-
Publication No.: US10664473B2Publication Date: 2020-05-26
- Inventor: Reinaldo T. Katahira , Craig M. Trim
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Schmeiser, Olsen & Watts
- Agent Mark C. Vallone
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/2458

Abstract:
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.
Public/Granted literature
- US20180218038A1 DATABASE OPTIMIZATION BASED ON FORECASTING HARDWARE STATISTICS USING DATA MINING TECHNIQUES Public/Granted day:2018-08-02
Information query