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 |
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.
|