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

Data query method and device

A data query and data technology, applied in the field of data processing, can solve problems such as high cost and complex materialized view maintenance process

Active Publication Date: 2015-05-27
HUAWEI TECH CO LTD +1
View PDF5 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in order to ensure query efficiency in this method, the materialized view needs to be maintained in real time. For example, whenever new data is inserted, the materialized view needs to be recalculated and updated. The maintenance process of the materialized view is complicated and expensive.

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
  • Data query method and device
  • Data query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0069] In order to enable those skilled in the art to better understand the technical solutions in the embodiments of the present invention, and to make the above-mentioned purposes, features and advantages of the embodiments of the present invention more obvious and understandable, the following describes the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings For further detailed explanation.

[0070] see figure 1 , is a flowchart of a data query method according to an embodiment of the present invention.

[0071] In the embodiment of the present invention, two databases can be pre-established, which are respectively used to store historical query requests (and their timestamps) and historical query results corresponding to historical query requests. In the initial stage, the two databases are empty. After the data query is performed, the data query request is added as a historical query request to the database for s...

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

Disclosed are a data search method and apparatus. In the data search method, multiple historical search request and timestamps thereof, as well as historical search results corresponding to the historical search requests one by one are prestored. The search method comprises: receiving a data search request; performing matching on the data search request and the multiple historical search requests; dividing the data search request into at least one sub-search request according to a matching result; performing a data search according to the sub-search request; and combining search results of the at least one sub-search request, and using the combined search results as results of the data search request. In the method, a materialized view does not need to be established and maintained, and repeated searches do not need to be performed for historical result data and data on which a search has been performed. In this way, data amounts of scanning and computation can be significantly reduced, thereby improving search efficiency, enhancing search performance, and reducing a search cost.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data query method and device. Background technique [0002] With the rapid development of IT technology and the Internet, many applications are accompanied by the generation of large amounts of data, such as stock trading, e-commerce, social networking, etc. These applications are gradually adopting NoSQL to store data. The feature of this data storage method is that most of the data is stored in the way of appending. There is a record time, which is a timestamp. [0003] Based on the above data storage method, in the prior art, when performing data query on big data in the cloud environment, in order to improve the query efficiency, it is necessary to pre-define the query request, and calculate and establish materialization based on the pre-defined query request and the original data in the database. View, when receiving a query request, if the query request is a pre...

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): G06F17/30
CPCG06F16/3349
Inventor 张桂刚李超邢春晓
Owner HUAWEI 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