Transient materialized view rewrite
US11216462B1 · kind B1 · utility
3Cited by
1References
30Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Aug 14, 2020 |
| Grant date | Jan 4, 2022 |
| Priority date | — |
| Expiry date | Aug 14, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24542
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Queries executed against a materialized view can execute up to orders of magnitude faster than equivalent queries on a source (or base) table. However, although a query can reference a materialized view directly, a user (e.g., query author) may not know about a relevant materialized view. Moreover, if a source table has multiple materialized views generated, the user may not know which materialized view to reference in the query. Thus, embodiments of the present disclosure provide techniques for automatically rewriting queries directed to a source table to utilize existing materialized views.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.