A Kind of Heterogeneous Database Synchronization Mechanism

In the distributed database system, the data is stored in the different nodes of the same network. In order to achieve synchronization update of the database information, problem of data consistency and integrity turns up. Under this background, the data synchronization research on distributed database system is a hot topic. The proposed synchronization mechanism based on ETL and XML is mainly proposed by analyzing the instability of network environment and data overload while ensuring data consistency and integrity. The ETL technology effectively alleviates the server pressure and reduces network load. This scheme is efficient for mass data processing and effectively solves the problem of heterogeneous data synchronization.

[1]  Gottfried Vossen,et al.  Visioning and Engineering the Knowledge Society. A Web Science Perspective, Second World Summit on the Knowledge Society, WSKS 2009, Chania, Crete, Greece, September 16-18, 2009. Proceedings , 2009, WSKS.

[2]  Sharma Chakravarthy,et al.  Composite Events for Active Databases: Semantics, Contexts and Detection , 1994, VLDB.

[3]  Cuihong Wu,et al.  Research on application of Web based ESB in School Common Data Platform , 2009, 2009 4th International Conference on Computer Science & Education.

[4]  Jennifer Widom,et al.  The TSIMMIS Project: Integration of Heterogeneous Information Sources , 1994, IPSJ.

[5]  Jian Li,et al.  ETL tool research and implementation based on drilling data warehouse , 2010, 2010 Seventh International Conference on Fuzzy Systems and Knowledge Discovery.

[6]  Huamin Wang,et al.  An ETL Services Framework Based on Metadata , 2010, 2010 2nd International Workshop on Intelligent Systems and Applications.

[7]  A Min Tjoa,et al.  Zero-Latency Data Warehousing for Heterogeneous Data Sources and Continuous Data Streams , 2003, iiWAS.

[8]  Jie Xu,et al.  Dynamic data integration using Web services , 2004 .

[9]  Jose-Norberto Mazon,et al.  Systematic review and comparison of modeling ETL processes in data warehouse , 2010, 5th Iberian Conference on Information Systems and Technologies.

[10]  Timos K. Sellis,et al.  State-space optimization of ETL workflows , 2005, IEEE Transactions on Knowledge and Data Engineering.

[11]  Lunan Li.  A framework study of ETL processes optimization based on metadata repository , 2010, 2010 2nd International Conference on Computer Engineering and Technology.

[12]  Wu Wei,et al.  XML-based integration data model and schema mapping in multidatabase systems , 2005 .