CN113946725B

CN113946725B - Paging query method and device, storage medium and electronic equipment

Info

Publication number: CN113946725B
Application number: CN202111559740.5A
Authority: CN
Inventors: 王硕; 闵博; 孙成新; 王金明
Original assignee: Feihu Information Technology Tianjin Co Ltd
Current assignee: Feihu Information Technology Tianjin Co Ltd
Priority date: 2021-12-20
Filing date: 2021-12-20
Publication date: 2022-03-01
Anticipated expiration: 2041-12-20
Also published as: CN113946725A

Abstract

The invention provides a paging query method and device, a storage medium and an electronic device, wherein the method comprises the following steps: responding to the operation that a user jumps from a current result page to a target result page, judging whether the target result page is a page except for a first page and a last page, and if so, determining a second page in the current result page, the first page and the last page; determining the relative page number and the relative sequence relation between the target result page and the second page; determining a target data identifier corresponding to the second page in the data identifier sequence; and determining a plurality of query result identifications in the data identification sequence according to the relative page number, the relative sequence relation and the target data identification, and taking the result data corresponding to each query result identification as the query result corresponding to the target result page. When the method of the invention is used for inquiring the data of a certain page, the data screening from the first data is not required to be fixed, the data quantity of the screening inquiry can be reduced, and the resource and performance consumption can be reduced.

Description

Paging query method and device, storage medium and electronic equipment

Technical Field

The present invention relates to the field of data query technologies, and in particular, to a paging query method and apparatus, a storage medium, and an electronic device.

Background

In the operation process of various enterprise organizations, the search query of data is one of the common business service functions. In the process of querying data by a user, if the data volume of the query result is large, the query result is usually displayed in a paging query mode, that is, the result data is divided into a plurality of pages to be displayed, and each page displays a fixed number of data.

When the query result is displayed in the form of paging query, the user can perform page skipping query, that is, specify to view data of a certain page. At present, when result data of a page corresponding to a specified page number is queried, all the result data need to be sorted, and after the result data corresponding to all pages before the specified page number is queried by screening from front to back, the result data of the page corresponding to the specified page number is obtained.

In the actual paging query process, a user often needs to perform deep paging query, that is, query a result data page with a large page number. Based on the existing paging query method, when result data of a page corresponding to a large page number is queried, the quantity of the data needing to be screened and queried is large, so that resource and performance consumption in the query process is large.

Disclosure of Invention

In view of this, the embodiment of the present invention provides a paging query method, so as to solve the problems that the amount of data to be screened and queried is large and the consumption of resources and performance is large in the existing paging query process.

The embodiment of the invention also provides a paging inquiry device which is used for ensuring the actual realization and application of the method.

In order to achieve the above purpose, the embodiments of the present invention provide the following technical solutions:

a method of paging queries, comprising:

responding to the operation that a user jumps from a current result page to a target result page in the query process, and judging whether the target result page is a page in each first page, wherein the first page is a page except a first page and a last page in each result page corresponding to the query process;

if the target result page is a page in each first page, determining a second page corresponding to the target result page in the current result page, the first page and the last page;

determining the relative page number and the relative sequence relation between the target result page and the second page;

determining a target data identifier corresponding to the second page in the data identifier sequence; the data identification sequence comprises a plurality of data identifications corresponding to the current query result;

determining a plurality of query result identifications corresponding to the target result page in the data identification sequence according to the relative page number, the relative sequence relation and the target data identification;

and determining result data corresponding to each query result identifier, and taking each result data as a query result corresponding to the target result page.

Optionally, in the method, determining, in the current result page, the first page, and the last page, a second page corresponding to the target result page includes:

determining a current page number corresponding to the current result page, a first page number corresponding to the first page, a tail page number corresponding to the tail page and a target page number corresponding to the target result page;

determining a first difference value corresponding to the home page, wherein the first difference value is a difference value between the target page number and the home page number;

determining a second difference value corresponding to the tail page, wherein the second difference value is a difference value between the tail page number and the target page number;

determining a third difference value corresponding to the current result page, wherein the third difference value is an absolute value of a difference value between the target page and the current page;

comparing the first gap value, the second gap value and the third gap value, and taking the gap value with the minimum value as a target gap value;

and taking the page corresponding to the target gap value as the second page.

In the foregoing method, optionally, the determining, in the data identifier sequence, a target data identifier corresponding to the second page, where the second page is the current result page, includes:

determining a header data identifier and a footer data identifier corresponding to the second page in the data identifier sequence;

if the relative sequence relationship is characterized, and the second page is a page before the target result page, taking a data identifier which is next to the page tail data identifier in the data identifier sequence as the target data identifier;

and if the relative sequence relationship is characterized and the second page is a page behind the target result page, taking a previous data identifier of the header data identifier in the data identifier sequence as the target data identifier.

In the foregoing method, optionally, the second page is the home page, and determining, in the data identifier sequence, a target data identifier corresponding to the second page includes:

and identifying the first data in the data identification sequence as the target data identification.

