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 low query efficiency and long aggregate query response time, and achieve the effect of shortening query response time and improving query efficiency

Active Publication Date: 2020-10-09
HANGZHOU HIKVISION DIGITAL TECH
View PDF7 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In order to solve the problems of long response time and low query efficiency of aggregation query in the prior art, the embodiment of the present invention provides a data query method and device

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

[0065] 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.

[0066] Before explaining and describing the embodiments of the present invention in detail, the application scenarios of the embodiments of the present invention are firstly introduced. In the current information society, all kinds of information resources can be digitized and stored as data. However, due to the increasing amount of data, the storage capacity of a device is often not enough. Therefore, a large amount of data can be dispersed Stored in multiple devices that can be connected via a network to form a large distributed database. In a distributed database, multiple devices generally store data through data tables, and different data tables include different dimensions, and different data tables are distinguished by table nam...

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 belongs to the data processing field. The method comprises the steps that when a structured query language (SQL) query statement is received,a target data table to be queried by the SQL statement is determined; according to dimensions and measurement included in the SQL query statement, target pre-statistical information is determined from at least one piece of pre-statistical information in the target data table; and aggregate query results are acquired according to the SQL query statement and the target pre-statistical information.Since the at least one piece of pre-statistical information is obtained by performing aggregation operation on data in the target data table in advance, after the target pre-statistical information isdetermined according to the SQL query statement, part or all of the aggregate query results can be directly acquired from the target pre-statistical information, the process of acquiring data from the target data table and performing real-time operation on a large amount of data is omitted, query response time is shortened, and query efficiency is improved.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a data query method and device. Background technique [0002] As the amount of data becomes larger and larger, a large amount of data can be stored in multiple devices through the data table, and the multiple devices are connected through the network to form a complete, globally logically centralized, physically dispersed large-scale distributed database. After that, the data in the distributed database can be queried through SQL (Structured Query Language, Structured Query Language). [0003] Wherein, when data query is performed on the database through an SQL statement, not only one piece of information in the data table can be queried, but also multiple pieces of information can be queried and summarized. The method of querying multiple pieces of information from the database through SQL statements and summarizing the multiple pieces of information is called aggregation query....

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/27G06F16/242G06F16/2455G06F16/2453
Inventor 郭峰陈国栋管国辰
Owner HANGZHOU HIKVISION DIGITAL TECH
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