지원사업
학술연구/단체지원/교육 등 연구자 활동을 지속하도록 DBpia가 지원하고 있어요.
커뮤니티
연구자들이 자신의 연구와 전문성을 널리 알리고, 새로운 협력의 기회를 만들 수 있는 네트워킹 공간이에요.
논문 기본 정보
- 자료유형
- 학술저널
- 저자정보
- 발행연도
- 2017.8
- 수록면
- 298 - 306 (9page)
이용수
초록· 키워드
오류제보하기
Objectives: Since 1998, the Korea National Health and Nutrition Examination Survey (KNHANES) has been conducted in order to investigate the health and nutritional status of Koreans. The food intake data of individuals in the KNHANES has also been utilized as source dataset for risk assessment of chemicals via food. To improve the reliability of intake estimation and prevent missing data for less-responded foods, the structure of integrated long-standing datasets is significant. However, it is difficult to merge multi-year survey datasets due to ineffective cleaning processes for handling extensive numbers of codes for each food item along with changes in dietary habits over time. Therefore, this study aims at 1) cleaning the process of abnormal data 2) generation of integrated long-standing raw data, and 3) contributing to the production of consistent dietary exposure factors.
Methods: Codebooks, the guideline book, and raw intake data from KNHANES V and VI were used for analysis. The violation of the primary key constraint and the 1 st -3rd normal form in relational database theory were tested for the codebook and the structure of the raw data, respectively. Afterwards, the cleaning process was executed for the raw data by using these integrated codes.
Results: Duplication of key records and abnormality in table structures were observed. However, after adjusting according to the suggested method above, the codes were corrected and integrated codes were newly created. Finally, we were able to clean the raw data provided by respondents to the KNHANES survey.
Conclusion: The results of this study will contribute to the integration of the multi-year datasets and help improve the data production system by clarifying, testing, and verifying the primary key, integrity of the code, and primitive data structure according to the database normalization theory in the national health data.
목차
등록된 정보가 없습니다.
참고문헌 (5)
참고문헌 신청
Korea Centers for Disease Control & Prevention / Korea National Health & Nutrition Examination Survey
Korea Food & Drug Administration / Study on Extension of Dietary Exposure Assessment System - On Dietary Intake Database and Food & Nutrient Content Database -
Choi HS / 2011 / Vitamin D Insufficiency in Korea—A Greater Threat to Younger Generation: The Korea National Health and Nutrition Examination Survey (KNHANES) 2008 / J Clin Endocrinol Metab 96:643~651
Codd EF / 1969 / Derivability, Redundancy, and Consistency of Relations Stored in Large Data Banks
Shin SK / 2006 / Denormalization strategies for data retrieval from data warehouses / Decision Support Systems 42(1):267~282
Korea Food & Drug Administration / Study on Extension of Dietary Exposure Assessment System - On Dietary Intake Database and Food & Nutrient Content Database -
Choi HS / 2011 / Vitamin D Insufficiency in Korea—A Greater Threat to Younger Generation: The Korea National Health and Nutrition Examination Survey (KNHANES) 2008 / J Clin Endocrinol Metab 96:643~651
Codd EF / 1969 / Derivability, Redundancy, and Consistency of Relations Stored in Large Data Banks
Shin SK / 2006 / Denormalization strategies for data retrieval from data warehouses / Decision Support Systems 42(1):267~282
함께 읽어보면 좋을 논문
논문 유사도에 따라 DBpia 가 추천하는 논문입니다. 함께 보면 좋을 연관 논문을 확인해보세요!
-
A cross-sectional study on the pulmonary function of residents in two urban areas with different PM10 concentrations : data from the fourth Korea national health and nutrition examination survey (KNHANES) 2007–2009
대한직업환경의학회지
2018 .07
-
The Effect of Long Working Hours on Ischemic Heart Disease in The Korean Population : The Korea National Health and Nutrition Examination Survey (KNHANES), 2007 to 2013
대한직업환경의학회 학술대회 논문집
2015 .11
-
An Overview of Ophthalmologic Survey Methodology in the 2008- 2015 Korean National Health and Nutrition Examination Surveys
Korean Journal of Ophthalmology
2015 .01
-
Calibration of High-Density Lipoprotein Cholesterol Values From the Korea National Health and Nutrition Examination Survey Data, 2008 to 2015
Annals of Laboratory Medicine
2017 .01
-
Change in the height of Korean children and adolescents: analysis from the Korea National Health and Nutrition Survey II and V
Clinical and Experimental Pediatrics
2015 .01
-
Factors Affecting the Quality of Life of Working Cancer Survivors: Based on the 6th and 7th (2014, 2016, 2018) Korean National Health and Nutrition Examination Survey (KNHANES)
Asian Oncology Nursing
2020 .12
-
Has the Incidence of Acute Pyelonephritis Increased in Korea? – Big Data as a Double-edged Sword
Journal of Korean Medical Science
2018 .01
-
우리 나라 성인의 구강건강과 자살시도와의 관련성 : 제 7기(2016-2018년) 국민건강영양조사를 바탕으로
한국치위생학회지
2020 .01
-
국민건강영양조사 구강검사 개요
대한구강보건학회지
2018 .12
-
Application of the 2013 American College of Cardiology/American Heart Association Cholesterol Guideline to the Korean National Health and Nutrition Examination Surveys from 1998 to 2012
Diabetes and Metabolism Journal
2017 .01
-
한국 노인의 건강관련 삶의 질과 영향요인 추이
한국보건간호학회지
2018 .08
-
우리나라 청년층(19세∼34세)의 자살생각의 영향요인 비교분석 : 제4기(2007년∼2009년)와 제7기(2016년∼2017년) 국민건강영양조사 자료를 이용하여
보건의료산업학회지
2020 .01
-
건강프로그램 일부참여자의 식이섭취실태에 따른 치아우식병과의 상관관계 연구
대한구강보건학회지
2022 .12
-
An assessment of dietary intake, food avoidance and food beliefs in patients with ulcerative colitis of different disease status
Intestinal research
2020 .01
-
빅 데이터의 소개
항공우주의학회지
2022 .08
-
Differences of nutritional intake habits and Dietary Inflammatory Index score between occupational classifications in the Korean working population
대한직업환경의학회지
2024 .12
-
Blood Cadmium levels and Depression among Adults in Korea
대한직업환경의학회 학술대회 논문집
2016 .11
-
Development of an Integrated Biospecimen Database among the Regional Biobanks in Korea
Healthcare Informatics Research
2016 .01
-
환경유래 식품오염물질의 범부처 통합 저감화 플랫폼 설계
한국환경보건학회지
2017 .08
-
Adequacy of Protein Intake among Korean Elderly: An Analysis of the 2013–2014 Korea National Health and Nutrition Examination Survey Data
Korean Journal of Family Medicine
2018 .01
이 논문의 저자 정보
최근 본 자료
댓글(0)
0