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
Article

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

Abstract

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.

Keywords

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

Abrrevations

BI

Business Intelligence

CER

Coastal Erosion Risk

CERA

Coastal Erosion Risk Assessment

DSS

Decision Support System

DTM

Digital Terrain Model

GIS

Geographical Information System

HOLAP

Hybrid OnLine Analytical Processing

MOLAP

Multidimensional OnLine Analytical Processing

ROLAP

Relational OnLine Analytical Processing

SDSS

Spatial Decision Support System

SMCM

Spatial Multidimensional Conceptual Model

SOLAP

Spatial On-Line Analytical Processing

UML

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