Abstract
The choice on information representation is extremely important to fulfil analysis requirements, making the modelling task fundamental in the Business Intelligence (BI) lifecycle. The semantic expressiveness in multidimensional (MD) design is an issue that has been studied for some years now. Nevertheless, the lack of conceptualization constructs from real world phenomena in MD design is still a challenge. This paper presents an ontological approach for the derivation of MD schemas, using categories from a foundational ontology (FO) to analyse the data source domains as a well-founded ontology. The approach is exemplified through a real scenario of the Brazilian electrical system, supporting the joint exploration of electrical disturbances data and their possible repercussion on the news.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abelló, A.: YAM: A Multidimensional Conceptual Model. PhD Thesis (2002)
Berlanga, R., Romero, O., Simitsis, A., Nebot, V., Pedersen, T., Abelló, A.: SW Technologies for BI. In: BI App and the Web: Models, Systems, and Technologies (2011)
Guizzardi, G., Wagner, G., de Almeida Falbo, R., Guizzardi, R.S.S., Almeida, J.P.A.: Towards Ontological Foundations for the Conceptual Modeling of Events. In: Ng, W., Storey, V.C., Trujillo, J.C. (eds.) ER 2013. LNCS, vol. 8217, pp. 327–341. Springer, Heidelberg (2013)
Guizzardi, G.: Ontological Foundations for Structural Conceptual Models. Phd thesis (2005)
Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P.: Fundamentals of Data Warehouses. Springer Book (2003)
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The definitve Guide to Dimensional Modeling. Wiley (2013) ISBN-13: 978-1118530801
Malinowski, E., Zimányi, E.: Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications. Springer (2009) ISBN 978-3-540-74405-4
Martínez, J., Berlanga, R., Aramburu, M., Pedersen, T.: Contextualizing data warehouses with documents. Decision Support Systems 45(1), 77–94 (2008)
Nebot, V., Berlanga, R., Martínez, J., Aramburu, M., Pedersen, T.: MD Integrated Ontologies: A Framework for Designing Semantic DW. J. Data Semantics 13, 1–36 (2009)
Pardillo, J., Mazón, J.-N.: Using Ontologies for the Design of Data Warehouses. International Journal of Database Management Systems (2011)
Romero, O., Abelló, A.: A framework for multidimensional design of data warehouses from ontologies. Data & Knowledge Engineering 69(11), 1138–1157 (2010)
Romero, O., Simitsis, A., Abelló, A.: GEM: Requirement-Driven generation of ETL and Multidimensional Conceptual Designs. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2011. LNCS, vol. 6862, pp. 80–95. Springer, Heidelberg (2011)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Moreira, J., Cordeiro, K., Campos, M.L., Borges, M. (2014). OntoWarehousing – Multidimensional Design Supported by a Foundational Ontology: A Temporal Perspective. In: Bellatreche, L., Mohania, M.K. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2014. Lecture Notes in Computer Science, vol 8646. Springer, Cham. https://doi.org/10.1007/978-3-319-10160-6_4
Download citation
DOI: https://doi.org/10.1007/978-3-319-10160-6_4
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-10159-0
Online ISBN: 978-3-319-10160-6
eBook Packages: Computer ScienceComputer Science (R0)