( 您好!臺灣時間:2021/05/10 13:10
字體大小: 字級放大   字級縮小   預設字形  


研究生(外文):Cheng-Chieh Chen
論文名稱(外文):Use Non-relational Database to Design and Implement A Visualization Platform for Health Insurance Resource Utilization
外文關鍵詞:NHIRDNHINoSQLData VisualizationNHI Resource Utilization
  • 被引用被引用:0
  • 點閱點閱:305
  • 評分評分:系統版面圖檔系統版面圖檔系統版面圖檔系統版面圖檔系統版面圖檔
  • 下載下載:0
  • 收藏至我的研究室書目清單書目收藏:0




Since 2000, Bureau of National Health Insurance of Taiwan commissioned the National Health Research Institutes (NHRI) to build up the "National Health Insurance Research Database(NHIRD)". NHIRD contains all insured medical record and provides excellent material for medical researcher. But researchers are difficult to handle the data amount. To those researchers, such huge amount of data has become a problem.

The relational database was developed at over twenty years ago; it has been seen as the mainstream of data storage technique. But relational database is not suitable for working with Big Data. Traditional relational database can’t working well in the approach with scale up. The new type of data storage models are commonly subsumed under the term NoSQL(Not-Only SQL). The key point is we may need to apply a new type of data storage model in NHIRD.

Focus on NHI Resource Utilization. Main purpose of present research is to set up a system based on non-relational database, try to provide a platform for analyzing NHI resource utilization systemically and to help researchers to derive significant information from NHIRD with data visualization tools.

誌謝 I
中文摘要 II
Abstract III
目錄 IV
圖目錄 VI
表目錄 VIII
第一章緒論 1
1.1研究背景 1
1.2研究動機及目的 1
1.3論文架構 1
第二章相關研究 3
2.1非關聯式資料庫 3
2.1.1 Key-Value Database 5
2.1.2 Column-Oriented Database 6
2.1.3 Document-Oriented 7
2.2 MapReduce 8
2.3 Data Visualization 10
2.4病例組合指標(CMI, Case Mix Index) 11
第三章材料與方法 12
3.1研究材料 12
3.2系統設計 13
3.2.1資料前處理 14
3.2.2資料儲存元件(DataStorage) 17
3.2.3計算元件(MapReduce Component) 18
3.2.4使用者介面及控制元件(User Interface/Controller) 19
第四章研究結果 21
4.1健保資源耗用概觀 21
4.2健保資源耗用排名 23
4.2.1疾病 23
4.2.2醫令 24
4.2.3醫療院所 24
4.3疾病資源耗用呈現 26
4.4 Timeline 28
4.4.1患者 28
4.4.2醫師 29
4.5疾病族群耗用比較 31
4.6病歷組合指標計算 32
4.7資料預篩匯出 33
4.8平台展示與討論 34
第五章結論與未來展望 37
5.1結論 37
5.2未來展望 38
參考文獻 39

[1] National Health Research Institutes:[Internet], Available fromhttp://nhird.nhri.org.tw/file_talk/apply101.xls(2012)
[2]連賢明,“如何使用健保資料進行經濟研究”經濟論文叢刊 36:1, pp115-143(2008)
[3] E. F. Codd,A Relational Model of Data for Large Shared Data Banks. Commun. ACM 13(6): 377-387(1970)
[4]M. Stonebraker, “Sql databases v. nosql databases,” Communications of the ACM, vol. 53, no. 4, pp.10–11, 2010.
[5]F Chang,Bigtable: A Distributed Storage System for Structured Data(2006)
[6]G DeCandia, Dynamo: Amazon’s Highly Available Key-value Store(2007)
[7]W. Vogels, “Eventually consistent,” Communications of the ACM, vol. 52, no. 1, pp. 40–44, 2009.
[8]J. Han, E. Haihong, G. Le, and J. Du, “Survey on nosql database,” in Pervasive Computing andApplications (ICPCA), 2011 6th International Conference on. IEEE, 2011, pp. 363–366.
[9]C. Strauch, U. Sites, and W. Kriha, “Nosql databases,” Lecture Notes, Stuttgart Media University,2011.
[10]RishabhAgrawal:[Internet], Available fromhttp://nosql.rishabhagrawal.com/2012_07_01_archive.html
[11]Wei-ping Z. and Ming-xin L. “Using MongoDB to Implement Textbook Management System instead of MySQL”, 3rd IEEE International Conference on Communication Software and Networks (ICCSN), May 27-29, 2011, Xi’an, China.
[12]Jeffrey Dean and Sanjay Ghemawat,MapReduce: Simplified Data Processing on Large Clusters,6th Symposium on Operating Systems Design and Implementation,2004
[14]M Memedi,A web application for follow-up of results from a mobile device test battery for Parkinson’s disease patients,COMPUTER METHODS AND PROGRAMS IN BIOMEDICINE 104 (2011)
[15]Wikipedia:[Internet], Available fromhttp://en.wikipedia.org/wiki/Case_mix_index
[16]National Health Insurance Research Database:[Internet], Available fromhttp://nhird.nhri.org.tw/date_02.htm
[17]EddDumbill,The SMAQ stack for big data,2010
[18]LingPipe,[Internet], Available fromhttp://alias-i.com/lingpipe/
[19]中華民國監察院:健保濫用調查報告-2013[Internet], Available from
[20]Baltimore Sun Graphic,2009
[21] Seth Flam DO,The Longitudinal Patient Record — A virtual “MRI” of your patient’s medical record,2011
[22]游斯雯,Characteristics and Medical Expenditures of Children Aged 0-19 Hospitalized for Injuries in Taiwan, 2006-2008,The Journal of Health Sciences,14:1,2012
[23]Chao-Hsiun Tang,One-year post-hospital medical costs and relapse rates of bipolar disorder patients in Taiwan: a population-based study,Bipolar Disorders 2010: 12: 859–865,2010
[24]Tien-Chiung Hung,Trend Analysis of Hospital Resource Utilization for Prolonged Mechanical Ventilation Patients in Taiwan: A Population-Based Study,RESPIRATORY CARE ‧ APRIL 2013 VOL 58 NO 4,2013
[25]Po-Huang Chiang et al,Healthcareutilizationandexpenditureanalysisbetween individualswithintellectualdisabilitiesandthegeneral populationinTaiwan:Apopulation-basednationwide child and adolescentstudy,Research inDevelopmentalDisabilities34,2013
[26]Cattell, R., “Scalable SQL and NoSQL data stores” SIGMOD Rec. 39, 4, May 2011, 12-27.
[27]Pokorny, J., “NoSQL databases: a step to database scalability in web environment.” In Proceedingsof the 13th International Conference on Information Integration and Web-based Applications andServices (iiWAS ''11). ACM, 2011, 278-283.
[28]Cogswell, Jeff., “SQL vs. NoSQL: Which Is Better?” [Internet], July 2012, Available fromhttp://slashdot.org/topic/bi/sql-vs-nosql-which-is-better/
[29]Gu, Genqiang,An overview of newly open-source cloud storage platforms,Granular Computing (GrC), 2012 IEEE International Conference
[30]MongoDB White Papers, "A Brief Introduction to MongoDB", In http://www.IOgen.comiwhite-papers.

第一頁 上一頁 下一頁 最後一頁 top
系統版面圖檔 系統版面圖檔