Invention Grant
- Patent Title: Transient materialized view rewrite
-
Application No.: US17538219Application Date: 2021-11-30
-
Publication No.: US11544262B2Publication Date: 2023-01-03
- Inventor: Shrainik Jain , Allison Waingold Lee , Boyung Lee , Prasanna Rajaperumal , Jiaqi Yan , Yongsik Yoon
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/2453
- IPC: G06F16/2453

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.
Public/Granted literature
- US20220092068A1 TRANSIENT MATERIALIZED VIEW REWRITE Public/Granted day:2022-03-24
Information query