CN102081626A - Data inquiring method and data inquiring server - Google Patents

Data inquiring method and data inquiring server Download PDF

Info

Publication number
CN102081626A
CN102081626A CN 200910238666 CN200910238666A CN102081626A CN 102081626 A CN102081626 A CN 102081626A CN 200910238666 CN200910238666 CN 200910238666 CN 200910238666 A CN200910238666 A CN 200910238666A CN 102081626 A CN102081626 A CN 102081626A
Authority
CN
China
Prior art keywords
querying condition
data query
search request
offline search
cluster field
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
Application number
CN 200910238666
Other languages
Chinese (zh)
Other versions
CN102081626B (en
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.)
China Mobile Communications Group Co Ltd
China Mobile Group Beijing Co Ltd
Original Assignee
China Mobile Communications Group Co Ltd
China Mobile Group Beijing 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 China Mobile Communications Group Co Ltd, China Mobile Group Beijing Co Ltd filed Critical China Mobile Communications Group Co Ltd
Priority to CN 200910238666 priority Critical patent/CN102081626B/en
Publication of CN102081626A publication Critical patent/CN102081626A/en
Application granted granted Critical
Publication of CN102081626B publication Critical patent/CN102081626B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

The invention discloses a data inquiring method and a data inquiring server. The data inquiring method comprises the following main step of: when receiving an offline inquiring request which has lower timeliness requirement and is transmitted by a client end, not immediately carrying out data inquiring for the client end but responding to the offline inquiring request after a data inquiring system is in an idle state. Accordingly, the client ends which are simultaneously responded by the data inquiring system are fewer, and the client end with high timeliness requirement can obtain rapid response and the treatment of the data inquiring request of the client end with lower timeliness requirement can not be affected.

Description

