Towards Eclipse Plug-ins for Automated Data Warehouse Design from an Ontology

The Semantic Web is experiencing a rise in recent years. As a result, ontologies have become ubiquitous in many areas while attracting growing interest from researchers. However, this knowledge representation model escapes to multidimensional analysis due to the lack of tools allowing the transition from the ontological model to the multidimensional model. In this contribution, we present our approach for the implementation of our multi-approaches model for the automatic generation of a Data Warehouse model from an ontology. In this context, we have first developed an Eclipse Plug-in for generating a conceptual model of a relational database from an ontology. Secondly, we have developed another Eclipse Plug-in for generating a Data Warehouse model from a database model. And finally, we have integrated these two plug-ins, based on model-to-model transformation and to build an automated design solution for a Data Warehouse model from an ontology.