1 / 84

全民健康保險研究資料庫論文 產出分析、研究方向及使用示範

全民健康保險研究資料庫論文 產出分析、研究方向及使用示範. 陳曾基 國立陽明大學醫學院醫務管理研究所 台北榮民總醫院家庭醫學部. 今天在北醫權充一天和尚 Der Prophet gilt nichts im eigenen Land. Nullus propheta in patria. An ass in Germany is a professor in Rome. -. Materials: Extract data from PubMed. .

gavril
Download Presentation

全民健康保險研究資料庫論文 產出分析、研究方向及使用示範

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. 全民健康保險研究資料庫論文產出分析、研究方向及使用示範全民健康保險研究資料庫論文產出分析、研究方向及使用示範 陳曾基 國立陽明大學醫學院醫務管理研究所 台北榮民總醫院家庭醫學部

  2. 今天在北醫權充一天和尚Der Prophet gilt nichts im eigenen Land.Nullus propheta in patria.An ass in Germany is a professor in Rome.

  3. -

  4. Materials: Extract data from PubMed  ("insurance, health"[MeSH Terms] OR "national health programs"[MeSH Terms] OR health insurance[TW] OR national health[TW] OR national insurance[TW] OR claims data*[TW] OR claim data*[TW] OR insurance claim*[TW] OR insurance data*[TW] OR administrative data*[TW] OR nationwide data*[TW] OR national data*[TW] OR NHIRD[TW] OR NHI[TW] OR BNHI[TW] OR population based[TW] OR population*[ti] OR nationwide[ti] ) AND taiwan[All Fields] AND English[lang] AND 1996:2009[dp] 2010 * Accuracy not guaranteed !!! Courtesy of Yu-Chun Chen

  5. Materials: Review of NHIRD Papers  383articles are included Courtesy of Yu-Chun Chen

  6. NHIRD Papers Grows Exponentially Courtesy of Yu-Chun Chen

  7. NHIRD Papers Increase In Both Quantity and Quality Courtesy of Yu-Chun Chen

  8. Cumulative Number of Papers Using NHIRD, 2000-2009 a Annual growth rate=(no. of studies in current year – no. of studies in previous year) / no. of studies in previous year b Doubling time is estimated by fitted exponential model

  9. Distribution of Study Topics Courtesy of Yu-Chun Chen

  10. Average IF in SCI Fields Courtesy of Yu-Chun Chen

  11. Productivity of authors: reproducible success? Courtesy of Yu-Chun Chen

  12. Status: 6 Apr 2011

  13. Distribution of NHIRD Papersby Journal Impact Factor and Year

  14. Social Network Analysis as a Tool to Visualize Flow of InformationAnalysis of studies using health databases 德國海德堡大學醫療資訊研究所 陳 育 群 Sep 25, 2010

  15. Collaboration Network: 2000-2009 • Chen YC et. al. Scientometrics (2010)Taiwan’s NHIRD: administrative health care database as study object in bibliometrics

  16. Collaboration network: 2000 Collaboration network, 2000

  17. Collaboration network: 2001 Collaboration network, 2001

  18. Collaboration network: 2002 Collaboration network, 2002

  19. Collaboration network: 2003 Collaboration network, 2003

  20. Collaboration network: 2004 Collaboration network, 2004

  21. Collaboration network: 2005 Collaboration network, 2005

  22. Collaboration network: 2006 Collaboration network, 2006

  23. Collaboration network: 2007 Collaboration network, 2007

  24. Collaboration network: 2008 Collaboration network, 2008

  25. Collaboration network: 2009 Collaboration network, 2009

  26. Collaboration network: 2009 (label) Collaboration network, 2009

  27. Design of Claims-Based Studies 資料處理 單純 複雜 低臨床 相關 高臨床 相關

  28. Types of Study Designs / Computation • Simple description • Association / Relationship • Complex computation (Data mining)

  29. Simple Description • Disease • Epidemiologic features of Kawasaki disease in Taiwan, 1996-2002. • A nationwide survey on epidemiological characteristics of childhood Henoch-Schönlein purpura in Taiwan. • Prevalence and risks of chronic airway obstruction: a population cohort study in Taiwan. • Drug • Utilization of hepatoprotectants within the National Health Insurance in Taiwan. • Demographics and patterns of acupuncture use in the Chinese population: the Taiwan experience. • Person • Risks and causes of hospitalizations among physicians in Taiwan • Specialty • Use frequency of traditional Chinese medicine in Taiwan. • Sector • Patterns of ambulatory care utilization in Taiwan.

  30. Association / Relationship • A  B (no temporal consideration) • Association between physician volume and hospitalization costs for patients with stroke in Taiwan: a nationwide population-based study. • A  B (temporal change) • Seasonal variations in urinary calculi attacks and the association with climate: a population-based study. • A => B (temporal sequence) • Risk of extrapyramidal syndrome in schizophrenic patients treated with antipsychotics: a population-based study. • Sudden sensorineural hearing loss increases the risk of stroke: A 5-year follow-up study • Does elective caesarean section increase utilization of postpartum maternal medical care? * Control Group

  31. Complex Computation • Association rule mining • Application of a data-mining technique to analyze coprescription patterns for antacids in Taiwan. • Frequent itemset mining • The prescriptions frequencies and patterns of Chinese herbal medicine for allergic rhinitis in Taiwan.

  32. Simple Description Pediatrics : IF 4.789, Ranking 2 / 86 (Pediatrics) • Disease • Epidemiologic features of Kawasaki disease in Taiwan, 1996-2002. • A nationwide survey on epidemiological characteristics of childhood Henoch-Schonlein purpura in Taiwan. • Prevalence and risks of chronic airway obstruction: a population cohort study in Taiwan. • Drug • Utilization of hepatoprotectants within the National Health Insurance in Taiwan. • Demographics and patterns of acupuncture use in the Chinese population: the Taiwan experience. • Specialty • Use frequency of traditional Chinese medicine in Taiwan. • Sector • Patterns of ambulatory care utilization in Taiwan. Rheumatology : IF 4.136, Ranking 7 / 22 (Rheumatology) Chest : IF 5.154, Ranking 4 / 40 (Respiratory system)

  33. Association / Relationship Stroke : IF 6.499, Ranking 6 / 156 (Clinical Neurology) • A  B (no temporal consideration) • Association between physician volume and hospitalization costs for patients with stroke in Taiwan: a nationwide population-based study. • A  B (temporal change) • Seasonal variations in urinary calculi attacks and the association with climate: a population-based study. • A => B (temporal sequence) • Risk of extrapyramidal syndrome in schizophrenic patients treated with antipsychotics: a population-based study. • Sudden sensorineural hearing loss increases the risk of stroke: A 5-year follow-up study • Does elective caesarean section increase utilization of postpartum maternal medical care? J Urology : IF 3.952, Ranking 9 / 57 (Urology …) Clin Pharmacol Ther : IF 7.586, Ranking 9 / 219 (Pharmacology …) Stroke : IF 6.499, Ranking 6 / 156 (Clinical Neurology) Med Care : IF 3.194, Ranking 5 / 62 (Health Care Sciences ...)

  34. Complex Computation • Association rule mining • Application of a data-mining technique to analyze coprescription patterns for antacids in Taiwan. • Frequent itemset mining • The prescriptions frequencies and patterns of Chinese herbal medicine for allergic rhinitis in Taiwan. Allergy : IF 6.204, Ranking 2 / 17 (Allergy)

  35. 使用示範 (陳育群醫師製作)

  36. NHIRD Datasets

  37. 健保資料庫長得這樣…

  38. 變成這樣…

  39. 40

  40. File Structures of Datasets to Process • Single file • Multiple files: • Of the same format • Of similar formats in different years • Of different formats, but connected through • Primary key / foreign key • Loop-up table

  41. Main Tasks 1.資料轉換 READ 2.變數處理 SELECT, FILTER APPEND, UNION JOIN, SORT 3.結果分析 AGGREGATE OUTPUT STATISTICS

  42. 程式語言 統計套裝軟體 資料管理系統

  43. 1.資料轉換      2.變數處理      3.結果分析    

  44. 由資料來源讀取出資料,將它們轉換成適合分析的型態,並且將它們匯入資料庫內。由資料來源讀取出資料,將它們轉換成適合分析的型態,並且將它們匯入資料庫內。 通常還要搭配著資料清潔 (Data Cleaning) 將系統源頭許多未經整合的、不允許的、遺失的或者錯誤的資料,在匯入之前重新整頓(Garbage In, Garbage Out) 資料轉換 1.資料轉換 READ

  45. 把分別儲存於不同表格的原始資訊,如醫院層級、藥物分類、疾病分類、重大傷病等等「串連」許多個資料表把分別儲存於不同表格的原始資訊,如醫院層級、藥物分類、疾病分類、重大傷病等等「串連」許多個資料表 資料加值 變數處理 2.變數處理 SELECT, FILTER APPEND, UNION JOIN, SORT

  46. 以SAS為例

  47. 已知某個族群 (ID_Cohort),想了解這個族群在2000年到2006年的就診情形(醫院層級、醫院所在地點、看診日期) 實際上的例子 (1)

  48. 已知某個族群 (ID_Cohort), 排除掉(exclusion criteria),想了解這個族群在2000年到2006年內第一次就診日期 實際上的例子 (2)

More Related