Data query method, device and electronic equipment

A data query and data technology, applied in the field of data processing, can solve the problems of affecting retrieval efficiency, high retrieval maintenance and interaction costs, unstable retrieval performance, etc., and achieve the effects of improving retrieval efficiency, reducing the amount of query data, and reducing maintenance costs

Active Publication Date: 2021-07-23
BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Overall, the existing methods of data retrieval based on partition columns are either unstable in retrieval performance, affecting retrieval efficiency, or require high maintenance and interaction costs for retrieval

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below in conjunction with the accompanying drawings. Obviously, the described embodiments are part of the embodiments of the present invention, not all of them. the embodiment. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0034] Considering that the existing methods of data retrieval based on partition columns have either low retrieval efficiency or high retrieval maintenance and interaction costs, the embodiments of the present invention provide a data query method, device and electronic equipment. It can be applied to query applications of various types of databases.

[0035] To facilitate the unde...

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 present invention provides a data query method, device and electronic equipment, and relates to the technical field of data processing. The method includes: receiving a query request for target data; The data set; wherein, the data of the database is divided into multiple data sets in advance according to the data attribute set and the attribute values ​​of each data attribute in the data attribute set; and the query result is obtained according to the determined data set. In the embodiment of the present invention, the data in the database is divided into multiple data sets according to the data attributes and their attribute values ​​in advance. When the target data needs to be queried, the data where the target data is located can be quickly located according to the data attributes and attribute values ​​of the target data. Set, and then narrow the query scope to one or more data sets, greatly reducing the amount of query data and improving retrieval efficiency.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data query method, device and electronic equipment. Background technique [0002] In the sub-database and table-splitting strategy of conventional distributed databases, a certain column of the database table is generally selected as the partition column (sharding key), and then the data of the database table is distributed among several databases according to the partition strategy (such as Hash, List, Range, etc.) node. However, in practical applications, some business accesses are not retrieved according to the partition column, resulting in query operations that need to traverse the storage engines of all database nodes in the cluster, greatly reducing efficiency. To solve this problem, commonly used solutions are: [0003] (1) High-frequency priority scheme: According to the access characteristics of the business, select the retrieval column corresponding to the ...

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/2458G06F16/248G06F16/22G06F16/27
CPCG06F16/2282G06F16/2471G06F16/248G06F16/27
Inventor 张健
Owner BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD
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