A kind of method of data query and querying server
Technical field
The present invention relates to the communications field, relate in particular to a kind of method and querying server of data query.
Background technology
Enterprise tends to produce mass data in the production and operation process, these mass datas are stored in the database after handling through processing, for enterprises personnel or other related personnel inquiry.With the Virtual network operator is example, the client of Virtual network operator can produce mass data in a plurality of operation flows such as charging, business, account and customer service, these data are through conversion, cleaning, loading and the aggregation process of enterprise-level data warehouse, finally form the comprehensive unified portrayal of client of operator, managerial personnel can carry out analysis and consult to the data after handling.The method that mass data is inquired about is as follows:
At first, client is provided with querying condition by the group polling option that webpage presets, and by query requests the querying condition that is provided with is submitted to querying server.
Then, querying server generates corresponding SQL signaling and submits to database server according to the querying condition that is provided with in the query requests that receives.
Then, database server is resolved the SQL signaling, and related, search the corresponding database table.
At last, database server sends to client with association, lookup result by Web server.
But because client's quantity very many (millions in full) of Virtual network operator, each client's feature field also may very many (feature field reaches hundreds of items even more).If carry out the real-time inquiry of multi-user concurrent according to above-mentioned querying method at mass data, reached under the situation of optimizing the limit at the hardware environment of querying server and database, inquiring user is difficult to obtain response speed faster.
Summary of the invention
The embodiment of the invention provides a kind of method and querying server of data query, when not influencing the data query processing of request of the lower client of ageing requirement, improves the data query speed of ageing client of having relatively high expectations.
A kind of method of data query, described method comprises:
After the offline search request that receives the client transmission, whether the resources occupation rate of judgment data inquiry system is less than setting value;
If then carry out data query according to the querying condition that carries in the described offline search request;
Otherwise the resources occupation rate that is deferred to described data query system is carried out data query according to the querying condition that carries in the described offline search request during less than setting value again.
A kind of querying server, described querying server comprises:
Receiver module is used to receive offline search request and the result that client sends and checks request;
Judge module, whether the resources occupation rate that is used for the judgment data inquiry system is less than setting value;
Enquiry module, when being used for resources occupation rate at described data query system less than setting value, carry out data query according to the querying condition that carries in the described offline search request, and, when the resources occupation rate of described data query system is not less than setting value, the resources occupation rate that is deferred to described data query system is carried out data query according to the querying condition that carries in the described offline search request during less than setting value again.
Because in the scheme of the embodiment of the invention, when receiving the offline search request of the lower client transmission of ageing requirement, do not carry out data query for this client immediately, but after being in idle condition, data query system responds the offline search request again, therefore, the client terminal quantity that data query system is responded simultaneously is less, guarantee to access quick response, and do not influence the data query processing of request of the lower client of ageing requirement ageing demanding client.
Description of drawings
Fig. 1 is a data query system synoptic diagram in the embodiment of the invention
Fig. 2 is for carrying out the method synoptic diagram of data query in the embodiment of the invention one;
Fig. 3 is for carrying out the method synoptic diagram of data query in the embodiment of the invention two;
Fig. 4 is for carrying out the method synoptic diagram of data query in the embodiment of the invention three;
Fig. 5 is the structural representation of querying server in the embodiment of the invention four.
Embodiment
In order to realize the object of the invention, it is also different to the ageing requirement of data query that the embodiment of the invention fully takes into account different clients, therefore, adopt the processing mode of offline search for the offline search request of the ageing lower client of data query, the offline search request is real-time response not, but when data query system is idle again to the data query request response of ageing lower client, can respond fast the data query request of ageing client of having relatively high expectations guaranteeing, and not influence the data query request of the lower client of ageing requirement.
Below in conjunction with Figure of description the embodiment of the invention is elaborated.
As shown in Figure 1, be the data query system synoptic diagram of the embodiment of the invention, relate generally to client, querying server (Application Server) and database server (Database).Querying server is to have the network element that in the embodiment of the invention request of client is carried out judgment processing, can be the network element that makes up in the existing network, also can be the logical block of network element in the existing network.Querying server and database server can integrate, and also can be provided with respectively, and hypothesis querying server and database server are independent network element in subsequent embodiment.
Embodiment one:
As shown in Figure 2, for carrying out the method synoptic diagram of data query in the embodiment of the invention one, said method comprising the steps of:
Step 101: querying server receives the offline search request that client sends.
In the present embodiment, client can send different query requests to querying server according to the requirement difference ageing to data query.If client is had relatively high expectations to the ageing of data query, then can send the data query request to querying server, expression need be carried out real-time data query, and returns Query Result; If client is lower to the ageing requirement of data query, then can send the offline search request as querying server, expression does not need to carry out real-time data query, returns Query Result after can waiting for a period of time.
Step 102: querying server detects the resources occupation rate of data query system, if the resources occupation rate of data query system is not less than setting value, then execution in step 103; Otherwise, execution in step 104.
In this step, the resources occupation rate of data query system can be regarded as the resources occupation rate of database server, querying server uses independent background thread, periodically whether the resources occupation rate of scan-data inquiry system is idle, and promptly whether the resources occupation rate of data query system is less than setting value.The resource here can be the memory source of database server or cpu resource etc., and resources occupation rate is not less than setting value and exists resources occupation rate to be not less than 50% in can being, or the occupancy of CPU is not less than 50%.
Step 103: querying server postpones to carry out follow-up data query process, and jumps to step 102 after postponing to set duration.
Step 104: querying server carries out data query according to the querying condition that carries in the described offline search request.
In this step, if querying server and database server integrate, then querying server directly carries out data query according to querying condition, and the generated query result; If querying server and database server set up separately, then querying server is according to the querying condition in the offline search request, generate corresponding SQL signaling and submit to database server, resolve the laggard line data inquiry of SQL signaling by database server, and the generated query result.
Step 105: querying server is after the result who receives described client transmission checks request, and the Query Result that will carry out obtaining behind the data query is exported to described client.
The Query Result that generates in step 104 is not necessarily exported to client immediately, can be buffered in the specific region, after the result who receives the client transmission checks request, check the client identification in the request, the sign of offline search request and the information such as transmitting time of offline search request according to the result, determine the Query Result that need return to client, and this Query Result is exported to client.
In the present embodiment, client sends the offline search request to querying server after can logining querying server, and releases querying server before receiving the Query Result that returns.When client need be checked Query Result, can land querying server again, send the result to querying server and check request, to obtain Query Result.If when client was checked request to querying server transmission result, querying server did not also carry out data query, the incident of then notifying client not carry out data query requires the client awaits Query Result.
Method by the embodiment of the invention one, at the offline search request of not being badly in need of, adopt the asynchronous process mode, when being in idle condition, data query system carries out data query for the offline search request, make data query system to distribute more resource for ageing client of having relatively high expectations, under the situation of the data query request that does not influence the lower client of ageing requirement, guarantee that the request of ageing client of having relatively high expectations can respond fast.
Embodiment two:
Initiate the offline search request as a plurality of clients, or same client is when repeatedly initiating the offline search request, querying server need carry out task scheduling to a plurality of offline search requests that receive, the embodiment of the invention two increases the task scheduling process on the basis of embodiment one, propose a kind of more excellent data query scheme.
As shown in Figure 3, for carrying out the method synoptic diagram of data query in the embodiment of the invention two, mainly may further comprise the steps:
Step 201: querying server receives the offline search request that client sends.
Step 202: querying server carries out the ordering first time according to the sequencing that receives the offline search request with the offline search request that receives.
Step 203: the offline search request after will sorting is divided into a plurality of request groups.
Wherein, the time of reception of any two offline search requests differs to be no more than and sets the duration application time of the offline search request in the same request group (be within the specific limits) in each request group, and an offline search request belongs to a request group.
10 the offline search requests of having supposed the querying server buffer memory according to the sequencing ordering that receives are: offline search request 1, the request 9 of offline search request 2...... offline search and offline search request 10.These 10 offline search requests are divided into the request group is: request 1 of request group 1={ offline search and offline search request 2}, request group 2={ offline search request 3~offline search request 8}, request 9 of request group 3={ offline search and offline search request 10}.
Step 204:, the ordering second time is carried out in the offline search request in each request group according to taking the ascending order of stock number.
At each request group, the resource that at first definite querying condition that each offline search request in this request group is carried need take when carrying out data query according to taking the ascending order of stock number, sorts the offline search request in this request group.
The resource that need take when in this step, carrying out data query includes but not limited to two aspect contents: the space size that duration that need take when the querying condition that the offline search request is carried carries out data query and Query Result are shared.
If the resource that need take when carrying out data query is the duration that need take when carrying out data query, the duration that then takies is short more, and the stock number that the request of expression offline search takies is more little; If the resource that need take when the carrying out data query shared space size that is Query Result, then Query Result takes up room more for a short time, and the stock number that the request of expression offline search takies is more little; If the resource that need take when carrying out data query is the duration and the shared space size of Query Result that need take when carrying out data query, then the weighted value of duration that needs are taken and occupation space size is more little, and the stock number that the request of expression offline search takies is more little.
Querying server can reach the operation of execution in step 203 and step 204 when setting quantity in the quantity of the untreated offline search request that receives, also can be periodically to the untreated offline search request execution in step 203 that receives and the operation of step 204.
Step 205: the resources occupation rate of querying server specified data inquiry system according to putting in order of offline search request, is carried out data query to the querying condition that carries in each offline search request respectively during less than setting value.
After sorting according to step 203 and step 204 pair offline search request, when data query system is idle, can handle each offline search request successively according to the sequencing of arranging.
In the scheme of present embodiment two, step 204 can be a preferred steps, data query system can be handled earlier take the less offline search request of resource, guaranteeing to take the less offline search request of resource can respond fast, farthest saves the response time.
Embodiment three:
In order to improve response speed further, the embodiment of the invention three also proposes to carry out personalized clustering processing on the basis of embodiment one and embodiment two, set up the corresponding relation of the Query Result (being the cluster field) that obtains after querying condition and this querying condition are inquired about, when data query system is idle, can be according to the described corresponding relation of setting up, find out the cluster field of the querying condition correspondence in the offline search request fast, obtain Query Result.Owing to do not need the full table of database server is detected, can improve offline search request responding speed, shorten query time.
As shown in Figure 4, the method synoptic diagram for the embodiment of the invention four may further comprise the steps:
Step 301: the cluster field that obtains after inquiring about according to the offline search request that receives in advance with to the querying condition in this offline search request, set up the corresponding relation of querying condition and cluster field.
This step is that data are carried out pre-service, specifically comprises:
At first, split offline search request and Query Result, metadata such as database table that obtain querying condition, uses when specifically inquiring about and cluster field.
Then, according to splitting the metadata that obtains, set up multi-level corresponding relation, promptly first level is a database table, for example: mtl_user_a; Second level is the one-level cluster field of first querying condition correspondence, for example: user_id=' admin '; Tri-layer is the secondary cluster field of second querying condition correspondence, for example: user_name=' abc '; Wherein, secondary cluster field belongs to one-level cluster field, by that analogy.
Step 101~step 103 of step 302~step 304 and embodiment one.
Step 302 in the present embodiment~step 304 also can be identical with the step 201~step 204 among the embodiment two.
Step 305: querying server determines to work as the sequencing of the querying condition that carries in the offline search request of pre-treatment.
Step 306: querying server judges whether to exist the cluster field of each querying condition correspondence successively according to the sequencing of querying condition, and obtains corresponding Query Result according to the querying condition of storage in advance and the corresponding relation of cluster field.
There are following three kinds of situations in this step:
First kind of situation: there is corresponding cluster field in each querying condition, then with the same section of the cluster field of each querying condition correspondence as the Query Result that carries out data query.
For example, the querying condition that carries in the offline search request of pre-treatment is user_id and user_name owing in step 301, there has been the corresponding relation of this querying condition and cluster field, therefore, directly with ' abc ' as Query Result.
Second kind of situation: there is corresponding cluster field in the partial query condition, then according to the sequencing of querying condition, determine the cluster field of the querying condition correspondence of the last position of first querying condition that does not have corresponding cluster field and this querying condition, and, in the cluster field of determining, carry out data query according to other querying conditions after the querying condition of determining and this querying condition.
For example, the querying condition that carries in the offline search request of pre-treatment is user_id and user_location, owing in step 301, only preserved the cluster field of user_id correspondence, then from the one-level cluster field of user_id correspondence, user_location is inquired about as querying condition, obtain final query result, the cluster field of supposing the user_location correspondence is user_location=' beijing '.
The third situation: all there is not corresponding cluster field in querying condition, then carries out data query from database table.
For example, the querying condition that carries in the offline search request of pre-treatment is user_time, owing to do not preserve the cluster field of user_time correspondence in step 301, then carries out data query from database table, obtains user_time=' 2009.01.01 '.
Step 307: querying server is receiving after the result checks request, to client output Query Result.
Step 308: querying server upgrades described corresponding relation according to the Query Result of step 306.
In this step, the different situations of carrying out according to step 306 have different corresponding relation update methods.
If what occur in the step 306 is first kind of situation, the querying condition that expression is carried in the offline search request of pre-treatment is identical with the querying condition of an offline search request that receives in advance, at this moment, do not need to upgrade the corresponding relation of querying condition and cluster field.
If what occur in the step 306 is second kind of situation, the querying condition that expression is carried in the offline search request of pre-treatment is identical with the querying condition part of an offline search request that receives in advance, then determine to carry out not have the querying condition of corresponding cluster field before the data query and in the cluster field of determining, carry out the corresponding relation of the cluster field that data query obtains, and utilize the corresponding relation of determining to upgrade the corresponding relation of described querying condition and cluster field.
For example, under the one-level cluster field of user_id correspondence, further set up the secondary cluster field of second querying condition correspondence, i.e. user_location=' beijing '.
If what occur in the step 306 is the third situation, the querying condition that expression is carried in the offline search request of pre-treatment is inequality fully with the querying condition of the offline search request that receives in advance, then determine there is not the querying condition of corresponding cluster field and from database table, carry out the corresponding relation of the cluster field that data query obtains, and utilize the corresponding relation of determining to upgrade the corresponding relation of described querying condition and cluster field.
For example, set up the one-level cluster field of first querying condition correspondence, i.e. user_time=' 2009.01.01 '.
The corresponding relation of querying condition in the present embodiment and cluster field can be kept in the querying server, also can be kept in the database server, can also be kept in the independent memory device that is provided with, though but preserve described corresponding relation in which way, querying server can carry out read-write operation to described corresponding relation.
Follow-up when continuing to receive the offline search request of client transmission, can utilize the corresponding relation after the renewal to carry out data query, all in database table from database server inquire about when avoiding carrying out data query at every turn, simplify query manipulation, improve inquiry velocity.
Embodiment four:
The embodiment of the invention four provides a kind of querying server that is applied to data query system, as shown in Figure 5, described querying server comprises receiver module 11, judge module 12 and enquiry module 13, and wherein: receiver module 11 is used to receive offline search request and the result that client sends and checks request; Whether judge module 12 is used for the resources occupation rate of judgment data inquiry system less than setting value; When enquiry module 13 is used for resources occupation rate at described data query system less than setting value, carry out data query according to the querying condition that carries in the described offline search request, and, when the resources occupation rate of described data query system is not less than setting value, the resources occupation rate that is deferred to described data query system is carried out data query according to the querying condition that carries in the described offline search request during less than setting value again.
Described querying server also comprises order module 14, is used for according to the sequencing that receives the offline search request offline search request that receives being sorted; Described enquiry module 13 also is used for respectively the querying condition that carries in each offline search request being carried out data query according to the putting in order of offline search request.
Described order module 14 also is used for the offline search request after the ordering is divided into a plurality of request groups, and the ascending order of stock number that need take when carrying out data query according to the querying condition that the offline search request is carried, respectively the offline search request in each request group is sorted, wherein, the time of reception of any two offline search requests differs and is no more than the setting duration in each request group, and an offline search request belongs to a request group.
Described enquiry module 13 comprises that also order determines submodule 21 and implementation sub-module 22, and wherein: order is determined the sequencing of the querying condition that submodule 21 is used for determining that described offline search request is carried; Implementation sub-module 22 is used for according to the querying condition of storage in advance and the corresponding relation of cluster field, judge whether to exist the cluster field of each querying condition correspondence successively according to the sequencing of querying condition, if there is corresponding cluster field in each querying condition, then with the same section of the cluster field of each querying condition correspondence as the Query Result that carries out data query; If there is corresponding cluster field in the partial query condition, then according to the sequencing of querying condition, determine the cluster field of the querying condition correspondence of the last position of first querying condition that does not have corresponding cluster field and this querying condition, and according to other querying conditions after the querying condition of determining and this querying condition, in the cluster field of determining, carry out data query, and with the cluster field of the querying condition correspondence of carrying in the described offline search request as the Query Result that carries out data query; If all there is not corresponding cluster field in querying condition, then from database table, carry out data query.
Described querying server also comprises update module 15, be used for when there is corresponding cluster field in the partial query condition, determine to carry out not have the querying condition of corresponding cluster field before the data query and in the cluster field of determining, carry out the corresponding relation of the cluster field that data query obtains, and utilize the corresponding relation of determining to upgrade the corresponding relation of described querying condition and cluster field, when all there is not corresponding cluster field in querying condition, determine there is not the querying condition of corresponding cluster field and from database table, carry out the corresponding relation of the cluster field that data query obtains, and utilize the corresponding relation of determining to upgrade the corresponding relation of described querying condition and cluster field.
In addition, the querying server in the present embodiment can also comprise output module 16, is used for the Query Result that carries out obtaining behind the data query is exported to described client.
The method and the server that provide by the embodiment of the invention, at the offline search request of not being badly in need of, adopt the asynchronous process mode, when being in idle condition, data query system carries out data query for the offline search request, make data query system to distribute more resource for ageing client of having relatively high expectations, under the situation of the data query request that does not influence the lower client of ageing requirement, guarantee that the request of ageing client of having relatively high expectations can respond fast; And the embodiment of the invention judges that to the stock number of carrying out the offline search request and taking priority processing takies the few offline search request of stock number, makes to take the less offline search request of resource and can respond fast, farthest saves the response time; By the personalized clustering processing of the embodiment of the invention, according to the corresponding relation of querying condition of having set up and cluster field, can find out the cluster field of the querying condition correspondence in the offline search request fast, obtain Query Result, shortened query time.
Obviously, those skilled in the art can carry out various changes and modification to the present invention and not break away from the spirit and scope of the present invention.Like this, if of the present invention these are revised and modification belongs within the scope of claim of the present invention and equivalent technologies thereof, then the present invention also is intended to comprise these changes and modification interior.

