應用NoSQL資料庫建置健保資料庫之巨量資料視覺化呈現

Use NoSQL Database to Implement Big Data Visualization of National Health Insurance Research Database

程炯謀(Jiung-Mou Cheng)

指導教授 ： 翁昭旼

共同指導教授 ： 蔣以仁

國立臺灣大學/工學院/醫學工程學研究所/碩士(2015年)

https://doi.org/10.6342/NTU.2015.01040

摘要

國家衛生研究院所建置的健保資料庫，儲存了自健保開辦以來全台投保者的就醫資料，累積下來非常可觀的健保資料成為實證的基礎，期盼從這些資料當中分析出有價值、有意義的訊息。

　　為了建置1996年到2010年15年間台灣健保資料庫一百萬人抽樣歸人檔，本研究選擇使用文件型NoSQL資料庫 - MongoDB，發揮其處理非結構化資料的特色，將原本近兩億筆的大量就醫紀錄整合為百萬筆歸人資料，不僅降低了龐大的資料量，也更為便利地查詢使用者有興趣之就醫經歷的患者。

　　在資料的存放上透過分片(Sharding)技術，以患者出生年月為依據進行分片，並結合MapReduce來進行運算，可循序有效地取得目標患者的資料，提供使用者有良好的操作環境。

　　本研究的目標是從巨量的健保資料中，即時地取得符合查詢條件之就醫經歷的患者資料。而患者就醫紀錄可能相當繁多，為了清楚地呈現患者的狀況，系統提供一視覺化的介面，使用者能一目了然地查看患者就醫的經歷，並做進一步的探討。

關鍵字

健保資料庫 ； NoSQL資料庫 ； MongoDB ； 巨量資料 ； 資料視覺化呈現

並列摘要

National Health Research Institutes of Taiwan had build National Health Insurance Research Database, this database stored medical information since 1996 insured health care offered, it accumulated substantial health care data that has become the basis of many valuable medical studies.

In order to build a more efficient 1996 to 2010, 15 years, Taiwan National Health Insurance Health Database of Longitudinal Health Insurance Database 2010, this study uses a NoSQL Database - MongoDB, to process characteristics of unstructured data, it transformed originally nearly 200 million medical records, into millions of personal data, not only reduces the amount of data, made them convenient for users to search particular medical information which they are interested.

Using the sharding technique, individual date of birth was picked as the basis for sharding, combined with MapReduce operations user can efficiently acquire their target information.

The object of this study is to arrange the healthcare information in a timely manner to provide an easy access medical data format to render the patient's condition, on a visual interface, users can view patient medical detail with few keyboard strokes.

並列關鍵字

NHIRD ； NoSQL Database ； MongoDB ； Big Data ； Data Visualization

參考文獻

[2] Wei-Pin Chang, Ying-Chen Chi, May-Lien Pan, Yen-Jen Sun, Yu-Chien Liao, Chien-Chang Yang, Der-Ming Liou. Drug Expense of Atopic Dermatitis in Taiwan. 北市醫學雜誌, SEP 2013; 10(3): 229-243. DOI：10.6200/TCMJ.2013.10.3.06

[5] Wei-Pin Chang, Pei-Ching Chen, Yi-Hsiu Kuo, May-Lien Pan, Yen-Jen Sung, Der-Ming Liou, Chung-Ming Wu. An Analysis of Drug Expenses in the National Health Insurance Database for Dry Eye Syndrome Patients in 2008. 澄清醫護管理雜誌, JUL 2012; 8(3):18-26.

[6] Jhao-Yin Li, Jhe-Wei Lin, Zong-Hua Wu, Haw-Wei Wu, Chia-Cheng Yeh, Ya-Wen Yang. A Study on the Characteristics and Medical Resource Utilization of Patients with Chronic Obstructive Pulmonary Disease. 醫務管理期刊, SEP 2008; 9(3):159-173

[8] Shiu-Ching Chen, Wen-Chen Tsai, Yu-Tung Huang, Yi-Chung Hsieh, Kuang-Hua Huang. A study on the Inappropriate Prescription of Medications to Treat Hypertension in Taiwan. 臺灣公共衛生雜誌, FEB 2012; 31(1):31-42

[9] Cheng-Hsiu Chou, Ming-Yung Yen, Hui-Jung Chuang, Wen-Ping Liao, Ching-Hui Loh, Yeong-Hwang Chen, Chih-Chieh Chou. Epidemiology Analysis of Usage Prescriptions of Non-Steroidal Anti-Inflammatory Drugs of Osteoarthritis Patients in Taiwan. 中華職業醫學雜誌, APR 2010; 17(2):81-91