American Journal of Embedded Systems and Applications
Volume 7, Issue 1, June 2019, Pages: 1-8
Received: Jan. 18, 2019;
Accepted: Feb. 28, 2019;
Published: Mar. 20, 2019
Views 859 Downloads 180
Fatima Kalna, Faculty of Science Ben M‘Sik, University Hassan II, Casablanca, Morocco
Abdessamad Belangour, Faculty of Science Ben M‘Sik, University Hassan II, Casablanca, Morocco
With the manifestation and evolution of Internet, several new types of data have emerged (videos, images, audio files, documents…). These new types of data classed as unstructured are more and more used and exchanged between IT systems, therefore their exploitation in Business Intelligence (BI) systems will absolutely provide a gold mine of information that guarantee a better and rich decision-making. Unfortunately BI systems don’t consider this sort of data and they are still limited to classical data sources: structured as Relational data source and semi-structured as XML files. Many research works separate the treatment and the design of a data warehouse that involves heterogeneous sources in order to avoid any problems of data integration and storage. However, the need for an approach that gathers diverse data sources still present. In this paper we appeal Model Driven Engineering (MDE) to propose a meta-model that assemble and describe all sort of structured, semi-structured and unstructured data sources such as relational, multidimensional, XML and NoSQL databases. Models conforming this meta-model will serve as an input for our BI process and for designing and modeling a data warehouse.
A Meta-model for Diverse Data Sources in Business Intelligence, American Journal of Embedded Systems and Applications.
Vol. 7, No. 1,
2019, pp. 1-8.
R. Sherman, Business Intelligence Guidebook From Data Integration to Analytics, Elsevier, 2014.
M. Chevalier, M. El Malki, O. Kopliku, R. Teste, Tournier, Multidimensional Data Warehouses NoSQL, EDA, 2015, pp.161-176.
T. Etienne, Establishment of a data warehouse for the strategic decision, Academia, 2008, pp 2.
R. Kimball, The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouse, John Wiley, 1996.
B. Inmon, Building the Data Warehouse, John Wiley and Sons, New York, 1996.
W. Brand, NoSQL For Dummies, John Wiley & Sons, 2015.
F. Abdelhadi, A. Ait Brahim, F. Atigui, G. Zurfluh, Logical Unified Modeling For NOSQL Databases, ICEIS, 2017.
J. Han, E. Haihong, G. Le, J. Du, Survey on NoSQL Database, Pervasive Computing and Applications, ICPCA 6th International Conference, 2011.
F. Atigui, Model-Driven Approach for Implementing and Reducing Data, 2013, pp 6-133.
R. Bruchez, Les bases de données NoSQL et le Big Data, Eyrolles 2nd edition 2015.
Object Management Group OMG, Common Warehouse Meta-model (CWM) Specification, Version1.1, March 2003.
X. Blanc, MDA in action: software engineering guided by models, Eyrolles, 2005.
F. Allilaire, T. Idrissi, Eclipse development tools for atl, http://www.sciences.univnantes.fr/lina/atl/Members/allilaire/Paper/ADT% AllilaireIdriss, 2004.
P. Vassiliadis, A Survey of Extract-Transform-Load Technology, International Journal of Data Warehousing and Mining IJDWM, 2009.
Object Management Group OMG, Meta Object Facility (MOF) Core Specification, Version 2.4.1, August 2011.
C. Favre, F. Bentayeb, O. Boussaid, J. Darmont, G. Gavin, N. Harbi, N. Kabachi, S. Loudcher, Data warehouses for dummies. . . or not !, 2nd Workshop helps the Decision at all Floors (EGC / AIDE) , January 2013.
F. Ravat, O. Teste, R. Tournier, G. Zuruh, Algebraic and graphic languages for olap manipulations, International Journal of Data Warehousing and Mining IJDWM, 2008, pp.17-46.
A. Abello, Big data design, DOLAP, 2015.
K. Dehbouh, F. Bentayed, O. Boussaid, N. Kabachi, Using the column oriented model for implemeting big data warehouses, PDPTA, 2015.
X3 G. Daniel, G. Sunyé, J. Cabot, UMLtoGraphDB: Mapping conceptuel schemas to graph databases, ER 2016 - 35th International Conference on Conceptual Modeling, Gifu, Japan, November 2016.
F. Abdelhedi, A. Ait Brahim, F. Atigui, G. Zurfluh, MDA-based approach for NoSQL Databases modelling, International Conference on Big Data Analytics and Knowledge Discovery (DaWaK 2017), France, 2017.