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

Frame Based Postprocessor for Speech Recognition Based on Augmented Conditional Random Fields

In this paper, we present a novel postprocessor for speech recognition using the Augmented Conditional Random Field (ACRF) framework. In this framework, a primary acoustic model is used to generate state poste- rior scor...

Using Artificial Intelligence to Predict Animal Behaviour in Food Webs

Overfishing of species in the marine life has caused oceans to become deserts at a fast pace. The population of specific species such as Cod and Haddock has reduced over the years. This has affected countries that hugely...

Architecture of A Semantic Annotation of Handwritten Documents Based on the Ontology "OMOS"

In this work we propose to present an application that supports the representation of manuscript documents according to an ontological approach. The implementation of this application makes it possible to annotate semant...

An Objective Approach to Schizophrenia Recognition Utilizing an Adaptive Neuro-Fuzzy Inference (ANFIS) Model

Schizophrenia is a brain disorder that distorts the way a person thinks, acts, expresses emotions, perceives reality, and relates to others. A systematic approach and an overview perception has been carried out over the...

Urban Flood Forecast using Machine Learning on Real Time Sensor Data

All the underpasses, flyovers and drainage networks in the urban areas are designed to manage a maximum rainfall. This situation implies an accepted flood risk for any greater rainfall event. This threat is very often un...

Download PDF file
  • EP ID EP310282
  • DOI 10.14738/tmlai.54.3337
  • Views 71
  • 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