ANNOTATING DATA WITH MULTIDIMENSIONAL PROPERTIES
Keywords:Data warehousing, Multidimensional modeling, Web semantic, Data Integration, Business Intelligence.
AbstractThe 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.
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.
How to Cite
LicenseInternational Journal of Computing is an open access journal. Authors who publish with this journal agree to the following terms:
• Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
• Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
• Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.