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.

[1]  Arkal Vittal Hegde,et al.  Development of Coastal Vulnerability Index for Mangalore Coast, India , 2007 .

[2]  Vincent R. Gray.  Climate Change 2007: The Physical Science Basis Summary for Policymakers , 2007 .

[3]  L. Greene.  EHPnet: United Nations Framework Convention on Climate Change , 2000, Environmental Health Perspectives.

[4]  A Decision Support System for an Optimal Design of Sea Dikes with Respect to Risk , 2002 .

[5]  Frank Van Kouwen,et al.  Applicability of Decision Support Systems for Integrated Coastal Zone Management , 2007 .

[6]  Charles H. Fletcher,et al.  The Predictive Accuracy of Shoreline Change Rate Methods and Alongshore Beach Variation on Maui, Hawaii , 2007 .

[7]  V. Gornitz,et al.  A coastal hazards data base for the U.S. West Coast , 1992 .

[8]  R. Nicholls,et al.  A New Global Coastal Database for Impact and Vulnerability Analysis to Sea-Level Rise , 2008 .

[9]  Esteban Zimányi,et al.  Hierarchies in a multidimensional model: From conceptual modeling to logical representation , 2006, Data Knowl. Eng..

[10]  Wen Wu,et al.  A Decision Support Framework for the Risk Assessment of Coastal Erosion in the Yangtze Delta , 2010, SDH.

[11]  Barton P. Miller,et al.  Vulnerability Assessment Enhancement for Middleware for Computing and Informatics , 2013 .

[12]  Adam S. Markowski,et al.  Aspects of risk analysis associated with major failures of fuel pipelines , 2006 .

[13]  M. Witko,et al.  Sixth International Symposium. Effects of surface heterogeneity in adsorption and catalysis on solids—ISSHAC VI, Zakopane, Poland, 28th August-2nd September 2006 , 2007 .

[14]  J. List,et al.  Using topographic lidar data to delineate the North Carolina Shoreline , 2007 .

[15]  Manuel Garcin,et al.  A ‘coastal-hazard GIS’ for Sri Lanka , 2010 .

[16]  Riccardo Torlone.  Conceptual Multidimensional Models , 2003, Multidimensional Databases.

[17]  E. Robert Thieler,et al.  National assessment of coastal vulnerability to sea-level rise; preliminary results for the U.S. Gulf of Mexico Coast , 2000 .

[18]  C. Woodroffe,et al.  International assessments of the vulnerability of the coastal zone to climate change, including an Australian perspective , 2006 .

[19]  Robert B. Nairn,et al.  SPATIAL AND TEMPORAL CONSIDERATION FOR CALCULATING SHORELINE CHANGE RATES IN THE GREAT LAKES BASIN , 2003 .

[20]  James H. Lambert,et al.  Integration of Decision Analysis and Scenario Planning for Coastal Engineering and Climate Change , 2011, IEEE Transactions on Systems, Man, and Cybernetics - Part A: Systems and Humans.

[21]  R. Valentini,et al.  A multi-component GIS framework for desertification risk assessment by an integrated index , 2010 .

[22]  W. L. Shirley,et al.  Social Vulnerability to Environmental Hazards , 2003 .

[23]  E. Robert Thieler,et al.  The Digital Shoreline Analysis System (DSAS) Version 4.0 - An ArcGIS extension for calculating shoreline change , 2009 .

[24]  R. Nicholls,et al.  Adaptation technologies for coastal erosion and flooding: a review , 2012 .

[25]  Hans-Martin Füssel,et al.  How inequitable is the global distribution of responsibility, capability, and vulnerability to climate change: A comprehensive indicator-based assessment , 2010 .

[26]  Esteban Zimányi,et al.  Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications , 2010 .

[27]  Torben Bach Pedersen,et al.  Multidimensional Database Technology , 2001, Computer.

[29]  Yvan Bédard,et al.  SOLAP technology: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data , 2005 .

[30]  Surajit Chaudhuri,et al.  An overview of business intelligence technology , 2011, Commun. ACM.

