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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Kuang, Y.C., Wang, F., Wei, L.H., et al.: Research on the bottom hole flow field analysis platform of PDC bit based on Web service. Chin. J. Eng. Des. 24(4), 380–386 (2017)
Lai, Q.J., Xu, Z., Chen, D., et al.: Architecture of HVDC transmission design software based on WEB service. China Power 51(2), 75–81 (2018)
Cui, H.X., Feng, J., Ma, W.J., et al.: Research and implementation of heterogeneous database synchronization based on netgap. Softw. Eng. 19(2), 10–13 (2016)
Ding, J.L., Zhou, D.X., Wang, J., et al.: Remote database synchronization mechanism based on SQL capture from connection driver. Comput. Eng. 43(9), 39–42 (2017)
He, S.T., Xue, L.S., Chen, X.H., et al.: Research on digital multiplex system with FPGA. Fire Control Command Control 41(8), 37–40 (2016)
Pan, M.M., Li, D.D., Tang, Y., et al.: Design and implementation of accessing hybrid database systems based on middleware. Comput. Sci. 15(5), 21–24 (2018)
Zhao, L.S., Li, G.Y., Wu, Z.Y., et al.: Historical data archiving technology based on hierarchical heterogeneous database system. Telecommun. Sci. 12(s1), 21–22 (2018)
Liu, M., Li, Z.B., Xiong, T.: Simulation research of incomplete information optimization detection in heterogeneous database. Comput. Simul. 15(11), 390–394 (2017)
Wu, L.H., Lu, Z.M., Gong, J.S., et al.: Integrating distributed heterogeneous food microorganism data by semantic web technology. China Biotechnol. 37(3), 124–132 (2017)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 ICST Institute for Computer Sciences, Social Informatics and Telecommunications Engineering
About this paper
Cite this paper
Li, Y., Xuan, H. (2019). Research on Data Synchronism Method in Heterogeneous Database Based on Web Service. In: Liu, S., Yang, G. (eds) Advanced Hybrid Information Processing. ADHIP 2018. Lecture Notes of the Institute for Computer Sciences, Social Informatics and Telecommunications Engineering, vol 279. Springer, Cham. https://doi.org/10.1007/978-3-030-19086-6_18
Download citation
DOI: https://doi.org/10.1007/978-3-030-19086-6_18
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-19085-9
Online ISBN: 978-3-030-19086-6
eBook Packages: Computer ScienceComputer Science (R0)