In the foregoing method, optionally, the second page is the end page, and determining, in the data identifier sequence, a target data identifier corresponding to the second page includes:

and taking the last data identifier in the data identifier sequence as the target data identifier.

Optionally, in the method, determining, in the data identifier sequence, a plurality of query result identifiers corresponding to the target result page according to the relative page number, the relative order relationship, and the target data identifier includes:

determining the selection quantity and the screening quantity corresponding to the relative page number;

determining the selection sequence of each data identifier in the data identifier sequence according to the relative sequence relation;

in the data identification sequence, the target data identification is used as a first selected data identification, and a plurality of first data identifications corresponding to the selected number are selected according to the selection sequence of each data identification;

and screening out each first data identifier corresponding to the screening quantity in the plurality of first data identifiers according to the selection sequence of the plurality of first data identifiers to obtain each second data identifier, and taking each second data identifier as the query result identifier corresponding to the target result page.

The above method, optionally, further includes:

if the target result page is not the page in each first page, determining whether the target result page is the tail page;

if the target result page is the tail page, performing reverse order arrangement on each data identifier in the data identifier sequence to obtain a reverse order sequence corresponding to the data identifier sequence;

determining the target quantity corresponding to the target result page;

in the reverse sequence, selecting a plurality of tail page result identifications corresponding to the target quantity according to the arrangement sequence of each data identification in the reverse sequence;

and determining tail page result data corresponding to each tail page result identification, and taking each tail page result data as a query result corresponding to the target result page.

A paging inquiry apparatus comprising:

a judging unit, configured to respond to an operation of a user jumping from a current result page to a target result page in a query process, and judge whether the target result page is a page in each first page, where the first page is a page, except for a first page and a last page, in each result page corresponding to the query process;

a first determining unit, configured to determine, if the target result page is a page in each of the first pages, a second page corresponding to the target result page in the current result page, the first page, and the last page;

a second determining unit, configured to determine a relative page number and a relative order relationship between the target result page and the second page;

a third determining unit, configured to determine, in the data identifier sequence, a target data identifier corresponding to the second page; the data identification sequence comprises a plurality of data identifications corresponding to the current query result;

a fourth determining unit, configured to determine, according to the relative page number, the relative order relationship, and the target data identifier, multiple query result identifiers corresponding to the target result page in the data identifier sequence;

and the fifth determining unit is used for determining result data corresponding to each query result identifier, and taking each result data as the query result corresponding to the target result page.

A storage medium comprising stored instructions, wherein the instructions, when executed, control a device on which the storage medium is located to perform a paging query method as described above.

An electronic device comprising a memory, and one or more instructions, wherein the one or more instructions are stored in the memory and configured to be executed by one or more processors to perform the page lookup method as described above.

Based on the above-mentioned paging inquiry method provided by the embodiment of the present invention, the paging inquiry method includes: responding to the operation that a user jumps from a current result page to a target result page in the query process, judging whether the target result page is a page other than a first page and a last page, and if the target result page is the page other than the first page and the last page, determining a second page corresponding to the target result page in the current result page, the first page and the last page; determining the relative page number and the relative sequence relation between the target result page and the second page; determining a target data identifier corresponding to the second page in the data identifier sequence; the data identification sequence comprises a plurality of data identifications corresponding to the current query result; determining a plurality of corresponding query result identifications in a data identification sequence according to the relative page number, the relative sequence relation and the target data identification; and taking the result data corresponding to each query result identification as the query result corresponding to the target result page. By applying the method provided by the embodiment of the invention, in the paging query process, a second page can be determined in the first page, the last page and the current result page, and in the data identification sequence, the data identification is screened based on the target data identification corresponding to the second page and the relative page number and relative sequence relation between the second page and the target result page. The first data identification of the data identification sequence is not required to be searched and screened, so that the data quantity of the screening query can be reduced, the consumption of system resources and performance is reduced, the time consumption of the query can be reduced, and the query efficiency is improved.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.

Fig. 1 is a flowchart of a method of a paging query method according to an embodiment of the present invention;

FIG. 2 is a flowchart of another method of a paging query method according to an embodiment of the present invention;

FIG. 3 is a flowchart of another method of a paging query method according to an embodiment of the present invention;

fig. 4 is a schematic structural diagram of a paging query apparatus according to an embodiment of the present invention;

fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

In this application, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.

As is known in the art, paging queries are one of the common forms of queries. The essence of the paging query is to filter and sort the data according to the set sorting conditions and the screening conditions, when the query result data corresponding to the number of pages N is viewed, the data can be regarded as data skipping N-1 pages, if each page displays M pieces of data, the data is screened according to the screening conditions and the sorting conditions in the data set, the (N-1) M pieces of data are counted all the time, the (N-1) M pieces of data are discarded, and the M pieces of data after being acquired are regarded as the data of the nth page. When deep paging is performed, that is, a large number of pages is queried, it is equivalent to query most data, and the consumption on system performance is very large.

