Paging querying method and system

A page-by-page query and page-by-page technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems of increasing the workload of application service developers, reducing the efficiency of application service development, waste of resources, etc., to avoid repeated development Work and improve development efficiency

Active Publication Date: 2015-01-21
CHINA CONSTRUCTION BANK
View PDF3 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, the result set segmentation process is performed by the application service (query service) of the application layer, thus increasing the workload of application service developers and reducing the development efficiency of application services; at the same time, the underlying database and the application service of the application layer There is often a one-to-many relationship between each application service, and the repetitive development of the result set segmentation function between application services also causes unnecessary waste of resources

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 querying method and system
  • Paging querying method and system
  • Paging querying method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0051] Embodiment 1 discloses a page-by-page query method.

[0052] When the user needs to use the page-by-page browsing function to browse a large amount of data in pages, in order to send the query results to the front-end page of the application service according to the specified page number for users to view, it is necessary to perform a segmentation process on the result set in the database that meets the query conditions. The data pseudo-column - ROWNUM column will be used when the query is performed. ROWNUM is the row number automatically generated by the database along with the query. Among them, the database generates a unique ROWNUM for each record in the result set that meets the query conditions, and each record in the result set The ROWNUM of a record starts from 0 and increases in increments of 1.

[0053] When segmenting the result set, the specific row number interval required for this pagination query can be calculated according to ROWNUM, page number, and the n...

Embodiment 2

[0078] Embodiment 2 discloses a page-by-page query system, which corresponds to the page-by-page query method disclosed in Embodiment 1. Refer to Figure 4 , the system includes a receiving module 100 , a first obtaining module 200 , a calculating module 300 , a second obtaining module 400 and a sending module 500 .

[0079] The receiving module 100 is configured to receive the query request sent by the application service of the application layer, and the query request includes the page number, the number of page records and query conditions.

[0080] The first obtaining module 200 is configured to obtain the total number of records meeting the query condition in the database, and mark it as the total number of records.

[0081] Wherein, the first obtaining module 200 includes a filtering unit, a first creating unit and a statistical unit.

[0082] a filtering unit, configured to filter out the query condition from the query request;

[0083] The first creation unit is 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
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a paging querying method and a system. The method comprises the following steps: receiving a querying request transmitted from an application service of an application layer, wherein the request comprises paging numbers, paging record numbers and querying conditions; subsequently, performing segmentation on a result cluster which meets the querying conditions according to the paging numbers and the paging record numbers in the querying request, specifically, calculating a line number section corresponding to a paging number, and acquiring a paging querying result cluster corresponding to the paging number based on a line number section; finally feeding back response information containing the paging querying result cluster to the application service, so as to achieve paging display of the result cluster through the application service. In a practical application situation, the system can be used as a service layer between the application layer and a databank, and the paging querying service is provided for the application layer, so that the process of segmenting the result cluster is extracted outside the application layer and is used as the universal function scheduled by the application layer, unnecessary repeated development operation among application services is avoided, and the development efficiency of the application services is improved.

Description

technical field [0001] The invention belongs to the technical field of page-by-page query of databases, and in particular relates to a page-by-page query method and system. Background technique [0002] The page-by-page browsing function is a common web application function. When users need to browse a large amount of data, they can use the page-by-page browsing function to view the result set page by page. [0003] The realization of the paging browsing function needs to perform a segmentation process on the result set (including multiple records) that meets the query conditions according to the number of paging records (that is, the maximum number of records that can be included in each page) and the specified paging number, so as to realize the specified paging number record acquisition. At present, the result set segmentation process is performed by the application service (query service) of the application layer, thus increasing the workload of application service deve...

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/2219G06F16/24537G06F16/2454G06F16/24553G06F16/24554G06F16/2465
Inventor 陈炙聂砂李拓贾国琛白彧斐
Owner CHINA CONSTRUCTION BANK
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