ABSTRACT
Nowadays, we are assisting to three continuously demands from companies: (i) developing analytical applications around Data Warehouse systems (DW) from numerous data sources, (ii) the explicitation the semantic of these sources to reduce heterogeneities and (iii) contextualization of sources. By examining the literature, we identify the existence of several efforts attempting to offer solutions merging these three issues. The merging has been performed partially. To be more concrete, we have identified that the two first demands have been merged. Similarly, the second and the third ones gave raise to contextual ontologies. Unfortunately, all three are not well merged. This paper proposes a comprehensive methodology to design multi-contextual semantic DWs. Our approach consists first in merging context and ontologies and then with DWs. Firstly, a connection between ontologies and context model is built at meta model level. Secondly, a formalization of multi-contextual semantic data warehouse is given, followed by a deep description of the most important steps of the data warehouse design. Finally, a case tool and experiments are conducted using a contextualized hospital ontology to show the effectiveness of our approach.
- D. Benslimane, A. Arara, G. Falquet, Z. Maamar, P. Thiran, and F. Gargouri. Contextual ontologies. In ADBIS, pages 168--176, 2006. Google ScholarDigital Library
- D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi, and R. Rosati. Data integration in data warehousing. International Journal of Cooperative Information Systems, 10(03):237--271, 2001. Google ScholarCross Ref
- Z. Djilani and S. Khouri. Understanding user requirements iceberg: Semantic based approach. In MEDI Conference, Springer, pages 297--310, 2015. Google ScholarDigital Library
- J. Euzenat, J. David, A. Locoro, and A. Inants. Context-based ontology matching and data interlinking. PhD thesis, Lindicle, 2015.Google Scholar
- I. Garrigós, J. Pardillo, J.-N. Mazón, and J. Trujillo. A conceptual modeling approach for olap personalization. In ER, pages 401--414. Springer, 2009. Google ScholarDigital Library
- B. Kämpgen, S. O'Riain, and A. Harth. Interacting with statistical linked data via olap operations. In Extended Semantic Web Conference, pages 87--101. Springer, 2012.Google Scholar
- S. Khouri, I. Boukhari, L. Bellatreche, S. Jean, E. Sardet, and M. Baron. Ontology-based structured web data warehouses for sustainable interoperability: requirement modeling, design methodology and tool. Computers in Industry, pages 799--812, 2012. Google ScholarDigital Library
- S. Khouri, L. El Saraj, L. Bellatreche, B. Espinasse, N. Berkani, S. Rodier, and T. Libourel. Cidhouse: contextual semantic data warehouses. In DEXA, pages 458--465. Springer, 2013. Google ScholarCross Ref
- L. Oukid, O. Asfari, F. Bentayeb, N. Benblidia, and O. Boussaid. Cxt-cube: contextual text cube model and aggregation operator for text olap. In DOLAP, pages 27--32. ACM, 2013. Google ScholarDigital Library
- J. M. Pérez, R. Berlanga, M. J. Aramburu, and T. B. Pedersen. A relevance-extended multi-dimensional model for a data warehouse contextualized with documents. In DOLAP, pages 19--28. ACM, 2005. Google ScholarDigital Library
- Y. Pitarch, C. Favre, A. Laurent, and P. Poncelet. Enhancing flexibility and expressivity of contextual hierarchies. In IEEE ICFS, pages 1--8, 2012. Google ScholarCross Ref
- O. Romero, D. Calvanese, A. Abelló, and M. Rodríguez-Muro. Discovering functional dependencies for multidimensional design. In DOLAP, pages 1--8, 2009. Google ScholarDigital Library
- D. Skoutas and A. Simitsis. Ontology-based conceptual design of etl processes for both structured and semi-structured data. IJSWIS, 3(4):1--24, 2007. Google ScholarCross Ref
Index Terms
- Bridging context and data warehouses through ontologies
Recommendations
Using Ontologies as Context for Data Warehouse Quality Assessment
Big Data Analytics and Knowledge DiscoveryAbstractIn Data Warehouse systems, Data Quality has an important role since quality of data is compromised throughout the Data Warehouse lifecycle. Data Quality is context-dependent and this fact should be considered in its management. This work is a step ...
An ETL process for OLAP using RDF/OWL ontologies
Journal on Data Semantics XIIIIn this paper, we present an advanced method for on-demand construction of OLAP cubes for ROLAP systems. The method contains the steps from cube design to ETL but focuses on ETL. Actual data analysis can then be done using the tools and methods of the ...
Reconciling Context, Observations and Sensors in Ontologies for Pervasive Computing
SMAP '11: Proceedings of the 2011 Sixth International Workshop on Semantic Media Adaptation and PersonalizationThere have been several ontologies developed for context-aware systems and frameworks based on semantic reasoning. In parallel, efforts have been made towards the realisation of ontologies for sensors and observations. While the main inputs of context-...
Comments