US 11,809,408 B2
Incremental refresh of a materialized view
Thierry Cruanes, San Mateo, CA (US); Benoit Dageville, San Mateo, CA (US); Prasanna Rajaperumal, Bangalore (IN); and Jiaqi Yan, Menlo Park, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Sep. 7, 2022, as Appl. No. 17/930,177.
Application 17/930,177 is a continuation of application No. 17/238,539, filed on Apr. 23, 2021, granted, now 11,461,309.
Application 17/238,539 is a continuation of application No. 16/662,645, filed on Oct. 24, 2019, granted, now 11,030,186.
Claims priority of provisional application 62/751,123, filed on Oct. 26, 2018.
Prior Publication US 2023/0004552 A1, Jan. 5, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/23 (2019.01); G06F 16/24 (2019.01); G06F 16/27 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2365 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2393 (2019.01); G06F 16/24 (2019.01); G06F 16/278 (2019.01)] 21 Claims
OG exemplary drawing
 
1. A method comprising:
storing a source table including a set of micro-partitions in a plurality of shared storage devices;
storing, by a compute service manager independent of the plurality of shared storage devices, a materialized view based on the source table, the materialized view being a persistent query result;
updating, by one or more execution nodes assigned by the compute service manager, the source table;
receiving, by the computer service manager, a query;
merging, by the compute service manager, the updated source table and the materialized view to generate a merged table;
scanning the merged table to identify an update to the source table not reflected in the materialized view, the update including a modification to one or more of micro-partitions in the set of micro-partitions in the source table;
applying, by one or more execution nodes assigned by the compute service manager, the identified update to the materialized view to generate an updated materialized view; and
executing the query using the updated materialized view without accessing the source table.