Migration of the Temporal RDB into Temporal ORDB including Bitemporal Data : Phases
Journal Title: Transactions on Machine Learning and Artificial Intelligence - Year 2017, Vol 5, Issue 4
Abstract
This paper proposes an approach for migrating existing relational database (TRDB) according to SQL: 2011 standard into temporal object relational database (TORDB) including Bitemporal data. This is done with methods that can extract various functions from a TRDB, which is based on the different kind of the relationships between tables. To do that we�re going to enhance 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 method for the translation from TRDB to TORDB. We are going to take an existing RDB with bitemporal data features as input, we provide our metamodel in order to get a correct description of a data structure, enriches its metadata representation, and generates a bitemporal data Model (BTDM), which captures essential characteristics of temporal databases for migration. A prototype has been developed which proves the effectiveness of this solution, and temporal queries has been made with help of Oracle 12C.
Authors and Affiliations
Ain El Hayat Soumiya, Bahaj Mohamed
Keywords
Related Articles
- EP ID EP308355
- DOI 10.14738/tmlai.54.2977
- Views 59
- Downloads 0
Automatic Tool Selection System based on STEP_NC and ISO13399 Standards
Computer Aided Process Planning (CAPP) is considered as an essential component of Computer Integrated manufacturing (CIM) environment and it is an important interface between Computer Aided Design (CAD) and Computer Aide...
Combining Overall and Target Oriented Sentiment Analysis over Portuguese Text from Social Media
This document describes an approach to perform sentiment analysis on social media Portuguese content. In a single system, we perform polarity classification for both the overall sentiment, and target oriented sentiment....
Robust Fuzzy Neural Network Sliding Mode Control for Wind Turbine with a Permanent Magnet Synchronous Generator
In the present paper, we are interested in the contribution of wind power to the electricity supply in power systems of small sized isolated communities. A robust fuzzy neural sliding control (FNSC) is proposed to track...
The GeoRSS Model and the Design of a Ranking Algorithm in Semantic Web
Ecommerce has become nowadays an influential actor in the international trade industry and has greatly contributed in the economic development of nations. The fact of dealing with this field along with the evolution of t...
Hello Message Scheme Enhancement in MANET based on Neighbor Mobility
The key idea behind the routing protocols based in multi hope is to find the required path from the source node to the destination. Since those protocols does not consider the node mobility in their mechanism, we propose...