| CPC G06F 16/2393 (2019.01) | 21 Claims |
|
1. A system to facilitate data analytics for a cloud computing environment, comprising:
a plurality of system tables storing system metadata that associates a first materialized view with a first view and a first table;
a transaction compute unit to process an update request relevant to the first view;
a query parser, including:
a computer processor, and
a memory storage device, coupled to the computer processor, including instructions that, when executed by the computer processor, enable the query parser to:
(i) capture the update request from the transaction compute unit,
(ii) detect which system tables are associated with the update request relevant to the first view,
(iii) responsive to the request, arrange for replication of first table data representing the system tables that were detected to be associated with the update request relevant to the first view, and
(iv) transmit a materialized view request to a materialized view compute unit; and
the materialized view compute unit, created as a Materialized View-as-a-Service (“MVaaS”) independent of the transaction compute unit, to receive the materialized view request, refresh the first materialized view using the replicated first table data, compute the first materialized view, and store a result of the computation.
|