20240020300. MATERIALIZED VIEWS AS A SERVICE FOR ANALYTICS simplified abstract (SAP SE)

From WikiPatents
Jump to navigation Jump to search

MATERIALIZED VIEWS AS A SERVICE FOR ANALYTICS

Organization Name

SAP SE

Inventor(s)

Shashank Mohan Jain of Bangalore (IN)

MATERIALIZED VIEWS AS A SERVICE FOR ANALYTICS - A simplified explanation of the abstract

This abstract first appeared for US patent application 20240020300 titled 'MATERIALIZED VIEWS AS A SERVICE FOR ANALYTICS

Simplified Explanation

The patent application describes a system for data analytics in a cloud computing environment. It involves storing system metadata in system tables that associate materialized views with views and tables. When an update request is received for a view, the query parser identifies the relevant system tables and arranges for the replication of data from the corresponding table. A materialized view request is then sent to a materialized view compute unit, which refreshes and computes the materialized view, storing the result.

  • The system enables data analytics in a cloud computing environment.
  • System tables store metadata linking materialized views with views and tables.
  • An update request for a view is captured and relevant system tables are identified.
  • Data from the corresponding table is replicated.
  • A materialized view request is sent to a separate materialized view compute unit.
  • The materialized view compute unit refreshes and computes the materialized view.
  • The result of the computation is stored.

Potential applications of this technology:

  • Data analytics in cloud computing environments.
  • Real-time data processing and analysis.
  • Business intelligence and reporting.
  • Decision support systems.

Problems solved by this technology:

  • Efficient processing of update requests for views.
  • Improved performance of data analytics in cloud environments.
  • Reduction of data transfer and processing overhead.

Benefits of this technology:

  • Faster and more efficient data analytics.
  • Improved scalability and flexibility in cloud computing environments.
  • Enhanced decision-making capabilities through real-time analysis.
  • Reduced network and processing costs.


Original Abstract Submitted

embodiments may facilitate data analytics for a cloud computing environment. a plurality of system tables may store system metadata that associates a first materialized view with a first view and a first table. a transaction compute unit may process an update request relevant to the first view. a query parser may capture the update request from the transaction compute unit and detect which system tables are associated with the update request relevant to the first view. responsive to the request, the query processor arranges for first table data to be replicated and transmit a materialized view request to a materialized view compute unit. the materialized view compute unit may be created as a materialized view-as-a-service (“mvaas”) independent of the transaction compute unit. the materialized view compute unit may receive the materialized view request, refresh the first materialized view, compute the first materialized view, and store a result of the computation.