Journal of Coastal Conservation

, Volume 17, Issue 3, pp 527–543

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

  • Amaneh Jadidi
  • Mir Abolfazl Mostafavi
  • Yvan Bédard
  • Bernard Long
  • Eve Grenier

DOI: 10.1007/s11852-013-0252-5

Cite this article as:
Jadidi, A., Mostafavi, M.A., Bédard, Y. et al. J Coast Conserv (2013) 17: 527. doi:10.1007/s11852-013-0252-5


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.


Coastal erosion risk assessment SOLAP Decision making GIS Spatial datacube Geospatial business intelligence 



Business Intelligence


Coastal Erosion Risk


Coastal Erosion Risk Assessment


Decision Support System


Digital Terrain Model


Geographical Information System


Hybrid OnLine Analytical Processing


Multidimensional OnLine Analytical Processing


Relational OnLine Analytical Processing


Spatial Decision Support System


Spatial Multidimensional Conceptual Model


Spatial On-Line Analytical Processing


Unified Model Language

Copyright information

© Springer Science+Business Media Dordrecht 2013

Authors and Affiliations

  • Amaneh Jadidi
    • 1
  • Mir Abolfazl Mostafavi
    • 1
  • Yvan Bédard
    • 1
  • Bernard Long
    • 2
  • Eve Grenier
    • 1
  1. 1.Centre of Research in GeomaticsLaval UniversityQuebec CityCanada
  2. 2.Centre Eau, Terre et Environnement, INRSQuebec CityCanada

Personalised recommendations