Research on Data Synchronism Method in Heterogeneous Database Based on Web Service

Abstract

As the synchronism effect of traditional methods is poor, the research on data synchronism method in heterogeneous database based on Web Service is proposed. Based on the structure of heterogeneous database, the synchronous execution flow is designed, and HTTP based SOAP transport protocols and XML standard are used to encode the data uniformly, the data source can be added or deleted at any moment. By decomposing the SQL statement in synchronous control module of heterogeneous database, the results data returned are converted into XML format with XML conversion function and are returned to uniform Web Service interface. The data synchronization in heterogeneous database based on Web Service is achieved through the local temporary table and its copy of source database. Through the comparative experiment, the following results can be concluded: the synchronism effect of data by data synchronism method in heterogeneous database based on Web Service reached 97%, which met the requirements for dealing with normal business in synchronism application system.