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/
http://umpir.ump.edu.my/id/eprint/5972/
http://umpir.ump.edu.my/id/eprint/5972/1/published_-_wulfenia.pdf
id ump-5972
recordtype eprints
spelling ump-59722018-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 http://multidisciplinarywulfenia.org/
repository_type Digital Repository
institution_category Local University
institution Universiti Malaysia Pahang
building UMP Institutional Repository
collection Online Access
language English
topic QA75 Electronic computers. Computer science
spellingShingle QA75 Electronic computers. Computer science
Noraziah, Ahmad
Abdalla, Ahmed N.
Beg, Abul Hashem
Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR)
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.
format Article
author Noraziah, Ahmad
Abdalla, Ahmed N.
Beg, Abul Hashem
author_facet Noraziah, Ahmad
Abdalla, Ahmed N.
Beg, Abul Hashem
author_sort Noraziah, Ahmad
title Managing Heterogeneous Database Replication Using Persistence Layer Synchronous Replication (PLSR)
title_short 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_sort managing heterogeneous database replication using persistence layer synchronous replication (plsr)
publisher WULFENIA
publishDate 2013
url http://umpir.ump.edu.my/id/eprint/5972/
http://umpir.ump.edu.my/id/eprint/5972/
http://umpir.ump.edu.my/id/eprint/5972/1/published_-_wulfenia.pdf
first_indexed 2023-09-18T22:01:26Z
last_indexed 2023-09-18T22:01:26Z
_version_ 1777414425045630976