skip to main content
10.1145/3019612.3019838acmconferencesArticle/Chapter ViewAbstractPublication PagessacConference Proceedingsconference-collections
research-article

Bridging context and data warehouses through ontologies

Published:03 April 2017Publication History

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.

References

  1. D. Benslimane, A. Arara, G. Falquet, Z. Maamar, P. Thiran, and F. Gargouri. Contextual ontologies. In ADBIS, pages 168--176, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. 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 ScholarGoogle ScholarCross RefCross Ref
  3. Z. Djilani and S. Khouri. Understanding user requirements iceberg: Semantic based approach. In MEDI Conference, Springer, pages 297--310, 2015. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. J. Euzenat, J. David, A. Locoro, and A. Inants. Context-based ontology matching and data interlinking. PhD thesis, Lindicle, 2015.Google ScholarGoogle Scholar
  5. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  6. 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 ScholarGoogle Scholar
  7. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  8. 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 ScholarGoogle ScholarCross RefCross Ref
  9. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  10. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  11. Y. Pitarch, C. Favre, A. Laurent, and P. Poncelet. Enhancing flexibility and expressivity of contextual hierarchies. In IEEE ICFS, pages 1--8, 2012. Google ScholarGoogle ScholarCross RefCross Ref
  12. O. Romero, D. Calvanese, A. Abelló, and M. Rodríguez-Muro. Discovering functional dependencies for multidimensional design. In DOLAP, pages 1--8, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. 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 ScholarGoogle ScholarCross RefCross Ref

Index Terms

  1. Bridging context and data warehouses through ontologies

    Recommendations

    Comments

    Login options

    Check if you have access through your login credentials or your institution to get full access on this article.

    Sign in
    • Published in

      cover image ACM Conferences
      SAC '17: Proceedings of the Symposium on Applied Computing
      April 2017
      2004 pages
      ISBN:9781450344869
      DOI:10.1145/3019612

      Copyright © 2017 ACM

      Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

      Publisher

      Association for Computing Machinery

      New York, NY, United States

      Publication History

      • Published: 3 April 2017

      Permissions

      Request permissions about this article.

      Request Permissions

      Check for updates

      Qualifiers

      • research-article

      Acceptance Rates

      Overall Acceptance Rate1,650of6,669submissions,25%

    PDF Format

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader