Synchronization algorithm for remote heterogeneous database environment

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 sync...

Full description

Main Authors: Imam, A.A., Basri, S.B., Ahmad, R.B.
Format: Article
Institution: Universiti Teknologi Petronas
Record Id / ISBN-0: utp-eprints.26275 /
Published: Springer Verlag 2015
Online Access: https://www.scopus.com/inward/record.uri?eid=2-s2.0-84942768464&doi=10.1007%2f978-3-319-18473-9_6&partnerID=40&md5=0f7684fc5f34f0bcc10aaa17439465ca
http://eprints.utp.edu.my/26275/
Tags: Add Tag
No Tags, Be the first to tag this record!
id utp-eprints.26275
recordtype eprints
spelling utp-eprints.262752021-08-30T07:16:58Z Synchronization algorithm for remote heterogeneous database environment Imam, A.A. Basri, S.B. Ahmad, R.B. 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. © Springer International Publishing Switzerland 2015. Springer Verlag 2015 Article NonPeerReviewed https://www.scopus.com/inward/record.uri?eid=2-s2.0-84942768464&doi=10.1007%2f978-3-319-18473-9_6&partnerID=40&md5=0f7684fc5f34f0bcc10aaa17439465ca Imam, A.A. and Basri, S.B. and Ahmad, R.B. (2015) Synchronization algorithm for remote heterogeneous database environment. Advances in Intelligent Systems and Computing, 349 . pp. 55-65. http://eprints.utp.edu.my/26275/
institution Universiti Teknologi Petronas
collection UTP Institutional Repository
description 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. © Springer International Publishing Switzerland 2015.
format Article
author Imam, A.A.
Basri, S.B.
Ahmad, R.B.
spellingShingle Imam, A.A.
Basri, S.B.
Ahmad, R.B.
Synchronization algorithm for remote heterogeneous database environment
author_sort Imam, A.A.
title Synchronization algorithm for remote heterogeneous database environment
title_short Synchronization algorithm for remote heterogeneous database environment
title_full Synchronization algorithm for remote heterogeneous database environment
title_fullStr Synchronization algorithm for remote heterogeneous database environment
title_full_unstemmed Synchronization algorithm for remote heterogeneous database environment
title_sort synchronization algorithm for remote heterogeneous database environment
publisher Springer Verlag
publishDate 2015
url https://www.scopus.com/inward/record.uri?eid=2-s2.0-84942768464&doi=10.1007%2f978-3-319-18473-9_6&partnerID=40&md5=0f7684fc5f34f0bcc10aaa17439465ca
http://eprints.utp.edu.my/26275/
_version_ 1741197112136171520
score 11.62408

Similar Items