异构数据库数据同步分布式系统研究及实践

With the increasing application of distributed database systems, ensuring data consistency among different nodes in the database has become increasingly important, and database synchronization technology has emerged to solve such problems. This paper first studies the history, basic principles, and application scenarios of Oracle GoldenGate. Then, based on the real-time temperature monitoring system of the heavy-ion cancer treatment project, this paper designs data acquisition, database, and data synchronization. Through performance testing of data synchronization, the data acquisition plan can meet the accuracy requirements of real-time temperature data acquisition, the database design can meet the requirements of the monitoring system, and the synchronization of data from various nodes to the central database as well as the real-time monitoring of the central database on various nodes are achieved. The underlying data acquisition is completed by the PT100 sensor and PLC of PHOENIX company, and LabVIEW is used to write real-time temperature data into the local database. The data synchronization module is implemented by configuring the extraction process, delivery process, and replication process in Oracle GoldenGate. Finally, preliminary exploration is carried out on the synchronization performance of GoldenGate. Keywords: GoldenGate, heterogeneous database, data synchronization, distributed system