Converting Temporal Relational Database into Temporal Object Relational Database

Abstract

This paper presents an approach for migrating existing temporal relational database (TRDB), into temporal object relational database (TORDB). This is done by enhancing a representation of a varying time database’s structure, in order to make hidden semantic explicit. In contrast to other studies, our main goal here is to offer a first and better solution to mentioned limits to existing works, in order to provide the efficient and the correct method for the translation from TRDB to TORDB. We are going to take an existing RDB using valid time features as input, enrich its metadata representation, and generate a new valid time data Model (NVTM), which captures the most important characteristics of temporal databases for conversion. From the NVTM, we will develop our TORDB design scheme in order to simplify the implementation of a temporal object. Through this UML profile, we precede to the last step, the creation of temporal object relational tables integrating valid time aspects.