A UML & Spatial OCL based Approach for Handling Quality Issues in SOLAP Systems

Kamal Boulil, Sandro Bimonte, Francois Pinet

Abstract

Spatial Data warehouses and Spatial OLAP systems are Business Intelligence technologies allowing efficient and interactive analysis of large geo-referenced datasets. In such a kind of systems the goodness of analysis depends on: the warehoused data quality, how aggregations are performed, and how warehoused data are explored. In this paper, we propose a framework based on a UML profile and OCL-defined integrity constraints to grant quality in the whole SOLAP system. We also propose an automatic implementation in a classical ROLAP architecture to validate our proposal.

References

  1. Boulil, K., Bimonte, S., Pinet, F. (2011). Un modèle UML et des contraintes OCL pour les entrepôts de données spatiales : De la représentation conceptuelle à l'implémentation. Ingénierie des Systèmes d'Information, 16(6) 11-39
  2. Ghozzi, F., Ravat, F., Teste, O., Zurfluh, G. (2003). Constraints and Multidimensional Databases. In 5th International Conference on Enterprise Information Systems, 104-111
  3. Glorio, O. and Trujillo, J. 2008. An MDA Approach for the Development of Spatial Data Warehouses. In 10th International Conference on Data Warehousing and Knowledge Discovery, Berlin-Heidelberg: Springer, 23-32
  4. Lenz, H.-J. and Shoshani, A. 1997. Summarizability in OLAP and statistical data bases. In International Conference on Scientific and Statistical Database Management, IEEE, 132-143
  5. Levesque, M.-A., Y. Bédard, M. Gervais, R. Devillers, (2007). Towards managing the risks of data misuse for spatial datacubes. In 5th International Symposium on Spatial Data Quality, June 13-15, Enschede, Netherlands
  6. Malinowski, E. and Zimányi, E. (2008). Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications. Berlin: Springer-Verlag.
  7. Mazón, J.-N., J. Lechtenbörger, et al. (2009). A survey on summarizability issues in multidimensional modeling. Dataand Knowledge Engineering 68(12): 1452-1469.
  8. Pinet, F., Duboisset, M. and Soulignac, V. (2007). Using UML and OCL to maintain the consistency of spatial data in environmental information systems. Environmental modellingand software, 22(8) 1217- 1220
  9. Pinet, F., Schneider, M. (2009) A Unified Object Constraint Model for Designing and Implementing Multidimensional Systems. Journal of Data Semantics 13, 37-71
  10. Ribeiro, L., Goldschmidt, R., Cavalcanti, M. 2011. Complementing Data in the ETL Process. In 13th International Conference Data Warehousing and Knowledge Discovery, Berlin-Heidelberg: Springer, 112-123
  11. Salehi, M. (2009). Developing a Model and a Language to Identify and Specify the Integrity Constraints in Spatial Datacubes. Doctoral thesis. Faculté des études supérieures de l'Université Laval, Canada.
Download


Paper Citation


in Harvard Style

Boulil K., Bimonte S. and Pinet F. (2012). A UML & Spatial OCL based Approach for Handling Quality Issues in SOLAP Systems . In Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8565-10-5, pages 99-104. DOI: 10.5220/0003967100990104


in Bibtex Style

@conference{iceis12,
author={Kamal Boulil and Sandro Bimonte and Francois Pinet},
title={A UML & Spatial OCL based Approach for Handling Quality Issues in SOLAP Systems},
booktitle={Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2012},
pages={99-104},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003967100990104},
isbn={978-989-8565-10-5},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - A UML & Spatial OCL based Approach for Handling Quality Issues in SOLAP Systems
SN - 978-989-8565-10-5
AU - Boulil K.
AU - Bimonte S.
AU - Pinet F.
PY - 2012
SP - 99
EP - 104
DO - 10.5220/0003967100990104