Claims (11)

1. the method for a data query is characterized in that, described method comprises:
After the offline search request that receives the client transmission, whether the resources occupation rate of judgment data inquiry system is less than setting value;
If then carry out data query according to the querying condition that carries in the described offline search request;
Otherwise the resources occupation rate that is deferred to described data query system is carried out data query according to the querying condition that carries in the described offline search request during less than setting value again.
2. the method for claim 1 is characterized in that, after receiving the offline search request that client sends, and whether the resources occupation rate of judgment data inquiry system less than before the setting value, and described method also comprises:
Sequencing according to receiving the offline search request sorts the offline search request that receives;
Carry out data query according to the querying condition that carries in the described offline search request, comprising:
According to putting in order of offline search request, respectively the querying condition that carries in each offline search request is carried out data query.
3. method as claimed in claim 2 is characterized in that, after the offline search request that receives is sorted, and whether the resources occupation rate of judgment data inquiry system less than before the setting value, and described method also comprises:
Offline search request after the ordering is divided into a plurality of request groups, and wherein, the time of reception of any two offline search requests differs and is no more than the setting duration in each request group, and an offline search request belongs to a request group;
The ascending order of stock number that the querying condition that carries according to the offline search request need take when carrying out data query sorts the offline search request in each request group respectively.
4. the method for claim 1 is characterized in that, carries out data query according to the querying condition that carries in the described offline search request, comprising:
Determine the sequencing of the querying condition that carries in the described offline search request;
According to the querying condition of storage in advance and the corresponding relation of cluster field, judge whether to exist the cluster field of each querying condition correspondence successively according to the sequencing of querying condition;
If there is corresponding cluster field in each querying condition, then with the same section of the cluster field of each querying condition correspondence as the Query Result that carries out data query;
If there is corresponding cluster field in the partial query condition, then according to the sequencing of querying condition, determine the cluster field of the querying condition correspondence of the last position of first querying condition that does not have corresponding cluster field and this querying condition, and according to other querying conditions after the querying condition of determining and this querying condition, in the cluster field of determining, carry out data query, and with the cluster field of the querying condition correspondence of carrying in the described offline search request as the Query Result that carries out data query;
If all there is not corresponding cluster field in querying condition, then from database table, carry out data query.
5. method as claimed in claim 4 is characterized in that, carries out after the data query according to the querying condition that carries in the described offline search request, and described method also comprises:
When there is corresponding cluster field in the partial query condition, determine to carry out not have the querying condition of corresponding cluster field before the data query and in the cluster field of determining, carry out the corresponding relation of the cluster field that data query obtains, and utilize the corresponding relation of determining to upgrade the corresponding relation of described querying condition and cluster field;
When all there is not corresponding cluster field in querying condition, determine there is not the querying condition of corresponding cluster field and from database table, carry out the corresponding relation of the cluster field that data query obtains, and utilize the corresponding relation of determining to upgrade the corresponding relation of described querying condition and cluster field.
6. as the arbitrary described method of claim 1~5, it is characterized in that,
Described offline search request receives when client is landed data query system;
Carry out after the data query according to the querying condition that carries in the described offline search request, described method also comprises:
After the result that the reception client sends when landing data query system again checked request, the Query Result that will carry out obtaining behind the data query was exported to described client.
7. a querying server is characterized in that, described querying server comprises:
Receiver module is used to receive offline search request and the result that client sends and checks request;
Judge module, whether the resources occupation rate that is used for the judgment data inquiry system is less than setting value;
Enquiry module, when being used for resources occupation rate at described data query system less than setting value, carry out data query according to the querying condition that carries in the described offline search request, and, when the resources occupation rate of described data query system is not less than setting value, the resources occupation rate that is deferred to described data query system is carried out data query according to the querying condition that carries in the described offline search request during less than setting value again.
8. querying server as claimed in claim 7 is characterized in that, described querying server also comprises:
Order module is used for according to the sequencing that receives the offline search request offline search request that receives being sorted;
Described enquiry module also is used for respectively the querying condition that carries in each offline search request being carried out data query according to the putting in order of offline search request.
9. querying server as claimed in claim 8 is characterized in that,
Described order module, also be used for the offline search request after the ordering is divided into a plurality of request groups, and the ascending order of stock number that need take when carrying out data query according to the querying condition that the offline search request is carried, respectively the offline search request in each request group is sorted, wherein, the time of reception of any two offline search requests differs and is no more than the setting duration in each request group, and an offline search request belongs to a request group.
10. querying server as claimed in claim 7 is characterized in that, described enquiry module also comprises:
Order is determined submodule, the sequencing of the querying condition that is used for determining that described offline search request is carried;
Implementation sub-module is used for judging whether to exist the cluster field of each querying condition correspondence according to the querying condition of storage in advance and the corresponding relation of cluster field successively according to the sequencing of querying condition,
If there is corresponding cluster field in each querying condition, then with the same section of the cluster field of each querying condition correspondence as the Query Result that carries out data query;
If there is corresponding cluster field in the partial query condition, then according to the sequencing of querying condition, determine the cluster field of the querying condition correspondence of the last position of first querying condition that does not have corresponding cluster field and this querying condition, and according to other querying conditions after the querying condition of determining and this querying condition, in the cluster field of determining, carry out data query, and with the cluster field of the querying condition correspondence of carrying in the described offline search request as the Query Result that carries out data query;
If all there is not corresponding cluster field in querying condition, then from database table, carry out data query.
11. querying server as claimed in claim 10 is characterized in that, described querying server also comprises:
Update module, be used for when there is corresponding cluster field in the partial query condition, determine to carry out not have the querying condition of corresponding cluster field before the data query and in the cluster field of determining, carry out the corresponding relation of the cluster field that data query obtains, and utilize the corresponding relation of determining to upgrade the corresponding relation of described querying condition and cluster field, when all there is not corresponding cluster field in querying condition, determine there is not the querying condition of corresponding cluster field and from database table, carry out the corresponding relation of the cluster field that data query obtains, and utilize the corresponding relation of determining to upgrade the corresponding relation of described querying condition and cluster field.
CN 200910238666 2009-11-30 2009-11-30 Data inquiring method and data inquiring server Active CN102081626B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 200910238666 CN102081626B (en) 2009-11-30 2009-11-30 Data inquiring method and data inquiring server

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 200910238666 CN102081626B (en) 2009-11-30 2009-11-30 Data inquiring method and data inquiring server

