Converting relational databases into object relational databases

Maatuk, Abdelsalam, Ali, Akhtar and Rossiter, Nick (2010) Converting relational databases into object relational databases. Journal of Object Technology, 9 (2). pp. 145-161. ISSN 1660-1769

[img]
Preview
PDF (Article)
Maatuk A, Ali MA, Rossiter N - Converting relational databases into... Article.pdf

Download (3MB) | Preview
Official URL: http://dx.doi.org/10.5381/jot.2010.9.2.a3

Abstract

This paper proposes an approach for migrating existing Relational DataBases (RDBs) into Object-Relational DataBases (ORDBs). The approach is superior to existing proposals as it can generate not only the target schema but also the data instances. The solution takes an existing RDB as input, enriches its metadata representation with required semantics, and generates an enhanced canonical data model, which captures essential characteristics of the target ORDB, and is suitable for migration. A prototype has been developed, which migrates successfully RDBs into ORDBs (Oracle 11g) based on the canonical model. The experimental results were very encouraging, demonstrating that the proposed approach is feasible, efficient and correct.

Item Type: Article
Subjects: G900 Others in Mathematical and Computing Sciences
Department: Faculties > Engineering and Environment > Computer and Information Sciences
Related URLs:
Depositing User: EPrint Services
Date Deposited: 20 Aug 2009 14:17
Last Modified: 08 May 2017 11:04
URI: http://nrl.northumbria.ac.uk/id/eprint/3277

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