A Kind of Heterogeneous Database Synchronization Mechanism Based on ETL and XML
Shi Ying-chun, Qiuju Zhang, Jing Li · International Conference on Digital Manufacturing & Automation · 2015
In the distributed database system, the data stored in the same network is distributed on different nodes. How to synchronize the database information of each node is the key problem to be solved. Unless all the nodes obtain the synchronized information in the database, distributed database may sustain integrity. If the data is not synchronized, the platform would have a negative impact. So that, data synchronization is the thing we must firstly solve in the distributed database system. Framework of ETL building data warehouse is given. Analysis and research of the new synchronization mechanism based on ETL and XML is investigated. Provincial Level solution based on the synchronization mechanism of ETL and XML is also given. This scheme is efficient and reliable and it effectively solves the heterogeneous data synchronization issue.