An efficient transaction processing method on the distributed database

Author(s):  
Qiao Sun ◽  
Lan-mei Fu ◽  
Bu-qiao Deng ◽  
Jiasong Sun
CONVERTER ◽  
2021 ◽  
pp. 100-106
Author(s):  
Haitao Li

Based on the in-depth study of the existing database synchronization model, in order to improve the cross platform ability of the system and facilitate the construction of small and medium-sized enterprise information platform, this paper proposes a heterogeneous distributed computing scheme based on Web service. The scheme uses JMS to realize the message transmission between systems, and uses web service technology to realize cross platform data reading and writing. In the aspect of distributed transaction processing, the two-phase commit protocol is improved to reduce the probability of system deadlock and effectively ensure the consistency of distributed database data. In order to improve the performance of distributed database system, cache technology is introduced, and the way of integrating cache and database transaction processing is proposed, which effectively ensures the validity of cache data. The architecture is oriented to program developers, who can develop efficient and convenient distributed database system on the basis of this architecture. Finally, this architecture is applied to the background management system of mobile express service. The running results show that the architecture can well meet the business requirements of distributed heterogeneous database system synchronization.


2016 ◽  
Vol 96 ◽  
pp. 801-810 ◽  
Author(s):  
Tsukasa Kudo ◽  
Masahiko Ishino ◽  
Kenji Saotome ◽  
Nobuhiro Kataoka

Author(s):  
Changhong Jing ◽  
Wenjie Liu ◽  
Jintao Gao ◽  
Ouya Pei

Data processing can be roughly divided into two categories, online transaction processing OLTP(on-line transaction processing) and online analytical processing OLAP(on-line analytical processing). OLTP is the main application of traditional relational databases, and it is some basic daily transaction processing, such as bank pipeline transactions and so on. OLAP is the main application of the data warehouse system, it supports some more complex data analysis operations, focuses on decision support, and provides popular and intuitive analysis results. As the amount of data processed by enterprises continues to increase, distributed databases have gradually replaced stand-alone databases and become the mainstream of applications. However, the current business supported by distributed databases is mainly based on OLTP applications, lacking OLAP implementation. This paper proposes an implementation method of HTAP for distributed database CBase, which provides an implementation method of OLAP analysis for CBase, and can easily deal with data analysis of large amounts of data.


2008 ◽  
Author(s):  
Chi Chen ◽  
Deng-guo Feng ◽  
Min Zhang ◽  
De-sheng Zhang ◽  
He-qun Xian

Sign in / Sign up

Export Citation Format

Share Document