Data paging query method and device

A paging query and data technology, applied in the field of data processing, can solve the problems of large data processing overhead, increase data processing volume, etc., and achieve the effect of reducing data processing overhead, reducing data volume, and reducing network resource consumption

Active Publication Date: 2016-12-14
AGRICULTURAL BANK OF CHINA
View PDF4 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] At the same time, after the server receives the data returned by the Sybase database, it still needs to filter out the data results that meet the query conditions from the data and display them in pages, so that the server needs to perform secondary processing on the data, thereby increasing the amount of data processing and generating Large data processing overhead

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] First explain some terms that may be involved in the embodiments of this application:

[0056] Sybase database: a relational database product developed by Sybase Corporation of the United States, mainly including Sybase Adaptive Server Enterprise (ASE) and Sybase IQ for data warehouses.

[0057] Data pagination: In the case of a large amount of data, only part of the data is queried each time and displayed on a page-by-page basis. Data pagination query is a method of querying the data content to be displayed according to the number of pages specified by the user under the premise of a large amount of data. For example, the user sets 10 records per page, and there are 35 records in total. There are 4 pages in total, 10 pieces of data per page on pages 1-3, and only the last remaining 5 pieces of data are displayed on page 4 if there are less than 10 pieces of data.

[0058] Primary Key / Combined Primary Key: There is often a column or combination of columns in a table wh...

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 data paging query method and device. The method includes the steps: determining current paging query parameters of a data table to be queried; determining main keys and the number of the main keys of the data table; determining target query statement template groups corresponding to the number of the main keys from preset multi-group query statement template groups; writing the paging query parameters at the positions with the paging query parameters to be written in the target query statement template groups, writing the main keys at the positions with the main keys to be written in target query statement templates to obtain target query statement groups; executing the target query statement groups in a database and querying a plurality of entry records to be displayed from target entry records in the data table. The paging query parameters comprise current paging number of branches to be displayed, query conditions and of target number of branches of initial query. By the method and the device, network resources and data processing resources consumed by data paging can be reduced.

Description

technical field [0001] The present application relates to the technical field of data processing, and more specifically relates to a data paging query method and device. Background technique [0002] Data pagination means that in the case of a large amount of data, according to the number of pages specified by the user, the data content to be displayed is queried through calculations, and only part of the data is queried each time and displayed on a page-by-page basis. For example, if the total amount of data to be queried is 35 pieces of data, and each page displays 10 pieces of data, then it needs to be displayed in 4 pages. In this way, pages 1-3 each display 10 pieces of data, while page 4 displays 5 pieces of data. Article data. [0003] Due to the particularity of some databases, the implementation process of data paging is more complicated. For example, taking the Sybase database as an example, the Sybase database is a relational database, which uses the TOP method ...

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/2453G06F16/284
Inventor 刘宇鉴王强郭会
Owner AGRICULTURAL BANK OF CHINA
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap