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

Abdelsalam Maatuk, Akhtar Ali, Shadi Aljawarneh

Research output: Contribution to journalArticlepeer-review

13 Citations (Scopus)


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.
Original languageEnglish
Pages (from-to)122-131
JournalRecent Patents on Computer Science
Issue number2
Publication statusPublished - Dec 2015


Dive into the research topics of 'Translating Relational Database Schemas into Object-based Schemas: University Case Study'. Together they form a unique fingerprint.

Cite this