Research And Practice Of Heterogeneous Distributed Database Transaction Processing Environment

This paper provides a discussion on the theory of distributed database, and then puts forward a heterogeneous distributed database management system model to solve the problems encountered while Dalian Insurance Company was realizing the data share among different kind of databases located in different area. This model can deal with distributed querying, distributed updating, distributed transaction processing and distributed recovery, and now has been partly implemented.Besides, This paper also discusses the implementation mechanism of distributed transaction processing and the distributed recovery of the model. SPOOLING technology and advanced 2PC protocol are adopted while implementing the model in order to improve the probability of success and execution efficiency of distributed transaction.