응용통계연구 (The Korean Journal of Applied Statistics)

  • 제30권1호
  • /
  • Pages.13-24
  • /
  • 2017
  • /
  • 1225-066X(pISSN)
  • /
  • 2383-5818(eISSN)
한국통계학회 (The Korean Statistical Society)
권호 표지
DOI QR코드

DOI QR Code

국민건강보험공단의 표본연구DB를 위한 비주얼 쿼리 데이터베이스 시스템 개발 연구

A visual query database system for the Sample Research DB of the National Health Insurance Service

  • 조상훈 (숭실대학교 정보통계보험수리학과) ;
  • 김희찬 (숭실대학교 대학원 융합 소프트웨어학과) ;
  • 강근석 (숭실대학교 정보통계보험수리학과)
  • Cho, Sang-Hoon (Department of Statistics and Actuarial Science, Soongsil University) ;
  • Kim, HeeChan (Department of Software Convergence, Graduate School, Soongsil University) ;
  • Kang, Gunseog (Department of Statistics and Actuarial Science, Soongsil University)
  • 투고 : 2016.10.27
  • 심사 : 2016.12.12
  • 발행 : 2017.02.28
PDF 다운로드
⟨ 이전 논문 다음 논문 ⟩

초록

국민건강보험공단에서 제공하는 표본코호트DB는 보건의료계뿐만 아니라 통계학 연구를 위한 중요한 자원이다. 일반적으로 이들 자료에서 연구에 필요한 정보를 얻기 위하여 관련 사례들을 추출하는 과정에는 많은 시간과 노력이 들게 된다. 본 논문에서는 표본코호트DB를 이용하고자 할 때 사례 추출과정에 도움을 주는 데이터베이스 시스템인 National Health Insurance Service Cohort DB Extract Tool(NICE Tool)을 소개한다. SAS의 DATA 명령문이나 SQL문에 익숙하지 않은 연구자들도 쉽게 마우스 클릭만으로 DB에서 필요한 변수들과 조건에 맞는 사례들을 추출할 수 있는 기능을 제공한다. 이 시스템을 활용하면 빠른 사례추출이 가능하여 표본코호트DB를 사용한 연구들이 더욱 활성화되리라 판단된다.

The Sample Cohort DB supplied by the National Health Insurance Service is a valuable resource for statistical studies as well as for health and medical studies. It takes significant time and effort to extract data from this Cohort DB having a large size. As such, we introduce a database system, conveniently called the National Health Insurance Service Cohort DB Extract Tool (NICE Tool), which supports several useful operations for effectively and efficiently managing the Cohort DB. For example, researchers can extract variables and cases related with study by simply clicking a computer mouse without any prior knowledge regarding SAS DATA step or SQL. We expect that NICE Tool will facilitate the faster extraction of data and eventually lead to the active use of the Cohort DB for research purposes.

키워드

참고문헌

  1. Kim, T., Lee, H., Ahn, S., Kwon, O.-K., Bang, J. S., Hwang, G., Kim, J. E., Kang, H.-S., Son, Y.-J., Cho, W.-S., and Oh, C. W. (2016). Incidence and risk factors of intracranial aneurysm: a national cohort study in Korea, International Journal of Stroke, 11, 917-927. https://doi.org/10.1177/1747493016660096
  2. Ko, M. J., Park, C. M., Kim, Y. J., Kang, S. H., and Park, D. W. (2015). Clinical application and potential effects of 2014 hypertension guidelines on incident cardiovascular events, American Heart Journal, 170, 1042-1049. https://doi.org/10.1016/j.ahj.2015.07.028
  3. Lee, J. and Kim, K. (2012). Construction of an Appropriate Sampling Design and a Sample Database Using the National Health Information Database, Research Report, National Health Insurance Service.
  4. Lee, J., Lee, J. S., Park, S. H., Shin, S. A., and Kim, K. (2016). Cohort profile: the national health insurance service-national sample cohort (NHIS-NSC), South Korea, International Journal of Epidemiology, Available from: 10.1093/ije/dyv319
  5. Naramore, E. (2015). Beginning PHP5, Apache, and MySQL Web Development, Wiley Publishing, Indianapolis.
  6. NHIS (2016a). User's Manual for the Sample Research DB Ver4.0, Big Data Steering Department, National Health Insurance Service.
  7. NHIS (2016b). Training Book for Utilizing the Sample Research DB, National Health Insurance Service.
  8. Park, J., Suh, B., Shin, D. W., Hong, J. H., and Ahn, H. (2015). Changing patterns of primary treatment in Korean men with prostate cancer over 10 years: a nationwide population based study, Cancer Research and Treatment, 48, 899-906.
  9. Rim, T. H., Kim, D. W., Han, J. S., and Chung, E. J. (2015). Retinal vein occlusion and the risk of stroke development: a 9-year nationwide population-based study, Ophthalmology, 122, 1187-1194. https://doi.org/10.1016/j.ophtha.2015.01.020
  10. Rim, T. H., Oh, J., Kang, S. M., and Kim, S. S. (2016). Association between retinal vein occlusion and risk of heart failure: a 12-year nationwide cohort study, International Journal of Cardiology, 217, 122-127. https://doi.org/10.1016/j.ijcard.2016.04.174
  11. Welling, L. and Thomson, L. (2016). PHP and MySQL Web Development (5th ed), Addison & Wesley, Indianapolis.
  12. Yu, S., Wee, J., Kim, J. W., and Yoon S. (2015). Methodology for big data analysis using data from national health insurance service: preliminary methodologic study and review about the relationship between sinus surgery and asthma, Journal of Rhinology, 22, 28-33. https://doi.org/10.18787/jr.2015.22.1.28