Access path optimization through system statistics
US9734203B2 · kind B2 · utility
2Cited by
4References
1Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Nov 18, 2016 |
| Grant date | Aug 15, 2017 |
| Priority date | — |
| Expiry date | Nov 18, 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.