CN108228663A - A kind of paging search method and device - Google Patents

A kind of paging search method and device Download PDF

Info

Publication number
CN108228663A
CN108228663A CN201611197285.8A CN201611197285A CN108228663A CN 108228663 A CN108228663 A CN 108228663A CN 201611197285 A CN201611197285 A CN 201611197285A CN 108228663 A CN108228663 A CN 108228663A
Authority
CN
China
Prior art keywords
fragment
paging
record
collection
matching
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201611197285.8A
Other languages
Chinese (zh)
Inventor
王龙
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hangzhou Hikvision Digital Technology Co Ltd
Original Assignee
Hangzhou Hikvision Digital Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hangzhou Hikvision Digital Technology Co Ltd filed Critical Hangzhou Hikvision Digital Technology Co Ltd
Priority to CN201611197285.8A priority Critical patent/CN108228663A/en
Publication of CN108228663A publication Critical patent/CN108228663A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33Querying
    • G06F16/335Filtering based on additional data, e.g. user or group profiles
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/95Retrieval from the web
    • G06F16/953Querying, e.g. by the use of web search engines
    • G06F16/9535Search customisation based on user profiles and personalisation

Abstract

The embodiment of the present invention discloses a kind of paging search method and device, is related to paging retrieval technique, can promote paging recall precision.Including:Paging retrieval request is received, the paging retrieval request includes sort criteria, paging condition and filter condition;It determines to record number with the matching of each fragment of the fragment collection of the filter criteria matches, the fragment collection is the set of the fragment in the default fragment library established according to predetermined order condition;The matching record number of each fragment based on the sort criteria, the paging condition and the fragment collection, corresponding matching record is obtained from the fragment of the fragment collection, as paging retrieval result, for carrying out depth paging retrieval to the distributed data for supporting sequence.

Description

