- 學位論文
應用巨量健保資料分析診斷治療之趨勢
Trend Analysis of Theranostics in Big Data Derived from the National Health Insurance Research Database
摘要
有別於傳統關聯式資料庫需依賴JOIN才能進行跨表單查詢的作法，非關聯式資料庫（NoSQL：Not Only SQL）具有Schema-free的資料儲存特性與Sharding的資料分片機制，因此適合被用來處理巨量資料。此外，依據Shard Key設定值執行Sharding，將巨量資料切割成小範圍區塊來加速查詢速度。即便如此，就我們所知，目前尚未有一個成熟且系統化的方式管理（包含檢索與視覺化）巨量健保資料。因此，本研究以病患歸人檔之文件導向方式儲存巨量健保資料，並探討健保資料庫所提供的欄位屬性，歸納出12項在診斷治療上的重要欄位，將此選定為Shard Key進行Sharding並執行目標查詢（Targeted Query）以提高檢索效率。並以一範例進行查詢時間效能測試，據實驗結果顯示，本研究所提出的資料處理方法確實能大幅度地縮短巨量的健保資料的查詢時間。
並列摘要
NoSQL (Not Only SQL) database has schema-free data format and the function of sharding. Comparing the NoSQL database with the relational database, the NoSQL database is more suitable to handle the big data. The big data is sharding into small blocks which are based on shard keys to speed up queries answering. To our knowledge, there is not yet a mature and systematic approach (including retrieval and visualization) to managing the big data derived from the National Health Insurance Research Database. Therefore, our research used patient document-oriented way to average the big medical data storage and to explore the field properties of the health insurance research database. By summarizing 12 important fields as shard keys in theranostics, before executing target queries can improve search efficiency. According to our experimental results, it shows that the proposed method of data processing can indeed significantly reduce the big data query time.
參考文獻
延伸閱讀
- 吳家豪、馬麗菁（2017）。線上健康類新聞之分析與預測－巨量資料架構。企業管理學報，(113)，1-29。https://doi.org/10.3966/102596272017060113001
- 周建羽（2019）。以巨量資料分析為基礎之行動健康資訊服務系統設計與評估〔碩士論文，國立臺中科技大學〕。華藝線上圖書館。https://www.airitilibrary.com/Article/Detail?DocID=U0061-0507201911431300
- 紀雅玲、賴淑芬（2020）。健保雲端資訊導入電子病歷閱覽整合平台之效益分析。病歷資訊管理，18(1)，37-40。https://www.airitilibrary.com/Article/Detail?DocID=16827988-202012-202012310019-202012310019-37-40
- 蔡介文、林怡君、李玟儀（2019）。以資訊系統實施成功模式為基礎探討醫師對健保雲端藥歷系統的使用與評價之初探。醫療資訊雜誌，28(1)，1-8。https://www.airitilibrary.com/Article/Detail?DocID=10213155-201903-201905210012-201905210012-1-8
- Chang, K. Y. (2011). Item Response Analysis for Data on Written Examinations in Anesthesiology [doctoral dissertation, National Taiwan University]. Airiti Library. https://doi.org/10.6342/NTU.2011.01026