Translating Relational Database Schemas into Object-based Schemas: University Case Study

Maatuk, Abdelsalam, Ali, Akhtar and Aljawarneh, Shadi (2015) Translating Relational Database Schemas into Object-based Schemas: University Case Study. Recent Patents on Computer Science, 8 (2). pp. 122-131. ISSN 2213-2759

Full text not available from this repository.

Abstract

In this paper, we present a solution for translating an existing relational database (RDB) schema with recent patents into relatively newer database (i.e., object-oriented and object-relational database) schemas, based on available standards. The solution is more beneficial compared to the existing approaches as it generates two different and equivalent target schemas based on the user choice. The main aim of the proposed method is to enrich the source RDB semantically with metadata information, which may have not been obviously represented in it. An enriched common data model is then produced, which preserves all necessary characteristics of target models to be mapped into any of the target schemas. A prototype has been designed in order to translate RDBs into target schemas realizing the concepts and algorithms of the approach. An experiment has been conducted, results of which have been very encouraging, and validating the feasibility, efficiency and correctness of the proposed solution.

Item Type:	Article
Uncontrolled Keywords:	Relational database, object-based database, schema translation
Subjects:	G400 Computer Science G500 Information Systems
Department:	Faculties > Engineering and Environment > Computer and Information Sciences
Depositing User:	Paul Burns
Date Deposited:	20 Jul 2016 12:49
Last Modified:	12 Oct 2019 22:52
URI:	http://nrl.northumbria.ac.uk/id/eprint/27326

Downloads