Data query method and device and computer readable storage medium

A data query and data cube technology, applied in the field of big data processing, can solve problems such as low data efficiency, and achieve the effect of reducing workload and improving query efficiency

Active Publication Date: 2019-07-16
HANGZHOU HIKVISION DIGITAL TECH
View PDF10 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In order to solve the problem of low efficiency of querying target data from the data cube table in related technologies, the embodiment of the present invention provides a data query method, device and computer-readable storage medium

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0067] In order to make the object, technical solution and advantages of the present invention clearer, the implementation manner of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0068] For the convenience of subsequent description, before the data query method provided by the embodiment of the present invention is described in detail, First introduce the nouns involved in the embodiments of the present invention .

[0069] Attribute type refers to the information used to describe the inherent attributes of the data itself, and a piece of data can have multiple attribute types. For example, for sales data, sales time, product category and sales area are usually used to describe sales data in practical applications, such as "sales of milk in Xi'an on Monday", "sales of bread in Shanghai on Tuesday", etc. At this time, the attribute types of the sales data include sales time, product category, and sales area. ...

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 discloses a data query method and device and a computer readable storage medium, and belongs to the technical field of big data processing. The method comprises the steps that when a query request of target data is received, a time attribute value corresponding to the target data is determined, and the target data is queried from a data cube table according to the time attribute value corresponding to the target data. The recent data cube table included in the data cube table is used for storing the data of which the time attribute value is within the first preset time period; the historical data cube table included in the data cube table is used for storing data of which the time attribute value is within the second preset time period, therefore, the target data can be searched from the historical data cube table or the recent data cube table according to the time attribute value corresponding to the target data, the direct query of the target data from the whole data cube table is avoided, the workload of querying the target data from the data cube table is reduced, and the query efficiency of the target data can be improved.

Description

technical field [0001] The present invention relates to the technical field of big data processing, in particular to a data query method, device and computer-readable storage medium. Background technique [0002] With the development of Internet technology, it is usually necessary to query massive data according to the needs of users to obtain the data that users want to query. For the convenience of description, the data that users want to query is called target data. In practical applications, the target data is usually data within a certain period of time. For example, if a user wants to query the sales of a certain supermarket yesterday, the target data is the sales of the supermarket on the previous day. [0003] In related technologies, in order to improve the efficiency of querying target data from massive data, a multi-dimensional data cube table can be established in advance, each dimension corresponds to an attribute type of data, and the attribute value of data on...

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 Applications(China)
IPC IPC(8): G06F16/28G06F16/2453
CPCG06F16/24542G06F16/2453G06F16/283
Inventor 席大超
Owner HANGZHOU HIKVISION DIGITAL TECH
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