skip to main content
10.1145/1097002.1097009acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
Article

Towards a spatial multidimensional model

Published:04 November 2005Publication History

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.

References

  1. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  2. 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 ScholarGoogle Scholar
  3. 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 ScholarGoogle Scholar
  4. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  5. Cowen, D.J. GIS versus CAD versus DBMS: What are the differences ?. Fotogrammetric Engineering and Remote Sensing, 54 (1988), 1551--1555.]]Google ScholarGoogle Scholar
  6. Feng, L., and Dillon, T. Using Fuzzy Linguistic Representations to Provide Explanatory Semantics for Data Warehouses. IEEE TKDE, 15, 1 (2003), 86--102.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. 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 ScholarGoogle ScholarCross RefCross Ref
  8. Franklin, C. An Introduction to Geographic Information Systems: Linking Maps to databases. Database. 1992, 13--21.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. Jensen C., Klygis, A., Pedersen, T. and Timko, I. Multidimensional data modelling for location-based services. VLDB Journal, 13, 1 (2004), 1--21.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  11. Longley, P.A., Michael. F., Goodchild, D.J., and Maguire, Rhind, D. W. Geographic Information Systems and Science. John Wiley & Sons (August, 2001).]]Google ScholarGoogle Scholar
  12. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  13. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  14. 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 ScholarGoogle ScholarCross RefCross Ref
  15. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  16. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  17. 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 ScholarGoogle Scholar
  18. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  19. Pourabbas, E. Cooperation with geographic databases. Multidimensional Databases: Problems and Solutions. M. Rafanelli, Idea Group Publishing, 2003, 393--432.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  20. Rigaux, P., Scholl, M., Voisard, A. Spatial databases with application to GIS. Morgan Kaufmann Publishers Inc., San Francisco, CA, 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  21. 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 ScholarGoogle Scholar
  22. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  23. 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 ScholarGoogle Scholar
  24. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  25. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  26. Worboys, M.F., GIS, a computing perspective, Taylor&Francis, 1995]] Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Towards a spatial multidimensional model

            Recommendations

            Comments

            Login options

            Check if you have access through your login credentials or your institution to get full access on this article.

            Sign in
            • Published in

              cover image ACM Conferences
              DOLAP '05: Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
              November 2005
              122 pages
              ISBN:1595931627
              DOI:10.1145/1097002

              Copyright © 2005 ACM

              Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

              Publisher

              Association for Computing Machinery

              New York, NY, United States

              Publication History

              • Published: 4 November 2005

              Permissions

              Request permissions about this article.

              Request Permissions

              Check for updates

              Qualifiers

              • Article

              Acceptance Rates

              Overall Acceptance Rate29of79submissions,37%

              Upcoming Conference

            PDF Format

            View or Download as a PDF file.

            PDF

            eReader

            View online with eReader.

            eReader