Users Integrity Constraints in SOLAP Systems. Application in Agroforestry

Authors

DOI:

https://doi.org/10.9781/ijimai.2018.01.003

Keywords:

Agroforestry, Integrity Constraints, SOLAP, Spatial Data Warehouse, Spatial Decision Support System, Spatial Multidimensional Analysis, UML Multidimensional Modeling
Supporting Agencies
A part of this study was carried out in collaboration with experts from the Forestry Administration of Mostaganem (Algeria). Thereby we would like to acknowledge them with gratitude, in particular Mrs. “Touafek Narimann”, the forest Conservator who left us forever and will remain in our hearts and our prayers as long as we live.

Abstract

SpatialData Warehouse and Spatial On-Line Analytical Processing are decision support technologies which offer the spatial and multidimensional analysis of data stored in multidimensional structure. They are aimed also at supporting geographic knowledge discovery to help decision-maker in his job related to make the appropriate decision . However, if we don’t consider data quality in the spatial hypercubes and how it is explored, it may provide unreliable results. In this paper, we propose a system for the implementation of user integrity constraints in SOLAP namely “UIC-SOLAP”. It corresponds to a methodology for guaranteeing results quality in an analytical process effectuated by different users exploiting several facts tables within the same hypercube. We integrate users Integrity Constraints (IC) by specifying visualization ICs according to their preferences and we define inter-facts ICs in this case. In order to validate our proposition, we propose the multidimensional modeling by UML profile to support constellation schema of a hypercube with several fact tables related to subjects of analysis in forestry management. Then, we propose implementation of some ICs related to users of such a system.

Downloads

Download data is not yet available.

References

M.A.Mostafavi, G. Edwards and R. Jeansoulin, “An Ontology-based Method for Quality Assessment of Spatial Data Bases”, Proceedings of the 4th International Symposium on Spatial Data Quality, Vienna, Austria. 2004.

S. Vallières,J. Brodeur and D. Pilon, “Spatial Integrity Constraints: A Tool for Improving the Internal Quality of Spatial Data. Fundamentals of Spatial Data Quality, R. Devillers and R. Jeansoulin (Eds.), ISTE, pp. 161-177. 2006.

C. A. Hurtado, C. Gutierrez and A. O. Mendelzon,“Capturing summarizability with integrity constraints in OLAP”, ACM Transactions on Database Systems, 30(3), pp. 854-886, 2005.

F. Ghozzi, F. Ravat, O. Teste and G. Zurfluh, “Constraintes pour modèle et langage multidimensionnels». Ingénierie des Systèmes d’Information 9(1), pp. 9-34, 2004.

T. L. L. Siqueira, R. C. Mateus, R. R. Ciferri, V. C. Times, and C. D. A. Ciferri,“Querying vague spatial information in geographic data warehouses advancing geoinformation science for a changing world” Volume 1 of Lecture Notes in Geoinformation and Cartography, pp. 379–397. Springer, 2011.

D. Perez, M. J. Somodevilla, and I. H. Pineda,“Fuzzy spatial data warehouse : A multidimensional model”, Decision Support Systems Advances, pp. 3–9. IEEE Computer Society, 2007.

C. E. Dyreson, T. B. Pedersen, and C. S. Jensen, “Incomplete information in multidimensional databases”, Multidimensional databases, pp. 282–309, IGI Publishing, 2003.

K. Boulil, S. Bimonte and F. Pinet,»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, 2011.

F.Ghozzi, F. Ravat, O. Teste, and G. Zurfluh, “Modèle multidimensionnel à contraintes”, Revue d’Intelligence Artificielle 17(1-3), 43–55, 2003.

E. Malinowski and E. Zimanyi, “Advanced data warehouse design. Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications”, Data-Centric Systems and Applications, Volume. ISBN 978-3-540-74404-7. Springer, 2008.

O. Glorio, and J. Trujillo,“An MDA Approach for the Development of Spatial Data Warehouses”, In I.-Y. Song, J. Eder, et T. Nguyen (Eds.), Data Warehousing and Knowledge Discovery, Volume 5182 of Lecture Notes in Computer Science, pp. 23–32. Springer. 2008.

J.-N.Mazon, J. Lechtenborger, and J. Trujillo, “A survey on summarizability issues in multidimensional modeling”, Data & Knowledge Engineering, 68(12), 1452–1469. 2009.

M. Salehi, “Developing a model and a language to Identify and specify the integrity Constraints in spatial datacubes”, PhD Thesis presented at the Faculty of high studies of LAVAL University, Quebec, 2009.

F.Pinet and M. Schneider, “A unified object constraint model for designing and implementing multidimensional systems”. In Journal on Data Semantics XIII, Volume 5530 of Lecture Notes in Computer Science, pp. 37–71. Springer. 2009.

K.Boulil, “Une Approche Automatisée basée sur des Contraintes d’Intégrité définies en UML et OCL pour la Vérification de la Cohérence Logique dans les Systèmes SOLAP - Applications dans le domaine agri-environnemental”, PHD thesis, University Blaise Pascal ClermontFerrand II, France, 2012.

