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

Paging realization method and paging system

An implementation method and a paging system technology, applied in the computer field, can solve problems such as unsuitable for large-scale concurrent access, slow query speed, etc.

Active Publication Date: 2017-09-19
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF10 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the amount of data is large and the number of pages is large, the query speed of jumping to pages with larger page numbers is relatively slow, which is not suitable for large-scale concurrent access

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The present invention is described below based on examples, but the present invention is not limited to these examples. In the following detailed description of the present invention, some specific details are described in detail. Those skilled in the art can fully understand the present invention without the description of these details. In order to avoid obscuring the essence of the present invention, the well-known methods, processes, and procedures are not described in detail. In addition, the drawings are not necessarily drawn to scale. It should also be noted that in this article, relational terms such as first and second are only used to distinguish one entity or step from another entity or step, and do not necessarily require or imply these entities or steps. There is any such actual relationship or order between.

[0030] figure 1 It is a flowchart of a method for implementing paging according to an embodiment of the present invention. figure 1 The paging reali...

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

An embodiment of the invention provides a paging realization method. The method comprises the steps of receiving paging request information, wherein paging request data comprises a query SQL and check information of second data; judging whether a first cache stores the query SQL or not; retrieving the first cache according to the query SQL to obtain a first fragmentation index; judging whether a second cache stores the second data or not according to the check information; obtaining first data from the second cache; and obtaining the second data according to the first data, wherein the first fragmentation index includes at least one fragmentation index, the first cache stores a corresponding relationship between the query SQL and the first fragmentation index, the second cache stores the first data, and the first data is marked with one fragmentation index. Through combined use of the first cache and the second cache, the shortcomings of database paging and memory paging are overcome, the memory usage efficiency is improved, and a high-concurrent paging request is satisfied.

Description

Technical field [0001] The present invention relates to the field of computers, in particular to a paging realization method and paging system. Background technique [0002] With the rapid development of the Internet, the amount of information is getting larger and larger, and the data in some database storage tables has reached tens of millions of levels. Faced with such a huge data record set, it is impossible to display one page in a limited page. Then there needs to be a way to provide fast and accurate paging display. [0003] Traditional paging technologies include two types: [0004] One is to page after all the data is loaded. This kind of paging usually uses the front-end paging control for paging, and all the data in the background is queried and saved in the corresponding collection, and then the data collection is passed to the front-end paging control. This method is relatively simple to implement. The advantage is that it is fast, but the disadvantage is that when th...

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 BEIJING JINGDONG SHANGKE INFORMATION 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