퇴원손상심층조사 자료의 효율적 활용을 위한 데이터베이스 구축에 대한 연구
A Study on Database Construction for Efficient Utilization of Korean National Hospital Discharge In-depth Injury Survey Data
0
조회
0
다운로드
0
인용
0
참고문헌
키워드
초록
Objectives: The present study is focused on extracting various data such as diseases, surgical operations and treatments of the Korean National Hospital Discharge In-depth Injury Survey Data to construct an effective database that can be widely used in development of policies and research. Methods: The database construction methodology was applied to construct an effective database using the Korean National Hospital Discharge In-depth Injury Survey Data from 2006 to 2016. And for the data integration, the items and properties of data for each year were checked. As for the software to construct the database, the Relational Database Management System (RDBMS) MySql was used. And through normalization, the Entity Relationship Diagram was designed to record the DDL and DML to conduct physical modeling. Results: As a result of checking the collected items per year, there were no problems in constructing the database. There were total of 68 items and 2,253,001 cases of sample patients. Through the normalization process, they were divided into 3 different entities and each entity was issued a primary key consisting of the year and patient number. Finally, the integrated database construction was completed by compiling the SQL for physical modeling. Conclusions: The integrated database model of the Korean National Hospital Discharge In-depth Injury Survey Data was produced. In the future, its usage will increase as it enables effective data extraction for various researches related to diseases, surgical operations, and treatments. Furthermore, it could also be used in constructing the web-based supplying system for the Korean National Hospital Discharge In-depth Injury Survey Data.
Abstract
Objectives: The present study is focused on extracting various data such as diseases, surgical operations and treatments of the Korean National Hospital Discharge In-depth Injury Survey Data to construct an effective database that can be widely used in development of policies and research. Methods: The database construction methodology was applied to construct an effective database using the Korean National Hospital Discharge In-depth Injury Survey Data from 2006 to 2016. And for the data integration, the items and properties of data for each year were checked. As for the software to construct the database, the Relational Database Management System (RDBMS) MySql was used. And through normalization, the Entity Relationship Diagram was designed to record the DDL and DML to conduct physical modeling. Results: As a result of checking the collected items per year, there were no problems in constructing the database. There were total of 68 items and 2,253,001 cases of sample patients. Through the normalization process, they were divided into 3 different entities and each entity was issued a primary key consisting of the year and patient number. Finally, the integrated database construction was completed by compiling the SQL for physical modeling. Conclusions: The integrated database model of the Korean National Hospital Discharge In-depth Injury Survey Data was produced. In the future, its usage will increase as it enables effective data extraction for various researches related to diseases, surgical operations, and treatments. Furthermore, it could also be used in constructing the web-based supplying system for the Korean National Hospital Discharge In-depth Injury Survey Data.
참고문헌 (16)
- 임준원, "공공데이터 개방 정책이 공공 혁신에 미치는 영향에 관한 연구", 대한산업공학회지, 43(1), pp.19~29 (2017), 대한산업공학회[DOI]
- 김경열, "공공데이터 활용을 위한 개인정보보호 제도의 개선 과제", 경제규제와 법, 7(2), pp.22~37 (2014), 법학연구소
- 송석현, "한국의 공공데이터 개방 정책의 효과에 대한 연구: 생태계 관점에서", 한국지역정보화학회지, 20(4), pp.1~34 (2017), 한국지역정보화학회[DOI]
- Utilization of open government data for health policy, "Lee EH", Gyeonggi Research Institute, ~ (2016)
- 조수경, "성인 당뇨병 환자의 소득수준에 따른 혈당, 당화혈색소, 혈압, 및 혈중지질 지표의 변화 추이 : 국민건강영양조사 1998 ~ 2014 분석 결과", Journal of Nutrition and Health, 52(2), pp.206~216 (2019), 한국영양학회[DOI]
- Domestic secondary data resources utilization in healthcare research, "Hwang JS", National Evidence-based Healthcare Collaborating Agency, ~ (2013)
- Korea Centers for Disease Control and Prevention, "Korean National Hospital Discharge In-depth Injury Survey Guidebook", Korea Centers for Disease Control and Prevention, ~ (2010)
- "Access specifications"[URL]
- "MySQL Community Downloads"[URL]
- HYUN-IL SUNG, "CONSTRUCTION OF ASTRONOMICAL DATABASE BASED ON MySQL AND JSP", Publications of The Korean Astronomical Society, 19(1), pp.109~119 (2004), The Korean Astronomical Society[DOI]
- 윤상오, "공공데이터 개방정책의 실태분석 및 개선방안에 관한 연구: 공공데이터 포털의 국가중점데이터 개방 사례를 중심으로", 한국공공관리학보, 33(1), pp.219~247 (2019), 한국공공관리학회[DOI]
- 김희성, "분산병렬처리 환경에서 오토매핑 기법을 통한 NoSQL과 RDBMS와의 연동", 한국정보통신학회논문지, 21(11), pp.2067~2075 (2017), 한국정보통신학회[DOI]
- Mahajan D, "Improving the energy efficiency of relational and NoSQL databases via query optimizations", Sustainable Computing : Informatics and Systems, 22, pp.120~133 (2019)[DOI]
- 전동철, "HL7 FHIR 기반 의료 데이터 처리 시스템에서 YCSB를 통한 RDBMS와 MongoDB의 성능 분석 연구", 멀티미디어학회논문지, 21(8), pp.934~941 (2018), 한국멀티미디어학회[DOI]
- 신현광, "미국 헬스케어 오픈 데이터 기업의 에고 네트워크 분석", Journal of The Korean Data Analysis Society, 17(6), pp.3107~3118 (2015), 한국자료분석학회
- 이현직, "의료정보서비스 접근성 향상을 위한 개방형 플랫폼 구축방안", 디지털콘텐츠학회논문지, 18(7), pp.1341~1346 (2017), 한국디지털콘텐츠학회[DOI]