Therefore, the embodiment of the present invention provides a paging query method, which can perform data screening for relative page skipping based on a first page, a last page or a current result page when querying result data corresponding to a target result page, without starting to screen data from start data of a data set, so that the query amount of data can be reduced, and consumption of system performance can be reduced.

The embodiment of the invention provides a paging query method, which can be applied to various query systems, wherein an execution subject of the method can be a server of the system, and a flow chart of the method is shown in figure 1 and comprises the following steps:

s101: responding to the operation that a user jumps from a current result page to a target result page in the query process, and judging whether the target result page is a page in each first page, wherein the first page is a page except a first page and a last page in each result page corresponding to the query process;

in the method provided by the embodiment of the invention, a user can input query conditions (such as screening conditions and sorting conditions) in a query system according to the query requirement of the user to query data, a server can query, screen and sort the data based on the query conditions to obtain a current data set meeting the query conditions, and according to a result display mode of the query system, such as displaying M pieces of data on each page, the method can determine how many result pages are needed in total for displaying all result data in the current data set. When the query result is fed back to the user, each result data corresponding to the first result page, that is, the data of the first page, is displayed first, and meanwhile, the page number identifier corresponding to each result page is displayed in the page, and if ten pages are total, the user is prompted to view the result data of each page in the ten result pages with the tail page number as the identifier of ten.

When a user views data of a current result page at the front end of the system, the user can select to jump to a target result page through a page number selection mode in the current result page (such as clicking a certain page code identifier or inputting a certain page code number in a page frame), namely, the user selects to inquire result data in the target result page. And responding to the page jump operation of the user, and judging whether the target result page inquired by the user is a page other than the first page and the last page. Specifically, the determination may be performed by comparing the page numbers, and if there are ten pages in total, it is determined whether the page number of the target result page is one or ten.

In the method provided by the embodiment of the invention, the current result page can be any one of the result pages corresponding to the current query process. The query system can be a system constructed based on the search engine Elasticsearch (ES), and the ES is a search server based on Lucene. It provides a distributed multi-user capable full-text search engine based on RESTful web interface.

S102: if the target result page is a page in each first page, determining a second page corresponding to the target result page in the current result page, the first page and the last page;

in the method provided by the embodiment of the invention, if the target result page is a page other than the first page and the last page, the second page closest to the target result page is determined in the current result page, the first page and the last page. It should be noted that, in a specific application process, the current result page may be a first page or a last page, and therefore, a second page may be determined in the first page and the last page, which does not affect the implementation function of the method provided by the embodiment of the present invention. If the current result page is the first page or the last page, in the subsequent processing process, the page can be regarded as the current result page to be processed, but not as the first page or the last page to be processed.

S103: determining the relative page number and the relative sequence relation between the target result page and the second page;

in the method provided by the embodiment of the invention, the relative page number and the relative sequence relation between the target result page and the second page can be determined through the page number of the second page and the page number of the target result page. The relative page number is the page number counted from the reference to the target result page or the second page. If the second page is not the first page or the last page, counting is started from the second page, for example, the second page is the third page, the target result page is the sixth page, the sixth page is the third page after the third page, and the relative page number between the sixth page and the third page is three pages. If the second page is the first page or the last page (not the current result page), when the relative page number is determined, the second page is counted as the first page, for example, the second page is the first page, the target result page is the third page, and therefore the relative page number between the two pages is also three pages. If the second page is the end page, it is the tenth page, the target result page is the sixth page, and the relative page number between the two is five pages.

The relative order relationship is a relationship representing the front-back order of the target result page and the second page, and can be specifically determined by the size relationship of the two corresponding page numbers, if the page number of the second page is greater than that of the target result page, the second page is a page behind the target result page, and if the page number of the second page is less than that of the target result page, the second page is a page ahead of the target result page.

S104: determining a target data identifier corresponding to the second page in the data identifier sequence; the data identification sequence comprises a plurality of data identifications corresponding to the current query result;

in the method provided by the embodiment of the invention, in the query process, the data identifiers (such as data IDs) corresponding to the result data are generally subjected to query sorting screening, and after each data identifier corresponding to the page is determined, the result data is read according to the data identifiers and is used for page display. After data query is carried out based on query conditions input by a user, data identifiers corresponding to each result data corresponding to the query results can be obtained, and a data identifier sequence can be obtained by arranging according to the sorting conditions.

Through the matching of the data identifications, a target data identification corresponding to the second page can be determined in the data identification sequence, wherein the target data identification is an identification used for representing the result data displayed by the second page and the corresponding position in the data identification sequence. For example, the target data identifier may be a data identifier corresponding to the start or end result data in the second page, or may be a previous data identifier of a data identifier corresponding to the start result data, or a subsequent data identifier of a data identifier corresponding to the end result data, and may represent a location of the data identifier corresponding to the second page in the data identifier sequence, so as to filter data from the location.

S105: determining a plurality of query result identifications corresponding to the target result page in the data identification sequence according to the relative page number, the relative sequence relation and the target data identification;

