Title:
METHOD AND APPARATUS FOR CREATING MATERIALIZED VIEW, AND STORAGE MEDIUM AND ELECTRONIC DEVICE
Document Type and Number:
WIPO Patent Application WO/2023/029855
Kind Code:
A1
Abstract:
The present disclosure relates to a method and apparatus for creating a materialized view, and a storage medium and an electronic device. The method comprises: extracting an original sub-query from a historical query statement; according to the original sub-query, generating a candidate query set in accordance with a preset rule; determining a target query from the candidate query set, wherein the target query is a query with a query gain greater than a preset gain threshold value; creating a materialized view corresponding to the target query, wherein the materialized view is used for processing a corresponding query. Since the target query is a query, in the candidate query set, with a query gain greater than the preset revenue threshold value, a hit rate of the materialized view can be improved; in addition, the materialized view is established only on the basis of the target query, such that the calculation cost and the storage cost of the materialized view can be reduced.
Inventors:
ZHANG YOUJUN (CN)
GUO JUN (CN)
YANG SHIMIN (CN)
GUO JUN (CN)
YANG SHIMIN (CN)
Application Number:
PCT/CN2022/109471
Publication Date:
March 09, 2023
Filing Date:
August 01, 2022
Export Citation:
Assignee:
BEIJING VOLCANO ENGINE TECH CO LTD (CN)
International Classes:
G06F16/23; G06F16/242; G06F16/2455
Foreign References:
CN113986933A | 2022-01-28 | |||
CN112286953A | 2021-01-29 | |||
CN111597209A | 2020-08-28 | |||
CN112740199A | 2021-04-30 | |||
US20090319476A1 | 2009-12-24 | |||
US20080147598A1 | 2008-06-19 |
Attorney, Agent or Firm:
EAST & CONCORD PARTNERS (CN)
Download PDF:
Previous Patent: DATA QUERY METHOD AND APPARATUS, STORAGE MEDIUM, AND ELECTRONIC DEVICE
Next Patent: VACUUM CLEANER SELF-CLEANING FILTER DUST COVER
Next Patent: VACUUM CLEANER SELF-CLEANING FILTER DUST COVER