Using a materialized view to process a related query containing a one to many lossless join
US6449605B1 · kind B1 · utility
33Cited by
7References
20Claims
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/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and apparatus for transforming queries is provided. A select-project-join query Q is rewritten into another query that joins a materialized view M and a subset of the tables from Q not in the common section portion of Q. The common section may be one-to-many lossless with respect to the join with the materialized view delta. As compared to one-to-one rewrites, the one-to-many rewrites described herein provide a more general class of rewrites.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.