Cross-database transaction processing method and system based on relational database

A transaction processing and database technology, applied in the computer field, can solve the problems of no way to guarantee transaction atomicity, database data rollback, data inconsistency, etc., to ensure data synchronization, simplify consistent operations, and solve single point failures Effect

Active Publication Date: 2018-07-10
ZICT TECH CO LTD
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] For the situation where multiple types of data sources are distributed on multiple machines, the existing transaction processing methods cannot meet the requirements, because if one of the database servers fails, it cannot ensure that other databases still have uncommitted data rollback
In other words, without the ability to coordinate multiple transactions happening in different places, there is no way to guarantee transaction atomicity
[0008] Therefore, how to solve the data inconsistency caused by abnormalities in the cross-database operation in the distributed system has become a technical problem to be solved urgently

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Cross-database transaction processing method and system based on relational database
  • Cross-database transaction processing method and system based on relational database
  • Cross-database transaction processing method and system based on relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other.

[0037] In the following description, many specific details are set forth in order to fully understand the present invention. However, the present invention can also be implemented in other ways different from those described here. Therefore, the protection scope of the present invention is not limited by the specific details disclosed below. EXAMPLE LIMITATIONS.

[0038] figure 1 A schematic flowchart of a method for processing cross-database transactions based on a relational database according to an embodiment of the present invention is shown.

[0039] Su...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a crossing-base transaction processing method and system based on relational databases. The method comprises the steps of building a plurality of database connection pools, and allocating corresponding names to the database connection pools for storing a plurality of data sources; building the incident relation between a plurality of SQL statements and the data source names, and storing the incident relation into a buffer region; traversing the SQL statements, obtaining the corresponding data source names from the buffer region according to the SQL statements, obtaining the data source from the database connection pools through the data source names, and writing the SQL statements into log files; executing the SQL statements, storing a plurality of corresponding execution results, and setting data source transaction control switch states according to the execution results. According to the technical scheme, data synchronization among all the databases can be effectively ensured.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a relational database-based cross-database transaction processing method and a relational database-based cross-database transaction processing system. Background technique [0002] With the increasing business requirements, the application program becomes more and more complex, and often needs to access multiple databases, and these databases are usually distributed in different places, which constitutes a distributed transaction. Data modified by a distributed transaction is stored in multiple or types of data sources distributed across multiple machines, and there are even more complex cases. [0003] All operations in the transaction are either completed or not performed. The condition for the success of the transaction is that all operations in the transaction are successful. As long as one operation fails, the entire transaction fails and needs to be rolled back. For exam...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/25G06F16/284
Inventor 张志红
Owner ZICT TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap