U.S. flagAn official website of the United States government
                    Here's how you know **Official websites use .gov**
                            
                            A **.gov** website belongs to an official government organization in the United States.
 **Secure .gov websites use HTTPS**
                            
                            A **lock** (                            
                              A locked padlock                                                      
                            
                            ) or **https://** means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.


Menu Agricultural Research Service
						
                    U.S. DEPARTMENT OF AGRICULTURE
 close



Research
                Research Home
                            National Programs
                            Research Projects
                            Scientific Manuscripts
                            International Engagement
                            Scientific Software/Models
                            Databases and Datasets
                            Office of Scientific Quality Review
            Media
                News & Features
                            Multimedia
                            Briefing Room
                            Down on the Farm
                            Press Room
                            Science in Your Shopping Cart
                            Scientific Discoveries
                            Tellus
                            Under the Microscope
            About ARS
                About ARS Home
                            Staff Directory
                            Labs and Research Centers (Map)
                            Headquarter Offices
                            Organizational Chart
                            Employee Services (REE Employees Only)
                            Office of Outreach, Diversity, and Equal Opportunity
            Work With Us
                Work With Us Home
                            ARS Vacancies at USAJOBS
                            Careers at ARS Information
                            Scientific Collaborations
                            Extramural Agreements
                            1890 Faculty Research Sabbatical ProgramSearch small
                    Search
            
            ARS Home
                                About ARS
                                Contact Us




ARS Home Northeast Area Beltsville, Maryland (BHNRC) Beltsville Human Nutrition Research Center Food Surveys Research Group Research Publications at this Location





- ARS National Programs
- Search for a scientific manuscript
- Search for a research project
- ARS Software
- Programs and Projects
- Collaborations
- Subjects of Investigation
- Publications
- FSRG Home Page
- FSRG Main Menu
- WWEIA
- Dietary Methods Research
- What's In the Foods You Eat Search Tool
- FNDDS
- AMPM
- FPED
- FICRCD
- FSRG Listserv
- Food Surveys 1935-1998

Title:   Author  item
                                            Anderson, Ellenitem
                                            Steinfeldt, Loisitem
                                            Ahuja, Jaspreet
  Submitted to: Journal of Food Composition and Analysis
                                    Publication Type: Peer Reviewed Journal
                                    Publication Acceptance Date: 3/3/2004
                                    Publication  Date: 6/1/2004
                                    Citation: Anderson, E.T., Steinfeldt, L.C., Ahuja, J.K.C. 2004. Food and nutrient changes: Software for ensuring data quality. Journal of Food Composition and Analysis. 17:557-564.Interpretive Summary: The Food Database Management System (FDMS) is a software application designed to manage and maintain the U.S. Department of Agriculture's (USDA) technical support files used for large scale dietary surveys. Food and nutrient databases must be continually maintained and updated to reflect changes in the food supply and improvements in data values. Staff of the Food Surveys Research Group use FDMS to accomplish a variety of complex tasks involving the Food Code, Food Weights and Measures, Survey Nutrient, and Recipe and Formulas databases. FDMS was created using ObjectPal, the object-based, event-driven, visual programming language of the commercially available database program Paradox® (version 9). With FDMS, users can update the database files with new information such as adding a new food code or adding a brand name and gram weight to an existing food code. Another important feature is the ability to integrate time-related changes into the database files. Better data values, due to improved analytical procedures and sampling methods, can replace older values in the database. When there is a true change to the food product itself, FDMS allows users to specify these time-specific changes with start dates and end dates. Programmed into FDMS is a series of automated quality control checks which monitor processes in real-time to prevent potential errors from occurring. Interfile quality control checks are also in place so that related files across the different databases can be kept in sync and updated. FDMS also contains historical information, such as frequencies of food data used in previous surveys, which staff can utilize when setting priorities for database updates. Tracking different types of changes to data is important for studying trends in food and nutrient intakes over time. FDMS facilitates these changes in the database files and helps ensures data quality with built in quality control checks. USDA users of FDMS will benefit through more efficient database updates that require less time and resources. More frequent database updates result in more timely databases that reflect the latest dietary information available.
                                Technical Abstract: The Food Database Management System (FDMS) is a software application designed to manage and maintain the U.S. Department of Agriculture's (USDA) technical support files used for large scale dietary surveys.

Objective: Food and nutrient databases must be continually maintained and updated to reflect changes in the food supply and improvements in data values. Staff of the Food Surveys Research Group use FDMS to accomplish a variety of complex tasks involving the Food Code, Food Weights and Measures, Survey Nutrient, and Recipe and Formulas databases. 

Methods and Materials: FDMS was created using ObjectPal, the object-based, event-driven, visual programming language of the commercially available database program Paradox® (version 9).  The design of FDMS is modular such that different tasks can be programmed and implemented separately and user access can be controlled. 

Results: With FDMS, users can update the database files with new information such as adding a new food code or adding a brand name and gram weight to an existing food code. Another important feature is the ability to integrate time-related changes into the database files. Better data values, due to improved analytical procedures and sampling methods, can replace older values in the database. When there is a true change to the food product itself, FDMS allows users to specify these time-specific changes with start dates and end dates. Programmed into FDMS is a series of automated quality control checks which monitor processes in real-time to prevent potential errors from occurring. Interfile quality control checks are also in place so that related files across the different databases can be kept in sync and updated. FDMS also contains historical information, such as frequencies of food data used in previous surveys, which staff can utilize when setting priorities for database updates.  

Significance: Tracking different types of changes to data is important for studying trends in food and nutrient intakes over time. FDMS facilitates these changes in the database files and helps ensures data quality with built in quality control checks. An overview of FDMS features and user interface examples will be provided.


Return to top


Connect with ARS Sign up


ARS Home
                            USDA.gov
                            Plain Writing
                            Policies & Links
                            Civil Rights Statements
                            FOIA
                            Accessibility Statement
                            Privacy Policy
                            Non-Discrimination Statement
                            Quality of Information
                            USA.gov
                            WhiteHouse.gov