in the method provided by the embodiment of the invention, the quantity of data to be queried and the quantity of data to be filtered in the screening process can be determined according to the relative page number between the second page and the target result page, the screening direction of the data is determined according to the relative sequence relation, and each query result identifier corresponding to the target result page is obtained by screening by taking the target data identifier as a starting point in the data identifier sequence.

S106: and determining result data corresponding to each query result identifier, and taking each result data as a query result corresponding to the target result page.

In the method provided by the embodiment of the invention, the result data corresponding to each query result identifier can be read through the matching of the data identifiers, and each read result data is used as the query result corresponding to the target result page and is displayed in the front end of the system.

Based on the method provided by the embodiment of the invention, when the user jumps from the current result page to the target result page, if the target result page is not the first page or the last page, the second page is determined in the current result page, the first page and the last page. And determining the relative page number and the relative sequence relation between the second page and the target result page, and determining the target data identifier corresponding to the second page in the data identifier sequence containing the plurality of data identifiers corresponding to the current query result. And determining a plurality of query result identifications corresponding to the target result page in the data identification sequence according to the relative page number, the relative sequence relation and the target data identification so as to obtain each result data corresponding to the target result page. By applying the method provided by the embodiment of the invention, the data identification is screened from the target data identification in the data identification sequence based on the relative page number and the relative sequence relation between the second page and the target result page. The query screening is not required to be carried out from the first data identifier of the data identifier sequence, so that the data quantity of the screening query can be reduced, the consumption of resources and performance is reduced, and the query efficiency can be improved.

Further, on the basis of the method shown in fig. 1, an embodiment of the present invention provides another paging query method, where the process of determining, in the current result page, the first page, and the last page, a second page corresponding to the target result page, which is mentioned in step S102, includes:

and taking the page corresponding to the target gap value as the second page.

In the method provided by the embodiment of the present invention, the page number of the current result page may be used as the current page number, the page number of the first page may be used as the page number of the first page, the page number of the last page may be used as the page number of the last page, and the page number of the target result page may be used as the target page number. And performing difference operation on the target page number and the first page number to obtain a first difference value, namely a page value of the difference between the first page and the target result page. And performing difference operation on the tail page number and the target page number to obtain a second difference value, namely a page value of the difference between the tail page and the target result page. And performing difference operation on the target page number and the current page number, and taking an absolute value of an operation result to obtain a third difference value, namely a page value of the difference between the current result page and the target result page. In a specific application process, the subtraction number and the subtrahend number of each difference operation may not be limited, and an absolute value may be taken from the operation result.

In the method provided by the embodiment of the present invention, the calculated difference values may be compared in numerical value, the difference value with the smallest numerical value is used as the target difference value, and the page corresponding to the target difference value is used as the second page, that is, the page with the page number closest to the page number of the target result page among the current result page, the first page, and the last page is used as the second page. If the same difference value exists and the value is the minimum, one difference value can be randomly selected as the target difference value. The priority levels of the first page, the last page and the current result page can also be preset, and if the same difference value with the smallest numerical value exists, the difference value with the highest priority level of the corresponding page is selected as the target difference value.

To better explain the method provided by the embodiment of the present invention, an embodiment of the present invention provides another paging query method, and on the basis of the method shown in fig. 1, in the method provided by the embodiment of the present invention, the second page is the current result page, and the process of determining the target data identifier corresponding to the second page in the data identifier sequence mentioned in step S104 includes:

in the method provided by the embodiment of the present invention, a data identifier of a first displayed result data in a page among the result data corresponding to the second page may be obtained as a start data identifier, and a data identifier of a last displayed result data may be obtained as an end data identifier. And matching the data identifications in the data identification sequence, taking the data identifications matched with the initial data identifications as header data identifications corresponding to the second page, and taking the data identifications matched with the tail data identifications as tail data identifications corresponding to the second page.

If the relative sequence relationship is characterized, and the second page is a page before the target result page, taking a data identifier which is next to the page tail data identifier in the data identifier sequence as the target data identifier; and if the relative sequence relationship is characterized and the second page is a page behind the target result page, taking a previous data identifier of the header data identifier in the data identifier sequence as the target data identifier.

In the method provided by the embodiment of the present invention, if the second page is a page before the target result page, that is, the number of pages of the second page is less than the number of pages of the target result page, the data identifier subsequent to the page end data identifier in the data identifier sequence is used as the target data identifier. And if the second page is a page behind the target result page, namely the number of pages of the second page is greater than that of the target result page, taking the previous data identifier of the header data identifier in the data identifier sequence as the target data identifier.

It should be noted that the determination method of the target data identifier provided in the embodiment of the present invention is only to better describe a specific embodiment provided by the method provided in the present invention. In a specific application process, the page head data identifier or the page tail data identifier can also be directly used as a target data identifier, and in the subsequent process of screening the data identifier, the screening is started by using the data identifier before or after the target data identifier. Other methods can be adopted to determine the target data identification, and all the data identifications corresponding to the target result page can be obtained by combining the screening sequence and the screening quantity, so that the function of the method provided by the embodiment of the invention is not influenced.

