Abstract
Spatial Data Warehouses (SDW) and Spatial Online Analytical Processing (OLAP) systems are Business Intelligence technologies allowing efficient and interactive analysis of huge volume of geo-referenced data. Some efforts have been done to integrate complex spatial data such as field, generalized spatial data, etc., in such systems, at conceptual and physical levels. However, existing works do not support spatial networks (i.e. road networks), which define topological connections between spatial data. Thus, mandatory analysis capabilities offered by spatial networks cannot be introduced in the decision-making process powered by SOLAP systems. In this paper, motivated by relevance of using standards for the conceptual design of Data Warehouses and Geographic Information Systems, we propose a UML profile for data warehouses integrating spatial networks. We define our conceptual model in the Computer-Aided Software Engineering tool MagicDraw, and we propose a relational implementation in Oracle Spatial.
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
Bédard, Y., Larrivée, S., Proulx, M.-J., Nadeau, M.: Modeling geospatial databases with plug-ins for visual languages: a pragmatic approach and the impacts of 16 years of research and experimentations on Perceptory. In: Wang, S., Tanaka, K., Zhou, S., Ling, T.-W., Guan, J., Yang, D.-q., Grandi, F., Mangina, E.E., Song, I.-Y., Mayr, H.C. (eds.) ER Workshops 2004. LNCS, vol. 3289, pp. 17–30. Springer, Heidelberg (2004)
Bédard, Y., Rivest, S., Proulx, M.: Spatial On-Line Analytical Processing (SOLAP): Concepts, Architectures, and Solutions from a Geomatics Engineering Perspective. In: Wrembel, R., Koncilia, C. (eds.) Data Warehouses and OLAP: Concepts, Architecture, and Solutions, pp. 298–319. Idea Group Publishing (2006)
Bimonte, S., Tchounikine, A., Miquel, M., Pinet, F.: When Spatial Analysis Meets OLAP: Multidimensional Model and Operators. International Journal of DataWarehousing and Mining 6(4), 33–60 (2010)
Bimonte, S.: On Modelling and Analysis of Geographic Multidimensional Databases. In: Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction, pp. 96–112. IGI Global (2010)
Glorio, O., Trujillo, J.: Designing Data Warehouses for Geographic OLAP Querying by Using MDA. In: Gervasi, O., Taniar, D., Murgante, B., Laganà, A., Mun, Y., Gavrilova, M.L. (eds.) ICCSA 2009, Part I. LNCS, vol. 5592, pp. 505–519. Springer, Heidelberg (2009)
Gómez, L., Vaisman, A., Zimányi, E.: Physical Design and Implementation of Spatial Data Warehouses Supporting Continuous Fields. In: Bach Pedersen, T., Mohania, M.K., Tjoa, A.M. (eds.) DAWAK 2010. LNCS, vol. 6263, pp. 25–39. Springer, Heidelberg (2010)
Hadzilacos, T., Tryfona, N.: An Extended Entity-Relationship Model for Geographic Applications. SIGMOD Record 26(3), 24–29 (1997)
Kimball, R.: The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley & Sons, New York (1996)
Koster, G., Pagel, B., Six, H.: GeoOOA: Object-Oriented Analysis for Geographic Information Systems. In: International Conference on Requirements Engineering, pp. 245–254 (1996)
Laurini, R., Thompson, D.: Fundamentals of Spatial Information Systems. Academic Press (1992)
MagicDraw: No Magic, Inc., http://www.magicdraw.com/
Malinowski, E., Zimanyi, E.: Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications. Springer (2008)
Miralles, A., Pinet, F., Bédard, Y.: Describing Spatio-Temporal Phenomena for Environmental System Development: An Overview of Today’s Needs and Solutions. International Journal of Agricultural and Environmental Information Systems 1(2), 68–84 (2010)
Lisboa, F.J., Sampaio, G.B., Nalon, F.R., Borges, K.A.V.: A UML Profile for Conceptual Modeling in GIS Domain. In: Workshop on Domain Engineering 2010, pp. 18–31 (2010)
Luján-Mora, S., Trujillo, J., Song, I.: A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59(3), 725–769 (2006)
OMG: Unified Modeling LanguageTM (OMG UML), Infrastructure, Version 2.4, Object Management Group (2011)
Oracle: A load-on-demand approach to handling large networks in the oracle network data model (2009)
Parent, C., Spaccapietra, S., Zimányi, E.: Modeling and multiple perceptions. In: Shekhar, S., Xiong, H. (eds.) Encyclopedia of GIS, pp. 682–690. Springer (2008)
Rigaux, P., Scholl, M., Voisard, A.: Spatial databases with application to GIS. Morgan Kaufmann Publishers Inc. (2002)
Silva, J., Oliveira, A.G., Fidalgo, R.N., Salgado, A., Times, V.C.: Modelling and querying geographical data warehouses. Information Systems 35(5), 592–614 (2010)
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)
Stempliuc, S., Filho, J., Andrade, M.: Extending the UML-GEOFRAME data model for conceptual modelling of network applications. In: 11th International Conference on Enterprise Information Systems 2009, pp. 164–170 (2009)
Torlone, R.: Conceptual Multidimensional Models. In: Multidimensional Databases, pp. 69–90. IGI Global (2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bimonte, S., Kang, MA., Trujillo, J. (2013). Integration of Spatial Networks in Data Warehouses: A UML Profile. In: Murgante, B., et al. Computational Science and Its Applications – ICCSA 2013. ICCSA 2013. Lecture Notes in Computer Science, vol 7974. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-39649-6_18
Download citation
DOI: https://doi.org/10.1007/978-3-642-39649-6_18
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-39648-9
Online ISBN: 978-3-642-39649-6
eBook Packages: Computer ScienceComputer Science (R0)