CN103678408A - Method and device for inquiring data - Google Patents
Method and device for inquiring data Download PDFInfo
- Publication number
- CN103678408A CN103678408A CN201210359116.5A CN201210359116A CN103678408A CN 103678408 A CN103678408 A CN 103678408A CN 201210359116 A CN201210359116 A CN 201210359116A CN 103678408 A CN103678408 A CN 103678408A
- Authority
- CN
- China
- Prior art keywords
- data
- page number
- condition
- sequence
- storehouse
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24532—Query optimisation of parallel queries
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Computer And Data Communications (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and device for inquiring data. The method and device aim to solve the problem that a paging query method in the prior art increases network pressure. According to the method, a client determines the number N of data obtained from each branch library according to an input query page number and the number of data contained in each page, then the first N data in data which are in a condition interval and sequenced according to a sequencing rule are obtained in each branch library according to the input condition interval and the sequencing rule, and finally the obtained data are sequenced according to the sequencing rule and corresponding data are provided according to the query page number. By means of the method, the client carries out paging query in a branch library and branch table scene, not all the data in the condition interval need to be obtained from the branch libraries, and what is needed is to obtain a part of the data in the condition interval in each branch library so that network communication generated when the client obtains the data can be reduced, and the network pressure can be effectively reduced.
Description
Technical field
The application relates to Internet technical field, relates in particular to a kind of method and device of data query.
Background technology
At present, in database, during data query, often adopt the method for paging query to inquire about.When the method that adopts paging query is carried out data query, user needs initial conditions interval, ordering rule, the inquiry page number, database first extracts all data interior between condition portion, according to ordering rule, the data that extract are sorted again, in last data after sequence, determine that the data of the corresponding page number return to user.
For example, input condition portion between for the most in a couple of days, ordering rule is the sequencing of time, the inquiry page number is the 2nd page, database first extracts interior all data, then according to time order and function order, the data that extract is sorted, and supposes that every one page comprises 10 data, the 2nd page of data that comprise are 11st ~ 20, thereby database returns to user by 11st ~ 20 data after sequence.
The method of above-mentioned paging query is the querying method being applied in individual data storehouse.
In the prior art, in order to solve finite capacity, the large problem of access pressure in individual data storehouse, conventionally adopt the method storage data of minute storehouse submeter.Concrete, data are carried out to level fractionation, data are carried out to the storage of data according to the discrete method in a plurality of minutes storehouses of certain rule.
For example, dispose two minutes storehouses: A storehouse, B storehouse.Data for storing, if the serial number of these data is odd numbers, are stored in A storehouse, if the serial number of these data is even numbers, are stored in B storehouse.
While adopting A storehouse and B library storage data, if still will adopt the method for paging query, inquire about the 2nd interior page data, need by client obtain be respectively stored in A storehouse and B storehouse the most in a couple of days in all data, again by the A storehouse obtaining and B storehouse respectively storage the most in a couple of days in data according to time order and function order, sort, finally by sequence after the 2nd page data offer user.
Visible, in the prior art, while carrying out paging query under minute scene of storehouse submeter, client need to be obtained all data interior between the condition portion of storing in storehouse for each minute, because the data between the condition portion of storing in storehouse for each minute are a large amount of often, therefore this will inevitably produce a large amount of network service, thereby increases the pressure of network.
Summary of the invention
The application provides a kind of method and device of data query, can increase the problem of the pressure of network in order to solve paging query method of the prior art.
The embodiment of the present application provides a kind of method of data query, comprising:
Client, according to the quantity of the data that comprise in the inquiry page number of input and default every page, is determined the quantity N of the data that will obtain storehouse from each minute; And
According between the condition portion of input and ordering rule, within each minute, obtaining between described condition portion storehouse according to the front N bar data after described ordering rule sequence; And
According to described ordering rule, the data that get are sorted, and provide corresponding data according to the described inquiry page number.
The embodiment of the present application provides a kind of device of data query, comprising:
Determination module, for according to the quantity of the inquiry page number of input and default every page of data that comprise, determines the quantity N of the data that will obtain storehouse from each minute;
Acquisition module, for according between the condition portion of input and ordering rule, within each minute, obtaining between described condition portion storehouse according to the front N bar data after described ordering rule sequence;
Module is provided, for according to described ordering rule, the data that get is sorted, and provide corresponding data according to the described inquiry page number.
The embodiment of the present application provides a kind of method and device of data query, the method client is according to the quantity of the data that comprise in the inquiry page number of input and every page, determine the quantity N of the data that will obtain storehouse from each minute, again according to input condition portion between and ordering rule, front N bar data after sorting according to this ordering rule in obtaining between this condition portion storehouse from each minute, last according to this ordering rule to the data sorting getting, and provide corresponding data according to the inquiry page number.Pass through said method, when client is carried out paging query under minute scene of storehouse submeter, without all data obtained between condition portion storehouse from each minute in, and a part of data in only need obtaining storehouse from each minute between condition portion, thereby can reduce the network service producing when client is obtained data, effectively alleviate the pressure of network.
Accompanying drawing explanation
The process of the data query that Fig. 1 provides for the embodiment of the present application;
The apparatus structure schematic diagram of the data query that Fig. 2 provides for the embodiment of the present application.
Embodiment
Owing to carrying out paging query in prior art under minute scene of storehouse submeter, client need to be obtained from each minute all data interior between condition portion storehouse, and between the condition portion of storing in storehouse for each minute in all data a large amount of often, therefore client is obtained these a large amount of data and will inevitably be produced a large amount of network service, causes the increase of network pressure.The core concept of the embodiment of the present application is: can meet under the condition that its data that will inquire about are provided to user, reduce the quantity of the data of obtaining storehouse from each minute as far as possible, thereby reach, reduce the object obtain the network service that data produce, to alleviate the pressure of network.
Below in conjunction with Figure of description, the embodiment of the present application is described in detail.
The process of the data query that Fig. 1 provides for the embodiment of the present application, comprises the following steps:
S101: client, according to the quantity of the data that comprise in the inquiry page number of input and default every page, is determined the quantity N of the data that will obtain storehouse from each minute.
In the embodiment of the present application, when the method for employing paging query is inquired about the data of certain one page, [S between the condition portion that user still needs will inquire about to client input, E], ordering rule, inquiry page number p, wherein, S is the interval starting point between this condition portion of input, and E is the interval end point between this condition portion of input.Between this condition portion of input, [S, E], ordering rule, inquiry page number p represent: the data that inquire about are the p page data after sorting according to this ordering rule in [S, E] between condition portion.
The quantity of the data that comprise due to every one page is fixed, and the quantity of the data that comprise in therefore can presetting every page in client, for example, be set to n, represents that every page comprises n bar data.Client, first according to the quantity n of the data that comprise in the inquiry page number p of user's input and default every page, is determined the quantity N of the data that will obtain storehouse from each minute.Wherein, can by the inquiry page number p of user input with default every page in the product p * n of quantity n of the data that comprise, be defined as the quantity N of the data that will obtain storehouse from each minute, be also that N is p * n.
S102: according between the condition portion of input and ordering rule, within each minute, obtaining between this condition portion storehouse according to the front N bar data after this ordering rule sequence.
Having determined will be after the quantity N of the data obtained storehouse for each minute, and client was obtained storehouse from each minute between this condition portion in [S, E] according to the front N bar data after this ordering rule sequence.Concrete, client can be by [S between this condition portion, E], ordering rule, and the quantity N determining sends to each minute storehouse, in order to notify each minute storehouse [S between this condition portion to self storage respectively, E] in all data according to the sequence of this ordering rule, and the front N bar data after sequence are returned to client.Client receives respectively the N bar data that each minute storehouse returned.
S103: according to this ordering rule, the data that get are sorted, and provide corresponding data according to this inquiry page number.
Client got storehouse after N bar data from each minute, gathered all data that get, and the ordering rule according to user's input, sorts to all data that get, and according to the inquiry page number of user's input, to user, provided corresponding data.
In said process, client only need be obtained from each minute N bar data storehouse, and without obtaining [S between condition portion, E] interior all data, therefore reduce the quantity of the data of obtaining, thereby reduced the network service producing while obtaining data, effectively alleviated the pressure of network.
The concrete application scenarios of take is below example, and the data query method of dividing three kinds of situations to provide the embodiment of the present application is elaborated.
For example, suppose to have two minutes storehouses: A storehouse and B storehouse.Data for storing, if the serial number of these data is odd numbers, are stored in A storehouse, if the serial number of these data is even numbers, are stored in B storehouse.In current A storehouse, store the most in a couple of days in data serial number according to time order and function order respectively: 1,3,5,7 ..., 99.In current B storehouse, store the most in a couple of days in data serial number according to time order and function order respectively: 2,4,6,8 ..., 100.Also, the data in the most in a couple of days have 100, A library storage wherein serial number be odd number 50, B library storage wherein serial number be even number 50.
Under above-mentioned application scenarios, if the data that user will inquire about are that in the data (being also these 100 data) in the most in a couple of days, a certain page data after sorting according to time order and function order, is divided into following three kinds of situations.
Situation one, user have inputted [S between condition portion, E], after ordering rule, the inquiry page number, if client is determined [S between this condition portion based on input, E] and ordering rule do not inquire about any data, in above-mentioned steps S101, client by the inquiry page number p of input with default every page in the product p * n of quantity n of the data that comprise, be defined as the quantity N of the data that will obtain storehouse from each minute.
Then, client is carried out above-mentioned steps S102 again, that is, client is according between the condition portion of input and ordering rule, within each minute, obtaining storehouse between this condition portion in [S, E] according to the front N bar data after this ordering rule sequence.
Finally, client executing above-mentioned steps S103, that is, client, according to this ordering rule, sorts to the data that get, and according to the inquiry page number p of user's input, provides corresponding data.Wherein, client provides the method for corresponding data to be specially according to the inquiry page number p of user input: according to the quantity n of the data that comprise in inquiry page number p and default every page, determine interval [(p-1) n+1 of sequence number that inquiry page number p is corresponding, pn], and in the data after sequence, the data of sequence number in sequence number interval [(p-1) n+1, pn] corresponding to inquiry page number p are provided.
Continuation be take above-mentioned application scenarios and is described as example, supposes that data that user will inquire about are in the data in the most in a couple of days, according to the time order and function order data of the 2nd page afterwards that sorts:
Between the condition portion that user's input will be inquired about [S, E], between this condition portion, [S, E] is time interval the most in a couple of days.Suppose to be September 1 and September 2 the most in a couple of days, S is the interval starting point between this condition portion, is also 0 point on September 1, and E is the interval end point between this condition portion, is also 24 points (0 point on September 3 in other words) on September 2;
User's input sequencing rule is in chronological sequence sequentially;
The user input query page number is 2, is also p=2.
The quantity of the data that comprise in default every page is 10, also be n=10, that is every page comprise 10 data, if client is determined now not yet [S between the condition portion based on this user's input, E] and ordering rule (in chronological sequence order) inquired about any data, also be, determine that this inquiry is [S between this condition portion based on user's input, E] and the inquiry for the first time carried out of ordering rule (in chronological sequence order), by the inquiry page number of user input 2 with default every page in the product 20 of quantity 10 of the data that comprise, be defined as the quantity N of the data that will obtain storehouse from each minute, also be that N is 20.
Client is obtained in [S, E] between condition portion according to front 20 data after the sequence of time order and function order in A storehouse, obtains between condition portion in [S, E] according to front 20 data after the sequence of time order and function order in B storehouse.
Wherein, due in A storehouse, store the most in a couple of days in data serial number according to time order and function order be respectively 1,3,5,7 ..., 99, also be, [the S between condition portion storing in A storehouse, E] in data serial number according to time order and function order be respectively 1,3,5,7 ..., 99, therefore, between the condition portion that client is obtained from A storehouse in [S, E] according to the serial number of front 20 data after the sequence of time order and function order according to time order and function order respectively: 1,3,5,7 ..., 39.Similarly, between the condition portion that client is obtained from B storehouse in [S, E] according to the serial number of front 20 data after the sequence of time order and function order according to time order and function order respectively: 2,4,6,8 ... 40.Visible, client has been obtained altogether serial number and has been respectively 40 data of 1 ~ 40.
Client has all been obtained after 20 data from A storehouse and B storehouse,, according to the ordering rule of user's input, also according to time order and function order, all data that get is sorted.
1,2,3,4 suppose that serial number that client gets is respectively 40 data of 1 ~ 40 and is respectively according to time order and function order: ... 40, client, according to the quantity 10 of the data that comprise in the inquiry page number 2 of user input and default every page, is determined the sequence number interval of these inquiry page number 2 correspondences
1,2,3,4 the serial number getting due to client is respectively 40 data of 1 ~ 40 and is respectively according to time order and function order: ... 40, therefore, after these 40 data are sorted according to time order and function order, the data of sequence number in the sequence number interval [11,20] of these inquiry page number 2 correspondences are: serial number is respectively 11,12,13 ... 20 data.Thereby, client to user provide serial number be respectively 11,12,13 ... 20 data, as this user, to inquire about the most in a couple of days in, according to the 2nd page data after time order and function order sequence.
As can be seen here, in situation one, also when client is determined between the condition portion based on user's input and when ordering rule did not inquire about any data, only need to from A storehouse and B storehouse, obtain totally 40 data (obtaining respectively 20 data from A storehouse and B storehouse), can provide that it will inquire about to user the most in a couple of days in, the 2nd page data after sorting according to time order and function order.In prior art, need to from A storehouse and B storehouse, obtain altogether [S between condition portion, E] 100 interior data, the method of the data query that the embodiment of the present application provides has reduced the quantity of the data that client obtained storehouse from each minute, therefore reduce the network service producing when client is obtained data, effectively alleviated network pressure.
Further, in order further to alleviate network pressure in the process in subsequent query data, client [S between the condition portion based on user's input in the embodiment of the present application, E], ordering rule, inquiry page number p, after user provides corresponding data, also will be for the page number p-i that is not more than this inquiry page number p, determine interval [(p-i-1) n+1 of sequence number that page number p-i is corresponding, (p-i) n], wherein, i is 0 to p-1 positive integer; According to the data after sequence and sequence number interval [(p-i-1) n+1, (p-i) n] corresponding to page number p-i, adopt designation method to determine condition sub-range the record that page number p-i is corresponding; Wherein, this designation method comprises: in the data after sequence, the condition of the data that are (p-i-1) n+1 by sequence number is defined as the interval starting point in the condition sub-range that page number p-i is corresponding, and the condition of the data that are (p-i) n by sequence number is defined as the interval end point in the condition sub-range that page number p-i is corresponding.
Continue along using example, client to user, provide that this user will inquire about the most in a couple of days in, according to after the 2nd page data after the sequence of time order and function order, determine that the page number that is not more than this inquiry page number p=2 comprises the page number
therefore, determine interval [(p-i-1) n+1, (p-i) n]=[1,10] of sequence number of this page number 1 correspondence.
The serial number getting due to client is respectively 40 data of 1 ~ 40 and is respectively according to time order and function order: 1, 2, 3, 4, 40, therefore, after these 40 data are sorted according to time order and function order, sequence number is 1 data for the data of (p-i-1) n+1=1 are serial number, sequence number is 10 data for the data of (p-i) n=10 are serial number, suppose that this serial number is that time corresponding to data of 1 is R1S, serial number is that time corresponding to data of 10 is R1E, the condition sub-range of this page number 1 correspondence is [R1S, R1E], condition sub-range [the R1S of this page number 1 correspondence, R1E] represent: by [S between condition portion, E] in all data of (the most in a couple of days in) according to the sequence of time order and function order after, condition sub-range [R1S, R1E] in data be exactly the 1st page data.
Similarly, suppose that serial number is that time corresponding to data of 11 is R2S, time corresponding to data that serial number is 20 is R2E, and the condition sub-range of inquiring about the page number 2 correspondences is [R2S, R2E].
Recorded behind the condition sub-range that each page number that is not more than this inquiry page number is corresponding, the data that if follow-up this user continues to adopt between identical condition portion and ordering rule is inquired about other page numbers, can inquire about according to the condition sub-range corresponding to each page number of record situation about stating two specific as follows and situation three.
Situation two, user have inputted [S between condition portion, E], after ordering rule, inquiry page number p, if client is determined [S between this condition portion based on input, E] and ordering rule inquired about the data that the page number is less than this inquiry page number,, in above-mentioned steps S101, client determines that the method for the quantity N of the data that will obtain storehouse from each minute is: in each page number p-i inquiring about and be less than inquiry page number p, determine maximum page number max (p-i), wherein, i is 0 to p-1 positive integer; Determine the inquiry page number p of input and the difference p-max (p-i) of maximum page number max (p-i), by definite difference p-max (p-i) with default every page in product (p-max (p-i)) * n of quantity n of the data that comprise, be defined as the quantity N of the data that will obtain storehouse from each minute.
Then, client is when carrying out above-mentioned steps S102, according to [S between the condition portion of input, E] and ordering rule, from each minute, storehouse, obtain [S between condition portion, E] according to the method for the front N bar data after the sequence of this ordering rule, be specially: the condition sub-range corresponding to this maximum page number max (p-i) of recording while determining the data based on [S, E] and this ordering rule are inquired about this maximum page number max (p-i) between this condition portion; According to the condition sub-range of this maximum page number max (p-i) correspondence, the interval starting point of [S, E] between the condition portion of input is adjusted into the interval end point in the condition sub-range that this maximum page number max (p-i) is corresponding; Front N bar data after sorting according to this ordering rule in between the condition portion obtaining storehouse after adjustment for each minute.
Finally, client executing above-mentioned steps S103, that is, client, according to this ordering rule, sorts to the data that get, and according to the inquiry page number p of user's input, provides corresponding data.Wherein, client provides the method for corresponding data to be specially according to the inquiry page number p of user input: the quantity n of the data that comprise according to inquiry page number p, maximum page number max (p-i), in default every page, determine interval [(p-max (p-i)-1) n+1 of sequence number that this inquiry page number p is corresponding, (p-max (p-i)) n], and in the data after sequence, the data of sequence number in sequence number interval [(p-max (p-i)-1) n+1, (p-max (p-i)) n] corresponding to this inquiry page number p are provided.
Continuation be take above-mentioned application scenarios and is described as example, suppose in the data of user in having inquired about the most in a couple of days, the data of the 2nd page after sorting according to time order and function order, to continue now in the data in inquiry the most in a couple of days, the data of the 5th page after sorting according to time order and function order:
Between the condition portion that user's input will be inquired about, be still [S, E], between this condition portion, [S, E] is time interval the most in a couple of days;
User's input sequencing rule is still in chronological sequence order;
The user input query page number is 5, is also p=5.
Now, between the definite condition portion based on this user's input of client, [S, E] and ordering rule (in chronological sequence order) were inquired about the data that the page number is less than the current inquiry page number 5, and the page number that is less than the current inquiry page number 5 of inquiring about is the page number 2.Therefore, client is in each page number of inquiring about and be less than the current inquiry page number 5, and the maximum page number of determining is the page number 2, is also max (p-i)=2.The inquiry page number 5 of current input is p-max (p-i)=3 with the difference of the maximum page number 2.This difference 3 with default every page in the product of quantity 10 of the data that comprise be (p-max (p-i)) * n=30.The quantity N of the data that will obtain storehouse from each minute that therefore, client is determined is 30.
Due in above-mentioned situation one, client had been inquired about the data of the page number 2, therefore now client has recorded the condition sub-range [R2S of these page number 2 correspondences, R2E], thereby client is adjusted into the interval starting point S of [S, E] between the condition portion of input the interval end point R2E in the condition sub-range of these page number 2 correspondences, between the condition portion after adjustment, be (R2E, E].After having adjusted between condition portion, client is obtained (R2E between the condition portion after adjustment from A storehouse, E] according to front 30 data after time order and function order sequence, from B storehouse, obtain between condition portion (R2E, E] according to front 30 data after the sequence of time order and function order.
Wherein, due in A storehouse, by [S between condition portion, E] (serial number is respectively 1 to interior all data, 3, 5, 7 ... 99 data) according to after the sequence of time order and function order, condition sub-range [the R1S of the page number 1 correspondence, R1E] in data be that serial number is respectively 1, 3, 5, 7, 9 data, condition sub-range [the R2S of the page number 2 correspondences, R2E] in data be that serial number is respectively 11, 13, 15, 17, 19 data, therefore, (R2E between the condition portion after the adjustment that client is obtained from A storehouse, E] according to front 30 data after time order and function order sequence, be: serial number is respectively 21, 23, 25, 27, 79 data.Similarly, between the condition portion after the adjustment that client is obtained from B storehouse (R2E, E] according to front 30 data after the sequence of time order and function order, be: serial number is respectively 22,24,26,28 ... 80 data.Visible, client has been obtained altogether serial number and has been respectively 60 data of 21 ~ 80.
Client has all been obtained after 30 data from A storehouse and B storehouse,, according to the ordering rule of user's input, also according to time order and function order, all data that get is sorted.
21,22,23,24 suppose that serial number that client gets is respectively 60 data of 21 ~ 80 and is respectively according to time order and function order: ... 80, the quantity 10 of the data that client comprises according to the current inquiry page number 5, the maximum page number 2, in default every page, determine interval [(p-max (p-i)-1) n+1 of sequence number of current these inquiry page number 5 correspondences, (p-max (p-i)) n]=[21,30].
21,22,23,24 owing to the serial number obtaining being respectively to 60 data of 21 ~ 80, according to time order and function order, be respectively: ..., 80, therefore, after these 60 data are sorted according to time order and function order, the data of sequence number in the sequence number interval [21,30] of current these inquiry page number 5 correspondences are: serial number is respectively 41,42,43 ..., 50 data.Thereby, client to user provide serial number be respectively 41,42,43 ..., 50 data.
As can be seen here, in situation two, user was in the situation that inquiring about the 2nd page data, between the condition portion of continuation based on identical and when identical ordering rule inquires about the 5th page data, if the method according to situation one is inquired about, client need to all be obtained 50 data in A storehouse and B storehouse, also obtain altogether 100 data, if and inquired about according to the method for situation two, client can be according to the condition sub-range of the page number 2 correspondences that record when inquiring about the 2nd page data, dwindle the scope between the condition portion that will inquire about, and the quantity of the data that further minimizing is obtained from A storehouse and B storehouse, only need to from A storehouse and B storehouse, obtain respectively 30, obtain altogether 60 data, can provide that it will inquire about to user the most in a couple of days in, according to the 5th page data after the sequence of time order and function order, thereby further reduced the network service producing while obtaining data, further alleviated the pressure of network.
Certainly, in above-mentioned situation two, client provides after the 5th page data to user, also to determine respectively corresponding condition sub-range the record of each page number that is not more than the current inquiry page number 5, also determine respectively condition sub-range the record of the page number 1 ~ 5 correspondence, and the condition sub-range that in fact page number 1 and the page number 2 correspondences have been determined and recorded to client, therefore to user, provide after the 5th page data, as long as the condition sub-range of determining and recording the page number 3 ~ 5 correspondences, just repeats here no longer one by one.
Situation three, user have inputted [S between condition portion, E], after ordering rule, inquiry page number p, if client is determined [S between this condition portion based on input, E] and ordering rule inquired about the data that the page number is greater than this inquiry page number, in above-mentioned steps S101, client is determined: by the quantity n of the data that comprise in default every page, be defined as the quantity N of the data that will obtain storehouse from each minute.
Then, client is when carrying out above-mentioned steps S102, according to [S between the condition portion of input, E] and ordering rule, from each minute, storehouse, obtain [S between condition portion, E] according to the method for the front N bar data after the sequence of this ordering rule, be specially: determine condition sub-range corresponding to this inquiry page number that the data that the page number are greater than to this inquiry page number based on [S, E] and this ordering rule between this condition portion record while inquiring about; [S, E] between this condition portion of input is adjusted into the condition sub-range that this inquiry page number is corresponding; Front N bar data after sorting according to this ordering rule in between the condition portion obtaining storehouse after adjustment for each minute.
Finally, client executing above-mentioned steps S103, that is, client, according to this ordering rule, sorts to the data that get, and according to the inquiry page number p of user's input, provides corresponding data.Wherein, client provides the method for corresponding data to be specially according to this inquiry page number p of user's input: in the data after sequence, provide front n bar data.
Continuation be take above-mentioned application scenarios and is described as example, suppose in the data of user in having inquired about the most in a couple of days, the data of the 2nd page after sorting according to time order and function order, to continue now in the data in inquiry the most in a couple of days, the data of the 1st page after sorting according to time order and function order:
Between the condition portion that user's input will be inquired about, be still [S, E], between this condition portion, [S, E] is time interval the most in a couple of days;
User's input sequencing rule is still in chronological sequence order;
The user input query page number is 1, is also p=1.
Now, between the definite condition portion based on this user's input of client, [S, E] and ordering rule (in chronological sequence order) were inquired about the data that the page number is greater than the current inquiry page number 1, and the page number that is greater than the current inquiry page number 1 of inquiring about is the page number 2.Therefore, client is directly by the quantity 10 of the data that comprise in default every page, is defined as the quantity N of the data that will obtain storehouse from each minute, is also that N is 10.
Due in above-mentioned situation one, client had been inquired about the data of the page number 2, therefore now client has recorded the current inquiry page number of page number 1() corresponding condition sub-range [R1S, R1E], thereby client is directly adjusted into by [S, E] between the condition portion of input the condition sub-range that this current inquiry page number is corresponding, between the condition portion after adjustment, be the condition sub-range [R1S, R1E] of the page number 1 correspondence.
After having adjusted between condition portion, client is obtained [R1S between the condition portion after adjustment from A storehouse, R1E] according to front 10 data after the sequence of this ordering rule, from B storehouse, obtain between the condition portion after adjustment in [R1S, R1E] according to front 10 data after this ordering rule sequence.
Wherein, due in A storehouse, by [S between condition portion, E] (serial number is respectively 1,3,5,7 to interior all data ... 99 data) according to after the sequence of time order and function order, data in the condition sub-range of the page number 1 correspondence [R1S, R1E] are that serial number is respectively 1,3,5,7,9 data, therefore, between the condition portion after the adjustment that client is obtained from A storehouse, in [R1S, R1E], according to front 10 data after this ordering rule sequence, be: serial number is respectively 1,3,5,7,9 data.Similarly, between the condition portion after the adjustment that client is obtained from B storehouse, in [R1S, R1E], according to front 10 data after this ordering rule sequence, be: serial number is respectively 2,4,6,8,10 data.
It should be noted that, in fact between the condition portion of client after the adjustment getting storehouse for minute, the data in [R1S, R1E] are impossible surpass 10, as above in example, client has in fact only got 5 data from A storehouse, has also only got 5 data from B storehouse.Visible, client has been obtained altogether serial number and has been respectively 10 data of 1 ~ 10.
Client has all been obtained after 5 data from A storehouse and B storehouse,, according to the ordering rule of user's input, also according to time order and function order, all data that get is sorted.
1,2,3,4 suppose that serial number that client gets is respectively 10 data of 1 ~ 10 and is respectively according to time order and function order: ... 10, client directly provides front 10 data after sequence, and the data that also provide are exactly that serial number is respectively 10 data of 1 ~ 10.
As can be seen here, in situation three, user was in the situation that inquiring about the 2nd page data, between the condition portion of continuation based on identical and when identical ordering rule inquires about the 1st page data, if the method according to situation one is inquired about, client need to all be obtained 10 data in A storehouse and B storehouse, also obtain altogether 20 data, if and inquired about according to the method for situation three, client can be according to the condition sub-range of the page number 1 correspondence recording when inquiring about the 2nd page data, directly the scope between the condition portion of user's input is narrowed down to the scope in the condition sub-range of the page number 1 correspondence, and the quantity of the data that further minimizing is obtained from A storehouse and B storehouse, client reality has been obtained altogether 10 data from A storehouse and B storehouse, can provide that it will inquire about to user the most in a couple of days in, according to the 1st page data after the sequence of time order and function order, thereby further reduced the network service producing while obtaining data, further alleviated the pressure of network.
More than the detailed description that the method for minutes three kinds situations data query that the embodiment of the present application is provided is carried out, the thinking based on same, the embodiment of the present application also provides a kind of device of data query, as shown in Figure 2.
The apparatus structure schematic diagram of the data query that Fig. 2 provides for the embodiment of the present application, specifically comprises:
Described determination module 201 specifically for, when between the condition portion of determining based on input and when ordering rule did not inquire about any data, by the described inquiry page number p of input with default every page in the product p * n of quantity n of the data that comprise, be defined as the quantity N of the data that will obtain storehouse from each minute;
Described provide module 203 specifically for, according to the quantity n of the data that comprise in described inquiry page number p and default every page, determine interval [(p-1) n+1 of sequence number that described inquiry page number p is corresponding, pn], and in the data after sequence, the data of sequence number in sequence number interval [(p-1) n+1, pn] corresponding to described inquiry page number p are provided.
Described device also comprises:
Described determination module 201 specifically for, when between the condition portion of determining based on input and when ordering rule inquired about the page number and is less than the data of the described inquiry page number, in each page number p-i inquiring about and be less than described inquiry page number p, determine maximum page number max (p-i), wherein, i is 0 to p-1 positive integer; Determine the described inquiry page number p of input and the difference p-max (p-i) of described maximum page number max (p-i), by the described difference p-max (p-i) determining with default every page in product (p-max (p-i)) * n of quantity n of the data that comprise, be defined as the quantity N of the data that will obtain storehouse from each minute;
Described acquisition module 202 specifically for, determine the condition sub-range corresponding to described maximum page number max (p-i) of recording based between described condition portion and during the data of the described ordering rule described maximum page number max of inquiry (p-i); According to the condition sub-range of described maximum page number max (p-i) correspondence, the interval starting point between the described condition portion of input is adjusted into the interval end point in the condition sub-range that described maximum page number max (p-i) is corresponding; Front N bar data after sorting according to described ordering rule in between the condition portion obtaining storehouse after adjustment for each minute;
Described provide module 203 specifically for, the quantity n of the data that comprise according to described inquiry page number p, described maximum page number max (p-i), in default every page, determine interval [(p-max (p-i)-1) n+1 of sequence number that described inquiry page number p is corresponding, (p-max (p-i)) n], and in the data after sequence, the data of sequence number in sequence number interval [(p-max (p-i)-1) n+1, (p-max (p-i)) n] corresponding to described inquiry page number p are provided.
Described determination module 201 specifically for, when between the condition portion of determining based on input and when ordering rule inquired about the page number and is greater than the data of the described inquiry page number, by the quantity n of the data that comprise in default every page, be defined as the quantity N of the data that will obtain storehouse from each minute;
Described acquisition module 202 specifically for, determine based between described condition portion and the condition sub-range corresponding to the described inquiry page number of recording when described ordering rule data that the page number is greater than to the described inquiry page number are inquired about; To between the described condition portion of input, be adjusted into the condition sub-range that the described inquiry page number is corresponding; Front N bar data after sorting according to described ordering rule in between the condition portion obtaining storehouse after adjustment for each minute;
Described provide module 203 specifically for, in the data after sequence, provide front n bar data.
The device of concrete above-mentioned data query can be arranged in client.
The embodiment of the present application provides a kind of method and device of data query, the method client is according to the quantity of the data that comprise in the inquiry page number of input and every page, determine the quantity N of the data that will obtain storehouse from each minute, again according to input condition portion between and ordering rule, front N bar data after sorting according to this ordering rule in obtaining between this condition portion storehouse from each minute, last according to this ordering rule to the data sorting getting, and provide corresponding data according to the inquiry page number.Pass through said method, when client is carried out paging query under minute scene of storehouse submeter, without all data obtained between condition portion storehouse from each minute in, and a part of data in only need obtaining storehouse from each minute between condition portion, thereby can reduce the network service producing when client is obtained data, effectively alleviate the pressure of network.
Those skilled in the art should understand, the application's embodiment can be provided as method, system or computer program.Therefore, the application can adopt complete hardware implementation example, implement software example or in conjunction with the form of the embodiment of software and hardware aspect completely.And the application can adopt the form that wherein includes the upper computer program of implementing of computer-usable storage medium (including but not limited to magnetic disk memory, CD-ROM, optical memory etc.) of computer usable program code one or more.
The application is with reference to describing according to process flow diagram and/or the block scheme of the method for the embodiment of the present application, equipment (system) and computer program.Should understand can be in computer program instructions realization flow figure and/or block scheme each flow process and/or the flow process in square frame and process flow diagram and/or block scheme and/or the combination of square frame.Can provide these computer program instructions to the processor of multi-purpose computer, special purpose computer, Embedded Processor or other programmable data processing device to produce a machine, the instruction of carrying out by the processor of computing machine or other programmable data processing device is produced for realizing the device in the function of flow process of process flow diagram or a plurality of flow process and/or square frame of block scheme or a plurality of square frame appointments.
These computer program instructions also can be stored in energy vectoring computer or the computer-readable memory of other programmable data processing device with ad hoc fashion work, the instruction that makes to be stored in this computer-readable memory produces the manufacture that comprises command device, and this command device is realized the function of appointment in flow process of process flow diagram or a plurality of flow process and/or square frame of block scheme or a plurality of square frame.
These computer program instructions also can be loaded in computing machine or other programmable data processing device, make to carry out sequence of operations step to produce computer implemented processing on computing machine or other programmable devices, thereby the instruction of carrying out is provided for realizing the step of the function of appointment in flow process of process flow diagram or a plurality of flow process and/or square frame of block scheme or a plurality of square frame on computing machine or other programmable devices.
Although described the application's preferred embodiment, once those skilled in the art obtain the basic creative concept of cicada, can make other change and modification to these embodiment.So claims are intended to all changes and the modification that are interpreted as comprising preferred embodiment and fall into the application's scope.
Obviously, those skilled in the art can carry out various changes and modification and the spirit and scope that do not depart from the application to the application.Like this, if within these of the application are revised and modification belongs to the scope of the application's claim and equivalent technologies thereof, the application is also intended to comprise these changes and modification interior.
Claims (10)
1. a method for data query, is characterized in that, comprising:
Client, according to the quantity of the data that comprise in the inquiry page number of input and default every page, is determined the quantity N of the data that will obtain storehouse from each minute; And
According between the condition portion of input and ordering rule, within each minute, obtaining between described condition portion storehouse according to the front N bar data after described ordering rule sequence; And
According to described ordering rule, the data that get are sorted, and provide corresponding data according to the described inquiry page number.
2. the method for claim 1, is characterized in that, client, according to the quantity of the data that comprise in the inquiry page number of input and default every page, is determined the quantity N of the data that will obtain storehouse from each minute, specifically comprises:
When between the condition portion of determining based on input and when ordering rule did not inquire about any data, by the described inquiry page number p of input with default every page in the product p * n of quantity n of the data that comprise, be defined as the quantity N of the data that will obtain storehouse from each minute;
According to the described inquiry page number, provide corresponding data, specifically comprise:
According to the quantity n of the data that comprise in described inquiry page number p and default every page, determine interval [(p-1) n+1 of sequence number that described inquiry page number p is corresponding, pn], and in the data after sequence, the data of sequence number in sequence number interval [(p-1) n+1, pn] corresponding to described inquiry page number p are provided.
3. method as claimed in claim 2, is characterized in that, described method also comprises:
For the page number p-i that is not more than described inquiry page number p, determine the sequence number interval [(p-i-1) n+1, (p-i) n] that page number p-i is corresponding, wherein, i is 0 to p-1 positive integer;
According to the data after sequence and sequence number interval [(p-i-1) n+1, (p-i) n] corresponding to page number p-i, adopt designation method to determine condition sub-range the record that page number p-i is corresponding;
Wherein, described designation method comprises: in the data after sequence, the condition of the data that are (p-i-1) n+1 by sequence number is defined as the interval starting point in the condition sub-range that page number p-i is corresponding, and the condition of the data that are (p-i) n by sequence number is defined as the interval end point in the condition sub-range that page number p-i is corresponding.
4. the method for claim 1, is characterized in that, client, according to the quantity of the data that comprise in the inquiry page number of input and default every page, is determined the quantity N of the data that will obtain storehouse from each minute, specifically comprises:
When between the condition portion of determining based on input and when ordering rule inquired about the page number and is less than the data of the described inquiry page number, in each page number p-i inquiring about and be less than described inquiry page number p, determine maximum page number max (p-i), wherein, i is 0 to p-1 positive integer;
Determine the described inquiry page number p of input and the difference p-max (p-i) of described maximum page number max (p-i), by the described difference p-max (p-i) determining with default every page in product (p-max (p-i)) * n of quantity n of the data that comprise, be defined as the quantity N of the data that will obtain storehouse from each minute;
According between the condition portion of input and ordering rule, within each minute, obtaining between described condition portion storehouse, according to the front N bar data after described ordering rule sequence, specifically comprise:
Determine the condition sub-range corresponding to described maximum page number max (p-i) of recording based between described condition portion and during the data of the described ordering rule described maximum page number max of inquiry (p-i);
According to the condition sub-range of described maximum page number max (p-i) correspondence, the interval starting point between the described condition portion of input is adjusted into the interval end point in the condition sub-range that described maximum page number max (p-i) is corresponding;
Front N bar data after sorting according to described ordering rule in between the condition portion obtaining storehouse after adjustment for each minute;
According to the described inquiry page number, provide corresponding data, specifically comprise:
The quantity n of the data that comprise according to described inquiry page number p, described maximum page number max (p-i), in default every page, determines that the sequence number that described inquiry page number p is corresponding is interval
And in the data after sequence, provide the data of sequence number in sequence number interval [(p-max (p-i)-1) n+1, (p-max (p-i)) n] corresponding to described inquiry page number p.
5. the method for claim 1, is characterized in that, client, according to the quantity of the data that comprise in the inquiry page number of input and default every page, is determined the quantity N of the data that will obtain storehouse from each minute, specifically comprises:
When between the condition portion of determining based on input and when ordering rule inquired about the page number and is greater than the data of the described inquiry page number, by the quantity n of the data that comprise in default every page, be defined as the quantity N of the data that will obtain storehouse from each minute;
According between the condition portion of input and ordering rule, within each minute, obtaining between described condition portion storehouse, according to the front N bar data after described ordering rule sequence, specifically comprise:
Determine based between described condition portion and the condition sub-range corresponding to the described inquiry page number of recording when described ordering rule data that the page number is greater than to the described inquiry page number are inquired about;
To between the described condition portion of input, be adjusted into the condition sub-range that the described inquiry page number is corresponding;
Front N bar data after sorting according to described ordering rule in between the condition portion obtaining storehouse after adjustment for each minute;
According to the described inquiry page number, provide corresponding data, specifically comprise:
In data after sequence, provide front n bar data.
6. a device for data query, is characterized in that, comprising:
Determination module, for according to the quantity of the inquiry page number of input and default every page of data that comprise, determines the quantity N of the data that will obtain storehouse from each minute;
Acquisition module, for according between the condition portion of input and ordering rule, within each minute, obtaining between described condition portion storehouse according to the front N bar data after described ordering rule sequence;
Module is provided, for according to described ordering rule, the data that get is sorted, and provide corresponding data according to the described inquiry page number.
7. device as claimed in claim 6, it is characterized in that, described determination module specifically for, when between the condition portion of determining based on input and when ordering rule did not inquire about any data, by the described inquiry page number p of input with default every page in the product p * n of quantity n of the data that comprise, be defined as the quantity N of the data that will obtain storehouse from each minute;
Described provide module specifically for, according to the quantity n of the data that comprise in described inquiry page number p and default every page, determine interval [(p-1) n+1 of sequence number that described inquiry page number p is corresponding, pn], and in the data after sequence, the data of sequence number in sequence number interval [(p-1) n+1, pn] corresponding to described inquiry page number p are provided.
8. device as claimed in claim 7, is characterized in that, described device also comprises:
Logging modle, for the page number p-i for being not more than described inquiry page number p, determines the sequence number interval [(p-i-1) n+1, (p-i) n] that page number p-i is corresponding, and wherein, i is 0 to p-1 positive integer; According to the data after sequence and sequence number interval [(p-i-1) n+1, (p-i) n] corresponding to page number p-i, adopt designation method to determine condition sub-range the record that page number p-i is corresponding; Wherein, described designation method comprises: in the data after sequence, the condition of the data that are (p-i-1) n+1 by sequence number is defined as the interval starting point in the condition sub-range that page number p-i is corresponding, and the condition of the data that are (p-i) n by sequence number is defined as the interval end point in the condition sub-range that page number p-i is corresponding.
9. device as claimed in claim 6, it is characterized in that, described determination module specifically for, when between the condition portion of determining based on input and when ordering rule inquired about the page number and is less than the data of the described inquiry page number, in each page number p-i inquiring about and be less than described inquiry page number p, determine maximum page number max (p-i), wherein, i is 0 to p-1 positive integer; Determine the described inquiry page number p of input and the difference p-max (p-i) of described maximum page number max (p-i), by the described difference p-max (p-i) determining with default every page in product (p-max (p-i)) * n of quantity n of the data that comprise, be defined as the quantity N of the data that will obtain storehouse from each minute;
Described acquisition module specifically for, determine the condition sub-range corresponding to described maximum page number max (p-i) of recording based between described condition portion and during the data of the described ordering rule described maximum page number max of inquiry (p-i); According to the condition sub-range of described maximum page number max (p-i) correspondence, the interval starting point between the described condition portion of input is adjusted into the interval end point in the condition sub-range that described maximum page number max (p-i) is corresponding; Front N bar data after sorting according to described ordering rule in between the condition portion obtaining storehouse after adjustment for each minute;
Described provide module specifically for, the quantity n of the data that comprise according to described inquiry page number p, described maximum page number max (p-i), in default every page, determine interval [(p-max (p-i)-1) n+1 of sequence number that described inquiry page number p is corresponding, (p-max (p-i)) n], and in the data after sequence, the data of sequence number in sequence number interval [(p-max (p-i)-1) n+1, (p-max (p-i)) n] corresponding to described inquiry page number p are provided.
10. device as claimed in claim 6, it is characterized in that, described determination module specifically for, when between the condition portion of determining based on input and when ordering rule inquired about the page number and is greater than the data of the described inquiry page number, by the quantity n of the data that comprise in default every page, be defined as the quantity N of the data that will obtain storehouse from each minute;
Described acquisition module specifically for, determine based between described condition portion and the condition sub-range corresponding to the described inquiry page number of recording when described ordering rule data that the page number is greater than to the described inquiry page number are inquired about; To between the described condition portion of input, be adjusted into the condition sub-range that the described inquiry page number is corresponding; Front N bar data after sorting according to described ordering rule in between the condition portion obtaining storehouse after adjustment for each minute;
Described provide module specifically for, in the data after sequence, provide front n bar data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210359116.5A CN103678408B (en) | 2012-09-21 | 2012-09-21 | A kind of method and device of inquiry data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210359116.5A CN103678408B (en) | 2012-09-21 | 2012-09-21 | A kind of method and device of inquiry data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103678408A true CN103678408A (en) | 2014-03-26 |
| CN103678408B CN103678408B (en) | 2017-03-01 |
Family
ID=50315989
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210359116.5A Active CN103678408B (en) | 2012-09-21 | 2012-09-21 | A kind of method and device of inquiry data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103678408B (en) |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103984549A (en) * | 2014-05-14 | 2014-08-13 | 上海上讯信息技术股份有限公司 | General paging query method and system based on SSH framework |
| CN104123340A (en) * | 2014-06-25 | 2014-10-29 | 世纪禾光科技发展（北京）有限公司 | Table-by-table and page-by-page query method and system for database |
| CN104657446A (en) * | 2015-02-04 | 2015-05-27 | 深圳市汇朗科技有限公司 | Combined statistical query method, combined statistical query device and combined statistical query system for secondary tables |
| CN104778258A (en) * | 2015-04-21 | 2015-07-15 | 华中科技大学 | Data extraction method oriented to protocol dataflow |
| CN104850627A (en) * | 2015-05-21 | 2015-08-19 | 北京京东尚科信息技术有限公司 | Method and apparatus for performing paging display |
| CN105138676A (en) * | 2015-09-08 | 2015-12-09 | 浙江维融电子科技股份有限公司 | Sub-library and sub-table merge query method based on high-level language concurrent aggregation calculation |
| CN105183764A (en) * | 2015-07-29 | 2015-12-23 | 广州神马移动信息科技有限公司 | Data paging method and apparatus |
| CN105468644A (en) * | 2014-09-10 | 2016-04-06 | 阿里巴巴集团控股有限公司 | Method and device for performing query in database |
| CN106021357A (en) * | 2016-05-09 | 2016-10-12 | 泰华智慧产业集团股份有限公司 | Distribution-based big data paging query method and system |
| WO2017097124A1 (en) * | 2015-12-07 | 2017-06-15 | 阿里巴巴集团控股有限公司 | Method, apparatus and system for transmitting tasks based on sub-libraries and sub-tables |
| CN107577701A (en) * | 2017-07-26 | 2018-01-12 | 努比亚技术有限公司 | A kind of data reordering method, sequence server and computer-readable recording medium |
| CN107977378A (en) * | 2016-10-25 | 2018-05-01 | 南京途牛科技有限公司 | A kind of distributed data polymerization and device |
| CN108073661A (en) * | 2016-11-18 | 2018-05-25 | 北京京东尚科信息技术有限公司 | Data retrieval method and device, report generating system and method |
| CN108647347A (en) * | 2018-05-14 | 2018-10-12 | 中国平安财产保险股份有限公司 | Pagination Display method, user equipment, storage medium and device |
| CN109460404A (en) * | 2018-09-03 | 2019-03-12 | 中新网络信息安全股份有限公司 | A kind of efficient Hbase paging query method based on redis |
| CN110555034A (en) * | 2018-03-28 | 2019-12-10 | 武汉斗鱼网络科技有限公司 | Data query paging method, device, server and medium |
| CN110928902A (en) * | 2019-11-27 | 2020-03-27 | 杭州安恒信息技术股份有限公司 | Query method and system for acquiring cloud platform terminal data aiming at paging |
| CN112445833A (en) * | 2019-08-30 | 2021-03-05 | 普天信息技术有限公司 | Data paging query method, device and system for distributed database |
| CN112527824A (en) * | 2019-09-17 | 2021-03-19 | 浙江宇视科技有限公司 | Paging query method, paging query device, electronic equipment and computer-readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060129540A1 (en) * | 2004-12-15 | 2006-06-15 | Hillis W D | Data store with lock-free stateless paging capability |
| CN1866251A (en) * | 2005-12-08 | 2006-11-22 | 华为技术有限公司 | Method and apparatus for reducing paging data retrieve time |
| US20100215279A1 (en) * | 2009-02-25 | 2010-08-26 | Yuli Gao | Automatic and scalable image selection |
| CN102289473A (en) * | 2011-07-27 | 2011-12-21 | 迈普通信技术股份有限公司 | Device and method for paging query of a plurality of servers |
-
2012
- 2012-09-21 CN CN201210359116.5A patent/CN103678408B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060129540A1 (en) * | 2004-12-15 | 2006-06-15 | Hillis W D | Data store with lock-free stateless paging capability |
| CN1866251A (en) * | 2005-12-08 | 2006-11-22 | 华为技术有限公司 | Method and apparatus for reducing paging data retrieve time |
| US20100215279A1 (en) * | 2009-02-25 | 2010-08-26 | Yuli Gao | Automatic and scalable image selection |
| CN102289473A (en) * | 2011-07-27 | 2011-12-21 | 迈普通信技术股份有限公司 | Device and method for paging query of a plurality of servers |
Non-Patent Citations (2)
| Title |
|---|
| WILLIAM001ZS: "关于数据库水平切分中分页查询问题的解决方案", 《DATABASE.51CTO.COM/ART/201108/282891.HTM》 * |
| 张素智等: "基于ASP.NET的Web数据分页实现与性能优化", 《郑州轻工业学院学报（自然科学版）》 * |
Cited By (30)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103984549A (en) * | 2014-05-14 | 2014-08-13 | 上海上讯信息技术股份有限公司 | General paging query method and system based on SSH framework |
| CN104123340A (en) * | 2014-06-25 | 2014-10-29 | 世纪禾光科技发展（北京）有限公司 | Table-by-table and page-by-page query method and system for database |
| CN104123340B (en) * | 2014-06-25 | 2018-04-20 | 世纪禾光科技发展（北京）有限公司 | A kind of database divides table paging query method and system |
| CN105468644A (en) * | 2014-09-10 | 2016-04-06 | 阿里巴巴集团控股有限公司 | Method and device for performing query in database |
| CN105468644B (en) * | 2014-09-10 | 2018-11-23 | 菜鸟智能物流控股有限公司 | Method and equipment for querying in database |
| CN104657446A (en) * | 2015-02-04 | 2015-05-27 | 深圳市汇朗科技有限公司 | Combined statistical query method, combined statistical query device and combined statistical query system for secondary tables |
| CN104657446B (en) * | 2015-02-04 | 2018-10-30 | 深圳市汇朗科技有限公司 | Divide table joint statistical query method, device and system |
| CN104778258B (en) * | 2015-04-21 | 2018-04-24 | 华中科技大学 | A kind of data pick-up method of Protocol-oriented data flow |
| CN104778258A (en) * | 2015-04-21 | 2015-07-15 | 华中科技大学 | Data extraction method oriented to protocol dataflow |
| CN104850627A (en) * | 2015-05-21 | 2015-08-19 | 北京京东尚科信息技术有限公司 | Method and apparatus for performing paging display |
| CN104850627B (en) * | 2015-05-21 | 2018-06-15 | 北京京东尚科信息技术有限公司 | Carry out the method and device of paging displaying |
| CN105183764A (en) * | 2015-07-29 | 2015-12-23 | 广州神马移动信息科技有限公司 | Data paging method and apparatus |
| CN105183764B (en) * | 2015-07-29 | 2017-03-15 | 广州神马移动信息科技有限公司 | A kind of data paging method and device |
| CN105138676B (en) * | 2015-09-08 | 2017-11-24 | 浙江维融电子科技股份有限公司 | Table merge querying methods are divided in point storehouse for concurrently polymerizeing calculating based on high-level language |
| CN105138676A (en) * | 2015-09-08 | 2015-12-09 | 浙江维融电子科技股份有限公司 | Sub-library and sub-table merge query method based on high-level language concurrent aggregation calculation |
| CN106844397B (en) * | 2015-12-07 | 2020-05-12 | 阿里巴巴集团控股有限公司 | Task transmission method, device and system based on sub-base and sub-table |
| WO2017097124A1 (en) * | 2015-12-07 | 2017-06-15 | 阿里巴巴集团控股有限公司 | Method, apparatus and system for transmitting tasks based on sub-libraries and sub-tables |
| CN106021357B (en) * | 2016-05-09 | 2019-05-03 | 泰华智慧产业集团股份有限公司 | Based on distributed big data paging query method and system |
| CN106021357A (en) * | 2016-05-09 | 2016-10-12 | 泰华智慧产业集团股份有限公司 | Distribution-based big data paging query method and system |
| CN107977378A (en) * | 2016-10-25 | 2018-05-01 | 南京途牛科技有限公司 | A kind of distributed data polymerization and device |
| CN108073661A (en) * | 2016-11-18 | 2018-05-25 | 北京京东尚科信息技术有限公司 | Data retrieval method and device, report generating system and method |
| CN107577701A (en) * | 2017-07-26 | 2018-01-12 | 努比亚技术有限公司 | A kind of data reordering method, sequence server and computer-readable recording medium |
| CN110555034A (en) * | 2018-03-28 | 2019-12-10 | 武汉斗鱼网络科技有限公司 | Data query paging method, device, server and medium |
| CN110555034B (en) * | 2018-03-28 | 2021-11-09 | 武汉斗鱼网络科技有限公司 | Data query paging method, device, server and medium |
| CN108647347A (en) * | 2018-05-14 | 2018-10-12 | 中国平安财产保险股份有限公司 | Pagination Display method, user equipment, storage medium and device |
| CN109460404A (en) * | 2018-09-03 | 2019-03-12 | 中新网络信息安全股份有限公司 | A kind of efficient Hbase paging query method based on redis |
| CN112445833A (en) * | 2019-08-30 | 2021-03-05 | 普天信息技术有限公司 | Data paging query method, device and system for distributed database |
| CN112527824A (en) * | 2019-09-17 | 2021-03-19 | 浙江宇视科技有限公司 | Paging query method, paging query device, electronic equipment and computer-readable storage medium |
| CN112527824B (en) * | 2019-09-17 | 2023-04-18 | 浙江宇视科技有限公司 | Paging query method, paging query device, electronic equipment and computer-readable storage medium |
| CN110928902A (en) * | 2019-11-27 | 2020-03-27 | 杭州安恒信息技术股份有限公司 | Query method and system for acquiring cloud platform terminal data aiming at paging |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103678408B (en) | 2017-03-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103678408A (en) | Method and device for inquiring data | |
| CN102129425B (en) | The access method of big object set table and device in data warehouse | |
| CN106528787B (en) | query method and device based on multidimensional analysis of mass data | |
| CN103970870A (en) | Database query method and server | |
| CN103577474B (en) | The update method and system of a kind of database | |
| CN102200972A (en) | Database maintenance method and database maintenance equipment | |
| CN107783980A (en) | Index data generates and data query method and device, storage and inquiry system | |
| CN102375827B (en) | Method for fast loading versioned electricity network model database | |
| CN102609421A (en) | Data query method and device | |
| CN110941602B (en) | Database configuration method and device, electronic equipment and storage medium | |
| CN106471501A (en) | The method of data query, the storage method data system of data object | |
| CN104346458A (en) | Data storage method and device | |
| CN109977135A (en) | A kind of data query method, apparatus and server | |
| CN106708822A (en) | File storage method and device | |
| CN110597292A (en) | Unmanned aerial vehicle cluster operation planning method and device | |
| CN106126731A (en) | A kind of method and device obtaining Elasticsearch paged data | |
| CN105653652A (en) | Data synchronization method and system | |
| CN102932416B (en) | A kind of intermediate data storage method of information flow task, processing method and device | |
| CN104182826A (en) | A method and an apparatus for processing allocation data | |
| CN108446814A (en) | With the tree searching method and device of sequential pipeline Job-Shop problem | |
| CN112035207A (en) | Page menu dynamic loading method and device based on database | |
| CN103049561B (en) | A kind of data compression method, storage engines and storage system | |
| CN104063374A (en) | Data deduplication method and equipment | |
| CN103002053B (en) | The profit maximization dispatching method of cloud computing and system | |
| CN104008116A (en) | File synchronization method and electronic device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1193484 Country of ref document: HK |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: GR Ref document number: 1193484 Country of ref document: HK |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20191209 Address after: P.O. Box 31119, grand exhibition hall, hibiscus street, 802 West Bay Road, Grand Cayman, Cayman Islands Patentee after: Innovative advanced technology Co., Ltd Address before: Cayman Islands Grand Cayman capital building, a four storey No. 847 mailbox Patentee before: Alibaba Group Holding Co., Ltd. |