Based on the method provided by the embodiment of the invention, the target data identifier can be determined through the header data identifier and the footer data identifier of the current result page, so that the data identifier is screened in a relative page skipping manner in the data identifier sequence, and the target data identifier is used as the starting point of data screening, thereby reducing the data screening amount. In addition, in the actual application process, when the query result of the page is fed back each time, a data set obtained in real time based on the query condition is adopted, and the data set obtained by querying may be changed continuously. The data fed back based on the existing paging query method may be counterintuitive to the user, for example, one piece of data is added in each second in the data set, and 20 pieces of data are displayed in one page according to the time sequence of inserting the data, and when the user queries the data of the second page after 20 seconds after querying the first page, the displayed data is the same as the data of the first page viewed last time. By applying the method provided by the embodiment of the invention, the data can be screened in a relative page skipping mode through the positioning of the target data identifier in the data identifier sequence, so that the data repetition caused by screening the data from the beginning can be avoided, the query of the data is in accordance with the expected requirement and the impression of the user, and the query experience of the user is favorably improved.

Further, on the basis of the method shown in fig. 1, an embodiment of the present invention provides another paging query method, in the method provided in the embodiment of the present invention, the second page is the first page, and the process of determining the target data identifier corresponding to the second page in the data identifier sequence mentioned in step S104 includes:

In the method provided by the embodiment of the present invention, if the second page is a top page (the current result page is not the top page), the top data identifier in the data identifier sequence is used as the target data identifier.

Further, on the basis of the method shown in fig. 1, an embodiment of the present invention provides another paging query method, in the method provided in the embodiment of the present invention, the second page is the end page, and the process of determining the target data identifier corresponding to the second page in the data identifier sequence mentioned in step S104 includes:

In the method provided by the embodiment of the present invention, if the second page is a tail page (the current result page is not a tail page), the last data identifier in the data identifier sequence is used as the target data identifier.

To better explain the method provided by the embodiment of the present invention, on the basis of the method provided by the above embodiment, the embodiment of the present invention provides another paging query method, and with reference to the flowchart shown in fig. 2, in the method provided by the embodiment of the present invention, the step S105 is a process of determining, in the data identification sequence, a plurality of query result identifications corresponding to the target result page according to the relative number of pages, the relative order relationship, and the target data identification, and includes:

s201: determining the selection quantity and the screening quantity corresponding to the relative page number;

in the method provided by the embodiment of the invention, the quantity of the displayable result data of each page of the system can be used as the single-page data quantity, and the selection quantity and the screening quantity corresponding to the relative page number are determined based on the single-page data quantity. The selection number refers to the total number of the data identifications to be selected in the query process of the data identifications, and the screening number refers to the total number of the data identifications to be screened out in the screening process of the data identifications. The product of the relative number of pages and the data amount of a single page may be calculated, and the calculation result may be taken as the selected number. And subtracting one from the relative page number to obtain a screening page number, calculating the product of the screening page number and the single-page data quantity, and taking the calculation result as the screening quantity.

S202: determining the selection sequence of each data identifier in the data identifier sequence according to the relative sequence relation;

in the method provided by the embodiment of the invention, if the relative order relationship represents that the second page is a page before the target result page, the arrangement order of each data identifier in the data identifier sequence is used as the selection order of each data identifier. And if the relative sequence relationship represents that the second page is a page behind the target result page, reversely arranging each data identifier in the data identifier sequence, namely sequencing according to a reverse order, and taking the reversely arranged sequence of each data identifier as the selection sequence of each data identifier.

S203: in the data identification sequence, the target data identification is used as a first selected data identification, and a plurality of first data identifications corresponding to the selected number are selected according to the selection sequence of each data identification;

in the method provided by the embodiment of the invention, in the data identifier sequence, starting from the target data identifier, the data identifiers are sequentially selected according to the selection sequence of each data identifier, and the selected data identifiers are used as the first data identifiers to obtain a plurality of first data identifiers, wherein the total number of the selected first data identifiers is the selection number.

S204: and screening out each first data identifier corresponding to the screening quantity in the plurality of first data identifiers according to the selection sequence of the plurality of first data identifiers to obtain each second data identifier, and taking each second data identifier as the query result identifier corresponding to the target result page.

In the method provided by the embodiment of the present invention, in the plurality of first data identifiers, according to the selection sequence, each of the first data identifiers arranged in the front and corresponding to the screening number is screened out, and the remaining first data identifier is used as the second data identifier. And taking each second data identifier as a query result identifier corresponding to the target result page.

For example, the data identification sequence includes: a1, a2, a3 … … a50, these fifty data points out. The selection sequence of each data identifier is the arrangement sequence thereof. The target data is identified as a11, the number selected is fifteen, and the number sifted is ten. In the data identification sequence, from a11, fifteen data identifications are sequentially selected, and each first data identification is selected as: a11, a12, a13, a14 … … a24 and a 25. In each first data identifier, the ten data identifiers ranked at the top are filtered out according to the selection sequence, and then a11, a12, a13 … … a19 and a20 are filtered out. The rest a21, a22, a23, a24 and a25 are the query result identifications corresponding to the target result page.

