Abstract
In the past few years, several conceptual approaches have been proposed for the specification of the main multidimensional (MD) properties of the spatial data warehouses (SDW). However, these approaches often fail in providing mechanisms to univocally and automatically derive a logical representation. Even more, the spatial data often generates complex hierarchies (i.e., many-to-many) that have to be mapped to large and non-intuitive logical structures (i.e., bridge tables). To overcome these limitations, we implement a Model Driven Architecture (MDA) approach for spatial data warehouse development. In this paper, we present a spatial extension for the MD model to embed spatiality on it. Then, we formally define a set of Query/ View/ Transformation (QVT) transformation rules which allow us, to obtain a logical representation in an automatic way. Finally, we show how to implement the MDA approach in our Eclipse-based tool.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Kimball, R., Ross, M.: The Data Warehouse Toolkit, 2nd edn. Wiley, Chichester (2002)
Inmon, W.: Building the Data Warehouse. Wiley Sons, Chichester (2002)
Bimonte, S., Tchounikine, A., Miquel, M.: Towards a spatial multidimensional model. In: DOLAP 2005: Proceedings of the 8th ACM international workshop on Data warehousing and OLAP, pp. 39–46. ACM, New York (2005)
Malinowski, E., Zimányi, E.: Representing spatiality in a conceptual multidimensional model. In: GIS 2004: Proceedings of the 12th annual ACM international workshop on Geographic information systems, pp. 12–22. ACM, New York (2004)
Mazón, J.-N., Trujillo, J., Serrano, M., Piattini, M.: Applying mda to the development of data warehouses. In: DOLAP 2005: Proceedings of the 8th ACM international workshop on Data warehousing and OLAP, pp. 57–66. ACM, New York (2005)
OMG 2nd Revised Submission: MOF 2.0 Query/Views/Transformations (2002), http://www.omg.org/cgi-bin/doc?ad/05-03-02
Mazón, J.-N., Trujillo, J.: An MDA approach for the development of data warehouses. Decision Support Systems 45(1), 41–58 (2008)
The Eclipse Foundation: Eclipse, version 3.3.1.1 (Visited January 2008), http://www.eclipse.org
PostgreSQL Global Development Group: PostgreSQL, version 8.3 (February 2008), http://www.postgresql.org
Refractions Research : PostGIS, version 1.3.2 (December 2007), http://postgis.refractions.net/
OMG, Object Management Group: Model Driven Architecture (MDA) (2004), http://www.omg.org/mda/
Object Management Group: Unified Modeling Language (UML), version 2.1.1 (February 2007), http://www.omg.org/technology/documents/formal/uml.htm
Stefanovic, N., Han, J., Koperski, K.: Object-based selective materialization for efficient implementation of spatial data cubes. IEEE Transactions on Knowledge and Data Engineering 12(6), 938–958 (2000)
Rivest, S., Bèdard, Y., Marchand, P.: Toward better support for spatial decision making: Defining the characteristics of spatial on-line analytical processing. Geomatica 55(4), 539–555 (2001)
Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59(3), 725–769 (2006)
International Organization for Standardization, http://www.iso.org
Open Geospatial Consortium: Simple Features for SQL, http://www.opengeospatial.org
OMG, Object Management Group: Common Warehouse Metamodel (CWM) Specification 1.0.1 (2002), http://www.omg.org/cgi-bin/doc?formal/03-03-02
Kleppe, A., Warmer, J., Bast, W.: MDA Explained. The Practice and Promise of The Model Driven Architecture. Addison Wiley, Chichester (2003)
Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: from conceptual modeling to logical representation. Data Knowl. Eng. 59(2), 348–377 (2006)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Glorio, O., Trujillo, J. (2008). An MDA Approach for the Development of Spatial Data Warehouses. In: Song, IY., Eder, J., Nguyen, T.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2008. Lecture Notes in Computer Science, vol 5182. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-85836-2_3
Download citation
DOI: https://doi.org/10.1007/978-3-540-85836-2_3
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-85835-5
Online ISBN: 978-3-540-85836-2
eBook Packages: Computer ScienceComputer Science (R0)