Using a materialized view to process a related query containing a one to many lossless join
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Sep 10, 2002
Grant Date -
N/A
app pub date -
Dec 28, 1998
filing date -
Dec 28, 1998
priority date (Note) -
In Force
status (Latency Note)
Importance
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.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully