Converting relational databases into object relational databases

Abdelsalam Maatuk, Akhtar Ali, Nick Rossiter

Research output: Contribution to journalArticlepeer-review

11 Citations (Scopus)

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.
Original languageEnglish
Pages (from-to)145-161
JournalJournal of Object Technology
Volume9
Issue number2
DOIs
Publication statusPublished - Mar 2010

Fingerprint

Dive into the research topics of 'Converting relational databases into object relational databases'. Together they form a unique fingerprint.

Cite this