2019 VOL.2 Aug No.4

• Title: Research on Data Synchronization Method of Heterogeneous Database Based on Web Service
• Name: Monica Raschid
• Company: Delta School District
• Abstract:

  Aiming at the problem of poor synchronization effect in traditional methods, this paper proposes a research on data synchronization method of heterogeneous database based on Web Service. According to the heterogeneous database structure, the synchronous execution process is designed, and the data is uniformly encoded by using the HTTP-based SOAP transmission protocol and the XML standard, and the data source can be added or deleted at any time. The SQL statement in the heterogeneous database data synchronization control module is decomposed, and the result data returned by the database and the XML conversion function are converted into an XML format, and returned to the Web Service unified interface. The local temporary table and copy of the source database table are used to realize the synchronization of the data of the heterogeneous database based on the Web Service. Design comparison experiments can be concluded that the data synchronization effect of heterogeneous databases using the Web Service method is as high as 97%, which satisfies the normal business processing of the synchronous application system.

• Keyword: Web Service; heterogeneous database; data; synchronization
• DOI: 10.12250/jpciams2019040123
• Citation form: Monica Raschid.Research on Data Synchronization Method of Heterogeneous Database Based on Web Service[J]. Computer Informatization and Mechanical System, 2019, vol. 2, pp. 48-52.

[1] ZHOU Yu-chun, WANG Fang, WEI Li-hong, et al. Research on PDC bit bottom flow field analysis platform based on Web service[J]. Journal of Engineering Design, 2017, 24(4):380-386.

[2] Lai Qiuju, Xu Zheng, Chen Dong, et al. Architecture of basic design software for HVDC transmission based on WEB service [J]. China Power, 2018, 51(2):75-81.

[3] Lu Feng, Li Hairong, Han Yan. QoS Collaborative Filtering Recommendation for Web Services Based on Time and Space Similarity Perception[J]. Computer Engineering, 2017, 43(4):28-33.

[4] Sun Xiuting, Niu Jun, Gong Qingbo, et al. A Web Service Selection Strategy Based on Combination Weighting Method[J]. Computer Applied Research, 2017, 34(8):2408-2411.

[5] Yang Hui, Pan Qixin. Research on Mobile Synchronous Replication Conflict Resolution Method in Distributed Heterogeneous Database[J]. Science Technology and Engineering, 2017, 17(10):241-245.

[6] Pan Mingming, Li Dingding, Tang Yong, et al. A heterogeneous database fusion access method and system based on middleware[J]. Computer Science, 2018, 15 (5) :21-24.

[7] Ding Jianli, Zhou Dongxue, Wang Jing, et al. Remote database synchronization mechanism based on connection-driven SQL capture[J]. Computer Engineering, 2017, 43(9):39-42.

[8] Zhao Lishuai, Li Gengyu, Wu Zhenyu, et al. Historical Data Archiving Technology Based on Hierarchical Heterogeneous Database System[J]. Telecommunications Science, 2018, 12 (s1) :21-22.

[9] LIU Min, LI Zhi-xi, XIONG Ting. Simulation of incomplete information optimization detection under heterogeneous database[J]. Computer Simulation, 2017, 15 (11):390-394.

[10] Wu Linwei, Lu Zhenming, Gong Jinsong, et al. Distributed heterogeneous food microbial data integration using semantic web technology[J]. Chinese Journal of Biotechnology, 2017, 37(3):124-132.