The Design And Implementation Of Distributed Relational Database Transaction Manager

With the development of cloud computing,big data,IOE and other technologies,various industries are studying how to evolve from the centralized Oracle environment to the open source distributed database management system.Respond to the national call to achieve the core technology autonomous control.Because the traditional single database system cannot meet the needs of business development more and more,the bottleneck of database restricts the business development.However,the business application system of the traditional enterprise is based on Oracle.After decades of development,it has greatly promoted the production of the enterprise.Therefore,the business can be smoothly migrated to the new distributed database system.The newly researched distributed database must be fully compatible with Oracle and provide complete distributed transaction management capability to enable the business to realize transaction management.Through a lot of researches and comparison,this dissertation selected PostgreSQL database as the development and research background,studied the transaction management module in depth,transformed function calls into network interface calls,and used 2PC technology to achieve strong consistency guarantee of transactions and satisfy ACID characteristicsThis dissertation first expounds the key technologies of distributed database transaction management from the perspective of database architecture,WAL log log analysis and 2PC theory.According to PostgreSQL database,the whole structure of database,transaction management interface,WAL log storage structure and database instance structure are analyzed.Based on the in-depth study of transaction management of single PostgreSQL database,the transaction management ability of single PostgreSQL is proposed to provide a distributed transaction management network interface and internal interaction process based on 2PCOn the basis of the overall architecture of the design system,using the idea of componentization design,the internal flow of components and the list of functions of components are expounded from the perspective of data(global transaction ID,snapshot,clock,sequence,etc.)acquisition,update,data network transmission interaction,transaction log and transaction boundary.In combination with the distributed transaction manager high-availability scenario,design and ensure the ACID features and specific interaction processes of the distributed transaction manager in a high-availability environmentIn combination with the specific development and operation environment,the implementation process of core functional components is given from the perspective of function description,input and output,call relation,function call relation to database table,process logic,data structure,class definition,and core code implementation.A distributed database management system based on PostgreSQL is designed and implemented.Combined with the system function point,the system test cases are designed,and the system function test and performance test process are given.The feasibility and reliability of PostgreSQL-based distributed database management system is verifiedFinally,the research results of distributed database transaction management technology are summarized and the focus of the next stage is prospected.