Rewrite of queries containing rank or rownumber or min/max aggregate functions using a materialized view
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Jan 24, 2012
Grant Date -
May 5, 2011
app pub date -
Jan 12, 2011
filing date -
Mar 26, 2002
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
Techniques are provided for improving efficiency of database systems, and in particular, to refreshing materialized views maintained by database systems and rewriting queries to access the materialized views. According to the approaches, a ranked materialized view is incrementally refreshed, and during the incremental refresh operation, rows in the partitions of the materialized view are ranked within the partitions.
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