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

English Premier League (EPL) Soccer Matches Prediction using An Adaptive Neuro-Fuzzy Inference System (ANFIS) for

Prediction of English Premiership League (EPL) matches has been on the heart and minds of researcher over the pass decades, but none has sufficiently introduced and Adaptive Neuro-Fuzzy Inference System (ANFIS) approach...

Design of a Smart Model For Geolocalisation and E-commerce in the Semantic Web

Currently, ecommerce has become a pillar of the economy; there are huge growths of websites that offer different products to sell.This variety of web portals and products requires intelligent and autonomous operation to...

3D HMM-based Facial Expression Recognition using Histogram of Oriented Optical Flow

In this paper, we propose a 3D HMM (Three-dimensional Hidden Markov Models) approach to recognizing human facial expressions and associated emotions. Human emotion is usually classified by psychologists into six categori...

IoT Middleware Architecture based on Ontologies to Model Logistic Process

In recent years, the Internet of Things (IoT) become a promising topic of technical social and economic significance, especially with the high number of developed sensors and technologies. Logistic applications are a per...

Application of Genetic Algorithms Coupled with Neural Networks to Optimization of Reinforced Concrete Footings

This paper first applies genetic algorithms to optimally design reinforced concrete isolated footings subjected to concentric loading. Based on the ACI Building Code, constraints are built by considering wide-beam and pu...

Download PDF file
  • EP ID EP310282
  • DOI 10.14738/tmlai.54.3337
  • Views 45
  • Downloads 0

How To Cite

Morad Hajji, Mohammed Qbadou, Khalifa Mansouri (2017). Toward Multi-Approach Model for Semi-Automating a Data Warehouse Design from an Ontology. Transactions on Machine Learning and Artificial Intelligence, 5(4), 736-745. https://europub.co.uk/articles/-A-310282