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

Method and device for inquiring data

A technology for querying data and data, applied in the field of querying data, can solve problems such as increasing network pressure

Active Publication Date: 2014-03-26
ADVANCED NEW TECH CO LTD
View PDF4 Cites 30 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] This application provides a method and device for querying data to solve the problem that the paging query method in the prior art will increase the pressure on the network

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
  • Method and device for inquiring data
  • Method and device for inquiring data
  • Method and device for inquiring data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] Because in the existing technology, when performing pagination query in the scenario of sub-database and sub-table, the client needs to obtain all the data in the condition range from each sub-database, and all the data in the condition range stored in each sub-database is often a large amount. Therefore, the client's acquisition of these large amounts of data will inevitably generate a large amount of network communication, resulting in increased network pressure. The core idea of ​​the embodiment of the present application is to reduce the amount of data obtained from each sub-database as much as possible under the condition that the user can be provided with the data they want to query, so as to achieve the purpose of reducing the network communication generated by obtaining data. To reduce the pressure on the network.

[0022] The embodiments of the present application will be described in detail below in conjunction with the accompanying drawings.

[0023] figure...

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 method and device for inquiring data. The method and device aim to solve the problem that a paging query method in the prior art increases network pressure. According to the method, a client determines the number N of data obtained from each branch library according to an input query page number and the number of data contained in each page, then the first N data in data which are in a condition interval and sequenced according to a sequencing rule are obtained in each branch library according to the input condition interval and the sequencing rule, and finally the obtained data are sequenced according to the sequencing rule and corresponding data are provided according to the query page number. By means of the method, the client carries out paging query in a branch library and branch table scene, not all the data in the condition interval need to be obtained from the branch libraries, and what is needed is to obtain a part of the data in the condition interval in each branch library so that network communication generated when the client obtains the data can be reduced, and the network pressure can be effectively reduced.

Description

technical field [0001] The present application relates to the technical field of the Internet, in particular to a method and device for querying data. Background technique [0002] At present, when querying data in the database, the method of querying by paging is often used for querying. When using the paging query method for data query, the user needs to input the condition interval, sorting rules, and query page number, and the database will first extract all the data in the condition interval, then sort the extracted data according to the sorting rules, and finally sort Among the last data, the data that determines the corresponding page number is returned to the user. [0003] For example, if the input condition interval is the last two days, the sorting rule is the order of time, and the query page number is page 2, the database will first extract all the data in the last two days, and then sort the extracted data in chronological order , assuming that each page incl...

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): G06F17/30
CPCG06F16/24532G06F16/2471
Inventor 陈锐发
Owner ADVANCED NEW 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