Research Article
Research on Data Synchronism Method in Heterogeneous Database Based on Web Service
@INPROCEEDINGS{10.1007/978-3-030-19086-6_18, author={Yuze Li and Hui Xuan}, title={Research on Data Synchronism Method in Heterogeneous Database Based on Web Service}, proceedings={Advanced Hybrid Information Processing. Second EAI International Conference, ADHIP 2018, Yiyang, China, October 5-6, 2018, Proceedings}, proceedings_a={ADHIP}, year={2019}, month={5}, keywords={Web Service Heterogeneous database data Synchronization}, doi={10.1007/978-3-030-19086-6_18} }- Yuze Li
Hui Xuan
Year: 2019
Research on Data Synchronism Method in Heterogeneous Database Based on Web Service
ADHIP
Springer
DOI: 10.1007/978-3-030-19086-6_18
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.