Abstract
Inconsistencies and lack of uniformity of data and its structure is a deep-seated problem of data synchronization in heterogeneous database environment. In this paper, we proposed a model and a unique algorithm to synchronize data between heterogeneous databases, in order to provide alternative synchronization paths, concurrency in operation and bidirectional mode of data exchange. To achieve this feat, three separate algorithms are generated. In addition, jQuery technology is adopted to determine the active path, and the data is transmitted via web service that operates on XML technology over HTTP protocol. The model is independent of any database vendor or proprietary solutions and can be adapted to any database or platform. While fulfilling the set objectives, our proposed algorithm managed to provide an efficient data exchange mechanism for distributed databases using 3 steps for proper consistency and synchronization along with network utilization when tested with three different databases.
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
Preview
Unable to display preview. Download preview PDF.
References
Wiesmann, M., Pedoney, F., Schiper, A., Kemmez, B., Alonsoz, G.: Database Replication Techniques: a Three Parameter Classification. In: Proc. 19th IEEE Symp. Reliab. Distrib. Syst. (2000)
Lu, Z., Zhang, C., Liu, Z.: Optimization of Heterogeneous Databases Data Synchronization in WAN by Virtual Log Compression. In: Second Int. Conf. Futur. Networks, ICFN 2010, pp. 98–101 (January 2010)
Geng, Y., Zhao, Z., Kong, X.: Synchronization System among Remote Heterogeneous Database Systems. In: 2008 IEEE Int. Symp. Knowl. Acquis. Model. Work. (2008)
Zhang, Z., Lu, C.: Research and Implementation for Data Synchronization of Heterogeneous Databases. In: 2010 Int. Conf. on Comput. Commun. Technol. Agric. Eng. (CCTAE), vol. 3, June 12-13, pp. 464–466 (2010)
Selman, I.D., Gb, S., Bergman, R., Us, C.O., Neil, E.K.O.: (12) United States Patent Selman et al. (10) Patent No.: (45) Date of Patent 2(12) (2008)
Gajjam, N., Apte, S.S.: Mobile Agent based Communication Platform for Heterogeneous Distributed Database 2(9), 203–207 (2013)
Sethia, D., Mehta, S., Chodhary, A., Bhatt, K., Bhatnagar, S.: MRDMS-Mobile Replicated Database Management Synchronization. In: 2014 Int. Conf. Signal Process. Integr. Networks, pp. 624–631 (2014)
Stage, A.: Synchronization and replication in the context of mobile applications, pp. 1–16 (2005)
Stage, A.: Synchronization and replication in the context of mobile applications. In: Second International Conference on ICFN 2010, pp. 98–101 (2012)
Oracle®, Database Lite Developer’s Guide 10g (10.0.0) Part No. B13788-0
Vazquez-Briseno, M., Vincent, P., Nieto-Hipolito, J.I., Sanchez-Lopez, J.D.: Design and Implementation of an Automated Mobile Applications Generator for Remote Database Access 9(3), 351–357 (2011)
Yang, G.: Data Synchronization for Integration Systems based on Trigger, pp. 310–312 (2010)
Rayns, C., Burgess, G., Cooper, P., Fitzgerald, T., Goyal, A., Klein, P., Li, G.Q., Liu, S., Sun, Y.: Front cover Application Development for CICS. Contract (2015)
Narayan, S.: What is jQuery and how to start using jQuery (2011), http://www.codeproject.com/Articles/157446/What-is-jQuery-and-how-to-Start-using-jQuery (accessed: February 02, 2015)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Imam, A.A., Basri, S.B., Ahmad, R.B. (2015). Synchronization Algorithm for Remote Heterogeneous Database Environment. In: Silhavy, R., Senkerik, R., Oplatkova, Z., Prokopova, Z., Silhavy, P. (eds) Software Engineering in Intelligent Systems. Advances in Intelligent Systems and Computing, vol 349. Springer, Cham. https://doi.org/10.1007/978-3-319-18473-9_6
Download citation
DOI: https://doi.org/10.1007/978-3-319-18473-9_6
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-18472-2
Online ISBN: 978-3-319-18473-9
eBook Packages: EngineeringEngineering (R0)