Database materialized view construction system and method and system creation method

A materialized view and database technology, applied in the field of database materialized view construction systems, can solve problems such as the approximate optimization process failing to converge, oscillating back and forth, and failing to converge.

Pending Publication Date: 2020-08-28
TSINGHUA UNIV
View PDF6 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Among them, the optimization object of the first part is determined by means of probability calculation, which will cause the overall optimization goal to oscillate back and forth

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database materialized view construction system and method and system creation method
  • Database materialized view construction system and method and system creation method
  • Database materialized view construction system and method and system creation method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0077] The application describes a number of embodiments, but the description is illustrative rather than restrictive, and it will be obvious to those of ordinary skill in the art that within the scope of the embodiments described in the application, There are many more embodiments and implementations. Although many possible combinations of features are shown in the drawings and discussed in the detailed description, many other combinations of the disclosed features are possible. Except where expressly limited, any feature or element of any embodiment may be used in combination with, or substituted for, any other feature or element of any other embodiment.

[0078] This application includes and contemplates combinations of features and elements known to those of ordinary skill in the art. The disclosed embodiments, features and elements of this application can also be combined with any conventional features or elements to form unique inventive solutions as defined by the clai...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The embodiment of the invention discloses a database materialized view construction system and method and a system creation method. The system comprises a query load preprocessing module, an offline training module and an online recommendation module. The query load preprocessing module is used for preprocessing an input query load to obtain sub-query representatives; the offline training module is used for training a preset deep learning model and a reinforcement learning model by querying load historical data; the online recommendation module is used for predicting the query cost of a new query obtained after the original query corresponding to each sub-query representation is subjected to view rewriting by using the materialized view corresponding to the sub-query representation througha deep learning model to obtain a newly queried query representation and obtaining the optimal sub-query with the lowest query cost and the corresponding optimal materialized view through the reinforcement learning model. According to the scheme of the embodiment, the redundancy cost of batch query is reduced to a large extent, and convergence of the materialized view approximate optimization process is achieved.

Description

technical field [0001] This article relates to information retrieval technology, especially a database materialized view construction system, method and system creation method. Background technique [0002] In the field of database research, there are many ways to optimize batch queries, one of which is to use materialized view technology to reduce the redundancy cost of batch queries. Specifically, in an online analytical processing (OLAP) system, there are identical subqueries among analytical SQL query statements, and these common subqueries cause redundant query costs. In order to solve such problems, an optimization method is to construct corresponding views for common subqueries, and then reduce redundant query costs by storing the query results of the views and then reusing them. In other words, multiple reuse of one query can greatly improve query efficiency and reduce unnecessary query costs. [0003] However, most of the existing methods still need to rely on the...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/2453G06F16/28G06F16/26
CPCG06F16/24535G06F16/24542G06F16/24547G06F16/285G06F16/26
Inventor 李国良袁海涛冯建华
Owner TSINGHUA UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap