Invention Grant
- Patent Title: Incremental refresh of a materialized view
-
Application No.: US17930177Application Date: 2022-09-07
-
Publication No.: US11809408B2Publication Date: 2023-11-07
- Inventor: Thierry Cruanes , Benoit Dageville , Prasanna Rajaperumal , Jiaqi Yan
- 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/23
- IPC: G06F16/23 ; G06F16/24 ; G06F16/27 ; G06F16/22

Abstract:
Systems, methods, and devices for incrementally refreshing a materialized view are disclosed. A method includes generating a materialized view based on a source table. The method includes merging the source table and the materialized view to generate a merged table to identify whether an update has been executed on the source table that is not reflected in the materialized view. The method includes, in response to detecting an update made to the source table that is not reflected in the materialized view, applying the update to the materialized view.
Public/Granted literature
- US20230004552A1 INCREMENTAL REFRESH OF A MATERIALIZED VIEW Public/Granted day:2023-01-05
Information query