建立一個勞工保險職業災害資料庫之資料倉儲即時分析系統

The establishment of a labor insurance occupational warehouse system with real-time data analysis

近三年行政院勞工委員會勞工安全衛生研究所陸續建置勞工保險資料及相關職災給付基本資料庫，同時也進行相關職業衛生流行病學統計分析資料並將2004年及2005年之統計資料檔建構於網頁查詢災害統計資料庫及職業災害資料庫系統。然對提供勞委會減災策略的圖表分析性及即時性仍顯不足，且對資料庫擷取常產生重複性，對時間及人力可說是一項負擔也不符效益。而現今企業或具大型資料庫機構已體認資料倉儲乃是對已存於組織內的資料策略運用的關鍵。資料倉儲及線上即時分析是決策支援必要的元件，而資料採礦是從巨大資料倉儲找出有用資訊之一種過程與技術，其可提供機構洞察大筆資料中所隱含訊息的能力，協助機構找出資料中所隱含的營運資訊。本研究係利用勞委會已建置完成之2002～2006年勞保基礎資料庫，依資料倉儲發展步驟及流程及勞委會資料庫屬性而擬定之架構，完成勞保職災資料倉儲架構之建置，期望能具有線上即時分析、查詢／報告及資料採礦之基本功能。本系統完成後，可作為政府制訂勞工政策時的參考。並使本資料倉儲具有擴充性及延展性，未來可與勞委會已建置完成之其他相關勞工安全衛生資料庫整合，建立資料整體標準架構，以達到資料互相流通之目的。同時期望未來能朝向知識庫方向發展，而達到完整之知識管理層面。

Institute of Occupational Safety and Health (IOSH) had constructed the basic and cash payment database for the Labor Insurance for the past three years. In the meantime, epidemiological statistics of occupational health and safety were carried out, and a web page was established for the purpose of query. However, the interface of webpage is not efficient to generate analytical and instantaneous graphic tables for tactic of occupational events, and the query system produced lots redundancy and duplicated data. This has become a heavy work loading for the Institute of Occupational Safety and Health. According to the fast progress of information technology, Organizations that own large-scale database has understood that data warehouse (DW) is a key component for strategic performance of analyzing intra-organizational existent data. DW and Online Analytical Processing (OLAP) are the imperative components of support of decision-making, and data mining is a process and technique for calling on serviceable information from enormous DW. It offers the ability of revealing implied message from huge data, and help finding problems in the management. This study had focused on the establishment of a basic labor insurance database for years of 2002~2006, based on the developing methods and technological processes of DW framework. The DW for labor's occupational events was constructed according to the existed database attributes. The system also possessed the functions of OLAP, query/reporting, and data mining. After the system is completed, with the capability of analysis, we expect that it will help us understand the problems and reasons of occupational events or heath in real-time and integrated way, and then we can provide authentically necessary way of health care. The system can also be applied as reference site for government to set up the policies. Furthermore, this DW was designed to have the ability of expandable and extendable architecture. In the future, data standard such as metadata can be designed for the data exchange between different databases. Knowledge database is also expected to be developed for comprehensive knowledge management.