J. Ananda, “Implementing participatory decision making in forest planning”, Environment Managing, 39, 534–544, 2007.

A. Kangas, M. Kurttila, J. Kangas, T. Hujala and K. Eyvindson, “Decision Support for Forest Management”, Springer: New York, NY, USA, 2015.

C. Prell, K. Hubacek and M. Reed, “Stakeholder analysis and social network analysis in natural resource management”, Internet Society, 22(6), 501–518, 2009.

E.Nordström, L.O. Eriksson and K.Öhman, “Integrating multiple criteria decision analysis in participatory forest planning: Experience from a case study in northern Sweden. Forest Policy Econ. 2010, 12, 562–574.

M. Acosta and S. Corral, “Participatory Multi-Criteria Assessment of Forest Planning Policies in Conflicting Situations: The Case of Tenerife”, Forests, 6, 3946–3969, 2015.

N.Vainikainen, A.Kangas and J.Kangas, “Empirical study on voting power in participatory forest planning”. Journal of Environmental Management, 88, 173–180, 2008.

R. G. Crespo, V. H. M. García, J. J. R.Escribano, E. T. Franco andJ. M. C. Lovelle,“Forest fire detection and extinction software”, In Proceedings of the 2009 International Conference on Artificial Intelligence, ICAI 2009 (Vol. 2, pp. 885-890).

H.Sivakumar,C. Matt, M.Sethu, Z. Robert andG.Y.L. Denny, “Professional Microsoft SQL Server Analysis Services 2008 with MDX”, Indianapolis, Indiana, USA. Wiley Publishing Inc Press.2009

N.Stefanovic, J. Han, and K. Koperski,“Object-based selective materialization for efficient implementation of spatial data cubes”,IEEE Transactions on Knowledge and Data Engineering, 12(6), 938–958,2000.

Y. Bédard, S. Rivest and M.J. Proulx, “Spatial On-Line Analytical Processing (SOLAP): Concepts, Architectures and Solutions from a Geomatics Engineering Perspective. Data Warehouses and OLAP: Concepts, Architectures and Solutions”, R. Wrembel and C. Koncilia (Eds.), Idea Group Publishing, p. 298-319, 2007.

S.Cockcroft, “A Taxonomy of Spatial Data Integrity Constraints”, Geoinformatica, 1(4), pp. 327-343.1997.

M.H. Bohlen, “Valid Time Integrity Constraints”, Technical Report 94-30, Department of Computer Science, University of Arizona, Arizona, USA, 22 pages,1994.

K.Boulil, S. Bimonte and F. Pinet, “Un cadre conceptuel basé sur UML et Spatial OCL pour la définition des contraintes d’intégrité dans les systèmes SOLAP”. Actes des 8èmes journées francophones sur les Entrepôts de Données et l’Analyse en ligne (EDA 2012). Bordeaux, France, 2012.

M. Duboisset, 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, PHD thesis, école doctorale pour l’Ingénieur (SPI), Clermont-Ferrand, France,2007.

M.J. Egenhofer, “A FormaI Definition of Binary Topological Re1ationships”, Proceedings of the 3rd International Conference on Foundation of Data Organization and Algorithms, LNCS 716, SpringerVerlag, Paris, France, p. 457-472,1989.

L. Bravo, and M. A. Rodriguez, “Semantic Integrity Constraints for Spatial Databases”, Proceedings of the 3rd Alberto Mendelzon International Workshop on Foundations of Data Management, Arequipa, Peru, May 12-15, 2009.

R. Villarroel, E. Fernández-Medina, M. Piattini and J. Trujillo, “A UML 2.0/OCL Extension for Designing Secure Data Warehouses”, Journal of Research and Practice in Information Technology, 38(1), 2006.

J. Trujillo, E. Soler, E. Fernández-Medina and M. Piattini, “A UML 2.0 profile to define security requirements for Data Warehouses”, Computer Standards and Interfaces, 31(5), pp. 969–983, 2009.

K. Boulil, F. Le Ber, S. Bimonte, C. Grag and F. Cernesson, “Multidimensional modeling and analysis of large and complex watercourse data: an OLAP-based solution”, Ecological Informatics, 24, 90–106, 2014.

K. Boulil, S. Bimonte, F. Pinet, “Conceptual model for spatial data cubes: A UML profile and its automatic implementation”. Computer Standards & Interfaces, 38, pp 113–132, 2015.

Downloads

Published

2018-06-01
Metrics
Views/Downloads
  • Abstract
    52
  • PDF
    50

How to Cite

Charef, A. B. and Djamila, H. (2018). Users Integrity Constraints in SOLAP Systems. Application in Agroforestry. International Journal of Interactive Multimedia and Artificial Intelligence, 5(1), 47–56. https://doi.org/10.9781/ijimai.2018.01.003

Issue

Vol. 5 No. 1 (2018): IJIMAI 2018 - Regular Issue.

Section

Regular Articles