Join predicate push-down optimizations
US7945562B2 · kind B2 · utility
24Cited by
70References
12Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Mar 8, 2007 |
| Grant date | May 17, 2011 |
| Priority date | — |
| Expiry date | Jan 5, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24544
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Join predicate push down transformations push down a join predicate of an outer query into a view. Among the types of views for which join predicate push down is performed are a view with a GROUP BY or DISTINCT operator, an anti-joined or semi-joined view, and a view that contains one or more nested views. During optimization, join predicate push down may be used to generate many transformed queries for comparison. The number of query transformations performed for comparison is managed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.