Publications (2)

Publication Number Publication Date
CN102081626A true CN102081626A (en) 2011-06-01
CN102081626B CN102081626B (en) 2012-12-26

Family

ID=44087593

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 200910238666 Active CN102081626B (en) 2009-11-30 2009-11-30 Data inquiring method and data inquiring server

Country Status (1)

Country Link
CN (1) CN102081626B (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103559307A (en) * 2013-11-18 2014-02-05 中国农业银行股份有限公司 Caching method and device for query
CN107169085A (en) * 2017-05-12 2017-09-15 上海新储集成电路有限公司 A kind of data search system
CN108241698A (en) * 2016-12-27 2018-07-03 天津商安科技有限公司 A kind of customer data query system
CN108984763A (en) * 2018-07-20 2018-12-11 许志才 Querying method, client, server and computer-readable medium
CN109492138A (en) * 2018-10-22 2019-03-19 中国银行股份有限公司 A kind of data query processing method and system
CN109828984A (en) * 2019-01-11 2019-05-31 北京明略软件系统有限公司 A kind of method, apparatus, computer storage medium and the terminal of analysis processing
CN110334118A (en) * 2019-05-31 2019-10-15 口碑(上海)信息技术有限公司 Data query method and device
CN111782409A (en) * 2020-08-17 2020-10-16 支付宝(杭州)信息技术有限公司 Task processing method, risk identification task processing device and electronic equipment

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
DE602004030162D1 (en) * 2004-02-27 2010-12-30 Teamon Systems Inc COMMUNICATION SYSTEM AND METHOD FOR ACCESSING A SERVER AND PREVENTING ACCESS BLOCKING AND MINIMIZING NETWORK TRAFFIC
CN101242637A (en) * 2007-02-05 2008-08-13 华为技术有限公司 Relay device, wireless communication network access method and wireless communication system
CN101448270B (en) * 2008-12-23 2011-03-16 中兴通讯股份有限公司 Method and system for realizing dynamic flow control by network element signaling tracking

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103559307A (en) * 2013-11-18 2014-02-05 中国农业银行股份有限公司 Caching method and device for query
CN108241698A (en) * 2016-12-27 2018-07-03 天津商安科技有限公司 A kind of customer data query system
CN107169085A (en) * 2017-05-12 2017-09-15 上海新储集成电路有限公司 A kind of data search system
CN108984763A (en) * 2018-07-20 2018-12-11 许志才 Querying method, client, server and computer-readable medium
CN108984763B (en) * 2018-07-20 2021-10-01 深圳脉企大数据科技有限公司 Query method, client, server and computer readable medium
CN109492138A (en) * 2018-10-22 2019-03-19 中国银行股份有限公司 A kind of data query processing method and system
CN109828984A (en) * 2019-01-11 2019-05-31 北京明略软件系统有限公司 A kind of method, apparatus, computer storage medium and the terminal of analysis processing
CN110334118A (en) * 2019-05-31 2019-10-15 口碑(上海)信息技术有限公司 Data query method and device
CN110334118B (en) * 2019-05-31 2021-08-03 口碑(上海)信息技术有限公司 Data query method and device
CN111782409A (en) * 2020-08-17 2020-10-16 支付宝(杭州)信息技术有限公司 Task processing method, risk identification task processing device and electronic equipment
CN111782409B (en) * 2020-08-17 2023-12-19 支付宝(杭州)信息技术有限公司 Task processing method, device and electronic equipment, and risk identification task processing method and device

Also Published As

Publication number Publication date
CN102081626B (en) 2012-12-26

Similar Documents

Publication Publication Date Title
CN102081626B (en) Data inquiring method and data inquiring server
CN108632374B (en) Software gray level release method and device
CN110086636B (en) Message distribution method based on mqtt, server and storage medium
CN110716796B (en) Intelligent task scheduling method and device, storage medium and electronic equipment
CN110740217A (en) multi-channel data integration interaction method, device, equipment and storage medium
CN101951411A (en) Cloud scheduling system and method and multistage cloud scheduling system
CN110708256A (en) CDN scheduling method, device, network equipment and storage medium
CN109274730A (en) The optimization method and device that Internet of things system, MQTT message are transmitted
US10719555B2 (en) System and method in a database system for sharing a data item with an entity in another tenant domain
CN113296874B (en) Task scheduling method, computing device and storage medium
US20190138958A1 (en) Category identifier prediction
CN103428260A (en) System and method for allocating server to terminal and efficiently delivering messages to the terminal
CN102891851A (en) Access control method, equipment and system of virtual desktop
US10025859B2 (en) Method and system for second-degree friend query
CN109145092B (en) Database updating and intelligent question and answer management method, device and equipment
CN107147651B (en) Gray level publishing system and publishing method thereof
CN104469028B (en) A kind of service providing method, conversation server and customer service system
CN110798495A (en) Method and server for end-to-end message push in cluster architecture mode
CN115277707B (en) Service processing method, device, electronic equipment and storage medium
CN104243483A (en) Message processing method and message processing equipment
US20170139808A1 (en) Method and dispatcher node for server processing management
CN107948226A (en) A kind of license management method and system
CN102685227A (en) Message scheduling method and message scheduling system for cloud conference
KR20170072282A (en) Service data processing method, device and system
CN113177694B (en) Client allocation method, device, storage medium and computer equipment

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant