发明名称 |
FORECASTING QUERY ACCESS PLAN OBSOLESCENCE |
摘要 |
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. |
申请公布号 |
US2016224627(A1) |
申请公布日期 |
2016.08.04 |
申请号 |
US201514675808 |
申请日期 |
2015.04.01 |
申请人 |
International Business Machines Corporation |
发明人 |
Baranczyk Shawn J.;Konik Rafal P.;Mittelstadt Roger A.;Muras Brian R. |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. A method for generating a replacement query access plan, the method comprising:
receiving a query; generating, based on statistics for a database, a first query access plan for executing the query on the database; obtaining a first result set for the query by implementing the first query access plan on the database; forecasting, 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; generating, in response to the forecasting and based on the statistics, a replacement query access plan prior to the target time; and obtaining a second result set for the query by implementing, after the target time, the replacement query access plan rather than the first query access plan. |
地址 |
Armonk NY US |