Plan generation in database query optimizers through specification of plan patterns
US7343370B2 · kind B2 · utility
2Cited by
2References
15Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Mar 7, 2005 |
| Grant date | Mar 11, 2008 |
| Priority date | — |
| Expiry date | Feb 18, 2026 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99933
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and systems receive a query, receive a control statement that represents at least a portion of a desired execution plan associated with the query, and produce an execution plan that conforms to the desired plan to the extent that the produced plan preserves the semantics of the query, without requiring an exhaustive search. These methods also enable realization of bushy shaped plans that are outside the scope of the optimizer search space.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.