skip to main content
10.1145/1871940.1871948acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
research-article

Towards the definition of spatial data warehouses integrity constraints with spatial OCL

Published: 30 October 2010 Publication History

Abstract

Spatial Data Warehouses (SDWs) and Spatial OLAP systems are an effective solution to perform multidimensional spatial analysis on geographical data. However, the quality of such analysis heavily depends on the quality of stored data. Due to this, some works have been attempted to address the issues of data quality of SDWs using Integrity Constraints (ICs). In this paper, we propose a conceptual framework for SDW ICs based on two new classifications. Moreover, we describe the Model-Driven Architecture (MDA)-based specification and implementation of some IC classes using the Object Constraint Language (OCL) and an MDA-based code generator, called Spatial OCL2SQL

References

[1]
Abello, A., Samos, J. and Saltor, F. 2006. YAM2: a multidimensional conceptual model extending UML. Information Systems, vol. 31(6), 541--567.
[2]
Bédard, Y. 1997. Spatial OLAP. 2 Forum annuel sur la R-D, Géomatique VI: Un monde accessible, Montréal, Canada, 13--14.
[3]
Bimonte, S., Villanova-Oliver, M. and Gensel, J. 2009. A Multidimensional Model for Correct Aggregation of Geographic Measures. Evolving Application Domains of Data Warehousing and Mining: Trends and Solutions, IGI Group.
[4]
Cabibbo, L. and Torlone, R. 2004. On the integration of autonomous data marts. 16th International Conference on Scientific and Statistical Database Management, Santorini Island,Greece, 223--234.
[5]
Carpani, F. and Ruggia, R. 2001. An Integrity Constraints Language for a Conceptual Multidimensional Data Model. 13th International Conference on Software Engineering and Knowledge Engineering, Bones Aires, Argentina, 220--227.
[6]
Duboisset, M. 2007. Un Système de Contraintes d'Intégrité OCL pour les Bases de Données Spatiales - Application à un Système d'Information pour l'Epandage Agricole. Doctoral Thesis. Blaise Pascal University, Clermont-Ferrand, France.
[7]
Ghozzi, F., Ravat, F., Teste, O. and Zurfluh, G. 2003. Constraints and Multidimensional Databases. 5th International Conference on Enterprise Information Systems, Angers, France, 104--111.
[8]
Glorio, O. and Trujillo, J. 2008. An MDA Approach for the Development of Spatial Data Warehouses. 10th International Conference on Data Warehousing and Knowledge Discovery, Turin, Italy, 23--32.
[9]
Lenz, H. and Shoshani, A. 1997. Summarizability in OLAP and statistical data bases. 9th International Conference on Scientific and Statistical Database Management, Washington, USA, 132--143.
[10]
Malinowski, E. and Zimányi, E. 2008. Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications. Berlin: Springer-Verlag.
[11]
Mazón, J., Trujillo, J. and Lechtenboerger, J. 2007. Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. Data Knowl. Eng. 63(3), 725--751.
[12]
Mazón, J., Lechtenbörger, J. and Trujillo, J. 2009. A survey on summarizability issues in multidimensional modelling. Data & Knowledge Engineering, vol. 68(12), 1452--1469.
[13]
Munoz, L., Mazón, J. and Trujillo, J. 2009. Automatic generation of ETL processes from conceptual models. 12th International Workshop on Data Warehousing and OLAP, Hong Kong, China, 33--40.
[14]
Pinet, F., Duboisset, M. and Soulignac, V. 2007. Using UML and OCL to maintain the consistency of spatial data in environmental information systems. Environmental modelling & software, vol. 22(8), Elsevier, 1217--1220.
[15]
Pinet, F. and Schneider, M. 2009. A unified object constraint model for designing and implementing multidimensional systems. Journal on Data Semantics, vol. 13, 37--71.
[16]
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.

Cited By

View all
  • (2018)Modeling vague spatial data warehouses using the VSCube conceptual modelGeoinformatica10.1007/s10707-013-0186-y18:2(313-356)Online publication date: 24-Dec-2018
  • (2016)Use of Sensor Data Warehouse for Soil Moisture AnalysisAutomated Enterprise Systems for Maximizing Business Performance10.4018/978-1-4666-8841-4.ch003(43-57)Online publication date: 2016
  • (2014)Parallel online spatial and temporal aggregations on multi-core CPUs and many-core GPUsInformation Systems10.1016/j.is.2014.01.00544(134-154)Online publication date: Aug-2014
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
DOLAP '10: Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
October 2010
112 pages
ISBN:9781450303835
DOI:10.1145/1871940
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]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 30 October 2010

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. integrity constraints
  2. ocl
  3. spatial data quality
  4. spatial data warehouse

Qualifiers

  • Research-article

Conference

CIKM '10

Acceptance Rates

Overall Acceptance Rate 29 of 79 submissions, 37%

Upcoming Conference

CIKM '25

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)1
  • Downloads (Last 6 weeks)0
Reflects downloads up to 10 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2018)Modeling vague spatial data warehouses using the VSCube conceptual modelGeoinformatica10.1007/s10707-013-0186-y18:2(313-356)Online publication date: 24-Dec-2018
  • (2016)Use of Sensor Data Warehouse for Soil Moisture AnalysisAutomated Enterprise Systems for Maximizing Business Performance10.4018/978-1-4666-8841-4.ch003(43-57)Online publication date: 2016
  • (2014)Parallel online spatial and temporal aggregations on multi-core CPUs and many-core GPUsInformation Systems10.1016/j.is.2014.01.00544(134-154)Online publication date: Aug-2014
  • (2012)Spatial OLAP and Map GeneralizationInternational Journal of Data Warehousing and Mining10.4018/jdwm.20120101028:1(24-51)Online publication date: Jan-2012
  • (2012)High-performance online spatial and temporal aggregations on multi-core CPUs and many-core GPUsProceedings of the fifteenth international workshop on Data warehousing and OLAP10.1145/2390045.2390060(89-96)Online publication date: 2-Nov-2012
  • (2010)DOLAP 2010 workshop summaryProceedings of the 19th ACM international conference on Information and knowledge management10.1145/1871437.1871792(1973-1974)Online publication date: 26-Oct-2010

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media