A kind of paging search method and device
Technical field
The present invention relates to paging retrieval technique more particularly to a kind of paging search method and devices.
Background technology
With computer communication and the continuous development of Internet technology, the application of electronic equipment is more and more common, for example, Intelligent mobile phone, personal digital assistant, palm PC, laptop are more and more widely used, and become user An indispensable part in daily life and work.For example, carrying out the network interconnection using electronic equipment, closed by inputting search Keyword may search for out the data of user's needs.
Since the data volume searched out is big, when showing search result to user, need to use paging technique.In computer In data processing field, paging technique is a kind of technology that all data sectionals are showed to user, i.e., when query result sum When more, according to specified page number and every page of record number, the data record set for meeting above-mentioned condition specified range is returned after sequence, Data that user saw be not all of, but a part therein, can be with if not finding oneself desired data wherein The data searched are converted by way of specified page number or page turning, until finding required data.
From the point of view of application angle, one side distributed data base causes data set increasingly to disperse, data volume to be sorted It is increasing, on the other hand the quick response of system is required higher and higher.For the data scale of construction be larger than 100,000,000 record Highest using, current performance and popularization is distributed full-text search technology, wherein, global search technology uses inverted index Mode create and index and pass through indexed search, while support sequence and paging, for paging request (paging for sorting of needs Request includes filter condition, sort criteria and page number condition), retrieval flow is in the fragment of each server, will be met After the record of filter condition sorts according to sort criteria, then from the record after the sequence of each fragment, selector hinge code The record of condition is pulled to a convergence server, then on the convergence server to the record of all fragments according to paging request In sort criteria resequence, then the record of selector hinge code-bar part forms paging, as retrieval result return Electron equipment (retrieval end).
But above-mentioned global search technology due to needing first to carry out retrieval ordering in each server, then converges to server Resequence again, when the record sum for meeting page number condition in each fragment smaller (or paging request specify number of pages) compared with Hour, it can be with quick response;But when the record (or the number of pages specified in paging request) for meeting page number condition in each fragment When sum is larger, the record converged in server can be multiplied, and then the usage amount of caching and computing resource is caused to double, Response speed is slack-off so that paging recall precision is relatively low, so as to influence the performance and stability of entire distributed search system.
Invention content
In view of this, the embodiment of the present invention provides a kind of paging search method and device, can promote paging recall precision, To solve the problem of that paging recall precision is relatively low in relevant paging search method.
In a first aspect, the embodiment of the present invention provides a kind of paging search method, including:
Paging retrieval request is received, the paging retrieval request includes sort criteria, paging condition and filter condition;
Determine with the matching of each fragment of the fragment collection of filter criteria matches record number, the fragment collection be according to The set of several fragments in the default fragment library that predetermined order condition is established;
The matching record number of each fragment based on the sort criteria, the paging condition and the fragment collection, from institute It states and corresponding matching record is obtained in the fragment of fragment collection, as paging retrieval result.
With reference to first aspect, in the first embodiment of first aspect, point with the filter criteria matches is determined The matching record number of each fragment of piece collection, including:
The retrieval for judging to whether there is in caching with the filter criteria matches records:
Be not present in the caching when being recorded with the retrievals of the filter criteria matches, will in the default fragment library and The fragment of the filter criteria matches, as the fragment collection;
Inquiry request is sent to each fragment of the fragment collection, is obtained described in meeting in each fragment of the fragment collection The matching record number of filter condition.
The first embodiment with reference to first aspect in second of embodiment of first aspect, is preset from described It is determined in fragment library with the fragments of the filter criteria matches as the fragment collection, including:
Judge in the filter condition whether the codomain of the sort field comprising record to be retrieved:
In the filter condition in the case of the codomain of the sort field comprising record to be retrieved, from the default fragment In library, determine with the matched fragment of the codomain as the fragment collection;
In the filter condition in the case of the codomain of the sort field not comprising record to be retrieved, by described default point All fragments in valut are as the fragment collection.
The first embodiment with reference to first aspect, in the third embodiment of first aspect, described in acquisition After meeting the matching record number of the filter condition in each fragment of fragment collection, the method further includes:
The matching of the filter condition will be met in each fragment of the burst information of the fragment collection and the fragment collection Number is recorded, is stored in the caching as the retrieval record with the filter criteria matches.
With reference to first aspect, in the 4th kind of embodiment of first aspect, point with the filter criteria matches is determined The matching record number of each fragment of piece collection, including:
Judge whether to have in caching and be recorded with the retrieval of the filter criteria matches:
When there is the retrieval record with the filter criteria matches in the caching, the inspection is obtained from the caching The matching record number of the burst information of fragment collection in Suo Jilu and wherein each fragment.
With reference to first aspect, in the 5th kind of embodiment of first aspect, based on the sort criteria, the paging item The matching record number of each fragment of part and the fragment collection, obtains corresponding record from the fragment of the fragment collection, as Paging retrieval result, including:
The matching of single page record number and each fragment of the fragment collection specified according to the paging condition records number, It is concentrated from the fragment, determines several first points where the matching record in the range of the page number that the paging condition is specified Home record serial number in piece and each first fragment;
According to the home record serial number of each first fragment and matching record number, obtained from each first fragment corresponding Matching record;
According to the sort criteria to the matching record ordering of acquisition, the matching after sequence is recorded as the paging item The paging retrieval result corresponding to page number range that part is specified.
With reference to first aspect, any one embodiment in the first of first aspect to the 5th kind, in first aspect The 6th kind of embodiment in, in the preset fragment library according to the sort criteria establish, including:
Value row of the every record based on corresponding first sort field in each fragment in the preset fragment library Sequence, in the predetermined order condition clooating sequence of the first sort field in the sort criteria in the paging retrieval request The clooating sequence of first sort field is identical;
Codomain of each fragment based on each fragment in the preset fragment library sorts according to the sort criteria, Wherein, the codomain of each fragment is the range of the value of the first sort field corresponding to the record in the fragment, described preset The codomain of each fragment is non-intersect in fragment library.
Second aspect, the embodiment of the present invention provide a kind of paging retrieval device, including:Paging retrieval request module, matching Number determining module and paging retrieval result acquisition module are recorded, wherein,
Paging retrieval request module, for receiving paging retrieval request, the paging retrieval request includes sort criteria, divides Page condition and filter condition;
Matching record number determining module, for determining the matching with each fragment of the fragment collection of the filter criteria matches Record number;
Paging retrieval result acquisition module, for based on the sort criteria, the paging condition and the fragment collection The matching record number of each fragment, obtains corresponding matching record, as paging retrieval result from the fragment of the fragment collection.
With reference to second aspect, in the first embodiment of second aspect, the matching record number determining module includes: Judging unit, matching unit and record number acquiring unit, wherein,
Judging unit, for judging that the retrieval that whether there is in caching with the filter criteria matches records:
Matching unit, when the retrieval for being not present in the caching with the filter criteria matches records, by described in Fragment in default fragment library with the filter criteria matches, as the fragment collection;
Number acquiring unit is recorded, for sending inquiry request to each fragment of the fragment collection, obtains the fragment collection Each fragment in meet the filter condition matching record number.
With reference to the first embodiment of second aspect, in second of embodiment of second aspect, the matching is single Member includes:Record queries subelement, codomain inquiry subelement and fragment collection determination subelement are retrieved, wherein,
Record queries subelement is retrieved, the retrieval for being not present in the caching with the filter criteria matches records When, notice codomain inquiry subelement;
Codomain inquires subelement, for judging whether to include the value of the sort field of record to be retrieved in the filter condition Domain:
Fragment collection determination subelement, for including the codomain of the sort field of record to be retrieved in the filter condition In the case of, from the default fragment library, determine with the matched fragment of the codomain as the fragment collection;
In the filter condition in the case of the codomain of the sort field not comprising record to be retrieved, by described default point All fragments in valut are as the fragment collection.
With reference to the first embodiment of second aspect, in the third embodiment of second aspect, described device is also Including:
Memory module, for the mistake will to be met in each fragment of the burst information of the fragment collection and the fragment collection The matching record number of filter condition, is stored in as the retrieval record with the filter criteria matches in the caching.
With reference to second aspect, in the 4th kind of embodiment of second aspect, the matching record number determining module includes: Caching query unit and record number determination unit, wherein,
Whether caching query unit records for judging to have in caching with the retrieval of the filter criteria matches:
Number determination unit is recorded, when the retrieval for existing in the caching with the filter criteria matches records, from The burst information of the fragment collection in the retrieval record and the matching record number of wherein each fragment are obtained in the caching.
With reference to second aspect, in the 5th kind of embodiment of second aspect, the paging retrieval result acquisition module packet It includes:Fragment determination unit, matching record queries unit and paging retrieval result acquiring unit, wherein,
Fragment determination unit, for specified according to the paging condition single page record number and the fragment collection it is each The matching record number of fragment, is concentrated from the fragment, determines the matching record institute in the range of the page number that the paging condition is specified Several first fragments and each first fragment in home record serial number;
Record queries unit is matched, for the home record serial number according to each first fragment and matching record number, from every Corresponding matching record is obtained in a first fragment;
Paging retrieval result acquiring unit for the matching record ordering according to the sort criteria to acquisition, will sort The paging retrieval result corresponding to page number range that matching record afterwards is specified as the paging condition.
With reference to second aspect, second aspect the first to any embodiment in the 5th kind, the of second aspect In six kinds of embodiments, established in the preset fragment library according to the sort criteria, including:
Value row of the every record based on corresponding first sort field in each fragment in the preset fragment library Sequence, in the predetermined order condition clooating sequence of the first sort field in the sort criteria in the paging retrieval request The clooating sequence of first sort field is identical;
Codomain of each fragment based on each fragment in the preset fragment library sorts according to the sort criteria, Wherein, the codomain of each fragment is the range of the value of the first sort field corresponding to the record in the fragment, described preset The codomain of each fragment is non-intersect in fragment library.
A kind of paging search method provided in an embodiment of the present invention and device, after receiving paging retrieval request, from according to pre- If it in the default fragment library that sort criteria is established, determines each with the fragment collection of the filter criteria matches in paging retrieval request The matching record number of fragment, the matching note of each fragment based on the sort criteria, the paging condition and the fragment collection Number is recorded, corresponding matching record is obtained from the fragment of the fragment collection, as paging retrieval result, Resource Calculation can be reduced Amount promotes paging recall precision, to solve the problem of that paging recall precision is relatively low in relevant paging search method.
Description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, to embodiment or will show below There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this Some embodiments of invention, for those of ordinary skill in the art, without creative efforts, can be with Other attached drawings are obtained according to these attached drawings.
Fig. 1 is the paging search method flow diagram of the embodiment of the present invention;
Fig. 2 is that apparatus structure schematic diagram is retrieved in the paging of the embodiment of the present invention;
Fig. 3 is a kind of flow diagram of embodiment of the paging search method of the embodiment of the present invention.
Specific embodiment
The embodiment of the present invention is described in detail below in conjunction with the accompanying drawings.
It will be appreciated that described embodiment is only part of the embodiment of the present invention, instead of all the embodiments.Base Embodiment in the present invention, those of ordinary skill in the art obtained without creative efforts it is all its Its embodiment, shall fall within the protection scope of the present invention.
Fig. 1 is the embodiment of the present invention paging search method flow diagram.Paging retrieval side in the embodiment of the present invention The executive agent of method can be computer, server etc., for example, storage server.As shown in Figure 1, the method for the present embodiment can To include:
Step 101, paging retrieval request is received, the paging retrieval request includes sort criteria, paging condition and mistake Filter condition;
Step 102, it determines and the matching of each fragment of the fragment collection of filter criteria matches record number, the fragment Collect the set for several fragments in the default fragment library established according to predetermined order condition;
Step 103, the matching record of each fragment based on the sort criteria, the paging condition and the fragment collection Number obtains corresponding matching record, as paging retrieval result from the fragment of the fragment collection.
The fragment quantity that above-mentioned fragment is concentrated can be one or more.
Predetermined order condition can be, but not limited to include according to the first sort field from small to large or from big to small suitable Sequence etc..Sort criteria in paging retrieval request can be, but not limited to include:According to the first sort field from small to large or Sequence from big to small etc..
Predetermined order condition can also include:For the identical record of the first sort field, according to the second sort field from It is small to big or to small sequence etc..
Sort criteria in paging retrieval request can also include:For the identical record of the first sort field, according to Two sort fields are from small to large or to small sequence etc..
Predetermined order condition can be identical with the sort criteria in paging retrieval request, can also be different.
For example, predetermined order condition is:First sort field (time) is according to sequence from small to large, for the first sequence The identical record of field, the second sort field (digital code) is according to the sequence from A to Z;And the sequence in paging retrieval request Condition is:First sort field (time) is according to sequence from small to large.
In the present embodiment, after receiving paging retrieval request, from the default fragment according to specified predetermined order condition foundation In library, determine to record number with the matching of each fragment of the fragment collection of the filter criteria matches in paging retrieval request, be based on The matching record number of each fragment of the sort criteria, the paging condition and the fragment collection, from point of the fragment collection Corresponding matching record is obtained in piece, as paging retrieval result, due to that can directly acquire and meet the requirement of paging condition Matching record, therefore Resource Calculation amount can be reduced, paging recall precision is promoted, to solve in relevant paging search method, The problem of paging recall precision is relatively low.
In a kind of embodiment of the paging search method of the embodiment of the present invention, optionally, the preset fragment library According to predetermined order condition establish, including:
Value row of the every record based on corresponding first sort field in each fragment in the preset fragment library Sequence, in the predetermined order condition clooating sequence of the first sort field in the sort criteria in the paging retrieval request The clooating sequence of first sort field is identical;
Codomain of each fragment based on each fragment in the preset fragment library sorts according to the sort criteria, Wherein, the codomain of each fragment is the range of the value of the first sort field corresponding to the record in the fragment, described preset The codomain of each fragment is non-intersect in fragment library.
In the embodiment of the present invention, when designing fragment index rule, can fragment division be carried out with the codomain of sort field And corresponding fragment is set to index.If for example, when designing fragment index rule, sort field fieldToSort is then pressed The codomain progress fragment division of fieldToSort, the corresponding data of each fragment storage section sort field of division, division Without intersection between the codomain of each fragment, and orderly.
For example, for sort fields such as number, dates, fragment index using by the way of fixation or on-fixed difference into Row design.As an alternative embodiment, for date sort field 20161001-20170101, codomain that can be daily carries out Fragment Index Design, so as to which the sort field to be divided into the fragment library for including multiple fragments as follows:
【20161001-20161002,20161003-20161004 ..., 20161231-20170101】
Wherein, 20161001-20161002 is fragment.
For another example for numeric sorting field 0-1000000000, can be carried out according to the codomain as unit of 1000000 It divides, so as to which the numeric sorting field to be divided into the fragment library for including multiple fragments as follows:
【0-1000000,1000001-2000000 ..., 999000001-1000000000】
As an alternative embodiment, the indexed format of each fragment is in fragment library:
[fieldStart1, fieldStop1), [fieldStart2, fieldStop2) ..., [fieldStartN, fieldStopN)
Wherein,
FieldStartM is the minimum value of the fragment in sort field;
FieldStopM is the maximum value of the fragment in sort field;
FieldStopM > fieldStartM, 1≤M≤N;
N is fragment number;
FieldStopi=fieldStart (i+1) 1≤i≤(N-1).
In the present embodiment, in the indexed format of the fragment of setting, the fieldStop (ends of sort field in fragment Point) value be more than the value of fieldStart (start endpoint), and the fieldStop (end caps) of the current slice to sort Value of the value equal to the fieldStart (starting endpoint) of next fragment, for example, fieldStop1=fieldStop2.Due to fragment Using right half open interval, therefore, intersection is not present in two neighboring fragment.
In a kind of embodiment of the paging search method of the embodiment of the present invention, optionally, from the default fragment library In determine with the fragments of the filter criteria matches as the fragment collection, including:
Judge in the filter condition whether the codomain of the sort field comprising record to be retrieved:
In the filter condition in the case of the codomain of the sort field comprising record to be retrieved, pre- do not have fragment from described In library, determine with several matched fragments of the codomain as the fragment collection;
In the filter condition in the case of the codomain of the sort field not comprising record to be retrieved, by described default point All fragments in valut are as the fragment collection.
For example, using the serial number of record as sort field in paging retrieval request, all record requirements being retrieved by It being ranked up according to the size of serial number, sort criteria is that from small to large, filter condition is defined by serial number in [100-999], and The record for containing " parking lot " is retrieved.In this case, the codomain of the sort field of record to be retrieved is exactly [100- 999], at this moment, it is possible to from default fragment library, find out codomain with [100-999] there are the fragment of intersection, these fragments are made For fragment collection, the quantity of the record in " parking lot " is contained in each fragment for then concentrating this fragment, as each point The matching record number of piece.
In a kind of embodiment of the paging search method of the embodiment of the present invention, optionally, the fragment collection is being obtained Each fragment in meet the filter condition matching record number after, the method further includes:
The matching of the filter condition will be met in each fragment of the burst information of the fragment collection and the fragment collection Number is recorded, is stored in the caching as the retrieval record with the filter criteria matches.
If in this way, after paging retrieval request is received, determine to be stored with the same filter condition in caching Retrieval record, it is possible to the retrieval is directly read from caching and records the matching for meeting filter condition in corresponding each fragment Number is recorded, is computed repeatedly so as to reduce, promotes paging recall precision.
In a kind of embodiment of the paging search method of the embodiment of the present invention, optionally it is determined that with the filtering rod The matching record number of each fragment of the matched fragment collection of part, including:
The retrieval for judging to whether there is in caching with the filter criteria matches records:
Be not present in the caching when being recorded with the retrievals of the filter criteria matches, will in the default fragment library and Several fragments of the filter criteria matches, as the fragment collection;
Inquiry request is sent to each fragment of the fragment collection, is obtained described in meeting in each fragment of the fragment collection The matching record number of filter condition.
In the embodiment of the present invention, the filtered fields that filter criteria matches can refer in two filter conditions are identical.
For example, the filter condition that record is retrieved in caching is " time [20160101-20160201], keyword:Parking ", filter condition is " time [20160211-20160406], keyword in this paging retrieval request:Parking lot ", filtering Time field in field differs, and therefore, two filter conditions mismatch.So, it is necessary to by default fragment library, the time There are the fragments of intersection to find out with [20160211-20160406], as fragment collection A, then, then concentrated from this fragment In each fragment, determine to meet " the time:20160211-20160406, keyword:The quantity of the record in parking lot ", as The matching record number of this fragment.
It is then possible to by filter condition " time [20160211-20160406], keyword:Parking lot " and fragment collection A's Burst information (for example, fragment collection A include the fragment 1 to sort successively and fragment 2 and 2 respective value of fragment 1 and fragment Domain) and the matching record number of each fragment in fragment collection A correspond to, in deposit caching.
In a kind of embodiment of the paging search method of the embodiment of the present invention, optionally it is determined that with the filtering rod The matching record number of each fragment of the matched fragment collection of part, including:
Judge whether to have in caching and be recorded with the retrieval of the filter criteria matches:
When there is the retrieval record with the filter criteria matches in the caching, the inspection is obtained from the caching The matching record number of the burst information of fragment collection in Suo Jilu and wherein each fragment.
For example, the filter condition of retrieval record R1 is " time [20160101-20160201], keyword in caching:Parking ", filter condition is " time [20160101-20160201], keyword in this paging retrieval request:Parking lot ", two Filter criteria matches can read the burst information of fragment collection B that is stored in retrieval record R1 and therein directly from caching The matching record number of each fragment, computes repeatedly so as to reduce, promotes paging recall precision.
Single page record number and to be shown can be specified in a kind of embodiment of the embodiment of the present invention, in paging condition Match the page number range of record.For example, first page number to terminate the page number and every page record number, alternatively, home record serial number and Terminate record number etc..
Optionally, the matching record of each fragment based on the sort criteria, the paging condition and the fragment collection Number obtains corresponding record from the fragment of the fragment collection, as paging retrieval result, including:
The matching of single page record number and each fragment of the fragment collection specified according to the paging condition records number, It is concentrated from the fragment, determines several first points where the matching record in the range of the page number that the paging condition is specified Home record serial number in piece and each first fragment;
According to the home record serial number of each first fragment and matching record number, obtained from each first fragment corresponding Matching record;
According to the sort criteria to the matching record ordering of acquisition, the matching after sequence is recorded as the paging item The paging retrieval result corresponding to page number range that part is specified.
In this way, if the paging condition in paging retrieval request specifies, this paging retrieval result will include all inspections Page 2 in the matching record that rope goes out, single page record number is 100 records, and the matching of all fragments is concentrated to remember according to fragment The summation of number is recorded, it is 1002 to determine the record sum for meeting filter condition, then for this paging retrieval request, display The page gone out is exactly all pages 2 of matching record retrieved, and what is included in this page is the 101-200 articles matching record (symbol The record for closing filter condition is to match record).And the 1002nd article of record for meeting filter condition is located at 5 of fragment collection respectively In first fragment, then, it is possible to the matching record number in each first fragment determines the 101-200 articles matching note Record the position in this 5 first fragments.
As shown in figure 3, in one embodiment of the invention, the fragment in fragment library is preset with the first sort field FieldToSort sorts.
Paging retrieval request that server-side receives client transmission, that specified first sort field is fieldToSort When:
S301:In the fragment for checking whether to have with filter criteria matches in this paging retrieval request in caching cache [burst information and its matching record number] of collection, if it does not exist, then performing S302 steps;If it is present perform S303 steps Suddenly.
Each burst information and its result sum are pressed in [burst information and its matching record number] of fragment collection in caching Photograph answers the fieldStart of fragment to sort.
S302:The determining fragment collection for needing to retrieve, each fragment concentrated to the fragment determined send inquiry request.
Wherein, if there is fieldToSort ranges in filter condition, all fragments that find out has intersection with the range are made For the fragment collection for needing to retrieve;If there is no fieldToSort ranges in filter condition, to preset whole fragments in fragment library The fragment collection retrieved as needs.
S303:It obtains fragment and concentrates the matching record number for meeting filter condition in each fragment.
It is alternatively possible to inquiry request is sent, and meet filter condition in each fragment to each fragment that fragment is concentrated parallel Matching record number can also parallel computation, can shorten in this way respond retrieve time.
If determined in S301 steps caching retrieval record in have filter criteria matches [burst information and its With record number], then in the paging retrieving before just illustrating, the filter condition and this paging that have paging retrieval request are examined Rope request is consistent, in this way, based on paging retrieval request twice, the fragment collection determined from default fragment library and wherein each point The matching record number of piece is the same, it is therefore not necessary to calculate again, it is only necessary to corresponding retrieval record is extracted from caching and is deposited The burst information of storage and corresponding matching record number.
S304:The burst information and its matching record number concentrated by the fieldStart attributes of fragment to fragment are arranged Sequence, and be buffered in cache.
S305:According to the burst information of fragment collection and its matching record number, determine all fragments in the range of the page number and The home record serial number of each fragment retrieval and matching record number.
If it is yes in the judging result of S301, then, it can be obtained from caching and mistake in this paging retrieval request [burst information and its matching record number] of the fragment collection of condition coupling is filtered as the burst information of the fragment collection and its matching note Record number.If being no in the judging result of S301, need to calculate burst information and its matching record for obtaining that the fragment is concentrated Number.
In one embodiment of the invention, the summation of the matching record number of all fragments of fragment concentration can be calculated, Then the single page record number specified according to paging condition determines all matching records are eventually divided into how many page, determines Matching in the range of the page number is recorded in the section in all matching records, and concentrates fragment based on this section, fragment Sequence and each fragment matching record number, find out in the range of the page number matching record where fragment.
S306:The fragment in the range of the page number determined into S305 is sent comprising home record serial number and matching record number Retrieval request, obtain the matching record that each fragment retrieves;
S307:It is returned after being ranked up by fieldStart attributes to the matching of each fragment record got in S306 To client.
In an optional embodiment of the embodiment of the present invention, in S306, can concurrently it be determined into S305 Fragment in the range of the page number sends the retrieval request comprising home record serial number and matching record number, obtains each fragment retrieval The matching record gone out, so as to shorten the response time.
In another optional embodiment of the embodiment of the present invention, each record in each fragment in fragment library is preset All it is to sort according to the sequence of the first sort field from small to large, and each fragment is according to the first sort field The sequence sequence of the codomain of fieldToSort from small to large, it is arranged from small to large according to the fieldStart of fragment in S306 Sequence obtains the matching record that each fragment determined in S305 retrieves successively, in this way, the matching record after being retrieved Sequence is also the sequence of the first sort field from small to large, in this manner it is possible to save the sequencer procedure in step S307, directly will The matching record retrieved in S306 keeps original sequence to be sent to client, so as to reduce overall calculation amount, shortens response point The time of page retrieval request.
Fig. 2 is that apparatus structure schematic diagram is retrieved in the paging of the embodiment of the present invention, as shown in Fig. 2, the device of the present embodiment can To include:Paging retrieval request module 21, matching record number determining module 22 and paging retrieval result acquisition module 23, In,
Paging retrieval request module 21, for receiving paging retrieval request, the paging retrieval request include sort criteria, Paging condition and filter condition;
Matching record number determining module 22, for determining with each fragment of the fragment collection of the filter criteria matches With record number, the fragment collection is the set of several fragments in the default fragment library established according to the sort criteria;
Paging retrieval result acquisition module 23, for being based on the sort criteria, the paging condition and the fragment collection Each fragment matching record number, corresponding matching record is obtained from the fragment of the fragment collection, retrieves and ties as paging Fruit.
In the specific embodiment of the paging retrieval device of the embodiment of the present invention, optionally, the matching record number is true Cover half block includes:Judging unit, matching unit and record number acquiring unit (not shown), wherein,
Judging unit, for judging that the retrieval that whether there is in caching with the filter criteria matches records:
Matching unit, when the retrieval for being not present in the caching with the filter criteria matches records, by described in Fragment in default fragment library with the filter criteria matches, as the fragment collection, the fragment collection is according to predetermined order The set of several fragments in the default fragment library that condition is established;
Number acquiring unit is recorded, for sending inquiry request to each fragment of the fragment collection, obtains the fragment collection Each fragment in meet the filter condition matching record number.
In the present embodiment, the filtered fields that filter criteria matches can refer in two filter conditions are identical.The present invention is implemented In example, the page number range of single page record number and matching record to be shown can be specified in paging condition.For example, first page number arrives The page number and every page of record number are terminated, alternatively, home record serial number and termination record number etc..
In the present embodiment, when designing fragment index rule, fragment division is carried out with the codomain of sort field and phase is set The fragment index answered.If for example, when designing fragment index rule, sort field fieldToSort is then pressed The codomain progress fragment division of fieldToSort, the corresponding data of each fragment storage section sort field of division, division Without intersection between the codomain of each fragment, and orderly.
In the present embodiment, for example, for sort fields such as number, dates, fragment index is using fixed or on-fixed The mode of difference is designed.It, can be by for date sort field 20161001-20170101 as an alternative embodiment It codomain carries out fragment Index Design, so as to which the sort field to be divided into the fragment library for including multiple fragments as follows:
【20161001-20161002,20161003-20161004 ..., 20161231-20170101】
Wherein, 20161001-20161002 is fragment.
For another example for numeric sorting field 0-1000000000, can be carried out according to the codomain as unit of 1000000 It divides, so as to which the numeric sorting field to be divided into the fragment library for including multiple fragments as follows:
【0-1000000,1000001-2000000 ..., 999000001-1000000000】
In the present embodiment, as an alternative embodiment, the indexed format of each fragment is in fragment library:
[fieldStart1, fieldStop1), [fieldStart2, fieldStop2) ..., [fieldStartN, fieldStopN)
Wherein,
FieldStartM is the minimum value of the fragment in sort field;
FieldStopM is the maximum value of the fragment in sort field;
FieldStopM > fieldStartM, 1≤M≤N;
N is fragment number;
FieldStopi=fieldStart (i+1) 1≤i≤(N-1).
In the present embodiment, in the indexed format of the fragment of setting, the fieldStop (ends of sort field in fragment Point) value be more than the value of fieldStart (start endpoint), and the fieldStop (end caps) of the current slice to sort Value of the value equal to the fieldStart (starting endpoint) of next fragment, for example, fieldStop1=fieldStop2.Due to fragment Using right half open interval, therefore, intersection is not present in two neighboring fragment.
In the specific embodiment of the paging retrieval device of the embodiment of the present invention, optionally, the matching unit includes: Record queries subelement, codomain inquiry subelement and fragment collection determination subelement are retrieved, wherein,
Record queries subelement is retrieved, the retrieval for being not present in the caching with the filter criteria matches records When, notice codomain inquiry subelement;
Codomain inquires subelement, for judging whether to include the value of the sort field of record to be retrieved in the filter condition Domain:
Fragment collection determination subelement, for including the codomain of the sort field of record to be retrieved in the filter condition In the case of, from the default fragment library, determine with the matched fragment of the codomain as the fragment collection;
In the filter condition in the case of the codomain of the sort field not comprising record to be retrieved, by described default point For all fragments in valut as the fragment collection, the fragment collection is in the default fragment library established according to the sort criteria Several fragments set.
In the specific embodiment of the paging retrieval device of the embodiment of the present invention, optionally, described device further includes:
Memory module (not shown), for by each fragment of the burst information of the fragment collection and the fragment collection In meet the matching record number of the filter condition, be stored in the caching as the retrieval record with the filter criteria matches In.
In the specific embodiment of the paging retrieval device of the embodiment of the present invention, optionally, the matching record number is true Cover half block includes:Caching query unit and record number determination unit (not shown), wherein,
Whether caching query unit records for judging to have in caching with the retrieval of the filter criteria matches:
Number determination unit is recorded, when the retrieval for existing in the caching with the filter criteria matches records, from The burst information of the fragment collection in the retrieval record and the matching record number of wherein each fragment are obtained in the caching.
In the specific embodiment of the paging retrieval device of the embodiment of the present invention, optionally, the paging retrieval result Acquisition module includes:Fragment determination unit, matching record queries unit and paging retrieval result acquiring unit (are not shown in figure Go out), wherein,
Fragment determination unit, for specified according to the paging condition single page record number and the fragment collection it is each The matching record number of fragment, is concentrated from the fragment, determines the matching record institute in the range of the page number that the paging condition is specified Several first fragments and each first fragment in home record serial number;
Record queries unit is matched, for the home record serial number according to each first fragment and matching record number, from every Corresponding matching record is obtained in a first fragment;
Paging retrieval result acquiring unit for the matching record ordering according to the sort criteria to acquisition, will sort The paging retrieval result corresponding to page number range that matching record afterwards is specified as the paging condition.
In the specific embodiment of the paging retrieval device of the embodiment of the present invention, optionally, the preset fragment library According to predetermined order condition establish, including:
Value row of the every record based on corresponding first sort field in each fragment in the preset fragment library Sequence, in the predetermined order condition clooating sequence of the first sort field in the sort criteria in the paging retrieval request The clooating sequence of first sort field is identical;
Codomain of each fragment based on each fragment in the preset fragment library sorts according to the sort criteria, Wherein, the codomain of each fragment is the range of the value of the first sort field corresponding to the record in the fragment, described preset The codomain of each fragment is non-intersect in fragment library.
The quantity for the fragment that above-mentioned fragment is concentrated can be one or more, and the quantity of above-mentioned first fragment can be one It is or multiple.
The device of the present embodiment can be used for performing the technical solution of embodiment of the method shown in Fig. 1, realization principle and skill Art effect is similar, and details are not described herein again.
It should be noted that herein, relational terms such as first and second and the like are used merely to a reality Body or operation are distinguished with another entity or operation, are deposited without necessarily requiring or implying between these entities or operation In any this practical relationship or sequence.Moreover, term " comprising ", "comprising" or its any other variant are intended to Non-exclusive inclusion, so that process, method, article or equipment including a series of elements not only will including those Element, but also including other elements that are not explicitly listed or further include as this process, method, article or equipment Intrinsic element.In the absence of more restrictions, the element limited by sentence " including one ... ", it is not excluded that Also there are other identical elements in the process, method, article or apparatus that includes the element.
Each embodiment in this specification is described using relevant mode, identical similar portion between each embodiment Point just to refer each other, and the highlights of each of the examples are difference from other examples.
For device embodiment, since it is substantially similar to embodiment of the method, so the comparison of description is simple Single, the relevent part can refer to the partial explaination of embodiments of method.
Expression or logic and/or step described otherwise above herein in flow charts, for example, being considered use In the order list for the executable instruction for realizing logic function, may be embodied in any computer-readable medium, for Instruction execution system, device or equipment (such as computer based system, including the system of processor or other can be held from instruction The system of row system, device or equipment instruction fetch and execute instruction) it uses or combines these instruction execution systems, device or set It is standby and use.For the purpose of this specification, " computer-readable medium " can any can be included, store, communicate, propagate or pass Defeated program is for instruction execution system, device or equipment or the dress used with reference to these instruction execution systems, device or equipment It puts.The more specific example (non-exhaustive list) of computer-readable medium is including following:Electricity with one or more wiring Connecting portion (electronic device), portable computer diskette box (magnetic device), random access memory (RAM), read-only memory (ROM), erasable edit read-only storage (EPROM or flash memory), fiber device and portable optic disk is read-only deposits Reservoir (CDROM).In addition, computer-readable medium can even is that the paper that can print described program on it or other are suitable Medium, because can be for example by carrying out optical scanner to paper or other media, then into edlin, interpretation or when necessary with it His suitable method is handled electronically to obtain described program, is then stored in computer storage.
It should be appreciated that each section of the present invention can be realized with hardware, software, firmware or combination thereof.
In the above-described embodiment, multiple steps or method can be with storages in memory and by suitably instructing execution The software or firmware that system performs are realized.If for example, being realized with hardware in another embodiment, can use Any one of following technology well known in the art or their combination are realized:With for data-signal realization logic work( The discrete logic of the logic gates of energy has the application-specific integrated circuit of suitable combinational logic gate circuit, programmable gate Array (PGA), field programmable gate array (FPGA) etc..
Those skilled in the art are appreciated that realize all or part of step that above-described embodiment method carries Suddenly it is that relevant hardware can be instructed to complete by program, the program can be stored in a kind of computer-readable storage medium In matter, the program when being executed, one or a combination set of the step of including embodiment of the method.
For convenience of description, description apparatus above is to be divided into various units/modules with function to describe respectively.Certainly, exist Implement the function of each unit/module is realized can in the same or multiple software and or hardware during the present invention.
As seen through the above description of the embodiments, those skilled in the art can be understood that the present invention can It is realized by the mode of software plus required general hardware platform.Based on such understanding, technical scheme of the present invention essence On the part that the prior art contributes can be embodied in the form of software product in other words, the computer software product It can be stored in storage medium, such as ROM/RAM, magnetic disc, CD, be used including some instructions so that a computer equipment (can be personal computer, server either network equipment etc.) performs the certain of each embodiment of the present invention or embodiment Method described in part.
The above description is merely a specific embodiment, but protection scope of the present invention is not limited thereto, any Those familiar with the art in the technical scope disclosed by the present invention, all should by the change or replacement that can be readily occurred in It is included within the scope of the present invention.Therefore, protection scope of the present invention should be subject to the protection scope in claims.

Claims (14)

1. a kind of paging search method, which is characterized in that including:
Paging retrieval request is received, the paging retrieval request includes sort criteria, paging condition and filter condition;
It determines to record number with the matching of each fragment of the fragment collection of the filter criteria matches, the fragment collection is according to default The set of fragment in the default fragment library that sort criteria is established;
The matching record number of each fragment based on the sort criteria, the paging condition and the fragment collection, from described point Corresponding matching record is obtained in the fragment of piece collection, as paging retrieval result.
2. paging search method according to claim 1, which is characterized in that determine the fragment with the filter criteria matches The matching record number of each fragment of collection, including:
The retrieval for judging to whether there is in caching with the filter criteria matches records:
Be not present in the caching when being recorded with the retrievals of the filter criteria matches, by the default fragment library with it is described The fragment of filter criteria matches, as the fragment collection;
Inquiry request is sent to each fragment of the fragment collection, obtains in each fragment of the fragment collection and meets the filtering The matching record number of condition.
3. paging search method according to claim 2, which is characterized in that from the default fragment library determine with it is described The fragment of filter criteria matches as the fragment collection, including:
Judge in the filter condition whether the codomain of the sort field comprising record to be retrieved:
In the filter condition in the case of the codomain of the sort field comprising record to be retrieved, from the default fragment library In, it determines with the matched fragment of the codomain as the fragment collection;
In the filter condition in the case of the codomain of the sort field not comprising record to be retrieved, by the default fragment library In all fragments as the fragment collection.
4. paging search method according to claim 2, which is characterized in that in each fragment for obtaining the fragment collection After meeting the matching record number of the filter condition, the method further includes:
The matching for meeting the filter condition in each fragment of the burst information of the fragment collection and the fragment collection is recorded Number is stored in as the retrieval record with the filter criteria matches in the caching.
5. paging search method according to claim 1, which is characterized in that determine the fragment with the filter criteria matches The matching record number of each fragment of collection, including:
Judge whether to have in caching and be recorded with the retrieval of the filter criteria matches:
When there is the retrieval record with the filter criteria matches in the caching, the retrieval note is obtained from the caching The matching record number of the burst information of fragment collection in record and wherein each fragment.
6. paging search method according to claim 1, which is characterized in that based on the sort criteria, the paging item The matching record number of each fragment of part and the fragment collection, obtains corresponding record from the fragment of the fragment collection, as Paging retrieval result, including:
The matching of single page record number and each fragment of the fragment collection specified according to the paging condition records number, from institute State fragment concentration, determine in the range of the page number that the paging condition is specified matching record where several first fragments and Home record serial number in each first fragment;
According to the home record serial number of each first fragment and matching record number, corresponding matching is obtained from each first fragment Record;
According to the sort criteria to the matching record ordering of acquisition, the matching after sequence is recorded as the paging condition and is referred to Paging retrieval result corresponding to fixed page number range.
7. the paging search method according to any one of claim 1~6, which is characterized in that the preset fragment It is established in library according to predetermined order condition, including:
Value sequence of the every record based on corresponding first sort field in each fragment in the preset fragment library, institute State the clooating sequence of the first sort field and first in the sort criteria in the paging retrieval request in predetermined order condition The clooating sequence of sort field is identical;
Codomain of each fragment based on each fragment in the preset fragment library sorts according to the sort criteria, wherein, The codomain of each fragment is the range of the value of the first sort field corresponding to the record in the fragment, the preset fragment library In each fragment codomain it is non-intersect.
8. device is retrieved in a kind of paging, which is characterized in that including:Paging retrieval request module, matching record number determining module with And paging retrieval result acquisition module, wherein,
Paging retrieval request module, for receiving paging retrieval request, the paging retrieval request includes sort criteria, paging item Part and filter condition;
Matching record number determining module, for determining to record with the matching of each fragment of the fragment collection of the filter criteria matches Number, the fragment collection is the set of the fragment in the default fragment library established according to predetermined order condition;
Paging retrieval result acquisition module, for based on each of the sort criteria, the paging condition and the fragment collection The matching record number of fragment, obtains corresponding matching record, as paging retrieval result from the fragment of the fragment collection.
9. device is retrieved in paging according to claim 8, which is characterized in that the matching record number determining module includes: Judging unit, matching unit and record number acquiring unit, wherein,
Judging unit, for judging that the retrieval that whether there is in caching with the filter criteria matches records:
Matching unit, will be described default when the retrieval for being not present in the caching with the filter criteria matches records In fragment library with the fragment of the filter criteria matches, as the fragment collection;
Number acquiring unit is recorded, for sending inquiry request to each fragment of the fragment collection, obtains the every of the fragment collection Meet the matching record number of the filter condition in a fragment.
10. device is retrieved in paging according to claim 9, which is characterized in that the matching unit includes:Retrieval record is looked into Subelement, codomain inquiry subelement and fragment collection determination subelement are ask, wherein,
Record queries subelement is retrieved, when the retrieval for being not present in the caching with the filter criteria matches records, Notify codomain inquiry subelement;
Codomain inquires subelement, for judging whether to include the codomain of the sort field of record to be retrieved in the filter condition:
Fragment collection determination subelement, for including the situation of the codomain of the sort field of record to be retrieved in the filter condition Under, from the default fragment library, determine with the matched fragment of the codomain as the fragment collection;
In the filter condition in the case of the codomain of the sort field not comprising record to be retrieved, by the default fragment library In all fragments as the fragment collection.
11. device is retrieved in paging according to claim 9, which is characterized in that described device further includes:
Memory module, for the filtering rod will to be met in each fragment of the burst information of the fragment collection and the fragment collection The matching record number of part, is stored in as the retrieval record with the filter criteria matches in the caching.
12. device is retrieved in paging according to claim 8, which is characterized in that the matching record number determining module includes: Caching query unit and record number determination unit, wherein,
Whether caching query unit records for judging to have in caching with the retrieval of the filter criteria matches:
Number determination unit is recorded, when being recorded for existing in the caching with the retrievals of the filter criteria matches, from described The burst information of the fragment collection in the retrieval record and the matching record number of wherein each fragment are obtained in caching.
13. device is retrieved in paging according to claim 8, which is characterized in that the paging retrieval result acquisition module packet It includes:Fragment determination unit, matching record queries unit and paging retrieval result acquiring unit, wherein,
Fragment determination unit, for the single page record number and each fragment of the fragment collection specified according to the paging condition Matching record number, from the fragment concentrate, determine in the range of the page number that the paging condition is specified matching record where Home record serial number in several first fragments and each first fragment;
Record queries unit is matched, for the home record serial number according to each first fragment and matching record number, from each the Corresponding matching record is obtained in one fragment;
Paging retrieval result acquiring unit, for the matching record ordering according to the sort criteria to acquisition, after sequence The paging retrieval result corresponding to page number range that matching record is specified as the paging condition.
14. the paging retrieval device according to any one of claim 8~13, which is characterized in that described preset point It is established in valut according to the sort criteria, including:
Value sequence of the every record based on corresponding first sort field in each fragment in the preset fragment library, institute State the clooating sequence of the first sort field and first in the sort criteria in the paging retrieval request in predetermined order condition The clooating sequence of sort field is identical;
Codomain of each fragment based on each fragment in the preset fragment library sorts according to the sort criteria, wherein, The codomain of each fragment is the range of the value of the first sort field corresponding to the record in the fragment, the preset fragment library In each fragment codomain it is non-intersect.
CN201611197285.8A 2016-12-21 2016-12-21 A kind of paging search method and device Pending CN108228663A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201611197285.8A CN108228663A (en) 2016-12-21 2016-12-21 A kind of paging search method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201611197285.8A CN108228663A (en) 2016-12-21 2016-12-21 A kind of paging search method and device

Publications (1)

Publication Number Publication Date
CN108228663A true CN108228663A (en) 2018-06-29

Family

ID=62656849

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201611197285.8A Pending CN108228663A (en) 2016-12-21 2016-12-21 A kind of paging search method and device

Country Status (1)

Country Link
CN (1) CN108228663A (en)

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110909266A (en) * 2019-11-25 2020-03-24 北京金山云网络技术有限公司 Deep paging method and device and server
CN111046305A (en) * 2019-12-03 2020-04-21 深圳证券交易所 Data processing method, server and storage medium
CN111221815A (en) * 2019-11-07 2020-06-02 南京莱斯网信技术研究院有限公司 Script-based web service paging data acquisition system
CN111488370A (en) * 2020-04-02 2020-08-04 杭州迪普科技股份有限公司 List paging quick response system and method
CN112783925A (en) * 2019-11-11 2021-05-11 北京沃东天骏信息技术有限公司 Paging retrieval method and device
CN113535824A (en) * 2021-07-27 2021-10-22 杭州海康威视数字技术股份有限公司 Data searching method and device, electronic equipment and storage medium
WO2022179023A1 (en) * 2021-02-25 2022-09-01 华为技术有限公司 Sorting device and method

Citations (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050203898A1 (en) * 2004-03-09 2005-09-15 International Business Machines Corporation System and method for the indexing of organic chemical structures mined from text documents
CN101093501A (en) * 2007-07-31 2007-12-26 武汉大学 Method for querying high performance, transparent distributed spatial database
CN101216840A (en) * 2008-01-21 2008-07-09 金蝶软件(中国)有限公司 Data enquiry method and data enquiry system
CN101510223A (en) * 2009-04-03 2009-08-19 成都市华为赛门铁克科技有限公司 Data processing method and system
CN101533406A (en) * 2009-04-10 2009-09-16 北京锐安科技有限公司 Mass data querying method
CN101727436A (en) * 2008-10-29 2010-06-09 华为技术有限公司 Method for processing report data, reporting system and related device thereof
CN101833558A (en) * 2009-09-04 2010-09-15 广东省标准化研究院 Standard literature full text structuralization method based on extensible markup language
CN101909079A (en) * 2010-07-15 2010-12-08 北京迈朗世讯科技有限公司 User online behavior data acquisition method in backbone link and system
US20110154443A1 (en) * 2009-12-23 2011-06-23 Ravindranath Thakur Systems and methods for aaa-traffic management information sharing across cores in a multi-core system
CN102223309A (en) * 2011-07-07 2011-10-19 谢海春 Safe communication system and implementation method based on message load segmentation, encryption and reorder
CN102496081A (en) * 2011-11-15 2012-06-13 北京航空航天大学 Three-dimensional visualized and interaction method of project structured message
CN102831146A (en) * 2012-06-19 2012-12-19 天津神舟通用数据技术有限公司 Database substring filtering index system and method for constructing and inquiring database substring filtering index system
CN103309864A (en) * 2012-03-07 2013-09-18 腾讯科技(深圳)有限公司 Method, device and system for displaying search result
CN103617232A (en) * 2013-11-26 2014-03-05 北京京东尚科信息技术有限公司 Paging inquiring method for HBase table
CN103853727A (en) * 2012-11-29 2014-06-11 深圳中兴力维技术有限公司 Method and system for improving large data volume query performance
CN103886022A (en) * 2014-02-24 2014-06-25 上海上讯信息技术股份有限公司 Paging-query querying device and method based on primary key fields
CN104123340A (en) * 2014-06-25 2014-10-29 世纪禾光科技发展(北京)有限公司 Table-by-table and page-by-page query method and system for database
CN105843956A (en) * 2016-04-14 2016-08-10 北京搜狐新媒体信息技术有限公司 Paging query method and system

Patent Citations (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050203898A1 (en) * 2004-03-09 2005-09-15 International Business Machines Corporation System and method for the indexing of organic chemical structures mined from text documents
CN101093501A (en) * 2007-07-31 2007-12-26 武汉大学 Method for querying high performance, transparent distributed spatial database
CN101216840A (en) * 2008-01-21 2008-07-09 金蝶软件(中国)有限公司 Data enquiry method and data enquiry system
CN101727436A (en) * 2008-10-29 2010-06-09 华为技术有限公司 Method for processing report data, reporting system and related device thereof
CN101510223A (en) * 2009-04-03 2009-08-19 成都市华为赛门铁克科技有限公司 Data processing method and system
CN101533406A (en) * 2009-04-10 2009-09-16 北京锐安科技有限公司 Mass data querying method
CN101833558A (en) * 2009-09-04 2010-09-15 广东省标准化研究院 Standard literature full text structuralization method based on extensible markup language
US20110154443A1 (en) * 2009-12-23 2011-06-23 Ravindranath Thakur Systems and methods for aaa-traffic management information sharing across cores in a multi-core system
CN101909079A (en) * 2010-07-15 2010-12-08 北京迈朗世讯科技有限公司 User online behavior data acquisition method in backbone link and system
CN102223309A (en) * 2011-07-07 2011-10-19 谢海春 Safe communication system and implementation method based on message load segmentation, encryption and reorder
CN102496081A (en) * 2011-11-15 2012-06-13 北京航空航天大学 Three-dimensional visualized and interaction method of project structured message
CN103309864A (en) * 2012-03-07 2013-09-18 腾讯科技(深圳)有限公司 Method, device and system for displaying search result
CN102831146A (en) * 2012-06-19 2012-12-19 天津神舟通用数据技术有限公司 Database substring filtering index system and method for constructing and inquiring database substring filtering index system
CN103853727A (en) * 2012-11-29 2014-06-11 深圳中兴力维技术有限公司 Method and system for improving large data volume query performance
CN103617232A (en) * 2013-11-26 2014-03-05 北京京东尚科信息技术有限公司 Paging inquiring method for HBase table
CN103886022A (en) * 2014-02-24 2014-06-25 上海上讯信息技术股份有限公司 Paging-query querying device and method based on primary key fields
CN104123340A (en) * 2014-06-25 2014-10-29 世纪禾光科技发展(北京)有限公司 Table-by-table and page-by-page query method and system for database
CN105843956A (en) * 2016-04-14 2016-08-10 北京搜狐新媒体信息技术有限公司 Paging query method and system

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111221815A (en) * 2019-11-07 2020-06-02 南京莱斯网信技术研究院有限公司 Script-based web service paging data acquisition system
CN111221815B (en) * 2019-11-07 2021-07-27 南京莱斯网信技术研究院有限公司 Script-based web service paging data acquisition system
CN112783925A (en) * 2019-11-11 2021-05-11 北京沃东天骏信息技术有限公司 Paging retrieval method and device
CN112783925B (en) * 2019-11-11 2024-03-01 北京沃东天骏信息技术有限公司 Paging retrieval method and device
CN110909266A (en) * 2019-11-25 2020-03-24 北京金山云网络技术有限公司 Deep paging method and device and server
CN110909266B (en) * 2019-11-25 2022-09-02 北京金山云网络技术有限公司 Deep paging method and device and server
CN111046305A (en) * 2019-12-03 2020-04-21 深圳证券交易所 Data processing method, server and storage medium
CN111046305B (en) * 2019-12-03 2023-09-26 深圳证券交易所 Data processing method, server and storage medium
CN111488370A (en) * 2020-04-02 2020-08-04 杭州迪普科技股份有限公司 List paging quick response system and method
CN111488370B (en) * 2020-04-02 2023-09-12 杭州迪普科技股份有限公司 List paging quick response system and method
WO2022179023A1 (en) * 2021-02-25 2022-09-01 华为技术有限公司 Sorting device and method
CN113535824A (en) * 2021-07-27 2021-10-22 杭州海康威视数字技术股份有限公司 Data searching method and device, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
CN108228663A (en) A kind of paging search method and device
Bergman White paper: the deep web: surfacing hidden value
US6321228B1 (en) Internet search system for retrieving selected results from a previous search
US6594654B1 (en) Systems and methods for continuously accumulating research information via a computer network
Hotho et al. Information retrieval in folksonomies: Search and ranking
US8209317B2 (en) Method and apparatus for reconstructing a search query
US6411950B1 (en) Dynamic query expansion
TWI463337B (en) Method and system for federated search implemented across multiple search engines
US5748954A (en) Method for searching a queued and ranked constructed catalog of files stored on a network
US6601061B1 (en) Scalable information search and retrieval including use of special purpose searching resources
US8843481B1 (en) System and method of forming action based virtual communities and related search mechanisms
US9069853B2 (en) System and method of goal-oriented searching
CN108304444A (en) Information query method and device
US20080313142A1 (en) Categorization of queries
US20080243787A1 (en) System and method of presenting search results
EP2131290A1 (en) Method of displaying related keyword and system as the same
US6907425B1 (en) System and method for searching information stored on a network
WO2001016807A1 (en) An internet search system for tracking and ranking selected records from a previous search
US8180751B2 (en) Using an encyclopedia to build user profiles
US6711569B1 (en) Method for automatic selection of databases for searching
KR100671077B1 (en) Server, Method and System for Providing Information Search Service by Using Sheaf of Pages
CN101599069A (en) The searching method of electronic document and system
KR100557874B1 (en) Method of scientific information analysis and media that can record computer program thereof
Šimko et al. Semantic history map: Graphs aiding web revisitation support
US20080313166A1 (en) Research progression summary

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20180629