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

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)

PDF published_-_wulfenia.pdf - Published Version Restricted to Repository staff only Download (966kB) | Request a copy

Abstract

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.

Item Type:	Article
Additional Information:	Profesor Madya Dr. Ahmed N Abd Alla (A. N. Abdalla)
Uncontrolled Keywords:	Data replication; Persistence layer; Multi-threading; Heterogeneous system
Subjects:	Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Faculty/Division:	Faculty of Computer System And Software Engineering Faculty of Electrical & Electronic Engineering
Depositing User:	PM Dr. Noraziah Ahmad
Date Deposited:	17 Sep 2014 04:32
Last Modified:	03 Oct 2018 07:40
URI:	http://umpir.ump.edu.my/id/eprint/5972
Download Statistic:	View Download Statistics

Actions (login required)

View Item