Access path optimization through system statistics
US9436735B1 · kind B1 · utility
17Cited by
3References
1Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Feb 5, 2016 |
| Grant date | Sep 6, 2016 |
| Priority date | — |
| Expiry date | Feb 5, 2036 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/245
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.