Using materialized view to process a related query containing a one to many lossless join
US6449609B1 · kind B1 · utility
28Cited by
12References
24Claims
0Family size
Assignee
Inventor
Key dates
| Filing date | Dec 28, 1998 |
| Grant date | Sep 10, 2002 |
| Priority date | — |
| Expiry date | Dec 28, 2018 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99934
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and apparatus for transforming queries is described. According to an aspect of the present invention, a select-project-join query Q that specifies at least one semijoin is rewritten into another query that references the materialized view M. A common section shared by the select-project-join query and the materialized view includes the tables being semijoined.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.