Unlock instant, AI-driven research and patent intelligence for your innovation.

A data query method and device

A data query and data technology, applied in the field of database applications, can solve the problems of narrow practical application and low data query efficiency.

Active Publication Date: 2018-07-06
MAIPU COMM TECH CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The above method realizes the storage of massive data, and when querying multi-table data, the existing technology can partition data based on time to store data in multiple tables, and then perform partition query on data based on time, but in this way, when querying data It is necessary to require the stored data to contain time attributes, and the corresponding practical applications are very narrow, and the query efficiency for data that does not contain time attributes is very low

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] 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 only some, not all, embodiments of the present invention. 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.

[0025] An embodiment of the present invention provides a data query method, which is applied to paged query of data stored in multiple tables, such as figure 1 As shown, the method includes:

[0026] 101. The single table query manager acquires the first type of data from the data stored in the single table cache according to the query request input by the user.

[0027] Among them, the number of data contained in the first type of data is the same as the number o...

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 relates to the technical field of database application. The data query method and device can improve the data query efficiency during query of multi-list stored data. The method specifically comprises, according to a query request input by a user, obtaining a first type of data from data stored in single-list buffers, and then obtaining first data from the first type of data according to preset ordering rules, wherein the number of data contained in the first type of data is equal to that of storage lists, and every datum in the first type of data corresponds to one storage list; obtaining one datum from every storage list to compose the first type of data, and then obtaining one first datum from the first type of data. The data query method and device is mainly applied to the process of mass data query.

Description

technical field [0001] The invention relates to the technical field of database application, in particular to a data query method and device. Background technique [0002] With the development of application software, large-scale application systems emerge accordingly, and in these large-scale application systems, the amount of data to be processed is also increasing. When the amount of data is large, the data will be stored in the form of sub-tables, that is, the data of the same type will be stored in multiple tables. For example, when you need to store 10 million pieces of data, you can use 10 tables to store data, so that one table can only store 1 million pieces of data. [0003] The above method realizes the storage of massive data, and when querying multi-table data, the existing technology can partition data based on time to store data in multiple tables, and then perform partition query on data based on time, but in this way, when querying data It is necessary to ...

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): G06F17/30
CPCG06F16/2282G06F16/24552G06F16/2465
Inventor 邓鹏
Owner MAIPU COMM TECH CO LTD