Using geospatial business intelligence paradigm to design a multidimensional conceptual model for efficient coastal erosion risk assessment

One of the main challenges in Coastal Erosion Risk Assessment (CERA) is integrating and analysis of conflicting data in various time periods and spatial scales through dissimilar environmental, social, and economic criteria. Currently, Geographical Information Systems (GIS) are widely used in risk assessment despite their drawbacks and limitations as transactional systems for multi-scales, multi-epochs, and multi-themes analysis. Hence, an analytical conceptual framework is proposed in this paper based on geospatial business intelligence paradigm to develop a Spatial Multidimensional Conceptual Model (SMCM) to assess coastal erosion risk. The model is designed based on Spatial On-Line Analytical Processing (SOLAP) platform, on the top of both analytical and transactional paradigms, to allow fast synthesis of cross-tabulated data and easy comparisons over space, scales, epochs, and themes. This objective is achieved through a comprehensive integration of multiple environmental, social, and economic criteria as well as their interactions at various scales. It also takes into account multiple elements at risk such as people, infrastructure, and built environment as different dimensions of analysis. Using this solution allows decision makers to benefit from on-demand, interactive, and comprehensive information in a way that is not possible using GIS alone. The developed model can easily be adapted for any other coastal region through the proposed framework to perform risk assessment. The advantages and drawbacks of the proposed framework are also discussed and new research perspectives are presented.