Further, on the basis of the method shown in fig. 1, an embodiment of the present invention provides another paging query method, where the method provided in the embodiment of the present invention further includes:

in the method provided by the embodiment of the invention, if the target result page is not a page outside the first page and the last page, whether the target result page is the last page or not is determined.

in the method provided by the embodiment of the invention, if the target result page is a tail page, the data identifiers in the data identifier sequence are arranged in a reverse direction to obtain a corresponding reverse sequence.

Determining the target quantity corresponding to the target result page;

in the method provided by the embodiment of the invention, the target quantity is the quantity of the result data required to be displayed on the current tail page, and the single-page data quantity (the quantity of the displayable result data of each page of the system) can be used as the target quantity corresponding to the target result page.

It should be noted that, in the actual query process, the amount of result data displayed in the last page may be smaller than the amount of data in a single page, specifically determined according to the amount of overall result data, so that the target amount may be determined according to the amount of overall result data. For example, the total amount of result data is fifty six, and the amount of single-page data is ten, so the target amount for the end page is six.

in the method provided by the embodiment of the present invention, in the reverse sequence corresponding to the data identifier sequence, each data identifier corresponding to the target number may be selected according to the arrangement order of each data identifier, starting from the first data identifier, and the selected data identifier is used as the end page result identifier. And if the target quantity is six, selecting the first six data identifications as tail page result identifications.

In the method provided by the embodiment of the invention, the result data corresponding to each tail page result identifier can be read and used as the corresponding tail page result data, and each tail page result data is displayed at the front end of the system and used as the query result displayed by the target result page.

Based on the method provided by the embodiment of the invention, if the target result page is a tail page, the result identifiers corresponding to the target quantity can be obtained by reversely arranging the data identifier sequences to obtain the result data corresponding to the tail page.

Further, in the method provided in the embodiment of the present invention, if the target result page is a top page, the number of result data that needs to be displayed on the top page is determined, and is used as the number of top pages (usually, the amount of data in a single page).

In order to better explain the method provided by the embodiment of the present invention, in combination with the flowchart shown in fig. 3, the embodiment of the present invention provides another paging query method, and in combination with an actual application scenario, a paging query process provided by the embodiment of the present invention is further and integrally explained, as shown in fig. 3, the process includes:

s301: whether to first page/last page query;

in the method provided by the embodiment of the invention, each result page can display M pieces of data. When the user carries out paging query in the current result page, whether the target result page of the current paging query of the user is a first page or a last page is judged. If the current query is the data of the first page or the last page, step S305 is performed, and M pieces of data are selected according to the screening sorting mode corresponding to the first page or the last page.

If the current query is not data of the first page or the last page, the process proceeds to step S302.

S302: acquiring the head and tail data of the previous page of data;

in the method provided by the embodiment of the invention, the data identifications of the first result data and the last result data in each result data displayed in the previous page are obtained, wherein the previous page refers to the page queried last time, namely the currently displayed result page.

S303: calculating according to the current page number: 1. starting from the first page; 2. starting from the end page; 3. starting from the previous page; three cases which data offset is the smallest;

in the method provided by the embodiment of the present invention, the offset from the first page, the last page, and the current result page to the target result page of the current query, that is, the difference between the page numbers, may be determined according to the page number of the current result page (the so-called previous page). By comparing the offsets, it is determined from which page the offset to the target result page is the smallest.

S304: skipping according to the minimum offset scheme;

in the method provided by the embodiment of the invention, relative page skipping is carried out by using the page with the minimum offset with the target result page, and data is screened in a relative page skipping mode.

S305: and sorting and screening according to requirements, and acquiring and displaying M pieces of data.

In the method provided by the embodiment of the invention, the data is sorted and screened according to the following requirements:

(1) if the first page is inquired, obtaining a data set according to screening and sorting conditions, and acquiring the first M pieces of data in the data set;

(2) if the inquired tail page is searched, obtaining a data set according to screening and sorting conditions and reverse order, and obtaining the first M pieces of data;

(3) if the intermediate page number (non-first page or last page) is inquired, the data quantity difference from the first page, last inquiry page (current result page) to the current inquiry page is calculated respectively, and relative page skipping is carried out in a mode of minimum difference.

For example, with respect to the page jump N pages, if the current query page is behind the page of the page jump, data acquisition is performed according to the sorting condition of the data set, and if the current query page is in front of the page jump, data acquisition is performed in reverse order and in reverse order on the data set. And acquiring N x M pieces of data according to the data acquisition sequence, discarding (N-1) x M pieces of data, acquiring the rest M pieces of data, and displaying.

For example, in an auditing system, the audited video service is queried, the screening condition is 2021 years, the sorting mode is that the data is sorted according to the reverse time sequence, the total data is ten thousand pages, and the last query is the tenth page data.

