An Integrated Approach to Relational Database Migration

Maatuk, Abdelsalam, Ali, Akhtar and Rossiter, Nick (2008) An Integrated Approach to Relational Database Migration. In: International Conference on Information and Communication Technologies (IC-ICT 2008), 27 August 2008, Bannu, Pakistan.

[img]
Preview
PDF (Conference paper)
v_Ali_2008.pdf - Published Version

Download (2MB) | Preview
Official URL: http://www.ustb.edu.pk/index.php/iit-acheivements/...

Abstract

Relational DataBases (RDBs) are dominant in the market place yet they have limitations in the support of complex structure and user-defined data types provided by relatively recent database technologies (i.e., object-based and XML databases). Such a mismatch inspires work on migrating an RDB into these technologies. The problem is how to effectively migrate existing RDBs, as a source, into the recent database technologies, as targets, and what is the best way to enrich RDBs' semantics and constraints in order to meet the characteristics of these targets? Existing work does not appear to provide a solution for more than one target database. We tackle this question by proposing a solution for migrating an RDB into these targets based on available standards. The solution takes an existing RDB as input, enriches its metadata representation with as much semantics as possible, and constructs an enhanced Relational Schema Representation (RSR). Based on the RSR, a canonical data model is generated, which captures essential characteristics of the target data models that are suitable for migration. A prototype has been implemented, which successfully migrates RDBs into object-oriented, object-relational and XML databases using the canonical data model.

Item Type: Conference or Workshop Item (Paper)
Subjects: G400 Computer Science
G500 Information Systems
G600 Software Engineering
Department: Faculties > Engineering and Environment > Mathematics and Information Sciences
Related URLs:
Depositing User: Akhtar Ali
Date Deposited: 14 May 2012 08:49
Last Modified: 24 May 2017 17:25
URI: http://nrl.northumbria.ac.uk/id/eprint/7003

Actions (login required)

View Item View Item

Downloads

Downloads per month over past year

View more statistics


Policies: NRL Policies | NRL University Deposit Policy | NRL Deposit Licence