การจัดการข้อมูลภัยพิบัติด้วยระบบธุรกิจอัจฉริยะ : กรณีศึกษาผลกระทบระดับความรุนแรงจากภัยแล้ง อุทกภัย และดินถล่มในจังหวัดภูเก็ต

Abstract

Data management in agencies involved in disaster management collected the different structured data, extremely heterogeneous data, and various technology. Therefore, they occur the problems and delays in data analysis and decision making. This research presents the disaster data management using Business Intelligence (BI) conceptual model. BI is used to increase performance and improve the quality of data for collaboration and agility in the disaster agencies. Data and indicator requirements related to drought, flood, and landslide. Requirements were collected and classified for Information architecture design in different disaster management phases, tasks in related agencies into data dimension, data measurement. The result of Information architecture can be made to Schema design which contains 22 dimension tables and 16 fact tables. In the case study, which focuses on 1) the severity of risk areas by flood and landslide 2) The population and number of households were affected by the drought. Floods, landslides, and droughts data were collected from Department of Disaster Prevention and Mitigation, Phuket (DDPM Phuket) and Phuket land use data from Group for data analysis and research on tourism energy and environment (GDEN), Prince of Songkla University, Phuket campus. Data can be extracted, transform, and load into Data warehouse using ETL process and online analytical processing (OLAP) method. The result of the analysis is presented as reports on the dashboard. Bl system can be integrated with multidimensional data and improved performance of disaster data management. This Bl system can facilitate decision making in planning, monitoring, and disaster management in Phuket. Moreover, there are suggestions for the future work.