Use of materialized transient views in query optimization
US7693820B2 · kind B2 · utility
53Cited by
6References
12Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Apr 21, 2006 |
| Grant date | Apr 6, 2010 |
| Priority date | — |
| Expiry date | Apr 23, 2027 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99932
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and systems for integrating use of materialized transient views into generation of an optimized query execution plan. Features and aspects hereof provide rapid identification of common expressions in a query as transient view candidates and then rapidly select among the transient view candidates for those transient views that most benefit the cost of execution of the query. The selected transient views are incorporated into a generated final, optimized query execution plan including operator to materialize the selected transient views for re-use in execution of the query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.