Patent ID: 11860864
Assignee: SAP SE
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 18:
19. A non-transitory, computer readable medium having executable instructions stored therein to perform a method to facilitate data analytics for a cloud computing environment, the method comprising:
processing, by a transaction compute unit, an update request relevant to a first view, wherein a plurality of system tables store system metadata that associates a first materialized view with the first view and a first table;
capturing, by a computer processor of a query parser, the update request from the transaction compute unit;
detecting which system tables are associated with the update request relevant to the first view;
responsive to the request, arranging 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;
transmitting a materialized view request to a materialized view compute unit, created as a Materialized View-as-a-Service (“MVaaS”) independent of the transaction compute unit;
refreshing, by the materialized view compute unit, the first materialized view using the replicated first table data;
computing the first materialized view by the materialized view compute unit; and
storing, by the materialized view compute unit, a result of the computation.