Toward Multi-Approach Model for Semi-Automating a Data Warehouse Design from an Ontology
Journal Title: Transactions on Machine Learning and Artificial Intelligence - Year 2017, Vol 5, Issue 4
Abstract
The proliferation of projects that are part of the semantic Web is truly impressive. In fact, ontologies become increasingly present in information systems, they constitute great data sources that arouse the interest of being analyzed. Ontologies are used for standardizing, structuring and formalizing the Web, Web Service, Elearning systems, and other fields. Regarding multidimensional approaches, researches in this field have focused on direct Data Warehouse conception from an ontology, which do not integrate the intervention of the expert in this process. In this case, the transformations are global and not very customizable; it can reproduce the inherent defects from the data sources into the resulting data warehouse. In this paper, we propose a new multiapproach model based on the coupling of relational database design approaches from an ontology with Data Warehouse design approaches from a relational database. Our model is semiautomatic allowing Data Warehouse design from an ontology by giving the designer more ability to intervene in this process and closely control the transformations. To assess the usefulness of our approach, we evaluated it by applying it on an example case study. The results of the example show that our approach is more accurate in terms of useful data filtering and adaptation of the multidimensional model to the endusers businessneeds. KeywordsSemantic Web; Business Intelligence; Data Warehouse
Authors and Affiliations
Morad Hajji, Mohammed Qbadou, Khalifa Mansouri
Keywords
Related Articles
- EP ID EP310282
- DOI 10.14738/tmlai.54.3337
- Views 79
- Downloads 0
Opinion Mining Using Sequence Labelling
Opinion mining aims to determine the attitude of a person by identifying and extracting subjective information. The attitude is the judgement, evaluation or emotional state of the person towards a product, or service or...
Migration of the Temporal RDB into Temporal ORDB including Bitemporal Data : Phases
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...
A Metaheuristic Procedure for Calculating Optimal Osmotic Dehydration Parameters: A Case Study of Mushrooms
The Firefly Algorithm (FA) metaheuristic is employed to determine the optimal parameter settings in a case study of the osmotic dehydration of mushrooms. In the case, the functional form of the dehydration model is estab...
Comparison Performance Evaluation of Modified Genetic Algorithm and Modified Counter Propagation Network for Online Character recognition
This paper carries out performance evaluation of a Modified Genetic Algorithm (MGA) and Modified Counter Propagation Network (MCPN) Network for online character recognition. Two techniques were used to train the feature...
Handengineered Features vs Automated Features for Arabic Handwriting Recognition
This work aims to compare the learning features with Convolutional Neural Networks (CNNs) and the handcrafted features. In order to determine the relevant features among of those kinds. We consider our previous baseline...