Transient materialized view rewrite
US11544262B2 · kind B2 · utility
1Cited by
1References
24Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Nov 30, 2021 |
| Grant date | Jan 3, 2023 |
| Priority date | — |
| Expiry date | Nov 30, 2041 |
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.