Rewriting queries to access materialized views that group along an ordered dimension
US6345272B1 · kind B1 · utility
30Cited by
38References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jul 27, 1999 |
| Grant date | Feb 5, 2002 |
| Priority date | — |
| Expiry date | Jul 27, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99944
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and apparatus are provided for rewriting aggregate queries to access a materialized view when (1) the queries place a restriction on an ordered dimension, (2) the materialized view aggregates the information referenced in the query and groups by the same dimension, and (3) the materialized view groups the information at a coarser level of granularity than the granularity associated with the restriction contained in the aggregate queries.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.