Processing queries using hybrid access paths
US9652497B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 23, 2014 |
| Grant date | May 16, 2017 |
| Priority date | — |
| Expiry date | Feb 6, 2035 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24542
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Embodiments of techniques related to optimizing and processing queries are disclosed. In one embodiment, a query to access data of one or more databases is received, and a hybrid access path for accessing the data is generated. Generating the hybrid access path may include determining a plurality of candidate access paths and respective path cost values and selecting, based on the respective path cost values, two or more candidate access paths from the plurality of candidate access paths. Generating the hybrid access path may include generating, based on the two or more candidate access paths, the hybrid access path, the hybrid access path including at least one decision point and a set of options. The at least one decision point of the hybrid access path may indicate a difference between two or more candidate sequences of operations of candidate access paths from the two or more candidate access paths.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.