Users Integrity Constraints in SOLAP Systems. Application in Agroforestry

TitleUsers Integrity Constraints in SOLAP Systems. Application in Agroforestry
Publication TypeJournal Article
Year of Publication2018
AuthorsCharef, A. B., and H. Djamila
JournalInternational Journal of Interactive Multimedia and Artificial Intelligence
IssueRegular Issue
Date Published06/2018

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.

KeywordsAgroforestry, Integrity Constraints, SOLAP, Spatial Data Warehouse, Spatial Decision Support System, Spatial Multidimensional Analysis, UML Multidimensional Modeling
ijimai_5_1_6.pdf1.94 MB