CN106156174A - The system and method that a kind of db transaction processes - Google Patents
The system and method that a kind of db transaction processes Download PDFInfo
- Publication number
- CN106156174A CN106156174A CN201510182387.1A CN201510182387A CN106156174A CN 106156174 A CN106156174 A CN 106156174A CN 201510182387 A CN201510182387 A CN 201510182387A CN 106156174 A CN106156174 A CN 106156174A
- Authority
- CN
- China
- Prior art keywords
- subtransaction
- coordinator
- affairs
- transaction
- processing results
- 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
Abstract
The embodiment of the invention discloses the system and method that a kind of db transaction processes, this system may include that master transaction processor, the first subtransaction coordinator and the second subtransaction coordinator, call two kinds of subtransaction coordinators corresponding to type of database respectively by master transaction processor and carry out data manipulation, it is thus possible to process for the affairs during database combination of various database types, improve the integrity of issued transaction in the case of multiple types of data storehouse is mixed, it is ensured that the concordance of data.
Description
Technical field
The present invention relates to database field, particularly relate to the system and method that a kind of db transaction processes.
Background technology
Along with the progressively development of cloud computing technology, distributed data base is as a technology in cloud computing technology
Branch, is the most progressively used in enterprises.Distributed data base technique application in enterprise is to deposit
Storage inside data of enterprise coherence request is relatively low, structural data that data volume is bigger, but actual a lot
In the case of, need the business datum simultaneously processed i.e. to have the data meeting distributed data base technique feature, also
There are the data meeting RDBMS feature, need both to be processed, at this simultaneously
During reason, a kind of mechanism is needed to ensure the concordance of data manipulation.
In existing solution, the data manipulation concordance of relevant database is generally used relationship type
Db transaction ensures, is carried out the data manipulation concordance of distributed data base by distributed transaction
Ensure, and in the existing data meeting distributed data base technique feature of business datum processed, have again and meet
During the data of RDBMS feature, it is impossible to ensure simultaneously and meet the mixing storage of multiple types of data storehouse
The operational consistency of business datum, accordingly, it is desirable to provide a kind of processing method can meet multitype database
The operational consistency of business datum during the database combination of type.
Summary of the invention
For solving above-mentioned technical problem, embodiment of the present invention expectation provides the system that a kind of db transaction processes
And method, it is possible to process for the affairs during database combination of various database types, improve
The integrity of issued transaction in the case of multiple types of data storehouse is mixed, it is ensured that the concordance of data.
The technical scheme is that and be achieved in that:
First aspect, embodiments provides the system that a kind of db transaction processes, described system bag
Include: master transaction processor, the first subtransaction coordinator and the second subtransaction coordinator, wherein,
Described master transaction processor, is used for receiving data processing request;And,
Determine that described first subtransaction coordinator is coordinated with described second subtransaction according to described data processing request
The affairs that device is the most corresponding;Wherein, described first subtransaction coordinator and described second subtransaction coordinator institute
Corresponding affairs process corresponding to different types of database data;And,
Trigger described first subtransaction coordinator, and indicate thing corresponding to described first subtransaction mediators handle
Business;And,
Trigger described second subtransaction coordinator, and indicate thing corresponding to described second subtransaction mediators handle
Business;And,
The first corresponding thing is received with described second subtransaction coordinator respectively from described first subtransaction coordinator
Business result and the second transaction processing results;And by described first transaction processing results and described second affairs
Result carries out returning response;
Described first subtransaction coordinator, for being committed to relevant database by the affairs of self correspondence;
And, receive described relevant database after completing the affairs that described first subtransaction coordinator is corresponding
The first transaction processing results returned;
And, described first transaction processing results is back to described master transaction processor;
Described second subtransaction coordinator, for being committed to non-relational database by the affairs of self correspondence;
And, receive described non-relational database and complete the affairs that described second subtransaction coordinator is corresponding
Second transaction processing results of rear return;
And, described second transaction processing results is back to described master transaction processor.
Further, described data processing request includes pending data content and processes operation affairs;Phase
Ying Di, described master transaction processor, specifically for:
In determining, according to described pending data content, the first data that described first subtransaction coordinator is corresponding
Hold second data content corresponding with described second subtransaction coordinator;And,
By described process operation affairs divide into respectively with described relevant database and described non-relational data
The first specific operation affairs that storehouse is corresponding and the second specific operation affairs, wherein, described first specific operation thing
Business is for being committed to described relevant database in described first data by described first subtransaction coordinator
Holding and operate, described second specific operation affairs are for being committed to institute by described second subtransaction coordinator
State non-relational database described second data content is operated.
Further, described non-relational database is distributed data base, correspondingly, and described second sub-thing
Business coordinator, for being committed to each distributed data base by the affairs of self correspondence;And,
Receive each distributed data base described to divide after completing the affairs that described second subtransaction coordinator is corresponding
The second transaction processing results not returned;And,
The second transaction processing results each distributed data base returned returns to described master transaction processor.
Further, described master transaction processor, it is additionally operable to:
According to described first transaction processing results and described second transaction processing results and default decision plan
Determine whether to carry out transaction rollback;
When determine carry out transaction rollback time, indicate described first subtransaction coordinator by described relevant database
Recovering state to the state completed before the affairs that described first subtransaction coordinator is corresponding, and, instruction
Described second subtransaction coordinator by the recovering state of described non-relational database to completing described second sub-thing
State before the affairs that business coordinator is corresponding;And,
When described first subtransaction coordinator and described second subtransaction coordinator complete described relationship type respectively
After the recovering state of data base and the recovering state of described non-relational database, determine that transaction rollback completes.
Second aspect, embodiments provides a kind of method that db transaction processes, and described method should
The system processed for a db transaction, described system includes: master transaction processor, the first subtransaction association
Adjusting device and the second subtransaction coordinator, described method includes:
Described master transaction processor receives data processing request;And determine described according to described data processing request
The affairs that first subtransaction coordinator is the most corresponding with described second subtransaction coordinator;
Described master transaction processor triggers described first subtransaction coordinator, and indicates described first subtransaction association
Device is adjusted to process corresponding affairs;
The affairs of self correspondence are committed to relevant database by described first subtransaction coordinator;
Described first subtransaction coordinator receives described relevant database and completes described first subtransaction coordination
The first transaction processing results returned after the affairs that device is corresponding;
Described first transaction processing results is back to described master transaction and processes by described first subtransaction coordinator
Device;
Described master transaction processor triggers described second subtransaction coordinator, and indicates described second subtransaction association
Device is adjusted to process corresponding affairs;
The affairs of self correspondence are committed to non-relational database by described second subtransaction coordinator;
Described second subtransaction coordinator receives described non-relational database and completes described second subtransaction association
The second transaction processing results returned after adjusting the affairs that device is corresponding;
Described second transaction processing results is back to described master transaction and processes by described second subtransaction coordinator
Device;
Described master transaction processor is respectively from described first subtransaction coordinator and described second subtransaction coordinator
Receive the first corresponding transaction processing results and the second transaction processing results;And by described first issued transaction knot
Fruit and described second transaction processing results carry out returning response.
Further, described data processing request includes pending data content and processes operation affairs;Phase
Ying Di, described master transaction processor according to described data processing request determine described first subtransaction coordinator with
The affairs that described second subtransaction coordinator is the most corresponding, including:
Described master transaction processor determines described first subtransaction coordinator according to described pending data content
The second data content that the first corresponding data content is corresponding with described second subtransaction coordinator;
Described master transaction processor by described process operation affairs divide into respectively with described relevant database and
The first specific operation affairs that described non-relational database is corresponding and the second specific operation affairs, wherein, institute
State the first specific operation affairs for being committed to described relevant database by described first subtransaction coordinator
Operating described first data content, described second specific operation affairs are for by described second sub-thing
Business coordinator is committed to described non-relational database and operates described second data content.
Further, described non-relational database is distributed data base, correspondingly, and described second sub-thing
The affairs of self correspondence are committed to non-relational database by business coordinator;Described second subtransaction coordinator connects
Receive that described non-relational database returns after completing the affairs that described second subtransaction coordinator is corresponding second
Transaction processing results;Described second transaction processing results is back to described master by described second subtransaction coordinator
Transaction processor, specifically includes:
The affairs of self correspondence are committed to each distributed data base by described second subtransaction coordinator;
Described second subtransaction coordinator receives each distributed data base described and completes described second subtransaction
The second transaction processing results returned respectively after the affairs that coordinator is corresponding;
The second transaction processing results that each distributed data base is returned by described second subtransaction coordinator is to institute
State master transaction processor to return.
Further, described method also includes:
Described master transaction processor according to described first transaction processing results and described second transaction processing results with
And the decision plan preset determines whether to carry out transaction rollback;
When determine carry out transaction rollback time, described master transaction processor instruction described first subtransaction coordinator will
The recovering state of described relevant database is to before completing the affairs that described first subtransaction coordinator is corresponding
State, and indicate described second subtransaction coordinator by the recovering state of described non-relational database to complete
Become the state before the affairs that described second subtransaction coordinator is corresponding;
When described first subtransaction coordinator and described second subtransaction coordinator complete described relationship type respectively
After the recovering state of data base and the recovering state of described non-relational database, described master transaction processor is true
Determine transaction rollback to complete.
Embodiments provide the system and method that a kind of db transaction processes, processed by master transaction
Device calls two kinds of subtransaction coordinators corresponding to type of database respectively and carries out data manipulation such that it is able to for
The affairs during database combination of various database types process, and improve mixed in multiple types of data storehouse
The integrity of issued transaction in the case of with, it is ensured that the concordance of data.
Accompanying drawing explanation
Fig. 1 is the system construction drawing of a kind of db transaction process of the embodiment of the present invention;
A kind of application scenarios schematic diagram that Fig. 2 provides for the embodiment of the present invention;
The method flow schematic diagram that a kind of db transaction that Fig. 3 provides for the embodiment of the present invention processes.
Detailed description of the invention
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clearly
Chu, it is fully described by.
The system 10 that a kind of db transaction of the embodiment of the present invention shown in Figure 1 processes, this system 10
May include that master transaction processor the 101, first subtransaction coordinator 102 and the second subtransaction coordinator 103,
Wherein,
Master transaction processor 101, is used for receiving data processing request;And,
The first subtransaction coordinator 102 and the second subtransaction coordinator 103 points is determined according to data processing request
Not corresponding affairs;And,
Trigger the first subtransaction coordinator 102, and indicate the first subtransaction coordinator 102 to process the thing of correspondence
Business;And,
Trigger the second subtransaction coordinator 103, and indicate the second subtransaction coordinator 103 to process the thing of correspondence
Business;And,
The first thing of correspondence is received respectively from the first subtransaction coordinator 102 and the second subtransaction coordinator 103
Business result and the second transaction processing results;And by the first transaction processing results and the second transaction processing results
Carry out returning response;
First subtransaction coordinator 102, for being committed to relevant database by the affairs of self correspondence;
And, receive relevant database and return after the affairs completing the first subtransaction coordinator 102 correspondence
The first transaction processing results;
And, the first transaction processing results is back to master transaction processor 101;
Second subtransaction coordinator 103, for being committed to non-relational database by the affairs of self correspondence;
And, receive non-relational database and return after the affairs completing the second subtransaction coordinator 103 correspondence
The second transaction processing results returned;
And, the second transaction processing results is back to master transaction processor 101.
It should be noted that corresponding to the first subtransaction coordinator 102 and the second subtransaction coordinator 103
Affairs process corresponding to different types of database data;Exemplarily, data processing request includes pending
Data content and process operation affairs;Correspondingly, master transaction processor 101, specifically for:
According to pending data content determine the first subtransaction coordinator 102 correspondence the first data content and
Second data content of the second subtransaction coordinator 103 correspondence;And,
Respectively corresponding with relevant database and non-relational database first is divided into by processing operation affairs
Specific operation affairs and the second specific operation affairs, wherein, the first specific operation affairs are for by described the
One subtransaction coordinator is committed to described relevant database and operates described first data content, described
Second specific operation affairs are for being committed to described non-relational database by described second subtransaction coordinator
Described second data content is operated.
Specifically, the operation affairs that process in data processing request can be the general of pending data content
Process operation transaction information, therefore, master transaction processor 101 by processs operate affairs divide into respectively with pass
It is type data base first specific operation affairs corresponding with non-relational database and the second specific operation affairs,
Can be specifically that the conversion adapter for different pieces of information source is adapted for processing operation affairs for data base
Specific operation affairs;And, master transaction processor 101 can also be by the conversion adapter in different pieces of information source
First data content and the second data content are carried out the conversion of data form for corresponding type of database.
Exemplarily, in the present embodiment, relevant database can be relevant database, non-relational
Data base can be distributed data base, and correspondingly, the second subtransaction coordinator 103, for right by self
The affairs answered are committed to each distributed data base;And,
Receive each distributed data base to return respectively after the affairs completing the second subtransaction coordinator 103 correspondence
The second transaction processing results returned;And,
The second transaction processing results each distributed data base returned returns to master transaction processor 101.
Also, it should be noted master transaction processor 101 triggers the first subtransaction coordinator 102, and indicate
First subtransaction coordinator 102 processes the affairs of correspondence;And, trigger the second subtransaction coordinator 103,
And indicate the second subtransaction coordinator 103 to process the affairs of correspondence, can trigger on the time between the two simultaneously,
Can also be that the mode owing to the data of two kinds of data bases store, agreement etc. all have difference, according to sequencing
Trigger respectively.
Exemplarily, master transaction processor 101, it is additionally operable to:
Determine whether according to the first transaction processing results and the second transaction processing results and default decision plan
Carry out transaction rollback;
When determine carry out transaction rollback time, indicate the first subtransaction coordinator 102 by the shape of relevant database
State recovers the state before the affairs completing the first subtransaction coordinator 102 correspondence, and, indicate second
Subtransaction coordinator 103 by the recovering state of non-relational database to completing the second subtransaction coordinator 103
The corresponding state before affairs;And,
When the first subtransaction coordinator 102 and the second subtransaction coordinator 103 finish relation type data respectively
After the recovering state in storehouse and the recovering state of non-relational database, determine that transaction rollback completes;It is appreciated that
Ground, owing to transaction controlling needs to travel in different storages, so master transaction processor 101 needs
Treat the feedback of whole subtransaction coordinator.
The system that the db transaction that the present embodiment provides processes, it is possible to for the data of various database types
Affairs when storehouse combines process, and improve issued transaction in the case of multiple types of data storehouse is mixed
Integrity, it is ensured that the concordance of data.
Based on the technology design that previous embodiment is identical, seeing Fig. 2, it illustrates the embodiment of the present invention provides
A kind of application scenarios, in this scenario, including in above-described embodiment db transaction process system 10,
Also include submit to data processing request client 30 and respectively with the first subtransaction coordinator 102 and second
The relevant database 40 of subtransaction coordinator 103 correspondence and non-relational database 50, at the present embodiment
In, in order to this technical scheme is described, relevant database 40 can be relevant database, non-relational number
Can be profile data base according to storehouse 50.
Based on above-mentioned application scenarios, see Fig. 3, it illustrates a kind of data that the embodiment of the present invention provides
The method of storehouse issued transaction, the method is applied in the system that the db transaction shown in Fig. 1 processes, described
Method includes:
S301: master transaction processor receives the data processing request that client sends;
S302: determine the first subtransaction coordinator and the second subtransaction coordinator respectively according to data processing request
Corresponding affairs;
It should be noted that corresponding to described first subtransaction coordinator and described second subtransaction coordinator
Affairs process corresponding to different types of database data;
Exemplarily, data processing request includes pending data content and processes operation affairs;Correspondingly,
According to data processing request, master transaction processor determines that the first subtransaction coordinator and the second subtransaction coordinator divide
Not corresponding affairs, including:
Master transaction processor determines, according to pending data content, the first number that the first subtransaction coordinator is corresponding
According to the second data content that content is corresponding with the second subtransaction coordinator;
Master transaction processor by process operation affairs divide into respectively with relevant database and non-relational data
The first specific operation affairs that storehouse is corresponding and the second specific operation affairs, wherein, the first specific operation affairs are used
In being committed to described relevant database by described first subtransaction coordinator, described first data content is entered
Row operation, described second specific operation affairs are for being committed to described non-by described second subtransaction coordinator
Described second data content is operated by relevant database.
S303: master transaction processor triggers the first subtransaction coordinator, and indicates at the first subtransaction coordinator
The affairs that reason is corresponding;
The affairs of self correspondence are committed to relevant database by the S304: the first subtransaction coordinator;
S305: the first subtransaction coordinator receives relevant database and completes the first subtransaction coordinator correspondence
Affairs after return the first transaction processing results;
First transaction processing results is back to master transaction processor by the S306: the first subtransaction coordinator;
S307: master transaction processor triggers the second subtransaction coordinator, and indicates at the second subtransaction coordinator
The affairs that reason is corresponding;
The affairs of self correspondence are committed to non-relational database by the S308: the second subtransaction coordinator;
S309: the second subtransaction coordinator receives non-relational database and completes the second subtransaction coordinator pair
The second transaction processing results returned after the affairs answered;
Second transaction processing results is back to master transaction processor by the S310: the second subtransaction coordinator;
Exemplarily, non-relational database is distributed data base, correspondingly, and step S308 to S310
Specifically may include that
The affairs of self correspondence are committed to each distributed data base by the second subtransaction coordinator;
Second subtransaction coordinator receives each distributed data base to complete the second subtransaction coordinator corresponding
The second transaction processing results returned respectively after affairs;
The second transaction processing results that each distributed data base is returned by the second subtransaction coordinator is to master transaction
Processor returns.
It is right that S311: master transaction processor receives from the first subtransaction coordinator and the second subtransaction coordinator respectively
The first transaction processing results answered and the second transaction processing results;And by the first transaction processing results and the second thing
Business result returns response to client.
Exemplarily, the method also includes:
Master transaction processor is according to the first transaction processing results and the second transaction processing results and default judgement
Strategy determines whether to carry out transaction rollback;
When determine carry out transaction rollback time, master transaction processor indicates the first subtransaction coordinator by relationship type number
According to the recovering state in storehouse to the state completed before the affairs that the first subtransaction coordinator is corresponding, and indicate
Two subtransaction coordinators are corresponding to completing the second subtransaction coordinator by the recovering state of non-relational database
State before affairs;
When the first subtransaction coordinator and the state of the second subtransaction coordinator finish relation type data base respectively
Recover and after the recovering state of non-relational database, master transaction processor determines that transaction rollback completes.
It is to be appreciated that owing to transaction controlling needs to travel in different storages, so master transaction processes
Device 101 needs to wait the feedback of whole subtransaction coordinator.
Those skilled in the art are it should be appreciated that embodiments of the invention can be provided as method, system or meter
Calculation machine program product.Therefore, the present invention can use hardware embodiment, software implementation or combine software and
The form of the embodiment of hardware aspect.And, the present invention can use and wherein include calculating one or more
The computer-usable storage medium of machine usable program code (includes but not limited to disk memory and optical storage
Device etc.) form of the upper computer program implemented.
The present invention is with reference to method, equipment (system) and computer program according to embodiments of the present invention
Flow chart and/or block diagram describe.It should be understood that can be by computer program instructions flowchart and/or side
Flow process in each flow process in block diagram and/or square frame and flow chart and/or block diagram and/or the knot of square frame
Close.Can provide these computer program instructions to general purpose computer, special-purpose computer, Embedded Processor or
The processor of other programmable data processing device is to produce a machine so that by computer or other can
The instruction that the processor of programming data processing equipment performs produces for realizing in one flow process or multiple of flow chart
The device of the function specified in flow process and/or one square frame of block diagram or multiple square frame.
These computer program instructions may be alternatively stored in and can guide computer or other programmable data processing device
In the computer-readable memory worked in a specific way so that be stored in this computer-readable memory
Instruction produces the manufacture including command device, and this command device realizes at one flow process of flow chart or multiple stream
The function specified in journey and/or one square frame of block diagram or multiple square frame.
These computer program instructions also can be loaded in computer or other programmable data processing device, makes
Sequence of operations step must be performed to produce computer implemented place on computer or other programmable devices
Reason, thus the instruction performed on computer or other programmable devices provides for realizing flow chart one
The step of the function specified in flow process or multiple flow process and/or one square frame of block diagram or multiple square frame.
Above, only presently preferred embodiments of the present invention, it is not intended to limit protection scope of the present invention.
Claims (8)
1. the system that a db transaction processes, it is characterised in that described system includes: master transaction processes
Device, the first subtransaction coordinator and the second subtransaction coordinator, wherein,
Described master transaction processor, is used for receiving data processing request;And,
Determine that described first subtransaction coordinator is coordinated with described second subtransaction according to described data processing request
The affairs that device is the most corresponding;Wherein, described first subtransaction coordinator and described second subtransaction coordinator institute
Corresponding affairs process corresponding to different types of database data;And,
Trigger described first subtransaction coordinator, and indicate thing corresponding to described first subtransaction mediators handle
Business;And,
Trigger described second subtransaction coordinator, and indicate thing corresponding to described second subtransaction mediators handle
Business;And,
The first corresponding thing is received with described second subtransaction coordinator respectively from described first subtransaction coordinator
Business result and the second transaction processing results;And by described first transaction processing results and described second affairs
Result carries out returning response;
Described first subtransaction coordinator, for being committed to relevant database by the affairs of self correspondence;
And, receive described relevant database after completing the affairs that described first subtransaction coordinator is corresponding
The first transaction processing results returned;
And, described first transaction processing results is back to described master transaction processor;
Described second subtransaction coordinator, for being committed to non-relational database by the affairs of self correspondence;
And, receive described non-relational database and complete the affairs that described second subtransaction coordinator is corresponding
Second transaction processing results of rear return;
And, described second transaction processing results is back to described master transaction processor.
System the most according to claim 1, it is characterised in that described data processing request includes waiting to locate
The data content of reason and process operation affairs;Correspondingly, described master transaction processor, specifically for:
In determining, according to described pending data content, the first data that described first subtransaction coordinator is corresponding
Hold second data content corresponding with described second subtransaction coordinator;And,
By described process operation affairs divide into respectively with described relevant database and described non-relational data
The first specific operation affairs that storehouse is corresponding and the second specific operation affairs, wherein, described first specific operation thing
Business is for being committed to described relevant database in described first data by described first subtransaction coordinator
Holding and operate, described second specific operation affairs are for being committed to institute by described second subtransaction coordinator
State non-relational database described second data content is operated.
System the most according to claim 1, it is characterised in that described non-relational database is distribution
Formula data base, correspondingly, described second subtransaction coordinator, for being committed to the affairs of self correspondence respectively
Individual distributed data base;And,
Receive each distributed data base described to divide after completing the affairs that described second subtransaction coordinator is corresponding
The second transaction processing results not returned;And,
The second transaction processing results each distributed data base returned returns to described master transaction processor.
System the most according to claim 1, it is characterised in that described master transaction processor, is additionally operable to:
According to described first transaction processing results and described second transaction processing results and default decision plan
Determine whether to carry out transaction rollback;
When determine carry out transaction rollback time, indicate described first subtransaction coordinator by described relevant database
Recovering state to the state completed before the affairs that described first subtransaction coordinator is corresponding, and, instruction
Described second subtransaction coordinator by the recovering state of described non-relational database to completing described second sub-thing
State before the affairs that business coordinator is corresponding;And,
When described first subtransaction coordinator and described second subtransaction coordinator complete described relationship type respectively
After the recovering state of data base and the recovering state of described non-relational database, determine that transaction rollback completes.
5. the method that a db transaction processes, it is characterised in that described method is applied to data base's thing
The system that business processes, described system includes: master transaction processor, the first subtransaction coordinator and the second sub-thing
Business coordinator, described method includes:
Described master transaction processor receives data processing request;And determine described according to described data processing request
The affairs that first subtransaction coordinator is the most corresponding with described second subtransaction coordinator;Wherein, described first
Subtransaction coordinator and the affairs corresponding to described second subtransaction coordinator are corresponding to different types of data base
Data process;
Described master transaction processor triggers described first subtransaction coordinator, and indicates described first subtransaction association
Device is adjusted to process corresponding affairs;
The affairs of self correspondence are committed to relevant database by described first subtransaction coordinator;
Described first subtransaction coordinator receives described relevant database and completes described first subtransaction coordination
The first transaction processing results returned after the affairs that device is corresponding;
Described first transaction processing results is back to described master transaction and processes by described first subtransaction coordinator
Device;
Described master transaction processor triggers described second subtransaction coordinator, and indicates described second subtransaction association
Device is adjusted to process corresponding affairs;
The affairs of self correspondence are committed to non-relational database by described second subtransaction coordinator;
Described second subtransaction coordinator receives described non-relational database and completes described second subtransaction association
The second transaction processing results returned after adjusting the affairs that device is corresponding;
Described second transaction processing results is back to described master transaction and processes by described second subtransaction coordinator
Device;
Described master transaction processor is respectively from described first subtransaction coordinator and described second subtransaction coordinator
Receive the first corresponding transaction processing results and the second transaction processing results;And by described first issued transaction knot
Fruit and described second transaction processing results carry out returning response.
Method the most according to claim 5, it is characterised in that described data processing request includes waiting to locate
The data content of reason and process operation affairs;Correspondingly, described master transaction processor processes according to described data
Request determines the affairs that described first subtransaction coordinator is the most corresponding with described second subtransaction coordinator, bag
Include:
Described master transaction processor determines described first subtransaction coordinator according to described pending data content
The second data content that the first corresponding data content is corresponding with described second subtransaction coordinator;
Described master transaction processor by described process operation affairs divide into respectively with described relevant database and
The first specific operation affairs that described non-relational database is corresponding and the second specific operation affairs, wherein, institute
State the first specific operation affairs for being committed to described relevant database by described first subtransaction coordinator
Operating described first data content, described second specific operation affairs are for by described second sub-thing
Business coordinator is committed to described non-relational database and operates described second data content.
Method the most according to claim 5, it is characterised in that described non-relational database is distribution
Formula data base, correspondingly, the affairs of self correspondence are committed to non-relational by described second subtransaction coordinator
Data base;Described second subtransaction coordinator receives described non-relational database and completes described second sub-thing
The second transaction processing results returned after the affairs that business coordinator is corresponding;Described second subtransaction coordinator is by institute
State the second transaction processing results and be back to described master transaction processor, specifically include:
The affairs of self correspondence are committed to each distributed data base by described second subtransaction coordinator;
Described second subtransaction coordinator receives each distributed data base described and completes described second subtransaction
The second transaction processing results returned respectively after the affairs that coordinator is corresponding;
The second transaction processing results that each distributed data base is returned by described second subtransaction coordinator is to institute
State master transaction processor to return.
Method the most according to claim 5, it is characterised in that described method also includes:
Described master transaction processor according to described first transaction processing results and described second transaction processing results with
And the decision plan preset determines whether to carry out transaction rollback;
When determine carry out transaction rollback time, described master transaction processor instruction described first subtransaction coordinator will
The recovering state of described relevant database is to before completing the affairs that described first subtransaction coordinator is corresponding
State, and indicate described second subtransaction coordinator by the recovering state of described non-relational database to complete
Become the state before the affairs that described second subtransaction coordinator is corresponding;
When described first subtransaction coordinator and described second subtransaction coordinator complete described relationship type respectively
After the recovering state of data base and the recovering state of described non-relational database, described master transaction processor is true
Determine transaction rollback to complete.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510182387.1A CN106156174A (en) | 2015-04-16 | 2015-04-16 | The system and method that a kind of db transaction processes |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510182387.1A CN106156174A (en) | 2015-04-16 | 2015-04-16 | The system and method that a kind of db transaction processes |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106156174A true CN106156174A (en) | 2016-11-23 |
Family
ID=58057551
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510182387.1A Pending CN106156174A (en) | 2015-04-16 | 2015-04-16 | The system and method that a kind of db transaction processes |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106156174A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2018120171A1 (en) * | 2016-12-30 | 2018-07-05 | 华为技术有限公司 | Method, device and system for executing stored procedure |
CN112965984A (en) * | 2021-05-18 | 2021-06-15 | 鲁班(北京)电子商务科技有限公司 | Method and device for executing database transaction |
WO2021120995A1 (en) * | 2019-12-16 | 2021-06-24 | 中兴通讯股份有限公司 | Data synchronization method and device for databases, and storage medium |
WO2022206429A1 (en) * | 2021-03-30 | 2022-10-06 | 华为云计算技术有限公司 | Distributed transaction implementation method and distributed system |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102262680A (en) * | 2011-08-18 | 2011-11-30 | 北京新媒传信科技有限公司 | Distributed database proxy system based on massive data access requirement |
CN102855277A (en) * | 2012-07-23 | 2013-01-02 | 中国联合网络通信集团有限公司 | Data center system and data processing method |
CN103390015A (en) * | 2013-01-16 | 2013-11-13 | 华北电力大学 | Mass data united storage method based on unified indexing and search method |
CN103440130A (en) * | 2013-08-26 | 2013-12-11 | 成都金山数字娱乐科技有限公司 | Data processing method and device |
CN103577431A (en) * | 2012-07-27 | 2014-02-12 | 深圳市易通无限科技有限公司 | Method, device and system for performing system design through multiple databases |
KR101484882B1 (en) * | 2014-03-31 | 2015-01-23 | (주)지엠디시스템 | Forensic data recovery method and system |
CN103164219B (en) * | 2013-01-08 | 2015-09-23 | 华中科技大学 | The distributing real time system system of polymorphic type copy is used in decentralization framework |
-
2015
- 2015-04-16 CN CN201510182387.1A patent/CN106156174A/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102262680A (en) * | 2011-08-18 | 2011-11-30 | 北京新媒传信科技有限公司 | Distributed database proxy system based on massive data access requirement |
CN102855277A (en) * | 2012-07-23 | 2013-01-02 | 中国联合网络通信集团有限公司 | Data center system and data processing method |
CN103577431A (en) * | 2012-07-27 | 2014-02-12 | 深圳市易通无限科技有限公司 | Method, device and system for performing system design through multiple databases |
CN103164219B (en) * | 2013-01-08 | 2015-09-23 | 华中科技大学 | The distributing real time system system of polymorphic type copy is used in decentralization framework |
CN103390015A (en) * | 2013-01-16 | 2013-11-13 | 华北电力大学 | Mass data united storage method based on unified indexing and search method |
CN103440130A (en) * | 2013-08-26 | 2013-12-11 | 成都金山数字娱乐科技有限公司 | Data processing method and device |
KR101484882B1 (en) * | 2014-03-31 | 2015-01-23 | (주)지엠디시스템 | Forensic data recovery method and system |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2018120171A1 (en) * | 2016-12-30 | 2018-07-05 | 华为技术有限公司 | Method, device and system for executing stored procedure |
US11182353B2 (en) | 2016-12-30 | 2021-11-23 | Huawei Technologies Co., Ltd. | Stored-procedure execution method and device, and system |
WO2021120995A1 (en) * | 2019-12-16 | 2021-06-24 | 中兴通讯股份有限公司 | Data synchronization method and device for databases, and storage medium |
US11836154B2 (en) | 2019-12-16 | 2023-12-05 | Xi'an Zhongxing New Software Co., Ltd. | Data synchronization method and device for databases, and storage medium |
WO2022206429A1 (en) * | 2021-03-30 | 2022-10-06 | 华为云计算技术有限公司 | Distributed transaction implementation method and distributed system |
CN112965984A (en) * | 2021-05-18 | 2021-06-15 | 鲁班(北京)电子商务科技有限公司 | Method and device for executing database transaction |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10210212B2 (en) | Dynamic layout management for robotics warehouse system | |
CN109271450B (en) | Database synchronization method, device, server and storage medium | |
CN106156174A (en) | The system and method that a kind of db transaction processes | |
CN106599018A (en) | Inventory operation method and system | |
CN109902975A (en) | Dispatching method, system, device and computer readable storage medium | |
CN110866687A (en) | Task allocation method and device | |
US10860750B2 (en) | Model driven layout design for robotics warehouse | |
CN107437222A (en) | The processing method and system of online business data based on bank counter front end | |
CN107124473A (en) | The construction method and cloud platform of cloud platform | |
CN106897123B (en) | Database operation method and device | |
CN109308217A (en) | A kind of date storage method and device of timeliness task | |
US9595014B1 (en) | System and method for executing workflow instance and modifying same during execution | |
CN104299104A (en) | Project management platform and application method thereof | |
CN112466111A (en) | Vehicle running control method and device, storage medium and electronic equipment | |
CN110888925B (en) | Data loading and distributing method and device and storage medium | |
CN109614263A (en) | A kind of disaster tolerance data processing method, apparatus and system | |
CN112559496A (en) | Distributed database transaction atomicity realization method and device | |
CN105207990B (en) | A kind of method, server and network game system accessing game server | |
CN109829678A (en) | A kind of rollback processing method, device and electronic equipment | |
US9336257B2 (en) | Systems and methods providing a soft exit state for secondary business objects locks | |
CN115496835B (en) | Point cloud data color-imparting method and system based on CPU and GPU heterogeneous parallel architecture | |
CN110941422A (en) | Code automatic generation method, code generator and readable storage medium | |
CN108470072A (en) | A kind of query compiler method and apparatus | |
CN103530742B (en) | Improve the method and device of scheduling arithmetic speed | |
CN109993656A (en) | Tree-like block chain processing method, equipment and 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: 20161123 |