Invention Grant
- Patent Title: Forecasting query access plan obsolescence
-
Application No.: US15899827Application Date: 2018-02-20
-
Publication No.: US10929397B2Publication Date: 2021-02-23
- Inventor: Shawn J. Baranczyk , Rafal P. Konik , Roger A. Mittelstadt , Brian R. Muras
- 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
- Agent Peter K. Suchecki
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/17 ; G06F16/903

Abstract:
A query is received. Based on statistics for a database, a first query access plan is generated for executing the query on the database. A first result set for the query is obtained by implementing the first query access plan on the database. Based on at least one trend in the statistics, a target time after which implementing the first query access plan will fail a set of criteria is forecasted. In response to the forecasting and based on the statistics, a replacement query access plan is generated prior to the target time. After the target time, a second result set for the query is obtained by implementing the replacement query access plan rather than the first query access plan.
Public/Granted literature
- US20180189351A1 FORECASTING QUERY ACCESS PLAN OBSOLESCENCE Public/Granted day:2018-07-05
Information query