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

Data query paging method and device, server and medium

A data query and data technology, applied in the computer field, can solve the problems of heavy data server burden and high paging difficulty, and achieve the effect of improving paging efficiency and reducing data server burden

Active Publication Date: 2019-12-10
WUHAN DOUYU NETWORK TECH CO LTD
View PDF10 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present application provides a method, device, server, and medium for data query and paging, which solves the existing technical problems of data paging, such as heavy burden on the data server and high difficulty of paging after querying data

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0043] Such as figure 1 As shown, this embodiment provides a data query paging method, including:

[0044] Step S101, obtaining the query condition and the number of paged items, and querying and filtering the target data group in the database according to the query condition;

[0045] Step S102, finding the target field that enables the target data group to be sorted into a data sequence of a unique key; the data sequence of a unique key refers to a data sequence that is not sorted into parallel data items;

[0046]Step S103, according to preset rules, according to the value of the target field in the target data group, sort the data in the target data group to form a unique key data sequence;

[0047] Step S104, paging the data sequence according to the number of paging items, wherein the number of data items per page of the paginated data sequence is equal to the number of paging items;

[0048] Step S105, according to the value of the target field of the first item of da...

Embodiment 2

[0103] This embodiment provides a data paging device, such as figure 2 shown, including:

[0104] The query unit 201 is used to obtain the query condition and the number of paging items, and query and filter out the target data group in the database according to the query condition;

[0105] A search unit 202, configured to find a target field that enables the target data group to be sorted into a data sequence of a unique key; the data sequence of the unique key refers to a data sequence that is not sorted into parallel data items;

[0106] The sorting unit 203 is configured to sort the data in the target data group according to preset rules and according to the value of the target field in the target data group to form a unique key data sequence;

[0107] A paging unit 204, configured to paginate the data sequence according to the number of paging items, wherein the number of data items per page of the paged data sequence is equal to the number of paging items;

[0108] T...

Embodiment 3

[0114] Embodiment three

[0115] This embodiment provides an electronic device, such as image 3 As shown, it includes a memory 310, a processor 320, and a computer program 311 stored on the memory 310 and operable on the processor 320. When the processor 320 executes the computer program 311, the following steps are implemented:

[0116] Obtain the query condition and the number of paging items, and query and filter out the target data group in the database according to the query condition;

[0117] Finding out the target field that enables the target data group to be sorted into a data sequence of a unique key; the data sequence of the unique key refers to a data sequence that is not sorted as a parallel data item;

[0118] According to preset rules, according to the value of the target field in the target data group, sort the data in the target data group to form a unique key data sequence;

[0119] Paging the data sequence according to the number of pagination items, whe...

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 data query paging method and device, an electronic device and a medium, and the method comprises the steps: obtaining a query condition and the number of paging items, and querying a target data group in a database; searching a target field of a data sequence capable of sequencing the target data group into a unique key; sorting the data in the target data group accordingto a preset rule and the value of the target field in the target data group to form a data sequence of a unique key; paging the data sequence according to the paging item number; determining the dataof the previous page of the target page data according to the value of the target field of the first item of data of the target page data and the paging item number; and determining the data of the next page of the target page data according to the value of the preset item of the last item of the target page data and the paging item number. The technical problems of large burden of a data serverand high paging difficulty after data query in existing data paging are solved. The technical effects of reducing the burden of the data server and improving the paging efficiency are achieved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a data query paging method, device, server and medium. Background technique [0002] At present, with the advancement of network communication technology and the acceleration of broadband networks, various network applications have been developed more and more, and then accompanied by the collection of various network data to serve users or help application manufacturers Understand user needs. [0003] However, there is often a large amount of data collected and stored in the database. When it is necessary to obtain the data, in order to save transmission traffic and facilitate user browsing, it is necessary to page the data in the database and page them according to the specified page or in sequence Output data for browsing. Most of the existing paging methods need to take the paging requirements into consideration when designing the data structure, set the serial number (ID...

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): G06F16/2453G06F16/2458
Inventor 胡耀文陈少杰张文明
Owner WUHAN DOUYU NETWORK 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