CN111930830A - Distributed transaction data processing method and system based on shared database - Google Patents
Distributed transaction data processing method and system based on shared database Download PDFInfo
- Publication number
- CN111930830A CN111930830A CN202010575033.4A CN202010575033A CN111930830A CN 111930830 A CN111930830 A CN 111930830A CN 202010575033 A CN202010575033 A CN 202010575033A CN 111930830 A CN111930830 A CN 111930830A
- Authority
- CN
- China
- Prior art keywords
- service
- operation instruction
- service operation
- connection pool
- database connection
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 26
- 238000012545 processing Methods 0.000 claims abstract description 47
- 238000000034 method Methods 0.000 claims description 12
- 238000010586 diagram Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 231100000279 safety data Toxicity 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/23—Updating
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/466—Transaction processing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention aims to provide a distributed transaction data processing method based on a shared database. And acquiring a current database connection pool corresponding to the first service operation instruction and an updating result thereof in the database connection pool cluster according to the first service operation instruction and the instruction identifier. And the second service end operates the corresponding service database through the current database connection pool according to the second service operation instruction, and returns the result data of the second service operation instruction. The pool clusters are connected through the database, and the accuracy, timeliness and convenience of multi-database cooperation are improved. Another objective of the present invention is to provide a distributed transaction data processing system based on shared database, which improves the accuracy, timeliness and convenience of multi-database collaboration by connecting associated data.
Description
Technical Field
The present invention relates to the field of data analysis. The invention relates to a distributed transaction data processing method and system based on a shared database, which are applied to running safety data analysis.
Background
The current solutions of all distributed transaction databases are mainly divided into two solutions, one is that a service implementing party adopts a scheme of tcc (trycommincacel), which results in that the service implementation is complex and a rollback logic needs to be additionally implemented, and the other adopts a scheme of a database itself, which is submitted in two stages.
Disclosure of Invention
The invention aims to provide a distributed transaction data processing method based on a shared database, which improves the accuracy, timeliness and convenience of multi-database cooperation by establishing instruction connection associated data.
Another objective of the present invention is to provide a distributed transaction data processing system based on shared database, which improves the accuracy, timeliness and convenience of multi-database collaboration by connecting associated data.
The invention provides a distributed transaction data processing method based on a shared database, which comprises the following steps:
step S101, a database connection pool corresponding to a plurality of service operation instructions in a service system is obtained. The database connection pool is connected with a plurality of service databases.
And step S102, establishing a database connection pool cluster according to the database connection pools corresponding to the plurality of service operation instructions.
Step S103, the first service end obtains a first service operation instruction and a second service operation instruction from a current instruction set to be executed. The first service operation instruction and the second service operation instruction are in a plurality of service operation instructions. The current set of instructions to be executed has an instruction identification. And the first service operation instruction and the second service operation instruction are executed in sequence.
And step S104, the first service end acquires a current database connection pool corresponding to the first service operation instruction from the database connection pool cluster according to the first service operation instruction and the instruction identifier. The current database connection pool has identification information. The identification information includes an instruction identification.
And step S105, the first service end operates the corresponding service database through the current database connection pool according to the first service operation instruction, and returns the result data of the first service operation instruction.
And step S106, the first service end sends the instruction identification and the second service operation instruction to the second service end.
And step S107, the second service end acquires the current database connection pool from the database connection pool cluster according to the instruction identification.
And step S108, the second service terminal operates the corresponding service database through the current database connection pool according to the second service operation instruction, and returns the result data of the second service operation instruction.
In an embodiment of the distributed transaction data processing method of the present invention, in step S104 and step S108, the step of operating the corresponding service database through the current database connection pool includes calling and updating the corresponding service database through the current database connection pool.
In an embodiment of the distributed transaction data processing method of the present invention, step S104 includes: and the first service end generates a first service operation instruction message according to the first service operation instruction and the instruction identifier. And the first service end acquires a current database connection pool corresponding to the first service operation instruction from the database connection pool cluster according to the first service operation instruction message.
In an embodiment of the distributed transaction data processing method of the present invention, the current instruction set to be executed further includes: and a third business operation instruction. The third service operation instruction is executed in sequence after the second service operation instruction.
In an embodiment of the distributed transaction data processing method of the present invention, after step S108, the method further includes:
step S1091, the second service end sends the instruction identifier and the third service operation instruction to the third service end.
And step S1092, the third service end acquires the current database connection pool from the database connection pool cluster according to the instruction identifier.
Step S1093, the third service terminal calls and updates the corresponding service database through the current database connection pool according to the third service operation instruction, and returns the result data of the third service operation instruction.
Meanwhile, the invention also provides a distributed transaction data processing system based on the shared database, which comprises: the system comprises a database connection pool acquisition unit, a database connection pool cluster establishment unit, an instruction processing unit, a first service end processing unit and a second service end processing unit.
And the database connection pool acquisition unit is configured to acquire the database connection pools corresponding to the plurality of service operation instructions in the service system. The database connection pool is connected with a plurality of service databases.
And the database connection pool cluster establishing unit is configured to establish a database connection pool cluster according to the database connection pools corresponding to the plurality of service operation instructions.
The instruction processing unit is configured to enable the first service end to obtain a first service operation instruction and a second service operation instruction from a current instruction set to be executed. The first service operation instruction and the second service operation instruction are in a plurality of service operation instructions. The current set of instructions to be executed has an instruction identification. And the first service operation instruction and the second service operation instruction are executed in sequence.
And the first service end processing unit is configured to acquire a current database connection pool corresponding to the first service operation instruction from the database connection pool cluster according to the first service operation instruction and the instruction identifier. The current database connection pool has identification information. The identification information includes an instruction identification.
And the first service end operates the corresponding service database through the current database connection pool according to the first service operation instruction, and returns the result data of the first service operation instruction.
And the first service end sends the instruction identification and the second service operation instruction to the second service end.
And the second service end processing unit is configured to acquire the current database connection pool from the database connection pool cluster according to the instruction identifier.
And the second service end operates the corresponding service database through the current database connection pool according to the second service operation instruction, and returns the result data of the second service operation instruction.
In one embodiment of the distributed transaction data processing system of the present invention, the step of operating the corresponding service database through the current database connection pool comprises calling and updating the corresponding service database through the current database connection pool.
In an embodiment of the distributed transaction data processing system of the present invention, the first service-end processing unit is further configured to: and the first service end generates a first service operation instruction message according to the first service operation instruction and the instruction identifier. And the first service end acquires a current database connection pool corresponding to the first service operation instruction from the database connection pool cluster according to the first service operation instruction message.
In an embodiment of the distributed transaction data processing system of the present invention, the current instruction set to be executed further includes: and a third business operation instruction. The third service operation instruction is executed in sequence after the second service operation instruction.
In an embodiment of the distributed transaction data processing system of the present invention, the system further includes: a second traffic processing unit configured to: and the second service end sends the instruction identification and the third service operation instruction to the third service end. And the third service terminal acquires the current database connection pool from the database connection pool cluster according to the instruction identifier. And the third service end calls and updates the corresponding service database through the current database connection pool according to the third service operation instruction, and returns the result data of the third service operation instruction.
The characteristics, technical features, advantages and implementation manners of the bus transmission method and the PLC system capable of achieving efficient transmission will be further described in a clear and easy manner with reference to the accompanying drawings.
Drawings
Fig. 1 is a process flow diagram for explaining a distributed transaction data processing method based on a shared database in an embodiment of the present invention.
Fig. 2 is a schematic process flow diagram for explaining a distributed transaction data processing method based on a shared database according to another embodiment of the present invention.
Fig. 3 is a schematic flow chart for explaining the distributed transaction data processing method based on the shared database in a business process according to an embodiment of the present invention.
Fig. 4 is a schematic flow chart for explaining the shared database-based distributed transaction data processing method in another business process according to an embodiment of the present invention.
FIG. 5 is a schematic diagram illustrating the components of a shared database based distributed transaction data processing system according to an embodiment of the present invention.
Detailed Description
In order to more clearly understand the technical features, objects and effects of the present invention, embodiments of the present invention will now be described with reference to the accompanying drawings, in which the same reference numerals indicate the same or structurally similar but functionally identical elements.
"exemplary" means "serving as an example, instance, or illustration" herein, and any illustration, embodiment, or steps described as "exemplary" herein should not be construed as a preferred or advantageous alternative. For the sake of simplicity, the drawings only schematically show the parts relevant to the present exemplary embodiment, and they do not represent the actual structure and the true scale of the product.
The invention provides a distributed transaction data processing method based on a shared database, as shown in fig. 1 and 2, comprising the following steps:
and step S101, acquiring a database connection pool.
In this step, at the server side or the user side, the database connection pool corresponding to the plurality of service operation instructions in the service system is obtained according to the data to be called by the service system. The database connection pool is connected with a plurality of service databases. Such as an order system or an inventory system. The service operation instructions comprise operation instructions such as 'insert addition, modification update and deletion'. The database connection pool connects a plurality of service databases 1, 2, 3.
Step S102, a database connection pool cluster is established.
In this step, a database connection pool cluster is established according to the database connection pools corresponding to the plurality of service operation instructions in step S101. For example, the respective database connection pools corresponding to the operation instructions such as "insert addition, modify update, and delete" are obtained first, and then the plurality of database connection pools are combined into the database connection pool cluster 101 (fig. 2).
Step S103, a first service operation instruction and a second service operation instruction are obtained.
In this step, the first service end 201 obtains a first service operation instruction and a second service operation instruction from a current instruction set to be executed. The first service operation instruction and the second service operation instruction are in a plurality of service operation instructions. The current set of instructions to be executed has an instruction identification. And the first service operation instruction and the second service operation instruction are executed in sequence.
Such as: the current instruction set to be executed is a set of instructions and includes a plurality of business operation instructions in step S101.
And step S104, acquiring a current database connection pool.
In this step, the first service end 201 generates a first service operation instruction message 202 according to the first service operation instruction and the instruction identifier. The first service end 201 sends a first service operation instruction message 202 to the database connection pool cluster 101. And acquiring or establishing a current database connection pool 1 corresponding to the first service operation instruction in the database connection pool cluster 101. The current database connection pool 1 has identification information. The identification information includes an instruction identification.
And step S105, returning the result data of the first service operation instruction.
In this step, the first service end 201 operates the corresponding service database through the current database connection pool according to the first service operation instruction, and returns the result data of the first service operation instruction.
And step S106, sending to the second service terminal.
In this step, the first service end 201 sends the instruction identifier and the second service operation instruction to the second service end 301.
And step S107, the second service end acquires the current database connection pool.
In this step, the second service end 301 packages the second service operation instruction message 302 according to the instruction identifier and sends the second service operation instruction message to the database connection pool cluster 101, and the database connection pool cluster 101 obtains the current database connection pool 1 according to the second service operation instruction message 302.
And step S108, returning the result data of the second service operation instruction.
In this step, the second service end 301 operates the corresponding service database through the current database connection pool according to the second service operation instruction, and returns the result data of the second service operation instruction.
Therefore, the distributed transaction data processing method based on the shared database can continuously process the same database connection in multi-service processing by establishing the database connection cluster, thereby improving the accuracy of database updating on one hand and improving the data processing efficiency on the other hand.
In an embodiment of the distributed transaction data processing method of the present invention, in step S104 and step S108, the step of operating the corresponding service database through the current database connection pool includes calling and updating the corresponding service database through the current database connection pool.
In an embodiment of the distributed transaction data processing method of the present invention, step S104 includes:
the first service end 201 generates a first service operation instruction message according to the first service operation instruction and the instruction identifier. The first service end 201 obtains a current database connection pool corresponding to the first service operation instruction from the database connection pool cluster according to the first service operation instruction packet.
In an embodiment of the distributed transaction data processing method of the present invention, the current instruction set to be executed further includes: and a third business operation instruction. The third service operation instruction is executed in sequence after the second service operation instruction. Therefore, the distributed transaction data processing method based on the shared database can process data of multiple service processes.
In an embodiment of the distributed transaction data processing method of the present invention, after step S108, the method further includes:
in step S1091, the second service end 301 sends the instruction identifier and the third service operation instruction to the third service end.
And step S1092, the third service end acquires the current database connection pool from the database connection pool cluster according to the instruction identifier.
Step S1093, the third service terminal calls and updates the corresponding service database through the current database connection pool according to the third service operation instruction, and returns the result data of the third service operation instruction.
Fig. 3 and 4 show the application of the distributed transaction data processing method based on shared database in different service systems.
As shown in fig. 3, the service end includes: system service A, system service B and system service C. Wherein the system service a is the first service end in the above embodiment, the system service B is the second service end in the above embodiment, and the system service C is the third service end in the above embodiment.
The system service a generates a requested identifier and inserts an insert operation instruction, and then sends the requested identifier and the insert operation instruction to the database connection pool cluster. In the database connection pool cluster, the requested is firstly cached, and the corresponding connection pool is allocated. According to the connection type and the called data range (such as an A library database specifically related to an A inventory inserting instruction), specific database connection is distributed in the database connection pool, and database updating is called according to the database connection.
The system service a sends an update operation instruction and a requested (request identification) to the system service B, which are executed in sequence with the insertion of the insert operation instruction. And the service system B finds the database connection pool called by the system service A according to the requested.
According to the connection type and the called data range, specific database connection is distributed in the database connection pool, and if the specific database connection is not in the current connection, a connection can be reestablished. And distributing specific database connection in the database connection pool, and calling database updating according to the database connection.
The system business B sends delete operation instructions and request identifiers sequentially executed with the insert operation instructions to the system business C, and the system business calls the database connection pool called by the system business A to process corresponding data in the database connection pool cluster. Thereby realizing the processing of multi-service data.
Meanwhile, the present invention further provides a distributed transaction data processing system based on a shared database, as shown in fig. 5, the distributed transaction data processing system includes: the system comprises a database connection pool obtaining unit 10, a database connection pool cluster establishing unit 20, an instruction processing unit 30, a first service end processing unit 40 and a second service end processing unit 50.
The database connection pool obtaining unit 10 is configured to obtain a database connection pool corresponding to a plurality of service operation instructions in the service system. The database connection pool is connected with a plurality of service databases.
The database connection pool cluster establishing unit 20 is configured to establish a database connection pool cluster according to the database connection pools corresponding to the plurality of service operation instructions.
The instruction processing unit 30 is configured to obtain a first service operation instruction and a second service operation instruction from a current instruction set to be executed by the first service end 201. The first service operation instruction and the second service operation instruction are in a plurality of service operation instructions. The current set of instructions to be executed has an instruction identification. And the first service operation instruction and the second service operation instruction are executed in sequence.
The first service end processing unit 40 is configured to, by the first service end 201, obtain, in the database connection pool cluster, the current database connection pool corresponding to the first service operation instruction according to the first service operation instruction and the instruction identifier. The current database connection pool has identification information. The identification information includes an instruction identification.
The first service end 201 operates the corresponding service database through the current database connection pool according to the first service operation instruction, and returns result data of the first service operation instruction.
The first service end 201 sends the instruction identifier and the second service operation instruction to the second service end 301.
The second service end processing unit 50 is configured to obtain the current database connection pool from the database connection pool cluster by the second service end 301 according to the instruction identifier.
The second service end 301 operates the corresponding service database through the current database connection pool according to the second service operation instruction, and returns result data of the second service operation instruction.
In one embodiment of the distributed transaction data processing system of the present invention, the step of operating the corresponding service database through the current database connection pool comprises calling and updating the corresponding service database through the current database connection pool.
In an embodiment of the distributed transaction data processing system of the present invention, the first service-end processing unit 40 is further configured to: the first service end 201 generates a first service operation instruction message according to the first service operation instruction and the instruction identifier. The first service end 201 obtains a current database connection pool corresponding to the first service operation instruction from the database connection pool cluster according to the first service operation instruction packet.
In an embodiment of the distributed transaction data processing system of the present invention, the current instruction set to be executed further includes: and a third business operation instruction. The third service operation instruction is executed in sequence after the second service operation instruction.
In an embodiment of the distributed transaction data processing system of the present invention, the system further includes: a second service-side processing unit 50 configured to: the second service end 301 sends the instruction identifier and the third service operation instruction to the third service end. And the third service terminal acquires the current database connection pool from the database connection pool cluster according to the instruction identifier. And the third service end calls and updates the corresponding service database through the current database connection pool according to the third service operation instruction, and returns the result data of the third service operation instruction.
It should be understood that although the present description is described in terms of various embodiments, not every embodiment includes only a single embodiment, and such description is for clarity purposes only, and those skilled in the art will recognize that the embodiments described herein as a whole may be suitably combined to form other embodiments as will be appreciated by those skilled in the art.
The above-listed detailed description is only a specific description of a possible embodiment of the present invention, and they are not intended to limit the scope of the present invention, and equivalent embodiments or modifications made without departing from the technical spirit of the present invention should be included in the scope of the present invention.
Claims (10)
1. A method of distributed transactional data processing based on a shared database, comprising:
step S101, a database connection pool corresponding to a plurality of service operation instructions in a service system is obtained; the database connection pool is connected with a plurality of service databases;
step S102, establishing a database connection pool cluster according to the database connection pools corresponding to the plurality of service operation instructions;
step S103, the first service end obtains a first service operation instruction and a second service operation instruction from a current instruction set to be executed; the first service operation instruction and the second service operation instruction are in the plurality of service operation instructions; the current instruction set to be executed has an instruction identification; the first service operation instruction and the second service operation instruction are executed in sequence;
step S104, the first service end obtains a current database connection pool corresponding to the first service operation instruction from the database connection pool cluster according to the first service operation instruction and the instruction identification; the current database connection pool has identification information; the identification information comprises the instruction identification;
step S105, the first service terminal operates the corresponding service database through the current database connection pool according to the first service operation instruction, and returns first service operation instruction result data;
step S106, the first service end sends the instruction identification and the second service operation instruction to the second service end;
step S107, the second service end acquires the current database connection pool from the database connection pool cluster according to the instruction identification;
step S108, the second service terminal operates the corresponding service database through the current database connection pool according to the second service operation instruction, and returns the result data of the second service operation instruction.
2. The distributed transaction data processing method according to claim 1, wherein in step S104 and step S108, the step of operating the corresponding service database through the current database connection pool includes:
and calling and updating the corresponding service database through the current database connection pool.
3. The distributed transaction data processing method according to claim 1, wherein the step S104 comprises:
the first service end generates a first service operation instruction message according to the first service operation instruction and the instruction identifier;
and the first service end acquires a current database connection pool corresponding to the first service operation instruction from the database connection pool cluster according to the first service operation instruction message.
4. The distributed transaction data processing method of claim 1 wherein the current set of instructions to be executed further comprises: a third service operation instruction; and the third service operation instruction is sequentially executed after the second service operation instruction.
5. The distributed transaction data processing method of claim 4, wherein the step S108 is followed by further comprising:
step S1091, the second service end sends the instruction identifier and the third service operation instruction to the third service end;
step S1092, the third service end obtains the current database connection pool from the database connection pool cluster according to the instruction identifier;
step S1093, the third service end calls and updates the corresponding service database through the current database connection pool according to the third service operation instruction, and returns the result data of the third service operation instruction.
6. A shared database based distributed transactional data processing system, comprising: the system comprises a database connection pool acquisition unit, a database connection pool cluster establishment unit, an instruction processing unit, a first service end processing unit and a second service end processing unit;
the database connection pool acquisition unit is configured to acquire database connection pools corresponding to a plurality of service operation instructions in the service system; the database connection pool is connected with a plurality of service databases;
the database connection pool cluster establishing unit is configured to establish a database connection pool cluster according to the database connection pools corresponding to the plurality of service operation instructions;
the instruction processing unit is configured to enable the first service end to obtain a first service operation instruction and a second service operation instruction from a current instruction set to be executed; the first service operation instruction and the second service operation instruction are in the plurality of service operation instructions; the current instruction set to be executed has an instruction identification; the first service operation instruction and the second service operation instruction are executed in sequence;
the first service end processing unit is configured to acquire, by the first service end, a current database connection pool corresponding to the first service operation instruction from the database connection pool cluster according to the first service operation instruction and the instruction identifier; the current database connection pool has identification information; the identification information comprises the instruction identification;
the first service end operates the corresponding service database through the current database connection pool according to the first service operation instruction, and returns first service operation instruction result data;
the first service end sends the instruction identification and the second service operation instruction to the second service end; a second service end processing unit configured to acquire the current database connection pool from the database connection pool cluster by the second service end according to the instruction identifier;
and the second service end operates the corresponding service database through the current database connection pool according to the second service operation instruction, and returns result data of the second service operation instruction.
7. The distributed transactional data processing system of claim 6, wherein the step of operating the corresponding business database through the current database connection pool comprises invoking and updating the corresponding business database through the current database connection pool.
8. The distributed transaction data processing system of claim 6 wherein the first business end processing unit is further configured to:
the first service end generates a first service operation instruction message according to the first service operation instruction and the instruction identifier;
and the first service end acquires a current database connection pool corresponding to the first service operation instruction from the database connection pool cluster according to the first service operation instruction message.
9. The distributed transactional data processing system of claim 6, wherein said current set of instructions to be executed further comprises: a third service operation instruction; and the third service operation instruction is sequentially executed after the second service operation instruction.
10. The distributed transactional data processing system of claim 9, further comprising: a second traffic processing unit configured to: the second service end sends the instruction identification and the third service operation instruction to the third service end;
the third service end acquires the current database connection pool from the database connection pool cluster according to the instruction identification;
and the third service end calls and updates the corresponding service database through the current database connection pool according to the third service operation instruction, and returns the result data of the third service operation instruction.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010575033.4A CN111930830B (en) | 2020-06-22 | 2020-06-22 | Distributed transaction data processing method and system based on shared database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010575033.4A CN111930830B (en) | 2020-06-22 | 2020-06-22 | Distributed transaction data processing method and system based on shared database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111930830A true CN111930830A (en) | 2020-11-13 |
| CN111930830B CN111930830B (en) | 2024-04-16 |
Family
ID=73316613
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010575033.4A Active CN111930830B (en) | 2020-06-22 | 2020-06-22 | Distributed transaction data processing method and system based on shared database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111930830B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113946624A (en) * | 2021-10-11 | 2022-01-18 | 北京达佳互联信息技术有限公司 | Distributed cluster, information processing method and device, electronic equipment and storage medium |
Citations (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080243865A1 (en) * | 2007-03-28 | 2008-10-02 | Oracle International Corporation | Maintaining global state of distributed transaction managed by an external transaction manager for clustered database systems |
| CN103064964A (en) * | 2012-12-29 | 2013-04-24 | 天津南大通用数据技术有限公司 | Connection method of data base supporting distributed type affairs |
| CN104572077A (en) * | 2014-12-12 | 2015-04-29 | 百度在线网络技术（北京）有限公司 | Database service processing method and business system |
| CN105138693A (en) * | 2015-09-18 | 2015-12-09 | 联动优势科技有限公司 | Method and device for having access to databases |
| CN106484882A (en) * | 2016-10-14 | 2017-03-08 | 腾讯科技（深圳）有限公司 | A kind of management method of database connection pool and device |
| CN106503007A (en) * | 2015-09-08 | 2017-03-15 | 阿里巴巴集团控股有限公司 | database operation method and device |
| WO2017041637A1 (en) * | 2015-09-08 | 2017-03-16 | 阿里巴巴集团控股有限公司 | Database operating method and device |
| CN106855821A (en) * | 2015-12-08 | 2017-06-16 | 阿里巴巴集团控股有限公司 | A kind of distributed transaction processing method and device |
| WO2018103318A1 (en) * | 2016-12-06 | 2018-06-14 | 上海壹账通金融科技有限公司 | Distributed transaction handling method and system |
| CN108304255A (en) * | 2017-12-29 | 2018-07-20 | 北京城市网邻信息技术有限公司 | Distributed task dispatching method and device, electronic equipment and readable storage medium storing program for executing |
| CN108572991A (en) * | 2017-03-14 | 2018-09-25 | 北京京东尚科信息技术有限公司 | Data base processing method, device and storage medium |
| CN108984639A (en) * | 2018-06-22 | 2018-12-11 | 联想(北京)有限公司 | The data processing method and device of server cluster |
| CN110019113A (en) * | 2017-08-31 | 2019-07-16 | 华为软件技术有限公司 | A kind of method for processing business and database server of database |
| WO2019154394A1 (en) * | 2018-02-12 | 2019-08-15 | 中兴通讯股份有限公司 | Distributed database cluster system, data synchronization method and storage medium |
| CN110196759A (en) * | 2018-06-20 | 2019-09-03 | 腾讯科技（深圳）有限公司 | Distributed transaction processing method and device, storage medium and electronic device |
| CN110830538A (en) * | 2018-08-13 | 2020-02-21 | 华为技术有限公司 | Message transmission method, device and storage medium |
| CN111045794A (en) * | 2019-12-17 | 2020-04-21 | 深圳前海环融联易信息科技服务有限公司 | Distributed transaction processing method, device, system, computer equipment and storage medium |
| CN111125240A (en) * | 2018-10-31 | 2020-05-08 | 北京金山云网络技术有限公司 | Distributed transaction implementation method and device, electronic equipment and storage medium |
-
2020
- 2020-06-22 CN CN202010575033.4A patent/CN111930830B/en active Active
Patent Citations (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080243865A1 (en) * | 2007-03-28 | 2008-10-02 | Oracle International Corporation | Maintaining global state of distributed transaction managed by an external transaction manager for clustered database systems |
| CN103064964A (en) * | 2012-12-29 | 2013-04-24 | 天津南大通用数据技术有限公司 | Connection method of data base supporting distributed type affairs |
| CN104572077A (en) * | 2014-12-12 | 2015-04-29 | 百度在线网络技术（北京）有限公司 | Database service processing method and business system |
| CN106503007A (en) * | 2015-09-08 | 2017-03-15 | 阿里巴巴集团控股有限公司 | database operation method and device |
| WO2017041637A1 (en) * | 2015-09-08 | 2017-03-16 | 阿里巴巴集团控股有限公司 | Database operating method and device |
| CN105138693A (en) * | 2015-09-18 | 2015-12-09 | 联动优势科技有限公司 | Method and device for having access to databases |
| CN106855821A (en) * | 2015-12-08 | 2017-06-16 | 阿里巴巴集团控股有限公司 | A kind of distributed transaction processing method and device |
| CN106484882A (en) * | 2016-10-14 | 2017-03-08 | 腾讯科技（深圳）有限公司 | A kind of management method of database connection pool and device |
| WO2018103318A1 (en) * | 2016-12-06 | 2018-06-14 | 上海壹账通金融科技有限公司 | Distributed transaction handling method and system |
| CN108572991A (en) * | 2017-03-14 | 2018-09-25 | 北京京东尚科信息技术有限公司 | Data base processing method, device and storage medium |
| CN110019113A (en) * | 2017-08-31 | 2019-07-16 | 华为软件技术有限公司 | A kind of method for processing business and database server of database |
| CN108304255A (en) * | 2017-12-29 | 2018-07-20 | 北京城市网邻信息技术有限公司 | Distributed task dispatching method and device, electronic equipment and readable storage medium storing program for executing |
| WO2019154394A1 (en) * | 2018-02-12 | 2019-08-15 | 中兴通讯股份有限公司 | Distributed database cluster system, data synchronization method and storage medium |
| CN110209726A (en) * | 2018-02-12 | 2019-09-06 | 中兴通讯股份有限公司 | Distributed experiment & measurement system system, method of data synchronization and storage medium |
| CN110196759A (en) * | 2018-06-20 | 2019-09-03 | 腾讯科技（深圳）有限公司 | Distributed transaction processing method and device, storage medium and electronic device |
| CN108984639A (en) * | 2018-06-22 | 2018-12-11 | 联想(北京)有限公司 | The data processing method and device of server cluster |
| CN110830538A (en) * | 2018-08-13 | 2020-02-21 | 华为技术有限公司 | Message transmission method, device and storage medium |
| CN111125240A (en) * | 2018-10-31 | 2020-05-08 | 北京金山云网络技术有限公司 | Distributed transaction implementation method and device, electronic equipment and storage medium |
| CN111045794A (en) * | 2019-12-17 | 2020-04-21 | 深圳前海环融联易信息科技服务有限公司 | Distributed transaction processing method, device, system, computer equipment and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 于振华;怀文佳;: "分布式事务数据库评测体系研究与实践", 中国金融电脑, no. 01, 7 January 2018 (2018-01-07) * |
| 陈蓓;刘文涛;: "银行业如何玩转分布式数据库", 金融电子化, no. 12, 15 December 2016 (2016-12-15) * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113946624A (en) * | 2021-10-11 | 2022-01-18 | 北京达佳互联信息技术有限公司 | Distributed cluster, information processing method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111930830B (en) | 2024-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107733957B (en) | Distributed service configuration system and version number distribution method | |
| CN107203560B (en) | Database, multi-database operation transaction consistency ensuring method and system | |
| CN110119292A (en) | System operational parameters querying method, matching process, device and node device | |
| GB2449037A (en) | Multilayer distributed processing system | |
| CN112866421B (en) | Intelligent contract operation method and device based on distributed cache and NSQ | |
| CN112650812A (en) | Data fragment storage method and device, computer equipment and storage medium | |
| CN107870982A (en) | Data processing method, system and computer-readable recording medium | |
| CN101953188B (en) | Method and apparatus for processing multi-channel request subscription under service management platform | |
| CN111930830A (en) | Distributed transaction data processing method and system based on shared database | |
| CN114040020A (en) | Cross-cluster service calling method and system | |
| US11777852B1 (en) | System and method for web service atomic transaction (WS-AT) affinity routing | |
| CN1972276B (en) | A management method and system for protocol access | |
| CN105978744A (en) | Resource allocation method, device and system | |
| CN112328632B (en) | Distributed two-level caching method and system | |
| CN100407623C (en) | Method and system for user data transaction in communication system | |
| CN113821521A (en) | Distributed identification generation method and device, electronic equipment and storage medium | |
| CN108259605A (en) | A kind of data calling system and method based on multiple data centers | |
| CN115526586A (en) | Business process processing method based on intelligent operation | |
| CN113727138A (en) | HLS intranet source returning method | |
| CN113783826A (en) | Micro-service exception handling method and device | |
| CN106201606A (en) | software distribution method and system | |
| CN101419596B (en) | Translation dictionary enquiring system applying to master/slave mode structure and method thereof | |
| CN106570038A (en) | Distributed data processing method and system | |
| CN111246028A (en) | System and method for merging advertisement services | |
| CN105245575A (en) | Information interaction management system and target information receiving ends |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |