ABSTRACT
The retrieval and manipulation of data from large public databases like the U.S. National Health and Nutrition Examination Survey (NHANES) may require sophisticated statistical software and significant expertise that may be unavailable in the university setting. In response, we have developed the Data Retrieval And Manipulation System (DReAMS), an automated information system to handle all processes of data extraction and cleaning and then joining different subsets to produce analysis-ready output. The system is a browser-based data warehouse application in which the input data from flat files or operational systems are aggregated in a structured way so that the desired data can be read, recoded, queried and extracted efficiently. The current pilot implementation of the system provides access to a limited amount of NHANES database. We plan to increase the amount of data available through the system in the near future and to extend the techniques to other large databases from CDU archive with a current holding of about 53 databases.
Subject(s)
Data Mining/methods , Database Management Systems/organization & administration , Information Dissemination/methods , Internet/organization & administration , Natural Language Processing , Nutrition Surveys/statistics & numerical data , User-Computer Interface , Nutrition Surveys/classification , Nutrition Surveys/methods , Pilot Projects , United StatesABSTRACT
Luego de los años setenta, y a partir de la experiencia norteamericana, en varios países, se comienza a medir el estado alimenticio de la población y los cambios a través del tiempo. La encuesta nacional, con el fin de ofrecer información periódica y actualizada, permite desarrollar, monitorear y establecer políticas en relación a la salud y nutrición de la población infantil. Entre los métodos de encuesta nutricional más utilizados están el recordatorio de 24 horas, el registro diario de alimentos, peso directo de los alimentos y frecuencia semi-cuantitativa.
After the seventies, and from the American experience in several countries, begin to measure the nutritional status of the population and changes over time. The national survey, in order to provide regular and updated information, can develop, monitor and develop policies in relation to health and nutrition of children. Among the nutritional survey methods most used are the 24-hour recall, the journal of food, live weight of food and often semi-quantitative.