CN106407244A - Multi-database-based data query method, system and apparatus - Google Patents
Multi-database-based data query method, system and apparatus Download PDFInfo
- Publication number
- CN106407244A CN106407244A CN201610452090.7A CN201610452090A CN106407244A CN 106407244 A CN106407244 A CN 106407244A CN 201610452090 A CN201610452090 A CN 201610452090A CN 106407244 A CN106407244 A CN 106407244A
- Authority
- CN
- China
- Prior art keywords
- branch
- query
- database
- task number
- central
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000001514 detection method Methods 0.000 description 6
- 235000013399 edible fruits Nutrition 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 230000004083 survival effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24537—Query rewriting; Transformation of operators
-
- 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/24534—Query rewriting; Transformation
- G06F16/2454—Optimisation of common expressions
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The invention relates to a multi-database-based data query method. The method is characterized by comprising the following steps of obtaining a database query request, and generating a query instruction according to the query request, wherein the query request carries query information; determining a central task number and a plurality of corresponding sub-task numbers according to query information; sending the sub-task numbers to corresponding sub-databases, thereby enabling the sub-databases to obtain the query instruction according to the sub-task numbers; and receiving and collecting query results fed back by the sub-databases. According to the method, related information in the sub-task numbers can be queried once without querying the sub-task numbers one by one, so that the query efficiency is improved. In addition, the invention provides a multi-database-based data query system and apparatus.
Description
Technical field
The present invention relates to technical field of information processing, more particularly to a kind of data query method based on multiple database,
System and device.
Background technology
Database is the system of one of computer application system concrete management data resource.Data has various ways,
As word, number, symbol, figure, image and sound etc..With the development of technology, generally all can store in a database
There is substantial amounts of data.
However, big for some business datum amounts, or the widely distributed company of business datum, generally for being easy to manage
Reason, and it is provided with multiple databases.In the case of above-mentioned, when needing to obtain the related data in the plurality of database, pass
The querying method of system typically requires to be inquired about one by one for each database, is then collected the data inquiring again,
Its search efficiency is not high.
Content of the invention
Based on this it is necessary to be directed to above-mentioned technical problem, provide a kind of can improve search efficiency based on multiple database
Data query mthods, systems and devices.
A kind of data query method based on multiple database, the method comprising the steps of：
Server obtains inquiry request, carries Query Information in described inquiry request, is generated according to described inquiry request and looks into
Ask instruction, described query statement is sent to central database；
Central database receive described query statement, according to described query statement generate corresponding with described query statement in
Heart task number and with described central task number associated plurality of branch task number, by described central task number and multiple points
Portion's task number sends to described server, and described branch task number is associated with corresponding multiple branches databases；
Described server receives described central task number and multiple branches task number, and described branch task number is sent to right
The multiple branches database answered, makes the plurality of branch database root obtain described inquiry according to the plurality of branch task number and refers to
Order；
Described server receives the Query Result of each branch's Database Feedback, collects looking into of each branch's Database Feedback
Ask result.
Wherein in an embodiment, described according to described query statement generate center corresponding with described query statement appoint
Business number and the step with described central task number associated plurality of branch task number, including：
The branch database related to described Query Information is determined according to described query statement；
Generate central task number and the branch database corresponding branch task number related to Query Information.
Wherein in an embodiment, receive the Query Result of each branch's Database Feedback in described server, collect
Before the step of the Query Result of each branch's Database Feedback, also include：
The plurality of branch database root obtains described query statement according to the plurality of branch task number, according to described inquiry
Instructions query generates Query Result, and described Query Result is sent to described server.
Wherein in an embodiment, the described step according to described query statement query generation Query Result, including：
Obtain the free value of branch's database according to predeterminated frequency, when described free value is more than predetermined threshold value, according to institute
State query statement query generation Query Result.
Wherein in an embodiment, the described step according to described query statement query generation Query Result, including：
Generate the inquiry subtask of respective amount according to classification number default in described branch database, according to described inquiry
Subtask carries out asynchronous query, generates Query Result.
A kind of data query method based on multiple database, methods described includes：
Obtain data base querying request, in described inquiry request, carry Query Information, generated according to described inquiry request and look into
Ask instruction；
Central task number and corresponding multiple branches task number are determined according to described Query Information；
The plurality of branch task number is sent to corresponding multiple branches database, makes the plurality of branch database root
Obtain described query statement according to the plurality of branch task number；
Receive the Query Result of the plurality of branch Database Feedback, collect the inquiry knot of each branch's Database Feedback
Really.
A kind of data query system based on multiple database, described system includes server and central database；
Described server is used for obtaining inquiry request, carries Query Information in described inquiry request, please according to described inquiry
Seek survival into query statement, described query statement is sent to central database；
Described central database is used for receiving described query statement, is generated and described query statement according to described query statement
Corresponding central task number and with described central task number associated plurality of branch task number, by described central task number with
And multiple branches task number sends to described server, described branch task number is associated with corresponding multiple branches databases；
Described server is additionally operable to receive described central task number and multiple branches task number, and described branch task number is sent out
Deliver to corresponding multiple branches database, so that the plurality of branch database root is looked into according to described in the task number acquisition of the plurality of branch
Ask instruction；Receive the Query Result of each branch's Database Feedback, collect the Query Result of each branch's Database Feedback.
Wherein in an embodiment, described system also includes multiple branches database；
Each described branch database is used for obtaining described query statement according to corresponding branch task number, is looked into according to described
Ask instructions query and generate Query Result, described Query Result is sent to described server.
Wherein in an embodiment, each described branch database is additionally operable to according to default in described branch database
Classification number generates the inquiry subtask of respective amount, carries out asynchronous query according to described inquiry subtask, generates Query Result.
A kind of data query arrangement based on multiple database, described device includes：
Inquiry request acquisition module, for obtaining data base querying request, carries Query Information, root in described inquiry request
Generate query statement according to described inquiry request；
Task number determining module, for determining central task number and corresponding multiple branches task according to described Query Information
Number；The plurality of branch task number is sent to corresponding multiple branches database, makes the plurality of branch database root according to institute
State multiple branches task number and obtain described query statement；
Query Result summarizing module, for receiving the Query Result of the plurality of branch Database Feedback, collects each point
The Query Result of portion's Database Feedback.
The above-mentioned data query mthods, systems and devices based on multiple database, when needs are looked in multiple branches database
When asking data, by central task number is generated with multiple branches task number so that can disposably inquire according to query statement
Relevant information in each branch's task number, and each branch's task number need not be inquired about one by one, improve search efficiency.
Brief description
Fig. 1 is the flow chart of the data query method in an embodiment based on multiple database；
Fig. 2 is the flow chart of the data query method in another embodiment based on multiple database；
Fig. 3 is the flow chart of the data query method in another embodiment based on multiple database；
Fig. 4 is the structural representation of the data query system in an embodiment based on multiple database；
Fig. 5 is the structural representation of the data query arrangement in an embodiment based on multiple database.
Specific embodiment
In order that the objects, technical solutions and advantages of the present invention become more apparent, below in conjunction with drawings and Examples, right
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only in order to explain the present invention, not
For limiting the present invention.
In one embodiment, as shown in Figure 1, there is provided a kind of data query method based on multiple database, the method
Comprise the steps 102～108.
Step 102, server obtains inquiry request, carries Query Information in inquiry request, is generated according to inquiry request and looks into
Ask instruction, query statement is sent to central database.
In the present embodiment, the inquiry request that inquiry request can send for user terminal, alternatively background system automatically initiates
Inquiry request, carry specific Query Information in inquiry request.Inquiry request may include but be not limited to insurance business correlation
The related inquiry request of the business such as inquiry request, bank or finance.Server, after getting inquiry request, parses this inquiry
Query Information in request, and corresponding query statement is generated according to the Query Information in this inquiry request, by this query statement
Send to central database.
Taking the inquiry request of insurance business class as a example, then its entrained Query Information includes the insurance kind of insurance kind to be checked
Mark.This inquiry request may include the inquiry request saving information change from damage, and corresponding Query Information includes inquiry in the first period
The related number of policy of interior occurred Insurance User information change.Inquiry request may also include life insurance dividend strategy inquiry request,
Corresponding Query Information includes inquiring about the Insurance User that should provide life insurance bonus in the second preset period of time to related insurance user
Number of policy, name and provide number etc..Wherein, the inquiry request saving information change from damage can be asked for the inquiry that user terminal sends
Ask, server can receive this inquiry request, obtain entrained corresponding Query Information in this inquiry request.Life insurance dividend strategy is looked into
Ask the inquiry request that can automatically initiate for background system of request, in background system, be predetermined this inquiry request, can reach pre-
If during trigger condition, automatically this inquiry request is sent to server.Such as, current time can be detected, if current time reaches
Preset Time, then automatically initiate this inquiry request.Further, life insurance dividend strategy inquiry request can be looking into of periodically initiating
Ask request, such as can initiate this inquiry request for daily in fixed time period, life insurance dividend strategy knot in the previous day for the inquiry
Fruit etc..
Step 104, central database receives query statement, generates center corresponding with query statement according to query statement and appoints
Business number and with central task number associated plurality of branch task number, central task number and multiple branches task numbers are sent
To server.
In the present embodiment, central database is for the inquiry of the inquiry request received by storage server and/or transmission
The record such as instruction.Specifically, the query statement that central database the reception server is sent, and obtain looking in this query statement
Inquiry information, generates corresponding central task number and multiple branches task number according to this Query Information.Wherein, central task number with every
Between individual branch task number, there is incidence relation, each branch's task number is corresponding with corresponding branch database.Branch's data
Storehouse can have multiple, the tables of data of the relevant user data that is stored with or business datum.Can be located at different between branch's database
Place, and not necessarily there is association.Such as, adaptation can be correspondingly arranged with region for reference feature according to the scope of business datum
The separate uncorrelated branch database of quantity, the region that in each branch's database, correspondence is stored with corresponding thereto
User data or business datum, in order to the storage and management of data.
Therefore, central database is appointed with multiple branches by the central task number generating associated according to this query statement
Business number, each branch's task number is corresponding with corresponding branch database, so that can be according to central task number and branch
Task number makes to set up incidence relation between each branch's database, jointly executes this query statement.
Step 106, server receives central task number and multiple branches task number, and branch's task number is sent to corresponding
Multiple branches database, makes multiple branches database root obtain query statement according to multiple branches task number.
Step 108, server receives the Query Result of each branch's Database Feedback, collects each branch's Database Feedback
Query Result.
Specifically, the Query Result of each Database Feedback can be aggregated in Query Result table for server, and this inquiry is tied
Be stored with fruit table the Query Result of each branch's Database Feedback.This Query Result table is sent to corresponding user terminal.
Further, the Query Result in this Query Result table is classified according to the data of corresponding branch database,
Such as can classification by geographical area or be sorted by time so that Query Result is more visual and understandable.
Further, server can detect whether collected Query Result can be stored in a Query Result table
In, if it is not, then the data volume automatically according to the memory capacity of this Query Result table and Query Result generates and corresponding multiple has
The Query Result table of association, to avoid data cannot show completely.
Such as, default Query Result tableau format is the form of excel 2003, its at most writable 65536 row, when
When Query Result exceedes this line number, then so that overage cannot be shown.
In the present embodiment, central database central task number and multiple branches task number are generated according to query statement so that
The relevant information in each branch's task number can disposably be inquired, and each branch's task number need not be looked into one by one
Ask, improve search efficiency.
In one embodiment, appoint according to query statement generation central task number corresponding with query statement and with center
The step of business number associated plurality of branch task number, including：The branch number related to Query Information is determined according to query statement
According to storehouse；Generate central task number and the branch database corresponding branch task number related to Query Information.
In the present embodiment, central database, after receiving query statement, parses to this query statement, obtains its institute
The Query Information carrying, determines associated branch's database according to this Query Information, and generates related with Query Information
Branch's database corresponding branch task number, for the branch database unrelated with Query Information, then need not generate corresponding point
Portion's task number, thus also can reduce the occupancy to query resource.
In one embodiment, centre data place generate central task number and multiple branches task number in can carry appoint
Business priority.This task priority can be by determining according to query statement so that branch's database receives in presence multiple waits to hold
During the task number of row, pending task number execution order can be determined according to the task priority of each task number.
In one embodiment, as shown in Figure 2, there is provided another kind of data query method based on multiple database, the party
Method also includes：
Step 107, multiple branches database root obtains query statement according to multiple branches task number, is inquired about according to query statement
Generate Query Result, Query Result is sent to server.
With the quantity of the plurality of branch database, as N, (i.e. the 1st branch's database, the 2nd branch's database are to N branch number
According to storehouse) exemplarily illustrated, then alternatively N number of (i.e. the 1st branch's task number, the 2nd branch's task of corresponding branch task number
Number to N branch task number), i-th branch's task number is corresponding with i-th branch's database.Server is appointed receiving the i-th branch
It may be determined that its corresponding i-th branch's database after business number, and send it to i-th branch's database.
I-th branch's database, when receiving this i-th branch task number, can obtain this according to this i-th branch task number and look into
Ask instruction, and inquired about in i-th branch's database, generate Query Result, Query Result is sent to server.
In one embodiment, the step according to query statement query generation Query Result, including：Obtained according to predeterminated frequency
Take the free value of branch's database, when free value is more than predetermined threshold value, according to query statement query generation Query Result.
In the present embodiment, free value is used for characterizing the situation of the Current resource occupancy of reflection corresponding branch database, empty
Not busy value is bigger, then illustrate that the resources occupation rate of this branch's database is less, and it is then faster to the execution speed of instruction or task；Empty
Not busy value is less, then illustrate that the resources occupation rate of this branch's database is bigger, and it is then slower to the execution speed of instruction or task, very
Extremely system crash can be caused so that instruction or tasks carrying fail.I-th predeterminated frequency of i-th branch's database can be any frequency
Rate, such as can be for detecting once per hour；I-th predetermined threshold value can be user-defined any number, alternatively system setting
Default number.I-th free value is used for characterizing the situation of the resources occupation rate of i-th branch's database, when the i-th free value is bigger,
Then illustrate that i-th branch's database is more idle.When judging that the i-th free value under current time is not more than predetermined threshold value, can basis
This i-th predeterminated frequency and current time determining detection time next time, when making current time reach detection next time
Between when, then detect whether the free value of operating system under this detection time is more than predetermined threshold value again, if so, then according to looking into
Ask instructions query generate Query Result, otherwise, can again according to i-th predeterminated frequency continue determine next time be used for judge whether
The detection time of execution backup.
Further, detection number of times or execution time also can be set and judge whether the i-th free value is pre- more than i-th so that working as
If after the number of times of the judgement that the judged result of threshold value is no reaches this detection number of times, directly execute this query statement, or working as
After the front time reaches execution time, also directly execute this query statement, to avoid being less than when i-th branch's database is constantly in
It is impossible to complete the situation of the execution to query statement under i-th predetermined threshold value.
Due to being likely present other processes needing execution in i-th branch's database, when numerous in i-th branch's database
Carry out under busy so that search efficiency is declined, and affect the execution efficiency of the process that other is carrying out, this reality
Apply to pass through in example to be more than under predetermined threshold value in the free value of branch's database and carry out to data query, can further improve data and look into
The execution efficiency ask.
In one embodiment, the step according to query statement query generation Query Result, including：According to branch's database
In default classification number generate the inquiry subtask of respective amount, asynchronous query is carried out according to inquiry subtask, generates inquiry knot
Really.
In the present embodiment, the data in branch's database can be classified to the data type being stored, and arranges multiple
Grade, each grade is by can be by sub- grade more than lower point.For example, can be carried out point according to the ownership region of the data of storage
Class, such as, the Insurance User data in one or more provinces in the whole nation that is stored with each branch's database, can be by Insurance User
Data is divided into secondary data and three DBMSs according to the correspondence such as the province being belonged to and cities and counties, can comprise under each secondary data
Multiple three DBMSs.
Branch's database can according to corresponding to it default multiple secondary structures or three layers of constitutions, generate with this secondary structure
Or the inquiry subtask of three layers of constitutions' respective amount, and this inquiry subtask of asynchronous execution, collect each inquiry subtask and given birth to
The Query Result becoming, the Query Result after collecting is sent to server.
In the present embodiment, carry out asynchronous query by query statement correspondence is split into multiple queries subtask, one can be entered
Step improves search efficiency.
In one embodiment, as shown in Figure 3, there is provided a kind of data query method based on multiple database, its feature
It is, the method includes：
Step 302, obtains data base querying request, carries Query Information in inquiry request, is generated according to inquiry request and looks into
Ask instruction.
Step 304, determines central task number and corresponding multiple branches task number according to Query Information.
In the present embodiment, this query statement can be sent to central database, make central database generate corresponding center
Task number and corresponding multiple branches task number, and obtain this central task number and multiple branches task number.
Step 306, multiple branches task number is sent to corresponding multiple branches database, makes multiple branches database root
Obtain query statement according to multiple branches task number.
Step 308, receives the Query Result of multiple branches Database Feedback, collects the inquiry of each branch's Database Feedback
Result.
Specifically, the Query Result of each Database Feedback can be aggregated in Query Result table, in this Query Result table
Be stored with the Query Result of each branch's Database Feedback.This Query Result table is sent to corresponding user terminal.
In the present embodiment, when needing to be inquired about in multiple branches database, can be by being generated according to query statement
Central task number with multiple branches task number so that the relevant information in each branch's task number can disposably be inquired, and
Each branch's task number need not be inquired about one by one, be improve search efficiency.
In one embodiment, as shown in Figure 4, there is provided a kind of data query system based on multiple database.Referring to
Fig. 4, server 402 can pass through network with central database 404 and other multiple branches database 406 (as the 1st branch's number
According to storehouse, the 2nd branch's database to N branch database) it is connected.Server 402 can receive user terminal send inquiry request,
Or receive the inquiry request that background system automatically initiates, generate query statement, and query statement is sent to central database
404.The assignment instructions that central database 404 is sent for storage server 402, and generate central task for this query statement
Number and associated branch's task number, send it to server 402, this branch task number is sent by server 402 again
To corresponding branch database 406 so as to carry out relevant inquiring.It is stored with branch's database 404 related to Query Information
Data, Query Result can be sent to server 402 by branch's database 404, and server receives and collects corresponding multiple branch
The Query Result information that data place sends.
In one embodiment, server 402 and central database are included based on the data query system of multiple database
404, wherein,
Server 402 is used for obtaining inquiry request, carries Query Information in inquiry request, generates inquiry according to inquiry request
Instruction, query statement is sent to central database；
Central database 404 is used for receiving query statement, generates center corresponding with query statement according to query statement and appoints
Business number and with central task number associated plurality of branch task number, central task number and multiple branches task numbers are sent
To server, branch's task number is associated with corresponding multiple branches databases；
Server 402 is additionally operable to receive central task number and multiple branches task number, and branch's task number is sent to correspondence
Multiple branches database, make multiple branches database root obtain query statement according to multiple branches task numbers；Receive each branch
The Query Result of Database Feedback, collects the Query Result of each branch's Database Feedback.
In one embodiment, central database 404 is additionally operable to determine divide related to Query Information according to query statement
Portion's database；Generate central task number and the branch database corresponding branch task number related to Query Information.
In one embodiment, the data query system based on multiple database also includes multiple branches database 406；
Each branch's database 406 is used for obtaining query statement according to corresponding branch task number, is looked into according to query statement
Ask and generate Query Result, Query Result is sent to server.
In one embodiment, each branch's database 406 is used for obtaining the free time of branch's database according to predeterminated frequency
Value, when free value is more than predetermined threshold value, according to query statement query generation Query Result.
In one embodiment, each branch's database 406 is additionally operable to according to classification number life default in branch's database
Become the inquiry subtask of respective amount, asynchronous query is carried out according to inquiry subtask, generates Query Result.
In one embodiment, as shown in figure 5, a kind of data query arrangement based on multiple database is it is characterised in that be somebody's turn to do
Device includes：
Inquiry request acquisition module 502, for obtaining data base querying request, carries Query Information, root in inquiry request
Generate query statement according to inquiry request；
Task number determining module 504, for determining central task number and corresponding multiple branches task according to Query Information
Number；Multiple branches task number is sent to corresponding multiple branches database, so that multiple branches database root is appointed according to multiple branches
Business number obtains query statement；
Query Result summarizing module 506, for receiving the Query Result of multiple branches Database Feedback, collects each branch
The Query Result of Database Feedback.
Each technical characteristic of embodiment described above can arbitrarily be combined, for making description succinct, not to above-mentioned reality
The all possible combination of each technical characteristic applied in example is all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, all it is considered to be the scope of this specification record.
Embodiment described above only have expressed the several embodiments of the present invention, and its description is more concrete and detailed, but simultaneously
Can not therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
Say, without departing from the inventive concept of the premise, some deformation can also be made and improve, these broadly fall into the protection of the present invention
Scope.Therefore, the protection domain of patent of the present invention should be defined by claims.
Claims (10)
1. a kind of data query method based on multiple database is it is characterised in that the method comprising the steps of：
Server obtains inquiry request, carries Query Information in described inquiry request, generates inquiry according to described inquiry request and refers to
Order, described query statement is sent to central database；
Central database receives described query statement, generates center corresponding with described query statement according to described query statement and appoints
Business number and with described central task number associated plurality of branch task number, described central task number and multiple branch are appointed
Business number sends to described server, and described branch task number is associated with corresponding multiple branches databases；
Described server receives described central task number and multiple branches task number, and described branch task number is sent to corresponding
Multiple branches database, makes the plurality of branch database root obtain described query statement according to the plurality of branch task number；
Described server receives the Query Result of each branch's Database Feedback, collects the inquiry knot of each branch's Database Feedback
Really.
2. method according to claim 1 is it is characterised in that described generation according to described query statement is referred to described inquiry
Make corresponding central task number and the step with described central task number associated plurality of branch task number, including：
The branch database related to described Query Information is determined according to described query statement；
Generate central task number and the branch database corresponding branch task number related to Query Information.
3. method according to claim 1 is it is characterised in that receive each branch's Database Feedback in described server
Query Result, before the step of the Query Result collecting each branch's Database Feedback, also includes：
The plurality of branch database root obtains described query statement according to the plurality of branch task number, according to described query statement
Query generation Query Result, described Query Result is sent to described server.
4. method according to claim 3 it is characterised in that described according to described query statement query generation Query Result
Step, including：
Obtain the free value of branch's database according to predeterminated frequency, when described free value is more than predetermined threshold value, looked into according to described
Ask instructions query and generate Query Result.
5. method according to claim 3 it is characterised in that described according to described query statement query generation Query Result
Step, including：
Generate the inquiry subtask of respective amount according to classification number default in described branch database, appointed according to described inquiry
Business carries out asynchronous query, generates Query Result.
6. a kind of data query method based on multiple database is it is characterised in that the method comprising the steps of：
Obtain data base querying request, in described inquiry request, carry Query Information, inquiry is generated according to described inquiry request and refers to
Order；
Central task number and corresponding multiple branches task number are determined according to described Query Information；
The plurality of branch task number is sent to corresponding multiple branches database, makes the plurality of branch database root according to institute
State multiple branches task number and obtain described query statement；
Receive the Query Result of the plurality of branch Database Feedback, collect the Query Result of each branch's Database Feedback.
7. a kind of data query system based on multiple database is it is characterised in that described system includes server and centre data
Storehouse；
Described server is used for obtaining inquiry request, carries Query Information in described inquiry request, is given birth to according to described inquiry request
Become query statement, described query statement is sent to central database；
Described central database is used for receiving described query statement, is generated corresponding with described query statement according to described query statement
Central task number and with described central task number associated plurality of branch task number, by described central task number and many
Individual branch task number sends to described server, and described branch task number is associated with corresponding multiple branches databases；
Described server is additionally operable to receive described central task number and multiple branches task number, by described branch task number send to
Corresponding multiple branches database, makes the plurality of branch database root obtain described inquiry according to the plurality of branch task number and refers to
Order；Receive the Query Result of each branch's Database Feedback, collect the Query Result of each branch's Database Feedback.
8. system according to claim 7 is it is characterised in that described system also includes multiple branches database；
Each described branch database is used for obtaining described query statement according to corresponding branch task number, is referred to according to described inquiry
Make query generation Query Result, described Query Result is sent to described server.
9. system according to claim 8 is it is characterised in that each described branch database is additionally operable to according to described branch
In database, default classification number generates the inquiry subtask of respective amount, carries out asynchronous query according to described inquiry subtask,
Generate Query Result.
10. a kind of data query arrangement based on multiple database is it is characterised in that described device includes：
Inquiry request acquisition module, for obtaining data base querying request, carries Query Information in described inquiry request, according to institute
State inquiry request and generate query statement；
Task number determining module, for determining central task number and corresponding multiple branches task number according to described Query Information；
The plurality of branch task number is sent to corresponding multiple branches database, makes the plurality of branch database root according to described many
Individual branch task number obtains described query statement；
Query Result summarizing module, for receiving the Query Result of the plurality of branch Database Feedback, collects each branch's number
Query Result according to storehouse feedback.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610452090.7A CN106407244A (en) | 2016-06-21 | 2016-06-21 | Multi-database-based data query method, system and apparatus |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610452090.7A CN106407244A (en) | 2016-06-21 | 2016-06-21 | Multi-database-based data query method, system and apparatus |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106407244A true CN106407244A (en) | 2017-02-15 |
Family
ID=58005812
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610452090.7A Pending CN106407244A (en) | 2016-06-21 | 2016-06-21 | Multi-database-based data query method, system and apparatus |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106407244A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107346329A (en) * | 2017-06-19 | 2017-11-14 | 上海德启信息科技有限公司 | A kind of data processing method and device |
| CN107622096A (en) * | 2017-08-31 | 2018-01-23 | 上海保险交易所股份有限公司 | Asynchronous multiparty data exchange method and storage medium based on block catenary system |
| CN107657042A (en) * | 2017-09-30 | 2018-02-02 | 上海数据交易中心有限公司 | Data query method and device, storage medium, the terminal of multi-data source |
| CN109241195A (en) * | 2017-07-03 | 2019-01-18 | 北京国双科技有限公司 | The calculation method and device of ranking |
| CN109508344A (en) * | 2018-09-29 | 2019-03-22 | 中国平安人寿保险股份有限公司 | Business datum querying method, device, electronic equipment and storage medium |
| CN109543076A (en) * | 2018-10-12 | 2019-03-29 | 中国平安人寿保险股份有限公司 | User's managing detailed catalogue generation method and device, electronic equipment, storage medium |
| CN110019544A (en) * | 2017-09-30 | 2019-07-16 | 北京国双科技有限公司 | Data query method and system |
| CN110297955A (en) * | 2019-06-20 | 2019-10-01 | 阿里巴巴集团控股有限公司 | A kind of information query method, device, equipment and medium |
| CN110718216A (en) * | 2019-03-25 | 2020-01-21 | 广东省信息安全测评中心 | Network intelligent scheduling system and method |
| CN110837515A (en) * | 2019-11-06 | 2020-02-25 | 北京天融信网络安全技术有限公司 | Database-based data processing method and electronic equipment |
| CN110874370A (en) * | 2018-08-10 | 2020-03-10 | 广州弘度信息科技有限公司 | Data query method and device, computer equipment and readable storage medium |
| CN111343237A (en) * | 2020-02-07 | 2020-06-26 | 广州亚美信息科技有限公司 | Server cluster communication method, communication device and computer storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6389426B1 (en) * | 1999-02-09 | 2002-05-14 | Worldcom, Inc. | Central trouble ticket database and system and method for managing same to facilitate ticketing, trending, and tracking processes |
| CN101668046A (en) * | 2009-10-13 | 2010-03-10 | 成都市华为赛门铁克科技有限公司 | Resource caching method, resource obtaining method, device and system thereof |
| CN102075358A (en) * | 2010-12-31 | 2011-05-25 | 网宿科技股份有限公司 | System and method for distributing and deploying content of large-scale server cluster |
| CN105045877A (en) * | 2015-07-20 | 2015-11-11 | 深圳市深信服电子科技有限公司 | Database data fragmentation storage method and apparatus and data query method and apparatus |
| CN105631028A (en) * | 2015-12-30 | 2016-06-01 | 中国农业银行股份有限公司 | Method and system for implementing database clustering function |
-
2016
- 2016-06-21 CN CN201610452090.7A patent/CN106407244A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6389426B1 (en) * | 1999-02-09 | 2002-05-14 | Worldcom, Inc. | Central trouble ticket database and system and method for managing same to facilitate ticketing, trending, and tracking processes |
| CN101668046A (en) * | 2009-10-13 | 2010-03-10 | 成都市华为赛门铁克科技有限公司 | Resource caching method, resource obtaining method, device and system thereof |
| CN102075358A (en) * | 2010-12-31 | 2011-05-25 | 网宿科技股份有限公司 | System and method for distributing and deploying content of large-scale server cluster |
| CN105045877A (en) * | 2015-07-20 | 2015-11-11 | 深圳市深信服电子科技有限公司 | Database data fragmentation storage method and apparatus and data query method and apparatus |
| CN105631028A (en) * | 2015-12-30 | 2016-06-01 | 中国农业银行股份有限公司 | Method and system for implementing database clustering function |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107346329B (en) * | 2017-06-19 | 2021-01-29 | 上海德启信息科技有限公司 | Data processing method and device |
| CN107346329A (en) * | 2017-06-19 | 2017-11-14 | 上海德启信息科技有限公司 | A kind of data processing method and device |
| CN109241195A (en) * | 2017-07-03 | 2019-01-18 | 北京国双科技有限公司 | The calculation method and device of ranking |
| CN109241195B (en) * | 2017-07-03 | 2022-03-18 | 北京国双科技有限公司 | Ranking calculation method and device |
| CN107622096A (en) * | 2017-08-31 | 2018-01-23 | 上海保险交易所股份有限公司 | Asynchronous multiparty data exchange method and storage medium based on block catenary system |
| CN107622096B (en) * | 2017-08-31 | 2020-06-05 | 上海保险交易所股份有限公司 | Asynchronous multi-party data interaction method based on block chain system and storage medium |
| CN107657042A (en) * | 2017-09-30 | 2018-02-02 | 上海数据交易中心有限公司 | Data query method and device, storage medium, the terminal of multi-data source |
| CN110019544A (en) * | 2017-09-30 | 2019-07-16 | 北京国双科技有限公司 | Data query method and system |
| CN110874370A (en) * | 2018-08-10 | 2020-03-10 | 广州弘度信息科技有限公司 | Data query method and device, computer equipment and readable storage medium |
| CN109508344A (en) * | 2018-09-29 | 2019-03-22 | 中国平安人寿保险股份有限公司 | Business datum querying method, device, electronic equipment and storage medium |
| CN109508344B (en) * | 2018-09-29 | 2024-03-12 | 中国平安人寿保险股份有限公司 | Service data query method and device, electronic equipment and storage medium |
| CN109543076A (en) * | 2018-10-12 | 2019-03-29 | 中国平安人寿保险股份有限公司 | User's managing detailed catalogue generation method and device, electronic equipment, storage medium |
| CN110718216A (en) * | 2019-03-25 | 2020-01-21 | 广东省信息安全测评中心 | Network intelligent scheduling system and method |
| CN110297955B (en) * | 2019-06-20 | 2023-03-24 | 创新先进技术有限公司 | Information query method, device, equipment and medium |
| CN110297955A (en) * | 2019-06-20 | 2019-10-01 | 阿里巴巴集团控股有限公司 | A kind of information query method, device, equipment and medium |
| CN110837515A (en) * | 2019-11-06 | 2020-02-25 | 北京天融信网络安全技术有限公司 | Database-based data processing method and electronic equipment |
| CN111343237A (en) * | 2020-02-07 | 2020-06-26 | 广州亚美信息科技有限公司 | Server cluster communication method, communication device and computer storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106407244A (en) | Multi-database-based data query method, system and apparatus | |
| CN103902646B (en) | Distributed task managing system and method | |
| CN107515784B (en) | Method and equipment for calculating resources in distributed system | |
| CN109783512A (en) | Data processing method, device, computer equipment and storage medium | |
| CN103067297B (en) | A kind of dynamic load balancing method based on resource consumption prediction and device | |
| US11275667B2 (en) | Handling of workload surges in a software application | |
| CN105096174A (en) | Transaction matching method and transaction matching system | |
| CN104679884B (en) | Data analysing method, device and the system of database | |
| CN114791846B (en) | Method for realizing observability aiming at cloud-originated chaos engineering experiment | |
| CN108900626A (en) | Date storage method, apparatus and system under a kind of cloud environment | |
| CN112737800A (en) | Service node fault positioning method, call chain generation method and server | |
| CN107819825A (en) | A kind of service scheduling method, device and electronic equipment | |
| WO2017118318A1 (en) | Data storage and service processing method and device | |
| CN111338888B (en) | Data statistics method and device, electronic equipment and storage medium | |
| CN111666344A (en) | Heterogeneous data synchronization method and device | |
| CN105893156B (en) | Store the request processing method and storage computing system in computing system | |
| CN106446289A (en) | Information inquiry method and device based on Pinpoint | |
| CN106815318B (en) | Clustering method and system for time sequence database | |
| US7406461B1 (en) | System and method for processing a request to perform an activity associated with a precompiled query | |
| CN110909072B (en) | Data table establishment method, device and equipment | |
| CN107203554A (en) | A kind of distributed search method and device | |
| CN106940715B (en) | A kind of method and apparatus of the inquiry based on concordance list | |
| CN115237960A (en) | Information pushing method and device, storage medium and electronic equipment | |
| CN112667392B (en) | Cloud computing resource allocation method and device, computer equipment and storage medium | |
| CN109101595A (en) | A kind of information query method, device, equipment and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170215 |