[31]  Yvan Bédard,et al.  A FORMAL CONCEPTUAL MODEL AND DEFINITIONAL FRAMEWORK FOR SPATIAL DATACUBES , 2010 .

[32]  E. Robert Thieler,et al.  National assessment of coastal vulnerability to sea-level rise; U.S. Atlantic Coast , 1999 .

[33]  Angela Maria Tomasoni.  Modèles et méthodes d'évaluation et de gestion des risques appliquées aux systèmes de transport de marchandises dangereuses (TMD), reposant sur les nouvelles technologies de l'information et de la communication (NTIC) , 2010 .

[34]  Yvan Bédard,et al.  Toward better support for spatial decision making: Defining the characteristics of spatial on-line analytical processing (SOLAP) , 2001 .

[35]  Hans-Martin Füssel,et al.  Review and Quantitative Analysis of Indices of Climate Change Exposure, Adaptive Capacity, Sensitivity, and Impacts , 2010 .

[36]  W. Kent Muhlbauer,et al.  Pipeline Risk Management Manual , 1992 .

[37]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[38]  SCIENCE OF TSUNAMI HAZARDS , 2012 .

[39]  S. Cutter,et al.  Erosion Hazard Vulnerability of US Coastal Counties , 2005 .

[40]  C. Sharples,et al.  Indicative Mapping of Tasmanian Coastal Vulnerability to Climate Change and Sea-Level Rise: Explanatory Report (Second Edition) , 2006 .

[41]  David Alexander,et al.  Confronting Catastrophe: New Perspectives on Natural Disasters , 2000 .

[42]  Ali G. Hessami.  A systems framework for safety and security: The holistic paradigm , 2004, Syst. Eng..

[43]  Jiawei Han,et al.  Fundamentals of spatial data warehousing for geographic knowledge discovery , 2001 .

[44]  D. Varnes.  Landslide hazard zonation: A review of principles and practice , 1984 .

[45]  R. Nicholls,et al.  Assessment of coastal vulnerability to climate change , 1999 .

[46]  Hans-Martin Fussel,et al.  Development and climate change : review and quantitative analysis of indices of climate change exposure, adaptive capacity, sensitivity, and impacts , 2009 .

[47]  Erika S. Hammar-Klose,et al.  National Assessment of Coastal Vulnerability to Sea-Level Rise: Preliminary Results for the U.S. Atlantic Coast , 2000 .

[48]  Jiawei Han,et al.  Selective Materialization: An Efficient Method for Spatial Data Cube Construction , 1998, PAKDD.

[49]  Richard S. J. Tol,et al.  A Methodology for Modeling Coastal Space for Global Assessment , 2007 .

[50]  José Samos,et al.  YAM2: a multidimensional conceptual model extending UML , 2006, Inf. Syst..

[51]  J. Hinkel,et al.  DIVA: an iterative method for building modular integrated models , 2005 .

[52]  Emmanuel Eliot,et al.  Spatial risks and complex systems : methodological perspectives , 2009 .

[53]  R. Nicholls,et al.  DEVELOPING A GLOBAL DATABASE FOR COASTAL VULNERABILITY ANALYSIS: DESIGN ISSUES AND CHALLENGES , 2004 .

[54]  W. Kazakos,et al.  CoastBase - The Virtual European Coastal and Marine Data Warehouse , 2000 .

[55]  B. Wisner,et al.  At Risk: Natural Hazards, People's Vulnerability and Disasters , 1996 .

[56]  Sandro Bimonte,et al.  Definition and Analysis of New Agricultural Farm Energetic Indicators Using Spatial OLAP , 2012, ICCSA.

[57]  Yvan Bédard,et al.  Spatial Online Analytical Processing (SOLAP): Concepts, Architectures, and Solutions from a Geomatics Engineering Perspective , 2007 .

[58]  Sven Fuchs,et al.  A quantitative vulnerability function for fluvial sediment transport , 2011 .

[59]  Nebojsa Stefanovic.  Design and implementation of on-line analytical processing (OLAP) of spatial data , 1997 .

[60]  Raffaele Giordano,et al.  A fuzzy knowledge-based decision support system for groundwater pollution risk evaluation. , 2004, Journal of environmental management.