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
A Model Driven Approach for Modeling and Generating PHP CodeIgniter based Applicationspring
During the last decade, web development industry has grown exponentially. Models have been introduced as a solution to face the challenge of both business and technology changes. In this article, we present a Model Drive...
The Adept K-Nearest Neighbour Algorithm - An optimization to the Conventional K-Nearest Neighbour Algorithm
This research aims to study the efficiency of a well-known classification algorithm, K-Nearest Neighbour, and suggest a new classification method, an optimised version than one of the existing classification method. The...
Sentiment Analysis tool for Pharmaceutical Industry & Healthcare
Sentiment analysis (SA) is broadly used to analyze people’s opinions about a product or an event to identify breakpoints in public opinion. Particularly, pharmaceutical companies use SA to ensure they gain a competitive...
Contribution to the Measurement of Organizational Performance based on A Multi-Agent Approach
This research focuses on evaluating and analyzing the organizational performance of a risk management unit within banks. The main proposal is to analyze and simulate the process of risk management based on decision suppo...
Creatinine, Urea and Uric Acid in Hospitalized Patients with and Without Hyperglycemia Analysis using Generalized Additive Model
Hyperglycemia is an important risk factor for heart disease and premature mortality. In hospitalized patients, it is related to an increase in morbidity and development of other disease like kidney disease. To evaluate t...