If the third page data is inquired, all the data are sorted according to the reverse time sequence by taking 2021 years as a screening condition, the IDs of the first two pages of data are directly taken, discarded, and then the data of the third page is taken.

If the data of the ninth thousand nine hundred pages is inquired, the whole data set is sorted according to the time positive sequence, the ID of the first ninety nine pages of data is taken, the ID is discarded, and then the data of the first hundred pages is taken.

If the twelfth page data is queried, screening and querying are carried out according to the ID and the time of the last data of the tenth page data queried last time, wherein two values are taken because the ID and the time are simple time and cannot be guaranteed not to be repeated, and the ID has no sequence, so that the two values are taken, the integral data are guaranteed to be ordered, and the condition of repeated data cannot occur under the same sorting condition. In the query, in addition to the condition of 2021 year, the ID and the time are added to the condition of ID and time larger than the ID and time of the last data of the tenth page for screening, and the data of the second page after the tenth page is obtained for display.

And if the eighth page data is queried, displaying the data of the second page which is less than the ID and the time according to the ID and the time of the first piece of data of the tenth page data queried last time.

The paging query process provided by the embodiment of the present invention can perform page skipping relative to the last result based on the last query result, for example: the fifth page data is inquired last time, the tenth page data is inquired currently, effective data does not need to be inquired from the head to the tenth page, and the fifth page can be inquired backwards relatively based on the end of the fifth page data, so that the purpose of inquiring the tenth page is achieved, the data inquiry range is reduced, and the performance is ensured.

Corresponding to the paging query method shown in fig. 1, an embodiment of the present invention further provides a paging query apparatus, which is used for implementing the method shown in fig. 1 specifically, and a schematic structural diagram of the paging query apparatus is shown in fig. 4, where the apparatus includes:

a determining unit 401, configured to determine, in response to an operation of a user jumping from a current result page to a target result page in a query process, whether the target result page is a page in each first page, where the first page is a page, except a first page and a last page, in each result page corresponding to the query process;

a first determining unit 402, configured to determine, if the target result page is a page in each of the first pages, a second page corresponding to the target result page in the current result page, the first page, and the last page;

a second determining unit 403, configured to determine a relative page number and a relative order relationship between the target result page and the second page;

a third determining unit 404, configured to determine, in the data identifier sequence, a target data identifier corresponding to the second page; the data identification sequence comprises a plurality of data identifications corresponding to the current query result;

a fourth determining unit 405, configured to determine, according to the relative page number, the relative order relationship, and the target data identifier, multiple query result identifiers corresponding to the target result page in the data identifier sequence;

a fifth determining unit 406, configured to determine result data corresponding to each query result identifier, and use each result data as a query result corresponding to the target result page.

Based on the device provided by the embodiment of the invention, when the user jumps from the current result page to the target result page, if the target result page is not the first page or the last page, the second page is determined in the current result page, the first page and the last page. And determining the relative page number and the relative sequence relation between the second page and the target result page, and determining the target data identifier corresponding to the second page in the data identifier sequence containing the plurality of data identifiers corresponding to the current query result. And determining a plurality of query result identifications corresponding to the target result page in the data identification sequence according to the relative page number, the relative sequence relation and the target data identification so as to obtain each result data corresponding to the target result page. By applying the device provided by the embodiment of the invention, the data identification can be screened from the target data identification in the data identification sequence based on the relative page number and the relative sequence relation between the second page and the target result page. The query screening is not required to be carried out from the first data identifier of the data identifier sequence, so that the data quantity of the screening query can be reduced, the consumption of resources and performance is reduced, and the query efficiency can be improved.

On the basis of the apparatus provided in the foregoing embodiment, in the apparatus provided in the embodiment of the present invention, the first determining unit 402 includes:

a first determining subunit, configured to determine a current page number corresponding to the current result page, a first page number corresponding to the first page, a last page number corresponding to the last page, and a target page number corresponding to the target result page;

a second determining subunit, configured to determine a first gap value corresponding to the home page, where the first gap value is a difference between the target page number and the home page number; determining a second difference value corresponding to the tail page, wherein the second difference value is a difference value between the tail page number and the target page number; determining a third difference value corresponding to the current result page, wherein the third difference value is an absolute value of a difference value between the target page and the current page;

a comparison subunit, configured to compare the first gap value, the second gap value, and the third gap value, and use the gap value with the smallest value as a target gap value; and taking the page corresponding to the target gap value as the second page.

On the basis of the apparatus provided in the foregoing embodiment, in the apparatus provided in the embodiment of the present invention, the second page is the current result page, and the third determining unit 404 includes:

a third determining subunit, configured to determine, in the data identifier sequence, a header data identifier and a footer data identifier corresponding to the second page;

a fourth determining subunit, configured to, if the relative sequential relationship represents that the second page is a page before the target result page, use a data identifier subsequent to the footer data identifier in the data identifier sequence as the target data identifier; and if the relative sequence relationship is characterized and the second page is a page behind the target result page, taking a previous data identifier of the header data identifier in the data identifier sequence as the target data identifier.

