Materialized view selection and optimization method and device

A materialized view and optimization method technology, applied in the field of database and data warehouse, can solve problems such as high computational complexity and inability to handle nested queries, and achieve the effect of improving rapid response

Active Publication Date: 2020-02-07
INST OF AUTOMATION CHINESE ACAD OF SCI +1
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In order to solve the above-mentioned problems in the prior art, that is, in order to solve the large computational complexity in the actual application process, assuming that the queries are uniformly distributed, and cannot handle nested queries, etc., the present invention adopts the following technical solutions to solve the above-mentioned problems:

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
  • Materialized view selection and optimization method and device
  • Materialized view selection and optimization method and device
  • Materialized view selection and optimization method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The preferred embodiments of the present invention will be described below with reference to the drawings. Those skilled in the art should understand that these embodiments are only used to explain the technical principles of the present invention, and are not intended to limit the protection scope of the present invention.

[0035] It should be noted that the embodiments in this application and the features in the embodiments can be combined with each other if there is no conflict. The application will be described in detail below with reference to the drawings and in conjunction with the embodiments.

[0036] figure 1 It shows an exemplary system architecture that can apply the materialized view selection and optimization method based on the statistical binary tree graph and the linear planning model of the present application or the embodiment of the materialized view selection and optimization processing device.

[0037] Such as figure 1 As shown, the system architecture ...

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 invention relates to the field of computer data processing, provides a method and device for selecting and optimizing a materialized view, and aims at solving the problem about selecting, optimizing and updating of the materialized view in a mass data environment. The method comprises the steps that information of a database is acquired, grouped data with aggregate functions are obtained fromthe database according to the information, and a grouped data set is generated; undistributed aggregate functions of the grouped data are decomposed, grouped data elements of the grouped data are generated, and a grouped data element set is obtained; the grouped data elements identical in data dimensionality and aggregate operation expression mode are confirmed as the same grouped data family; a statistics binary tree model corresponding to each grouped data family is set up, a minimum linear programming model oriented to materialized view optimization is set up, an optimized materialized viewset is obtained, the grouped data are reconstructed based on the materialized view set, and the materialized view is updated according to the change of a fact table relevant to the materialized view.According to the method, fast responses can be made during statistic analysis of mass data.

Description

Technical field [0001] The present invention relates to the technical field of databases and data warehouses, in particular to a materialized view selection and optimization technology in a mass data environment, and in particular to a materialized view selection and optimization method and device. Background technique [0002] With the advent of the big data era, it is becoming more and more important to analyze and mine data with certain characteristics from massive amounts of data. The analysis and mining of massive data has become a necessary means for more and more enterprise decision-making analysis and scientific management. However, with the gradual increase of enterprise data, query response time is getting longer and longer. Materialized View (MV) is an effective query method. It is a physical structure that improves data access time by pre-calculating and saving intermediate results. Can greatly shorten the query response time. However, the use of materialized views ...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/28G06F16/25
CPCG06F16/254G06F16/283
Inventor 谭杰白熹微黄学文刘承宝李亚宁
Owner INST OF AUTOMATION CHINESE ACAD OF SCI
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