| 发明名称 |
ACCESS PATH OPTIMIZATION THROUGH SYSTEM STATISTICS |
| 摘要 |
In an approach for calculating one or more access paths during bind time, a computer receives a query. The computer identifies one or more access paths for processing the received query, wherein the one or more access paths include steps associated with retrieving data from a database based on the received query. The computer calculates resource costs associated with processing the received query on the one or more identified access paths based on one of more of: resources utilized to perform steps associated with processing the received query, and system statistics associated with the one or more identified access paths. |
| 申请公布号 |
US2017017686(A1) |
申请公布日期 |
2017.01.19 |
| 申请号 |
US201514798537 |
申请日期 |
2015.07.14 |
| 申请人 |
International Business Machines Corporation |
发明人 |
Feng Hao;Li Shuo;Sun ShengYan;Yang Xin Ying |
| 分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
| 代理机构 |
|
代理人 |
|
| 主权项 |
1. A method for calculating one or more access paths during bind time, the method comprising:
receiving, by one or more computer processors, a query; identifying, by one or more computer processors, one or more access paths for processing the received query, wherein the one or more access paths include steps associated with retrieving data from a database based on the received query; and calculating, by one or more computer processors, resource costs associated with processing the received query on the one or more identified access paths based on one or more of: resources utilized to perform steps associated with processing the received query, and system statistics associated with the one or more identified access paths. |
| 地址 |
Armonk NY US |
