Building an Integrated Relational Database from Swiss Nutrition National Survey and Swiss Health Datasets for Data Mining Purposes

Authors: Ilona Mewes, Helena Jenzer, Farshideh Einsele

Abstract:

Objective: The objective of the study was to integrate two big databases from Swiss nutrition national survey (menuCH) and Swiss health national survey 2012 for data mining purposes. Each database has a demographic base data. An integrated Swiss database is built to later discover critical food consumption patterns linked with lifestyle diseases known to be strongly tied with food consumption. Design: Swiss nutrition national survey (menuCH) with approx. 2000 respondents from two different surveys, one by Phone and the other by questionnaire along with Swiss health national survey 2012 with 21500 respondents were pre-processed, cleaned and finally integrated to a unique relational database. Results: The result of this study is an integrated relational database from the Swiss nutritional and health databases.

Keywords: Health informatics, data mining, nutritional and health databases, nutritional and chronical databases.

References:

[1] Diet, Nutrition and the Prevention of Chronic Diseases, Report of a Joint WHO/FAO Expert Consultation, World Health Organization Geneva 2003.
[2] Diet, physical activity and health. Geneva, World Health Organization, 2002 (documents A55/16 and A55/16 Corr.1).
[3] Lim SS Vos T Flaxman AD et al., A comparative risk assessment of burden of disease and injury attributable to 67 risk factors and risk factor clusters in 21 regions, 1990–2010: a systematic analysis for the Global Burden of Disease Study 2010. Lancet. 2012; 380: 2224-2260
[4] Forouzanfar MH Alexander L et al., GBD 2013 Risk Factors Collaborators, Global, regional, and national comparative risk assessment of 79 behavioral, environmental and occupational, and metabolic risks or clusters of risks in 188 countries, 1990–2013: a systematic analysis for the Global Burden of Disease Study 2013. Lancet. 2015; 386: 2287-2323
[5] Global, regional, and national comparative risk assessment of 79 behavioral, environmental and occupational, and metabolic risks or clusters of risks, 1990–2015: a systematic analysis for the Global Burden of Disease Study 2015.Lancet. 2016; 388: 1659-1724
[6] World Cancer Research Fund International, Recommendations and public health and policy implications 2018
[7] https://health.gov/our-work/food-nutrition/2015-2020-dietary-guidelines/guidelines/introduction/nutrition-and-health-are-closely-related/
[8] M. B. Schulze, M. A. Martínez-González, T. T Fung, A. H. Lichtenstein, F Nita G Forouhi, Food based dietary patterns and chronic disease prevention, BMJ 2018; 361 doi: https://doi.org/10.1136/bmj.k2396 (Published 13 June 2018)
[9] I. P. Hearty and M. J. Gibney, Analysis of meal patterns with the use of supervised data mining techniques artificial neural networks and decision trees, 2008;88:1632–42. American Society for Nutrition
[10] M. Sulaiman Khan, M. Muyeba, F. Coenen, On Extraction of Nutritional Patterns (NPS) Using Fuzzy Association Rule Mining, healthinf 2008
[11] Agrawal and R. Srikant, Quest Synthetic Data Generator. IBM Almaden Research Center, http://www.almaden.ibm.com/cs/projects/iis/hdb/Projects/data_mining/datasets/data/assoc.gen.tar.Z
[12] L. Manikonda, R. Mall, V.Pudi and R. Rao, Mining Nutrition Survey Data,
[13] J.D. Kinsey, P. Wolfson, N. Katsaras, B. Senauer, Data mining, A segmentation analysis of US grocery shoppers, Working paper (University of Minnesota. Retail Food Industry Center), 01-01
[14] J. Harris and N. Blisard, Food-consumption patterns among elderly age groups, Journal of Food Distribution Research, 2002
[15] https://sites.google.com/site/dataminingcourse2009/spring2016/annoucement2016/ assignment3 /D11-02.ZIP, date: 7/17/2020
[16] https://www.blv.admin.ch/blv/de/home/lebensmittel-und-ernaehrung /ernaehrung/ menuch.html, date: 7/17/2020
[17] https://www.bag.admin.ch/bag/de/home/zahlen-und-statistiken.html, date: 7/17/2020