IMPLEMENTING SPATIAL DATA WAREHOUSE HIERARCHIES IN OBJECT-RELATIONAL DBMSs

Elzbieta Malinowski, Esteban Zimányi

Abstract

Spatial Data Warehouses (SDWs) allow to analyze historical data represented in a space supporting the decision-making process. SDW applications require a multidimensional view of data that includes dimensions with hierarchies and facts with associated measures. In particular, hierarchies are important since traversing them users can analyze detailed and aggregated measures. To better represent users’ requirements for SDWs, the conceptual model with spatial support should be used. Afterwards, the conceptual schema is translated to the logical and physical schemas. However, during the translation process the semantics can be lost. In this paper, we present the translation of spatial hierarchies from the conceptual to physical schemas represented in the MultiDimER model and Oracle 10g Spatial, respectively. Further, to ensure the semantic equivalence between the conceptual and the physical schemas, integrity constraints are exemplified mainly using triggers.

References

  1. Bimonte, S., Tchounikine, A., and Miquel, M. (2005). Towards a spatial multidimensional model. In Proc. of the 8th ACM Int. Workshop on Data Warehousing and OLAP, pages 39-46.
  2. Fidalgo, R., Times, V., Silva, J., and Souza, F. (2004). GeoDWFrame: A framework for guiding the design of geographical dimensional schemes. In Proc. of the 6th Int Conf. on Data Warehousing and Knowledge Discovery, pages 26-37.
  3. Han, J., Koperski, K., and Stefanovic, N. (1997). GeoMiner: a system prototype for spatial data mining. In Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pages 553-556.
  4. Jensen, C., Klygis, A., Pedersen, T., and Timko, I. (2004). Multidimensional data modeling for location-based services. VLDB Journal, 13(1):1-21.
  5. Lenz, H. and Shoshani, A. (1997). Summarizability in OLAP and statistical databases. In Proc. of the 9th Int. Conf. on Scientific and Statistical Database Management, pages 132-143.
  6. Malinowski, E. and Zimányi, E. (2004). Representing spatiality in a conceptual multidimensional model. In Proc. of the 12th ACM Symposium on Advances in Geographic Information Systems, pages 12-21.
  7. Malinowski, E. and Zimányi, E. (2005). Spatial hierarchies and topological relationships in the Spatial MultiDimER model. In Proc. of the 22nd British Nat. Conf. on Databases, pages 17-28.
  8. Pedersen, T., Jensen, C., and Dyreson., C. (2001). A foundation for capturing and querying complex multidimensional data. Information Systems, 26(5):383-423.
  9. Pedersen, T. and Tryfona, N. (2001). Pre-aggregation in spatial data warehouses. In Proc. of the 7th Int. Symposium on Advances in Spatial and Temporal Databases, pages 460-478.
  10. Rivest, S., Bédard, Y., and Marchand, P. (2001). Toward better suppport for spatial decision making: Defining the characteristics of spatial on-line analytical processing (SOLAP). Geomatica, 55(4):539-555.
  11. Shekhar, S. and Chawla, S. (2003). Spatial Databases: A Tour. Prentice Hall.
  12. Stefanovic, N., Han, J., and Koperski, K. (2000). Objectbased selective materialization for efficient implementation of spatial data cubes. TKDE, 12(6):938-958.
Download


Paper Citation


in Harvard Style

Malinowski E. and Zimányi E. (2007). IMPLEMENTING SPATIAL DATA WAREHOUSE HIERARCHIES IN OBJECT-RELATIONAL DBMSs . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 186-191. DOI: 10.5220/0002355401860191


in Bibtex Style

@conference{iceis07,
author={Elzbieta Malinowski and Esteban Zimányi},
title={IMPLEMENTING SPATIAL DATA WAREHOUSE HIERARCHIES IN OBJECT-RELATIONAL DBMSs},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={186-191},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002355401860191},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - IMPLEMENTING SPATIAL DATA WAREHOUSE HIERARCHIES IN OBJECT-RELATIONAL DBMSs
SN - 978-972-8865-88-7
AU - Malinowski E.
AU - Zimányi E.
PY - 2007
SP - 186
EP - 191
DO - 10.5220/0002355401860191