ABSTRACT
Data warehouses and OLAP systems help to interactively analyze huge volume of data. This data, extracted from transactional databases, frequently contains spatial information which is useful for decision-making process. Integration of spatial data in multidimensional models leads to the concept of SOLAP (Spatial OLAP). Using a spatial measure as a geographical object, i.e. with geometric and descriptive attributes, raises problems regarding the aggregation operation in its semantic and implementation aspects. This paper shows the requirements for a multidimensional spatial data model and presents a multidimensional data model which is able to support complex objects as measures, inter-dependent attributes for measures and aggregation functions, use of ad-hoc aggregation functions and n to n relations between fact and dimension, in order to handle geographical data, according to its particular nature in an OLAP context.
- Abelló, A., Samos, J., and Saltor, F. YAM2 (Yet Another Multidimensional Model): An extension of UML. In Proceedings of International Database Engineering & Applications Symposium. (Canada, July 2002). IEEE Computer Society Press, 2002, 172--181.]] Google ScholarDigital Library
- Bédard, Y., and Bernier E. Supporting multiple representation with spatial databases views management and the concept of VUEL. In Proceedings of Workshop on Multi-Scale Representations of Spatial Data (Ottawa Canada, 2002). ISPRS / ICA.]]Google Scholar
- Bédard, Y., Merrett, T., and Han, J. Fundaments of Spatial Data Warehousing for Geographic Knowledge Discovery. Geographic Data Mining and Knowledge Discovery. Taylor & Francis, London, 2001, 53--73.]]Google Scholar
- Blaschka, M., Sapia, C., Hofling, G., and Dinter, B. Finding Your Way through Multidimensional Data Models. In Proceedings of the 9th International Conference on Database and Expert systems Applications. Lecture Notes in Computer Science, 1490 (1998), Springer-Verlag, 198--203]] Google ScholarDigital Library
- Cowen, D.J. GIS versus CAD versus DBMS: What are the differences ?. Fotogrammetric Engineering and Remote Sensing, 54 (1988), 1551--1555.]]Google Scholar
- Feng, L., and Dillon, T. Using Fuzzy Linguistic Representations to Provide Explanatory Semantics for Data Warehouses. IEEE TKDE, 15, 1 (2003), 86--102.]] Google ScholarDigital Library
- Fidalgo, R.N., Times, V.C., Silva, J., and Souza, F.F. GeoDWFrame: A Framework for Guiding the Design of Geographical Dimensional Schemas. In Proceedings of Int. Conf. on Data Warehousing and Knowledge Discovery (Zaragosa, Spain, 2004). 26--37.]]Google ScholarCross Ref
- Franklin, C. An Introduction to Geographic Information Systems: Linking Maps to databases. Database. 1992, 13--21.]] Google ScholarDigital Library
- Jensen C., Klygis, A., Pedersen, T. and Timko, I. Multidimensional data modelling for location-based services. VLDB Journal, 13, 1 (2004), 1--21.]] Google ScholarDigital Library
- Kouba Z., Matousek K., and Miksovsky P. On Data Warehouse and GIS integration. In Proceedings of the 11th Int. Conf. and Workshop on Database and Expert Systems Applications (Greenwich, UK, 2000).]] Google ScholarDigital Library
- Longley, P.A., Michael. F., Goodchild, D.J., and Maguire, Rhind, D. W. Geographic Information Systems and Science. John Wiley & Sons (August, 2001).]]Google Scholar
- Lujan-Mora, S., Trujillo, J. and Song, I. Extending UML for Multidimensional Modeling. In Proceedings of the 5th International Conference on the Unified Modeling Language (Dresden, Germany, 2002). LCNS, 2460, Springer-Verlag, 290--304]] Google ScholarDigital Library
- Lujan-Mora, S., Trujillo, J. and Song, I. Multidimensional Modeling with UML package Diagrams. In Proceedings of the 21st International Conference on Conceptual Modeling (Tampere, Finland, 2002). LNCS, 2503, Springer-Verlag, 199--213.]] Google ScholarDigital Library
- Marchand, P., Brisebois, A., Bédard, Y., and Edwards G. Implementation and evaluation of a hypercube-based method for spatio-temporal exploration and analysis. Journal of the International Society of Photogrammetry and Remote Sensing, 59 (2003), 6--20.]]Google ScholarCross Ref
- Malinowski, E., and Zim&225;nyi, E. Representing spatiality in a conceptual multidimensional model. In Proceedings of the 12th annual ACM International workshop on Geographic information systems. (Washington DC, New York, USA, 2004), ACM Press 2004, 12--22.]] Google ScholarDigital Library
- Malinowsky, E., and Zim&225;nyi <http://portal.acm.org/results.cfm?query=author%3AP671244&querydisp=author%3AEsteban%20Zim%26%23225%3Bnyi&coll=GUIDE&dl=GUIDE&CFID=36722371&CFTOKEN=49841257>&coll=GUIDE&dl=GUIDE&CFID=36722371&CFTOKEN=49841257>&dl=GUIDE&CFID=36722371&CFTOKEN=49841257>&CFID=36722371&CFTOKEN=49841257>&CFTOKEN=49841257>>, E., Spatial Hierarchies and Topological Relationships in SpatialMultiDimER model. In Proceedings of the 22th British National Conference on Databases (Sunderland UK, July 2005), LNCS 3567, Springer, 17--28]] Google ScholarDigital Library
- Miquel, M., Bédard, Y., and Brisebois, A. Conception d'entrepots de données géospatiales à partir de sources hétérogènes, exemple d'application en foresterie Revue ISI-NIS, Special Issue Data Warehousing, Paris, Edition Hermès Science, 7, 3 (2002).]]Google Scholar
- Pedersen, T.B. and Jensen, C.S. Multidimensional data modelling for complex data. In Proceedings of the 15th International Conference on Data Engineering. IEEE Computer Society Press, 1999, 336--345.]] Google ScholarDigital Library
- Pourabbas, E. Cooperation with geographic databases. Multidimensional Databases: Problems and Solutions. M. Rafanelli, Idea Group Publishing, 2003, 393--432.]] Google ScholarDigital Library
- Rigaux, P., Scholl, M., Voisard, A. Spatial databases with application to GIS. Morgan Kaufmann Publishers Inc., San Francisco, CA, 2002.]] Google ScholarDigital Library
- Rivest, S., Bédard Y., and Marchand P. Toward Better Support for Spatial Decision Making: Defining the Characteristics of Spatial On-Line Analytical Processing (SOLAP). Geomatica, 55, 4 (2001), 539--555.]]Google Scholar
- Stefanovic, N., Han, J., and Koperski K. Object-Based Selective Materialization for Efficient Implementation of Spatial Data Cubes. IEEE TKDE, 12, 6 (2000), 938--958.]] Google ScholarDigital Library
- Tchounikine, A., Maryvonne M., Robert, L., Taher, A., Bimonte, S. and Baillot, V. Panorama de travaux autour de l'intégration de données spatio-temporelles dans les hypercubes. Revue des Nouvelles Technologies de l'Information (RNTI), Editions Cepaduès, numéro spécial, 2005.]]Google Scholar
- Trujillo, J., Palomar, M., Gomez, J., and Song, I. Designing Data Warehouses with OO Conceptual Models. IEEE Computer, special issue on Data Warehouses, 34,12 (2001), 66--75.]] Google ScholarDigital Library
- Vassialiadis, P. Modeling multidimensional databases, cubes and cube operations. In Proceedings of the 10th International conference on Scientific and Statistical Database Management. IEEE Computer Science Press, 1998, 53--62.]] Google ScholarDigital Library
- Worboys, M.F., GIS, a computing perspective, Taylor&Francis, 1995]] Google ScholarDigital Library
Index Terms
Towards a spatial multidimensional model
Recommendations
Towards a logical multidimensional model for spatial data warehousing and OLAP
DOLAP '06: Proceedings of the 9th ACM international workshop on Data warehousing and OLAPDecision support systems (DSS) may be enhanced qualitatively if they are able to also deal with spatial dimensions and measures. Regardless the evident importance of using data warehousing and OLAP in DSS, the incorporation of spatial dimensions and ...
A foundation for spatial data warehouses on the Semantic Web
Large volumes of geospatial data are being published on the Semantic Web (SW), yielding a need for advanced analysis of such data. However, existing SW technologies only support advanced analytical concepts such as multidimensional (MD) data warehouses ...
Towards a model for the multidimensional analysis of field data
ADBIS'10: Proceedings of the 14th east European conference on Advances in databases and information systemsIntegration of spatial data into multidimensional models leads to the concept of Spatial OLAP (SOLAP). Usually, SOLAP models exploit discrete spatial data. Few works integrate continuous field data into dimensions and measures. In this paper, we provide ...
Comments