Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data query method and device, electronic equipment and computer readable storage medium

A data query, query type technology, applied in the database field, can solve problems such as low query efficiency

Active Publication Date: 2020-12-11
BEIJING BAIDU NETCOM SCI & TECH CO LTD
View PDF8 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Embodiments of the present invention provide a data query method, device, electronic equipment, and computer-readable storage medium to solve the problem of low query efficiency in the prior art when materialized views are used for data query

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
  • Data query method and device, electronic equipment and computer readable storage medium
  • Data query method and device, electronic equipment and computer readable storage medium
  • Data query method and device, electronic equipment and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0021] Firstly, the data query method provided by the embodiment of the present invention will be described below.

[0022] It should be noted that the data query method provided by the embodiment of the present invention can be applied to electronic devices. Here, the electronic device may be a server, such as a database server using Structured Query Language (SQL), and of course, the electronic device may also be other devices with data query capabil...

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 provides a data query method and device, electronic equipment and a computer readable storage medium. The method comprises the following steps of performing data aggregation processing on a basic materialized view to create a plurality of polymerized views; and under the condition that a data query request for the basic materialized view is received, determining a first materializedview supporting the data query request from the basic materialized view and the plurality of polymerized views, and performing data query in the first materialized view. Compared with the prior art, the method can reduce the query pressure and shorten the query time, and thereby query efficiency is improved.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular to a data query method, device, electronic equipment, and computer-readable storage medium. Background technique [0002] In the field of database technology, materialized views are widely used. It can be understood that the materialized view is a special physical table, and the materialized view is relative to the ordinary view, and the materialized view itself stores data. [0003] In many cases, it is necessary to query data based on materialized views. The existing query method is: when receiving a data query request for any materialized view, directly query the corresponding data in the materialized view and return the query result to the user. Then, when there are multiple concurrently initiated data query requests for the same materialized view, the query pressure will be very high, and the query process will take a very long time, which will...

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/22G06F16/2453G06F16/2458
CPCG06F16/2282G06F16/2453G06F16/2458
Inventor 陈浩牟宇航马如悦
Owner BEIJING BAIDU NETCOM SCI & TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com