Open Access Open Access  Restricted Access Subscription Access

ANNOTATING DATA WITH MULTIDIMENSIONAL PROPERTIES

Yassine Laadidi, Mohamed Bahaj

Abstract


The evolution of web technologies and the data we are manipulating announce profound changes on Business Intelligence (BI) systems and open up important researches and innovations particularly in multidimensional data modeling and data integration. The emergence of the semantic Web highlights the need of including external data sources in the BI system. The semantic web came with Resource Description Framework (RDF) model to describe data over the Web by annotating resources with semantics and properties and consequently establishing reasoning mechanisms. However, integrating and/or analyzing information from Wide World Sources still a very challenging process because of their “unpredictability” and heterogeneity. Consequently, the transition to an open BI/SW system is required to handle automatic alteration on structures and enabling discovery of multidimensional entities over multiple Web sources. In this paper, we introduce our prospective approach and architecture for including external data sources in an open BI/SW system and we provide an automatic method aimed to define multidimensional entities and properties over different sources for data acquisition and data analysis requests.

Keywords


Data warehousing; Multidimensional modeling; Web semantic; Data Integration; Business Intelligence.

Full Text:

PDF

References


R. Kimball, M. Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, John Wiley & Sons, 2011.

Y. Laadidi, M. Bahaj, “Data integration system for RDF Data Sources,” Journal of Theoretical & Applied Information Technology, vol. 83, no. 2, pp. 195-200, 2016.

OBITKO, Web Ontology Language OWL, [Online]. Available at: https://www.obitko.com/tutorials/ontologies-semantic-web/web-ontology-language-owl.html, last accessed 2017/08/01.

V. Nebot, R. Berlanga, “Building data warehouses with semantic web data,” Decision Support Systems, vol. 52, issue 4, pp. 853-868, 2012.

O. Romero, & A. Abelló, “A framework for multidimensional design of data warehouses from ontologies,” Data & Knowledge Engineering, vol. 69, issue 11, pp. 1138-1157, 2010.

M. Gulić, “Transformation of OWL ontology sources into data warehouse,” Proceedings of the IEEE 36th International Convention on Information and Communication Technology Electronics and Microelectronics (MIPRO), 2013, pp. 1143-1148.

H. Wache, T. Voegele, U. Visser, et al., “Ontology-based integration of information-a survey of existing approaches,” Proceedings of the IJCAI-01 Workshop: Ontologies and Information Sharing, 2001, pp. 108-117.

B. Vrdoljak, M. Banek, S. Rizzi, “Designing web warehouses from XML schemas,” Proceedings of the International Conference on Data Warehousing and Knowledge Discovery, Springer, Berlin, Heidelberg, September 2003, pp. 89-98.

L.T.T. Ho, C.P.T. Tran, Q. Hoang, “An approach of transforming ontologies into relational databases,” Proceedings of the Asian Conference on Intelligent Information and Database Systems, Springer, Cham, 2015, pp. 149-158.

The RDF Data Cube Vocabulary, [Online]. Available at: https://www.w3.org/TR/vocab-data-cube/, W3C Recommendation 16 January 2014, last accessed 2017/08/01.

M. Bouza, B. Elliot, L. Etcheverry, et al., “Publishing and querying government multidimensional data using QB4OLAP,” Proceedings of the IEEE 9th Latin American Web Congress (LA-WEB-2014), 2014, pp. 82-90.

O. Romero, A. Abelló, “Open access semantic aware business intelligence,” European Business Intelligence Summer School, Springer, Cham, 2013, pp. 121-149.

H. Wache, T. Vögele, U. Visser, H. Stuckenschmidt, G. Schuster, H. Neumann, and S. Hübner, “Ontology-based integration of information – A survey of existing approaches,” Proceedings of the IJCAI-01 Workshop: Ontologies and Information Sharing, Seattle, WA, 2001, pp. 108-117.

W.H. Inmon, “What is a data warehouse,” Prism Tech Topic, vol. 1, no 1, 1995.

R. J. Santos, J. Bernardino, “Real-time data warehouse loading methodology,” Proceedings of the 2008 ACM International Symposium on Database Engineering & Applications, September 2008, pp. 49-58.

A. Abello, et al., “Using semantic web technologies for exploratory OLAP: a survey,” IEEE Trans. Knowl. Data Eng., vol. 27, issue 2, pp. 571–588, 2015.

N. Prat, I. Megdiche, J, Akoka, “Multidimensional models meet the semantic web: defining and reasoning on OWL-DL ontologies for OLAP,” Proceedings of the ACM Fifteenth International Workshop on Data Warehousing and OLAP, ACM, 2012, pp. 17-24.

B. Neumayr, C. Schütz, M. Schrefl, “Semantic enrichment of OLAP cubes: multi-dimensional ontologies and their representation in SQL and OWL,” Proceedings of the OTM Confederated International Conferences “On the Move to Meaningful Internet Systems”, Springer, Berlin, Heidelberg, 2013, pp. 624-641.

I. Astrova, N. Korda, Ahto Kalja, “Storing OWL ontologies in SQL relational databases,” International Journal of Electrical, Computer and Systems Engineering, vol. 1, issue 4, pp. 242-247, 2007.

E. Vysniauskas, L. Nemuraite, “Mapping of OWL ontology concepts to RDB schemas. Information Technologies,” Proceedings of the 15th International Conference on Information and Software Technologies, IT 2009, Kaunas, Lithuania, April 23-24, 2009, pp. 317-327.

X. Liu, Data Warehousing Technologies for Large-scale and Right-time Data, PhD Thesis, Aalborg University, 2012.

K. Selma, et al., “Ontology-based structured web data warehouses for sustainable interoperability: requirement modeling, design methodology and tool,” Computers in Industry, vol. 63, issue 8, pp. 799-812, 2012.

S. Khouri, B. Ladjel, “A methodology and tool for conceptual designing a data warehouse from ontology-based sources,” Proceedings of the ACM 13th International Workshop on Data Warehousing and OLAP, 2010, pp. 19-24.

M. Niinimäki, T. Niemi, “An ETL process for OLAP using RDF/OWL ontologies,” Journal on Data Semantics XIII, Lecture Notes in Computer Science, vol 5530. Springer, Berlin, Heidelberg, pp. 97-119, 2009.

A. Berro, I. Megdiche-Bousarsar, O. Teste, “Transformer les open data brutes en graphes enrichis en vue d'une intégration dans les systèmes OLAP,” INFormatique des Organisations et Systemes d'Information et de Decision (INFORSID), 2014, pp. 1-16. (in French)

C. Ballard, D. M. Farrell, A. Gupta, et al., Dimensional Modeling: In a Business Intelligence Environment, IBM Redbooks, 2012.


Refbacks

  • There are currently no refbacks.
hgs yükleme