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

Paging query method and device

A paging query and paging technology, which is applied in the field of data processing, can solve problems such as program exceptions and untimely responses, and achieve the effects of reducing query volume, improving query efficiency and return efficiency, and improving programs that cannot respond in time or are abnormal

Active Publication Date: 2022-02-22
MAIPU COMM TECH CO LTD
View PDF13 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the purpose of the embodiments of the present invention is to provide a paging query method and device, so as to improve the query efficiency of data, and improve the problem of abnormal program or untimely response caused by processing timeout when the amount of data is too large

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

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0026] Please refer to image 3 , image 3 It is a flow chart of a paging query method provided in the first embodiment of the present invention. The paging query method specifically includes the following steps:

[0027] Step S110: Receive a data query command carrying a target data table.

[0028]When the user needs to query or export certain data in the database, as an implementation, the user can send a data query instruction to the server through the user terminal under network conditions, and the data query instruction can include: The data number interval to be queried, the page number to be queried, the data in the target data table, etc., the server end storing the database will receive the data query instruction carrying the target data table sent by the user terminal, and then the server will The above data query command completes the corresponding data query, wherein the database of the server can have one or more tables, and built-in indexes for each table, so t...

no. 2 example

[0041] Please refer to Figure 4 , Figure 4 It is a flow chart of a paged query method provided in the second embodiment of the present invention. The paged query method specifically includes the following steps:

[0042] Step S210: Receive a data query command carrying a target data table.

[0043] Step S220: Obtain the maximum data number and the minimum data number in the target data table, and obtain the total number of records according to the maximum data number and the minimum data number.

[0044] Step S230: Calculate and obtain an initial paging number based on the total number of records and the preset number of paging records.

[0045] Step S240: According to the initial page number and the preset page number of records, obtain the start data number and end data number of each initial page.

[0046] Specifically, the page number corresponding to each initial page is determined according to the initial page number calculated in step S230, wherein the page number ...

no. 3 example

[0067] In order to realize the above paged query method, the third embodiment of the present invention provides a paged query device 100, please refer to 5, Figure 5 A structural block diagram of a paging query device 100 provided in the third embodiment of the present invention, the device includes: a receiving instruction unit 110, a first obtaining unit 120, a second obtaining unit 130, a third obtaining unit 140, and a returning result unit 150.

[0068] The instruction receiving unit 110 is configured to receive a data query instruction carrying a target data table.

[0069] It should be noted that the data query instruction may also carry a specified interval.

[0070] The first obtaining unit 120 is configured to obtain a maximum data number and a minimum data number in the target data table, and obtain a total number of records according to the maximum data number and the minimum data number.

[0071] In particular, when the query instruction carries a specified int...

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 provides a page-by-page query method and device, belonging to the field of data processing. The method includes: receiving a data query instruction carrying a target data table; obtaining the maximum data number and the minimum data number in the target data table, and obtaining the total number of records according to the maximum data number and the minimum data number; based on the total number of records and The number of preset paging records is calculated to obtain the initial number of paging; according to the initial number of paging and the number of preset paging records, the corresponding start data number and end data number of each final page are obtained; according to the number of each final paging The start data number and the end data number return the data corresponding to each final page in the target data table, so that when querying the data of each final page, it will no longer involve querying data other than the final page, greatly It greatly reduces the amount of data query and improves the efficiency of data query and return.

Description

technical field [0001] The present invention relates to the field of data processing, in particular, to a page-by-page query method and device. Background technique [0002] With the development of information technology and the market, especially after the 1990s, data management is no longer just about storing and managing data, but has transformed into a variety of data management methods required by users. At the same time, the information in the database The amount is increasing, and people often need to search and query various information in the database according to their own needs. When the amount of data is too large, various problems may occur during the query, such as exhaustion of server resources, processing timeout due to excessive data transmission, etc., which will eventually cause the query to fail. [0003] The pagination query of the MYSQL database uses the limit method, and its usage method is: limit n m, where n represents the offset, and m represents t...

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/2453
CPCG06F16/2453
Inventor 李超黄山吴飞
Owner MAIPU COMM 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