台灣全民健保資料決策輔助工具之建立-以骨折為例

Building a Decision Support Tool for Taiwan’s National Health Insurance Data - An application to fractures study

潘庭問(PhanDinh Van)

指導教授 ： 詹前隆

元智大學/資訊學院/資訊管理學系/碩士(2012年)

https://doi.org/10.6838/YZU.2012.00001

摘要

本研究在於將台灣全民健康保險資料處理與分析自動化。由於全民健康保險所提供之資料為非結構型式，我們將資料轉入SQL Server。而在檢索和資料處理的過程中，為了輸出表格及結果，我們使用若干複雜的SQL查詢。即使如此，查詢資料與分析，對醫師、護理人員、健保人員和一些不熟練SQL Server的人仍然造成不便。因此，這個研究建立了SQL Server 2008的轉換和存檔工具，使資料處理過程自動化。這些工具不僅為研究人員、醫護人員和健保人員資料庫分析與處理提出好的方法。此外，這些工具可協助管理者在照顧病人和保健策略中提出有益的方案。

關鍵字

決策支援系統 ； 資料倉儲 ； 全民健康保險 ； 資料處理 ； SQL Server

並列摘要

This study aims to solve the problems related to handling the Taiwan’s National Health Insurance data. Since the input insurance data is in text data, it is necessary to transfer those data into a data warehouse such as SQL Server. However, the data retrieval and synthesis are still very complicated through a number of complex SQL queries to export the final figures and tables. This causes a major problem for doctors, medical and insurance researchers who are not familiar with SQL Server. Therefore, this study proposes the tools to extract and save the data in SQL Server 2008, which facilitates the data synthesis. The tools not only support doctors, medical and insurance researchers to obtain the final analysis for their treatment methods but also help them to make good decisions in building health care strategies.

並列關鍵字

Decision support system ； Data warehouse ； Taiwan’s National Health Insurance Data ； Data transfer ； SQL Server

參考文獻

1. ICD-9-CM English – Chinese Dictionary. National Center for Health Statistics, U.S.A, 2001.

7. Sorgek, G. (1985). Organizing information: principles of database and retrieval systems. Library and information science series, Academic press, London.

Journal papers

1. Bergeron, F., C. Buteau, and L. Raymond (1991). “Identification of strategic information systems opportunities: Applying and comparing two methodologies.” MIS Quarterly 15(1): 89-103.

2. Boehm, B. W. (1988). “A spiral model of software development and enhancement.” IEEE 21(5):61-72.