Generic placeholder image

Recent Patents on Computer Science

Editor-in-Chief

ISSN (Print): 2213-2759
ISSN (Online): 1874-4796

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

Author(s): Abdelsalam M. Maatuk, Muhammad A. Ali and Shadi Aljawarneh

Volume 8, Issue 2, 2015

Page: [122 - 131] Pages: 10

DOI: 10.2174/2213275908666150710174102

Price: $65

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.

Keywords: Relational database, object-based database, schema translation.


Rights & Permissions Print Cite
© 2024 Bentham Science Publishers | Privacy Policy