Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR)

Distributed database replication in the heterogeneous system is a very promising and challenging platform which is the compound of multi environment. Proper mechanism is significantly required in order to manage the complex heterogeneous data replication. This paper presents a new algorithm namely...

Full description

Bibliographic Details
Main Authors: Noraziah, Ahmad, Abdalla, Ahmed N., Beg, Abul Hashem
Format: Article
Language:English
Published: WULFENIA 2013
Subjects:
Online Access:http://umpir.ump.edu.my/id/eprint/5972/1/published_-_wulfenia.pdf
_version_ 1825821710837874688
author Noraziah, Ahmad
Abdalla, Ahmed N.
Beg, Abul Hashem
author_facet Noraziah, Ahmad
Abdalla, Ahmed N.
Beg, Abul Hashem
author_sort Noraziah, Ahmad
collection UMP
description Distributed database replication in the heterogeneous system is a very promising and challenging platform which is the compound of multi environment. Proper mechanism is significantly required in order to manage the complex heterogeneous data replication. This paper presents a new algorithm namely the Persistence Layer Synchronous Replication (PLSR) in order to manage the agent handling the replication. The main objective of this algorithm is to develop an adaptive persistence layer which consisted of reliable and smooth replication. It achieves faster time execution and cost minimization than that other replication processes. This algorithm also introduces a multi thread based persistence layer, which supports early binding and parallel connection to the servers. All the replication servers establish its connection through interfaces, which is furthermore, similar with the SOA (Service Oriented Architecture) and the structure is flexible enough to modify i.e.; adding and removing replication server. The performance has been compared with SQL Server in terms of transactional inserts and synchronization time. The result shows that PLSR performs outstandingly up to 83.2 % and 2.49% than that SQL server for transactional insert and time synchronization, respectively.
first_indexed 2024-03-06T11:45:39Z
format Article
id UMPir5972
institution Universiti Malaysia Pahang
language English
last_indexed 2024-03-06T11:45:39Z
publishDate 2013
publisher WULFENIA
record_format dspace
spelling UMPir59722018-10-03T07:40:35Z http://umpir.ump.edu.my/id/eprint/5972/ Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR) Noraziah, Ahmad Abdalla, Ahmed N. Beg, Abul Hashem QA75 Electronic computers. Computer science Distributed database replication in the heterogeneous system is a very promising and challenging platform which is the compound of multi environment. Proper mechanism is significantly required in order to manage the complex heterogeneous data replication. This paper presents a new algorithm namely the Persistence Layer Synchronous Replication (PLSR) in order to manage the agent handling the replication. The main objective of this algorithm is to develop an adaptive persistence layer which consisted of reliable and smooth replication. It achieves faster time execution and cost minimization than that other replication processes. This algorithm also introduces a multi thread based persistence layer, which supports early binding and parallel connection to the servers. All the replication servers establish its connection through interfaces, which is furthermore, similar with the SOA (Service Oriented Architecture) and the structure is flexible enough to modify i.e.; adding and removing replication server. The performance has been compared with SQL Server in terms of transactional inserts and synchronization time. The result shows that PLSR performs outstandingly up to 83.2 % and 2.49% than that SQL server for transactional insert and time synchronization, respectively. WULFENIA 2013 Article PeerReviewed application/pdf en http://umpir.ump.edu.my/id/eprint/5972/1/published_-_wulfenia.pdf Noraziah, Ahmad and Abdalla, Ahmed N. and Beg, Abul Hashem (2013) Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR). Wulfenia Journal, 20 (2). pp. 221-239. ISSN 1561-882X. (Published) http://multidisciplinarywulfenia.org/
spellingShingle QA75 Electronic computers. Computer science
Noraziah, Ahmad
Abdalla, Ahmed N.
Beg, Abul Hashem
Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR)
title Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR)
title_full Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR)
title_fullStr Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR)
title_full_unstemmed Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR)
title_short Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR)
title_sort managing heterogeneous database replication using persistence layer synchronous replication plsr
topic QA75 Electronic computers. Computer science
url http://umpir.ump.edu.my/id/eprint/5972/1/published_-_wulfenia.pdf
work_keys_str_mv AT noraziahahmad managingheterogeneousdatabasereplicationusingpersistencelayersynchronousreplicationplsr
AT abdallaahmedn managingheterogeneousdatabasereplicationusingpersistencelayersynchronousreplicationplsr
AT begabulhashem managingheterogeneousdatabasereplicationusingpersistencelayersynchronousreplicationplsr