On the basis of the apparatus provided in the foregoing embodiment, in the apparatus provided in the embodiment of the present invention, the second page is the first page, and the third determining unit 404 includes:

and the fifth determining subunit is used for identifying the first data in the data identification sequence as the target data identification.

On the basis of the apparatus provided in the foregoing embodiment, in the apparatus provided in the embodiment of the present invention, the second page is the end page, and the third determining unit 404 includes:

a sixth determining subunit, configured to identify a last data identifier in the data identifier sequence as the target data identifier.

On the basis of the apparatus provided in the foregoing embodiment, in the apparatus provided in the embodiment of the present invention, the fourth determining unit 405 includes:

a seventh determining subunit, configured to determine the selection number and the screening number corresponding to the relative page number;

the eighth determining subunit is configured to determine, according to the relative order relationship, a selection order of each data identifier in the data identifier sequence;

a selecting subunit, configured to select, in the data identifier sequence, a plurality of first data identifiers corresponding to the selected number according to a selection order of each data identifier, with the target data identifier as a first selected data identifier;

and the screening subunit is configured to screen out, according to the selection sequence of the plurality of first data identifiers, each first data identifier corresponding to the screening number in the plurality of first data identifiers to obtain each second data identifier, and use each second data identifier as the query result identifier corresponding to the target result page.

On the basis of the device provided by the above embodiment, the device provided by the embodiment of the present invention further includes:

a sixth determining unit, configured to determine whether the target result page is the end page if the target result page is not a page in each of the first pages;

the reverse order arrangement unit is used for performing reverse order arrangement on each data identifier in the data identifier sequence to obtain a reverse order sequence corresponding to the data identifier sequence if the target result page is the tail page;

a seventh determining unit, configured to determine a target number corresponding to the target result page;

a selecting unit, configured to select, in the reverse sequence, a plurality of end page result identifiers corresponding to the target number according to an arrangement order of each data identifier in the reverse sequence;

and the eighth determining unit is used for determining tail page result data corresponding to each tail page result identifier and taking each tail page result data as a query result corresponding to the target result page.

The embodiment of the invention also provides a storage medium, which comprises a stored instruction, wherein when the instruction runs, the device where the storage medium is located is controlled to execute the paging query method.

An electronic device is provided in an embodiment of the present invention, and the structural diagram of the electronic device is shown in fig. 5, which specifically includes a memory 501 and one or more instructions 502, where the one or more instructions 502 are stored in the memory 501, and are configured to be executed by one or more processors 503 to perform the following operations according to the one or more instructions 502:

The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, the system or system embodiments are substantially similar to the method embodiments and therefore are described in a relatively simple manner, and reference may be made to some of the descriptions of the method embodiments for related points. The above-described system and system embodiments are only illustrative, wherein the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.

Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.

The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for paging, comprising:

if the target result page is a page in each first page, determining a second page closest to the target result page from the current result page, the first page and the last page;

determining a target data identifier corresponding to the second page in the data identifier sequence; the data identification sequence comprises a plurality of data identifications corresponding to the current query result; the target data identifier is an identifier used for representing the corresponding position of the result data displayed on the second page in the data identifier sequence;

2. The method of claim 1, wherein the determining a second page corresponding to the target result page among the current result page, the first page, and the last page comprises:

and taking the page corresponding to the target gap value as the second page.

3. The method of claim 1, wherein the second page is the current result page, and the determining the target data identifier corresponding to the second page in the data identifier sequence comprises:

4. The method according to claim 1, wherein the second page is the first page, and the determining the target data identifier corresponding to the second page in the data identifier sequence comprises:

5. The method of claim 1, wherein the second page is the end page, and wherein determining the target data identifier corresponding to the second page in the data identifier sequence comprises:

6. The method of claim 1, wherein the determining, in the data identifier sequence, a plurality of query result identifiers corresponding to the target result page according to the relative page number, the relative order relationship, and the target data identifier comprises:

7. The method of claim 1, further comprising:

determining the target quantity corresponding to the target result page;

8. A paging inquiry apparatus, comprising:

a first determining unit, configured to determine, if the target result page is a page in each of the first pages, a second page that is closest to the target result page among the current result page, the first page, and the last page;

a third determining unit, configured to determine, in the data identifier sequence, a target data identifier corresponding to the second page; the data identification sequence comprises a plurality of data identifications corresponding to the current query result; the target data identifier is an identifier used for representing the corresponding position of the result data displayed on the second page in the data identifier sequence;

9. A storage medium comprising stored instructions, wherein the instructions, when executed, control a device on which the storage medium is located to perform the paging query method according to any one of claims 1 to 7.

10. An electronic device comprising a memory and one or more instructions, wherein the one or more instructions are stored in the memory and configured to be executed by the one or more processors to perform the method of paging inquiry as claimed in any one of claims 1 to 7.