View matching for materialized outer-join views
US7406468B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jun 14, 2005 |
| Grant date | Jul 29, 2008 |
| Priority date | — |
| Expiry date | Mar 9, 2026 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99934
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A computer implemented system that facilitates view matching for outer join views comprises an interface component that receives at least one query that includes one or more outer join operators. A view matching-component converts the at least one query and outputs a substitute query expression. In accordance with one aspect of the subject invention, the view-matching component can comprise a normalization component that converts the at least one query and at least one materialized view into a normalized query expression and a normalized view expression. Furthermore, the view-matching component can include an analysis component that receives the normalized query expression and the normalized view expression, and a construction component that constructs the substitute query expression.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.