Semantic Enrichment: The First Phase of Relational Database Migration

Maatuk, Abdelsalam, Ali, Akhtar and Rossiter, Nick (2010) Semantic Enrichment: The First Phase of Relational Database Migration. In: Innovations and Advances in Computer Sciences and Engineering. Springer, London, pp. 373-378. ISBN 978-90-481-3657-5

Full text not available from this repository. (Request a copy)
Official URL: http://dx.doi.org/10.1007/978-90-481-3658-2_65

Abstract

This paper presents an investigation into approaches and techniques used for database conversion. Constructing object views on top of a Relational DataBase (RDB), simple database integration and database migration are among these approaches. We present a categorisation of selected works proposed in the literature and translation techniques used for the problem of database conversion, concentrating on migrating an RDB as source into object-based and XML databases as targets. Database migration from the source into each of the targets is discussed in detail including semantic enrichment, schema translation and data conversion. Based on a detailed analysis of the existing literature, we conclude that an existing RDB can be migrated into object-based/XML databases according to available database standards. We propose an integrated method for migrating an RDB into object-based/XML databases using an intermediate Canonical Data Model (CDM), which enriches the source database’s semantics and captures characteristics of the target databases. A prototype has been implemented, which successfully translates CDM into object-oriented (ODMG 3.0 ODL), object-relational (Oracle 10g) and XML schemas.

Item Type: Book Section
Additional Information: e-ISSN: 978-90-481-3658-2
Subjects: G400 Computer Science
G500 Information Systems
Department: Faculties > Engineering and Environment > Computer and Information Sciences
Depositing User: EPrint Services
Date Deposited: 13 Aug 2009 14:37
Last Modified: 31 Jul 2021 08:39
URI: http://nrl.northumbria.ac.uk/id/eprint/670

Actions (login required)

View Item View Item

Downloads

Downloads per month over past year

View more statistics