A STUDY OF THE SPATIAL REPRESENTATION IN MULTIDIMENSIONAL MODELS

Concepción M. Gascueña, Rafael Guadalupe

Abstract

In this work, we do an analysis on the different models proposed to model Multidimensional Databases MDB, and Spatial Databases SD. We analyze the basic and advanced rules that the conceptual multidimensional models should to support, according sort criterion exposed for some authors. As result of this study, we propose to add new rules to gather the spatial and temporal semantics. Are analyzed some of models more relevant, and a comparative table is presented, where the advantages of the model called FactEntity FE, with respect to the other examined modes, to collect multidimensional and spatial semantics, is obvious. We emphasizing on the novel contributions of FE model and shortcomings of the rest of seen models. We besides show a formalization of the FE model with a metamodel made up with the extended ER model, where the semantics of FE model is representing. Finally, an example of application clarifies our exposure.

References

  1. Abello A., Samos J., Saltor F., 2000. A Data Warehouse Multidimensional Models Classification. Technical Report LSI-2000-6. (Universidad de Granada).
  2. Abelló A., Samos J., Saltor F., 2002. YAM2 (Yet Another Multidimensional Model): An extension of UML. In Proc. of the Int. DB Engineering and Application Symposium, pp. 172-181.
  3. Abelló A., Samos J., Saltor F., 2006. YAM2, a multidimensional conceptual model extending UML. Information Systems, Vol. 31, No. 6. pp. 541-567.
  4. Blaschaka M., Sapia C., Höfling G., Dintel B., 1998. Finding your way through multidimensional data models. In 9th Int. Conf. on Database and Expert Systems Applicactions (DEXA). Lecture Notes in Computer Science 1460, Springer-Verlag, pag 198- 203.
  5. Bedard Y., 1999. Visual modeling of spatial databases: towards spatial PVL and UML. Geomantic 53 (2), 169-186.
  6. Bedard Y., Bernier E., 2002. Supporting Multiple Representations with Spatial Databases Views Management and the concept of VUEL. Proc. of the Joint Workshop on Multi-Scale Representations of Spatial Data, ISPRS.
  7. Berloto M., 1998. Geometric Modeling of Spatial Entities at Multiple Levels of Resolution. PhD Thesis, Uni. degli Studi di Genova.
  8. Bettini, C., Jajodia, S. & Wang, S., 2000. Time Granularities in Databases, Data Mining and Temporal Reasoning. Ed. Springer-Verlag, New York, Inc. Secaucus, NJ, USA.
  9. Borges, K. A. V., Davis Jr C.A., Laender A. H. F. 2001. OMT-G: An object-oriented data model for geographic applications. Geo Informatics 5 (3), 221- 260.
  10. Camossi, E., Bertolotto M., Bertino E., Guerrini G., , 2003. ST_ODMG: A Multigranular Spatiotemporal Extension of ODMG Model. Technical Report DISITR-03-09, Università degli Studi di Genova.
  11. Camossi E., Bertolotto M., Bertino E., Guerrini G., 2003. A Multigranular Spactiotemporal Data Model. Proc. of the 11th ACM international symposium, Advances in GIS, pp: 94-101. New Orleans. USA.
  12. Gascueña C. M., Moreno L., Cuadra D., 2005. Dos Perspectivas para la Representación de la MultiGranularidad en Bases de Datos Espacio-Temporales. IADIS 2005 conferences.
  13. Gascueña C. M., Cuadra D., Martínez P., 2006. A Multidimensional Approach to the Representation of the Spatiotemporal Multigranularity. Proc. of the 8th International Conference on Enterprise Information Systems, ICEIS 2006.Cyprus.
  14. Gascueña C. M., Guadalupe Rafael, 2008. Some Types of Spatio-Temporal Granularities in a Conceptual Multidimensional Model. 7th International Conference , APLIMAT Bratislava, Slovak.
  15. Gascueña C. M., Guadalupe Rafael, 2008. Some Types of Spatio-Temporal Granularities in a Conceptual Multidimensional Model. Aplimat -Journal of Applied Mathematics, volume 1 (2008), number 2, pag: 215- 216.
  16. Golfarelli M., Mario D., Rizzi S., 1998. The dimensional fact model: a conceptual model for data warehouses. (IJCIS) 7 (2-3) pp: 215-247.
  17. Jones C.B., Kidner D.B., Luo L.Q., Bundy G.L., Ware J.M., 1996. Databases design for a multi-scale spatial information system. Int. J., GIS 10 (8) pg 901-920,.
  18. Khatri V., Ram S., Snodgrass R. T.,. 2006. On Augmenting database design-support environments to capture the geo-spatio-temporal data semantics, 2004, Publisher Elsevier Science Ltd, Volume 31, Issue 2 2006, Pages: 98 - 133.
  19. Kimball R., 1996. The Data Warehouse Toolkit. John Wiley&Sons Ed.
  20. Le, Y., 2005. A prototype temporal GIS for multiple spatio-temporal representations. Cartography and GIS Science, 32(4), 315-329.
  21. Luján-Mora S., Trujillo J., Song Il- Yeol., 2006. A UML profile for multidimensional modeling in data warehouses. DKE, 59(3), p. 725-769.
  22. Malinowski, E. and Zimanyi, E., 2004. Representing Spatiality in a Conceptual Multidimensional Model. Proc. of the 12th annual ACM international workshop on GIS. Washington, DC, USA.
  23. Malinowski E., Zimanyi E. , 2004. OLAP hierarchies: A conceptual perspective. In Proc. of the 16th Int. Conf. on Advanced Information Systems Engineering, pages 477-49.
  24. Malinowski E., Zimanyi E., 2005. Spatial Hierarchies and Topological Relationships in the Spatial MultiDimER model. Lecture Notes in Computer Science, page 17, Volume 3567.
  25. Malinowski E., Zimanyi E., 2006. Inclusion of TimeVarying Measures in Temporal Data Warehouses dimensions. Proc. of 8th International Conference on Enterprise Information Systems, Paphos, Cyprus.
  26. Malinowski E., Zimanyi E., 2006. A Conceptual Solution for Representing Time in Data Warehouse Dimensions. Proc. of 3rd Asia-Pacific (APCCM2006), Hobart, Australia.
  27. Parent C., Spaccapietra S., Zimanyi E., 1999. Spatiotemporal conceptual models: Data structures+space+time. Proc. of 7th ACM Symposium on Advances in Geographic Information Systems, Kansas City, USA, pp.
  28. Parent C., Spaccapietra S., Zimanyi E., 2005. The MurMur project: Modeling and querying multirepresentation spatio-temporal databases, in press Elsevier ltd.
  29. Parent C., Spaccapietra S., Zimanyi E., 2006. The MurMur project: Modeling and querying multirepresentation spatio-temporal databases. Information Systems, Volume 31, Issue 8, Pages 733-769.
  30. Pedersen T., 2000. Aspects of Data Modeling and Query Processing for Complex Multidimensional Data. PhD thesis, Faculty of Engineering & Science, Aalborg University.
  31. Piattini Mario G., Esperanza Marcos, Coral Calero, Belén Vela, Tecnología y Diseño de Bases de Datos, Editorial: Ra-Ma 2006.
  32. Sapia C., Blaschka M., Höfling G., Dinter B., 1999. Extending the E/R Model for the Multidimensional Paradigm. Advances in DB Technologies. LNCS Vol 1552, Springer-Verlag.
  33. Stefanovic, N. Han, J. and Koperski, K., 2000. Objectbased selective materialization for efficient implementation of spatial data cubes. IEEE Trans. on Knowledge and Data Engineering, 12(6):938-958.
  34. Stell J., Worboys M., 1998. Stratified map spaces: a formal basic for multi-resolution spatial databases. Proc. of the 8th International Symposium on Spatial Data Handling, SDH'98 pag 180-189.
  35. Timpf S., 1999. Abstraction, level of detail, and hierarchies in map series. International Conference on Spatial Information Theory, COSIT'99, LNCS 1661, pp. 125-140.
  36. Torlone R., 2001. Conceptual Multidimensional Models. In Rafanelli ed., pages 69-90.
  37. Torlone R. 2003. Conceptual Multidimensional Models. In Multidimensional databases: problems and solutions, Idea Group Publishing, Hershey, PA, pages 69-90, USA,
  38. Tryfona N., Busborg F., Borch J. , , 1999. StarER: A Conceptual Model for Data Warehouse Design. In Proc. of the 2nd ACM Int. Workshop on DW and OLAP, pp. 3-8.
  39. Tryfona, N., Price, R., & Jensen, C. S., . 2003. Conceptual Models for Spatio-temporal Applications. In M. Koubarakis et al. (Eds.), Spatio-Temporal DB: The CHOROCHRONOS Approach (pp. 79-116). Berlin, Heidelberg.
  40. Vargas da Rocha L., Edelweiss L. V., Iochpe C. , 2001. GeoFrame-T: A temporal conceptual framework for data modeling. Proceedings of the ninth ACM international symposium on Advances in GIS, Atlanta, GA, USA.
  41. William A. Mackaness., 2006. Automated Cartography in a Busch of Ghosts. Cartography and GIS Science, Volume 33, Nº 4.
Download


Paper Citation


in Harvard Style

M. Gascueña C. and Guadalupe R. (2008). A STUDY OF THE SPATIAL REPRESENTATION IN MULTIDIMENSIONAL MODELS . In Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8111-36-4, pages 339-348. DOI: 10.5220/0001715503390348


in Bibtex Style

@conference{iceis08,
author={Concepción M. Gascueña and Rafael Guadalupe},
title={A STUDY OF THE SPATIAL REPRESENTATION IN MULTIDIMENSIONAL MODELS},
booktitle={Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2008},
pages={339-348},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001715503390348},
isbn={978-989-8111-36-4},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - A STUDY OF THE SPATIAL REPRESENTATION IN MULTIDIMENSIONAL MODELS
SN - 978-989-8111-36-4
AU - M. Gascueña C.
AU - Guadalupe R.
PY - 2008
SP - 339
EP - 348
DO - 10.5220/0001715503390348