Incremental refresh of materialized views containing rank function, and rewrite of queries containing rank or rownumber or min/max aggregate functions using such a materialized view
US7111020B1 · kind B1 · utility
44Cited by
11References
32Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Mar 26, 2002 |
| Grant date | Sep 19, 2006 |
| Priority date | — |
| Expiry date | Jul 5, 2022 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99952
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.