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

Data paging method, device and system

A data allocation and data technology, applied in the field of data processing, can solve problems such as poor execution performance of database statements, achieve the effect of reducing complexity and execution times, and reducing contention

Active Publication Date: 2012-05-30
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF4 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the embodiments of the present invention is to provide a data paging method, aiming to solve the problem in the prior art that when the data query results are paginated and displayed, the physical table needs to be accessed multiple times, resulting in poor execution performance of database statements

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0019] In the embodiment of the present invention, by generating a temporary table with a sequence number, the paged display of the data query result is realized according to the sequence number in the temporary table, so that when the data query result is displayed in pages, it is not necessary to display each The physical table is accessed during paging, which reduces the complexity and execution times of database statements, and reduces the contention of lock resources.

[0020] In order to illustrate the technical solutions of the present invention, specific examples are used below to illustrat...

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 is applicable to the data processing field and provides a data paging method, a data paging device and a data paging system. The method comprises the following steps: acquiring data in accordance with inquiry conditions from a physical table, assigning a sequence number for the acquired data, and storing the data with the assigned sequence number in a temporary table; calculating left and right margins of the sequence number of the currently showed page according to the number of the showed data of each page, set by the data showed page; and acquiring the showed data of the current page from the temporary table according to the left and right margins of the sequence number in the currently showed page. According to the invention, the temporary table with the sequence number is generated to realize paging show of the data inquiry result directly based on the sequence number in the temporary table when the data inquiry result is showed in a paging manner, and meanwhile, when the data in the physical table is modified, the data in the temporary table is updated synchronously, thus the complexity and execution frequency of the database sentences can be reduced.

Description

technical field [0001] The invention belongs to the field of data processing, and in particular relates to a data paging method, device and system. Background technique [0002] To realize data query in the existing data management system, firstly, it needs to associate with the physical table of the query data, query and save the key information of the data that meets the query conditions, and then display each page of data in pages according to the range of the key Every time, a page of data is read from the physical table. Since each query needs to be associated with the physical table, the complexity of the database statement and the overhead of locking resources are increased. At the same time, once the data in the physical table changes, the relevant data needs to be obtained again, which increases the execution time of the database statement. Complexity and times, execution performance is greatly affected. Contents of the invention [0003] The purpose of the embo...

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
IPC IPC(8): G06F17/30
Inventor 崔智刚
Owner KINGDEE SOFTWARE(CHINA) 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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com