災害緊急簡訊發送資料庫系統之研製

Implementation of Emergency Response SMS System Using DBMS

 

吳佳容a、郭凱文b、劉鈞鴻c、陳偉堯d

台北科技大學土木與防災研究所

忠孝東路三段1

台北市106大安區

s1428032@ntut.edu.tw, loveru@geoit.ws, aponson@yahoo.com.tw, waltchen@ntut.edu.tw

 

Chia-Jung Wua, Kevin Kuob, Chun-Hung Liuc, Walter Chend

Graduate Institute of Civil and Disaster Prevention Engineering

National Taipei Univ. of Technology

1, Sec. 3, Chung-Hsiao E. Rd

Taipei 106, Taiwan, ROC

 

摘要

台灣地區之地理及地形位置使得天然災害頻傳,地震、颱風、豪雨、洪水、土石流等無法避免之天然意外災害,造成人民生命財產損失嚴重。當天然災害發生時,首要的即是快速傳遞災情以及動員救災人員,為了將災情迅速傳遞至各相關災害應變中心,最短時間內召集救災人員進駐各救災崗位,災情傳遞簡訊發送系統顯得格外重要。本文以資料庫管理系統(DBMS)為基礎,利用Microsoft Access資料庫建置一套災情緊急簡訊發送資料庫,透過登入認證機制,可有效管理資料庫,提供管理者發送簡訊、新增、修改、刪除發送成員、群組資料等功能。於災害發生之初期,迅速發送災害緊急簡訊,有助於救災人員迅速投入搶救災工作,以達成在災害搶救時效內傷患救助之目的。

 

關鍵詞: 簡訊、資料庫、災害

 

Abstract

Because of the topography and the geographical location of Taiwan, natural disasters such as earthquakes, typhoons, heavy rains, floods, and debris flows are frequent causing severe property damage and loss of life.  When natural disasters strike, the most important task is to mobilize the rescue personnel.  In order to transmit disaster information and warnings to various Emergency Operation Centers (EOC) and call up the emergency response teams, a fast and easy-to-use messaging system is needed.  This paper applied the concept of Database Management System (DBMS) to implement a system capable of such messaging task using Microsoft Access.  With login validation, the system can provide a mechanism to send short messages and allow qualified users to create, delete, or modify communication data in the database.  It is believed that this system will be very valuable in delivering SMS to emergency response personnel to speed up the rescue operations after various natural or man-made disasters.

 

Keywords: SMS, Database, Disaster