Towards Semantic Geo/BI: A Novel Approach for Semantically Enriching Geo/BI Data with OWL Ontological Layers (OOLAP and ODW) to Enable Semantic Exploration, Analysis and Discovery of Geospatial Business Intelligence Knowledge

Full Text (PDF, 1393KB), PP.1-13

Views: 0 Downloads: 0

Author(s)

Belko Abdoul Aziz Diallo 1,* Thierry Badard 2 Frederic Hubert 2 Sylvie Daniel 2

1. West African Science Service Centre on Climate Change and Adapted Land Use (WASCAL), Competence Centre, Ouagadougou, Burkina Faso

2. Centre de Recherche en Géomatique, Université Laval, Québec, Canada G1V 0A6

* Corresponding author.

DOI: https://doi.org/10.5815/ijieeb.2018.06.01

Received: 10 Apr. 2018 / Revised: 17 Jun. 2018 / Accepted: 6 Aug. 2018 / Published: 8 Nov. 2018

Index Terms

Business Intelligence, Geospatial Business Intelligence, semantic Geo/BI, OLAP, Data warehouse, metadata, semantic gap, semantic relations, data semantics, OWL Ontology, semantic layer, data analysis, knowledge discovery, Decision support

Abstract

To contribute in filling up the semantic gap in data warehouses and OLAP data cubes, and enable semantic exploration and reasoning on them, this paper highlights the need for semantically augmenting Geo/BI data with convenient semantic relations, and provides OWL-based ontologies (ODW and OOLAP) which are capable of replicating data warehouses (respectively OLAP data cubes) in the form semantic data with respect of Geo/BI data structures, and which enable the possibility of augmenting these semantic BI data with semantic relations. Moreover, the paper demonstrates how ODW and OOLAP ontologies can be combined to current Geo/BI data structures to deliver either pure semantic Geo/BI data or mixed semantically interrelated Geo/BI data to business professionals.

Cite This Paper

Belko Abdoul Aziz Diallo, Thierry Badard, Frédéric Hubert, Sylvie Daniel, "Towards Semantic Geo/BI: A Novel Approach for Semantically Enriching Geo/BI Data with OWL Ontological Layers (OOLAP and ODW) to Enable Semantic Exploration, Analysis and Discovery of Geospatial Business Intelligence Knowledge", International Journal of Information Engineering and Electronic Business(IJIEEB), Vol.10, No.6, pp. 1-13, 2018. DOI:10.5815/ijieeb.2018.06.01

Reference

[1]Gartner.com, "Gartner Forecasts Global Business Intelligence Market to Grow 9.7 Percent in 2011," Gartner, 18 02 2011. [Online]. Available: http://www.gartner.com/it/page.jsp?id=1553215. [Accessed 26 05 2012].
[2]Gartner.com, «Gartner Says Worldwide Business Intelligence and Analytics Market to Reach $18.3 Billion in 2017,» 17 02 2017. [En ligne]. Available: https://www.gartner.com/newsroom/id/3612617.
[3]S. Rizzi, A. Abello, J. Lechtenborger et J. Trujillo, «Research in data warehouse modeling and design:dead or alive?,» DOLAP, pp. 3-10, 2006.
[4]A. C. S. C. N. &. B. S. Sarkar, «Implementation of Graph Semantic Based Multidimensional Data Model: An Object Relational Approach,» International Journal of Computer Information System and Industrial Management Applications (IJCISIM), 3, pp. 127-136, 2011.
[5]E. Malinowski and E. Zimányi, "Hierarchies in a multidimensional model: from conceptual modeling to logical representation," Data Knowl. Eng., 59 (2), p. 348–377, 2006.
[6]C. A. Hurtado and A. O. Mendelzon, "OLAP dimension constraints," in ACM PODS, 2004.
[7]J. Lechtenborger et G. Vossen, « Multidimensional normal forms for data warehouse design,» Information Systems, vol. 28, n° %15, p. 415–434, 2003.
[8]J. Pardillo, J.-N. Maz´on et J. Trujillo, «Bridging the semantic gap in OLAP models: platform-independent queries,» DOLAP, p. 89–96, 2008.
[9]O. Glorio et J. Trujillo, «An MDA Approach for the Development of Spatial Data Warehouses,» chez DaWak, Turin, Italy, 2008.
[10]Wikipedia.org, «Model-driven architecture,» en.wikipedia.org, 26 11 2012. [En ligne]. Available: http://en.wikipedia.org/wiki/Model-driven_architecture. [Accès le 26 11 2012].
[11]Wikipedia, «Object Constraint Language,» wikipedia.org, 26 11 2012. [En ligne]. Available: http://en.wikipedia.org/wiki/Object_Constraint_Language. [Accès le 26 11 2012].
[12]Wikipedia.org, «QVT,» en.wikipedia.org, 26 11 2012. [En ligne]. Available: http://en.wikipedia.org/wiki/QVT. [Accès le 26 11 2012].
[13]V. Stefanov et B. List, «Business Metadata for the DataWarehouse - Weaving Enterprise Goals and Multidimensional Models,» chez 10th IEEE Int.Enterprise Distributed Object Computing Conference Workshops, 2006.
[14]K. Shahzad et J. Zdravkovic, «Towards Goal-driven access to Process Warehouse: Integrating Goals with Process Warehouse for Business Process Analysis,» chez Fifth IEEE International Conference on Research Challenges in Information Sciences (RCIS), Guadeloupe, France, 2011.
[15]C. Diamantini et D. Potena, «Semantic Enrichtment of Strategic Datacubes,» chez 11th International Workshop on Data Warehousing and OLAP (DOLAP 2008), New York, 2008.
[16]M. Kehlenbeck and M. Breitner, "Ontology-Based Exchange and Immediate Application of Business Calculation Definitions for Online Analytical Processing," in DaWaK 2009, 2009.
[17]M. Niinimaki et T. Niemi, «An ETL Process for OLAP Using RDF/OWL Ontologies,» Journal on Data Semantics XIII. LNCS, vol. 5530, Springer, Heidelberg, p. 97–119, 2009.
[18]T. Niemi, S. Toivonen, M. Niinimaki et J. Nummenmaa, « Ontologies with Semantic Web/grid in data integration for OLAP.,» International Journal on Semantic Web and Information Systems, Special Issue on Semantic Web and Data Warehousing 3(4), 2007.
[19]T. Niemi et M. Niinimaki, «Ontologies and summarizability in OLAP,» chez ACM Symposium on Applied Computing SAC 10, 2010.
[20]N. Shah, C. Tsai, M. Marinov, J. Cooper, P. Vitliemov et K. Chao, «Ontological On-line Analytical Processing for Integrating Energy Sensor Data,» Iete Technical Review 26, 375, 2009.
[21]T. Gu, X. Wang, H. Pung et D. Zhang, «An ontology-based context model in intelligent environments,» chez Communication Networks and Distributed Systems Modeling and Simulation Conference, San Diego, CA, USA, 2004.
[22]IHMC.US, "COE," 10 03 2012. [Online]. Available: http://www.ihmc.us/sandbox/groups/coe/wiki/welcome/attachments/d2a1b/COEmanual06.pdf. [Accessed 10 03 2012].
[23]É. Dubé, «Conception et développement d’un service web de constitution de mini cubes solap pour clients mobiles,» Msc Dep. Sciences geomatiques, Centre de Recherche en geomatique, Univ. Laval, Quebec, QC, Canada, 2008.
[24]OMG, «Common Warehouse Metamodel (CWM) specification,» Object Management Group, Inc., 2003.