INCREMENTAL REFRESH OF A MATERIALIZED VIEW
First Claim
Patent Images
1. A system comprising:
- a compute service manager for managing internal operations of a cloud-based database platform;
a plurality of shared storage devices collectively storing database data, wherein the plurality of shared storage devices is independent of the compute service manager; and
an execution platform comprising a plurality of execution nodes, wherein the execution platform independent is independent of the plurality of shared storage devices and the compute service manager;
wherein the compute service manager is configured to;
generate a materialized view based on a source table;
merge 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; and
in response to detecting an update made to the source table that is not reflected in the materialized view, assign tasks to one or more execution nodes of the execution platform to apply the update to the materialized view.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
25 Claims
-
1. A system comprising:
-
a compute service manager for managing internal operations of a cloud-based database platform; a plurality of shared storage devices collectively storing database data, wherein the plurality of shared storage devices is independent of the compute service manager; and an execution platform comprising a plurality of execution nodes, wherein the execution platform independent is independent of the plurality of shared storage devices and the compute service manager; wherein the compute service manager is configured to; generate a materialized view based on a source table; merge 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; and in response to detecting an update made to the source table that is not reflected in the materialized view, assign tasks to one or more execution nodes of the execution platform to apply the update to the materialized view. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method comprising:
-
generating a materialized view based on a source table; 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; and 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. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A processor that is configurable to execute instructions stored in non-transitory computer readable storage media, the instructions comprising:
-
generating a materialized view based on a source table; 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; and 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. - View Dependent Claims (22, 23, 24, 25)
-
Specification