Product Overview

• You agree to comply with local laws, regulations, and public ethics when using the Kunpeng BoostKit OmniCache. You shall not use OmniCache to engage in any activities that violate the law, infringe on the rights and interests of others, interrupt social order, undermine social stability, or engage in any activities that endanger or attempt to endanger the computer system and network security.
• You agree that Huawei shall assume no liability for any indirect, incidental, special, or any form of punitive damages, or any loss of profits, revenue, data, or data use.
• You acknowledge and agree that you need to download and integrate the open source and third-party software on which the software package of OmniCache depends. Huawei does not assume any responsibility for the software vulnerabilities and security issues.

The OmniCache materialized view feature is designed for scenarios where SQL analysis tasks in a data warehouse have many identical subqueries. Repeated calculations on these subqueries waste a large number of computing resources and decrease the query efficiency.

The OmniCache materialized view feature uses AI algorithms to recommend the optimal materialized view from historical SQL queries, automatically matches SQL statements with a materialized view in Spark, and replaces the matched materialized view with the existing one in the execution plan of SQL statements. This feature greatly reduces repeated calculations and increases the query efficiency.

The replacement is implemented using the OmniCache plugin, which performs the following functions:

• Pre-calculates and caches batch queries. Compared with the original query from the base table, the OmniCache plugin greatly improves the performance of the computing engine.
• Recommends the optimal materialized view using deep learning and reinforcement learning algorithms.