Cover Image
close this book Food Composition Data: A User's Perspective (1987)
close this folder Managing food composition data
close this folder Maintaining a food composition data base for multiple research studies: the NCC food table
View the document (introductory text)
View the document Introduction
View the document Specific user needs and approaches to these needs
View the document Minimizing redundancy in the nutrient data base
View the document Summary
View the document References

Specific user needs and approaches to these needs

Specific user needs and approaches to these needs

The Need for Standardized Methods of Determining Nutrient Values for All Foods and Beverages Consumed by the Study Population

Users of a nutrient data base require that the system be capable of handling not only common foods and beverages, but also any uncommon items that might be consumed by the study population. New entries are frequently added to the NCC Food Table to meet study-specific needs. Food composition data are gathered for regional foods and local recipes which appear on dietary intake forms, and also for new manufactured products or reformulations of existing products consumed by the study population. These new foods or beverages are compared with existing Food Table entries. If the item cannot be represented by an existing entry or a combination of existing entries, a new entry is developed. All coding decisions are documented and cross referenced as appropriate to ensure that the item will be coded in the same way if it appears on future dietary intake forms.

The Need for Updated and Complete Nutrient Profiles

Nutrient data bases must be updated continually to meet the needs of a wide range of investigators. The updated file must reflect new published or provisional data provided by the United States Department of Agriculture (USDA), new analytic data from the scientific literature, and current food composition data for new or reformulated commercial products.

To ensure that nutrient values in the NCC Food Table are current, several dozen scientific journals are reviewed by the NCC nutrition staff on a monthly basis. Any new data on food composition, new products, or food labelling are extracted. These data, along with any other newly available data from USDA or food manufacturers, are compared with existing values in the Food Table. Limits have been established for each nutrient to guide data-base nutritionists in determining when the difference between the new and the existing value is sufficient to warrant a modification to the Food Table; modification procedures are implemented only when differences exceed the established limit values. This system prevents the expenditure of considerable time and effort on making changes to the Food Table that are insignificant considering the variability inherent in nutrient data.

Major food manufacturers are contacted annually for updated information on the nutrient composition of their products, and new data are compared with existing values. Differences that exceed the established limit values are identified as being caused by either product reformulation or better analytical data. If the product has been reformulated, a new entry is added to the Food Table and the old entry deactivated so that it cannot be used in future coding. If the nutrient differences are the result of better analytical data, modification procedures are implemented.

New nutrients have been added to the NCC Food Table to accommodate investigators' current research interests. USDA data are the preferred sources, but when these are incomplete or unavailable other sources, including foreign food tables, scientific literature, data from food manufacturers, or unpublished laboratory data, are used. All sources of raw data are reviewed and compared by a data-base nutritionist, and values are selected or imputed for the Food Table based on factors which include the reliability of the data sources, the laboratory analytic method used, and the number of samples analysed.

Adding new nutrients to the NCC Food Table often requires making separate entries for items grouped within a single entry. For example, the addition of sodium to the nutrient profile resulted in new entries for canned vegetables, which were previously included in the entries for vegetables cooked from fresh or frozen sources.

Users also need a data base that is complete for all nutrient values. Since missing values are calculated as zeros in the nutrient analysis, they are tolerated only in cases where zero is as good an estimate as any other for a given nutrient in a given food item. The NCC data-base nutritionists impute values, whenever possible, from the nutrient content of similar foods, recipes, or product ingredient lists. As soon as better data become available, the values are updated to reflect the analytic data.

The Need for Documentation of Sources of Nutrient Values

Users of a nutrient data base require documentation of the sources of nutrient information used in the calculation of their dietary data to enable them to judge the reliability of the nutrient analysis.

The NCC reference system includes a six-character field for proximate composition and a two-character field for all other food components. The leading character in the proximate composition field designates the general category of the reference source, and remaining characters specify the actual page or code number in the designated source. The two-character code for nutrient references designates the source as an USDA reference, other food table reference, specific journal reference, or other source of nutrient data, including calculations and imputations.

A paper file is maintained for every entry in the NCC Food Table. All details of calculations and imputations of nutrient values, including the rationale for selection of the foods on which these determinations are based, are documented in the paper file. General guidelines by food groups are maintained for calculating or imputing nutrient values.

Codes for reliability of nutrient data have been discontinued due to the difficulty of establishing objective guidelines to meet the needs of all users. Sources of all nutrient data are documented as completely as possible in the NCC Food Table so that the user is able to judge reliability in relation to a specific research setting.

The Need for Quality-control Procedures to Ensure the Accuracy of the Data Base

Nutrient data-base users need assurances that the values used in the calculation of their dietary intake data are accurate and that the computer programs used to calculate the data are reliable.

Despite ongoing efforts to maintain the accuracy of a nutrient data base, mistakes can find their way into a system as a result of human error or mechanical or software malfunctions. A number of quality-control procedures have been developed by the NCC to document the accuracy of the Food Table and the calculation software.

The NCC Food Table is updated on a daily basis by the data-base nutrition staff. All Food Table modifications are made to a separate file called the Reference Food Table. Nutrient modifications are edited in the data-entry system by comparing new nutrient values with NCC established nutrient ranges. A value that falls out of range must be verified by an NCC nutritionist.

The Reference Food Table is periodically checked for accuracy by running a series of computer-generated integrity reports that are reviewed by the nutrition staff. Some integrity checks are algorithms that are calculated for each entry and compared with a predetermined value. Other integrity checks are listings of individual nutrients by food groups. Any nutrient value that deviates substantially from other values in that food group is verified by a nutritionist.

After all integrity reports have been verified, a test set of dietary intake records are analysed to check the various calculation procedures. The results of the nutrient calculations are compared with the previous calculations of the test records. Any differences observed must be verified as being due to recent modifications to the Reference Food Table. After satisfactory implementation of these procedures, the Reference Food Table is available for research use and becomes the current version of the NCC Food Table.

The Need for Stability of the Nutrient Data Base for Long-term Studies

Although the majority of researchers want to use the most current nutrient information available at the outset of a study, they require that the data base remain stable for the duration of their study. This may present a problem for those who maintain a nutrient data base for multiple users.

The NCC has resolved this problem by maintaining multiple versions of the Food Table. The most recent version available at the beginning of a long-term study is used for nutrient calculations for the duration of the study. The only permissible change to a study-assigned Food Table is the addition of new entries for foods or beverages not previously included. lt is essential that no modifications be made to previously established entries; changing the data base while a study is in progress will confound the interpretation of the dietary data. At the end of the study, the investigator may choose to rerun all data on an updated version of the Food Table.

The Need for Comparability of Nutrient Data between Studies

Investigators may require a nutrient data base that will permit comparison of their study results with other studies using the same data base. Inter-study comparability of dietary data can provide information beyond the scope of a single study.

A system has been established at the NCC that allows comparison of dietary data between past and future studies. Such comparison is possible even though the NCC Food Table is updated routinely. This is accomplished by ensuring that no entry is ever deleted from the data base. When a product is taken off the market, the item is "deactivated," which means that it can no longer be used in coding; however, the item remains in the data base and its nutrients continue to be updated as new nutrients are added to the Food Table. Maintaining these deactivated entries in the Food Table makes possible the recalculation of nutrients for dietary intake data collected in the past while using an updated version of the Food Table. The results of these recalculations can then be compared with those of current studies.

The Need for Flexibility in the Level of Specificity Required for Documenting Dietary Detail

Some researchers require considerable detail in documenting dietary intake data while others select methodologies that document dietary intake in broad food group categories. A nutrient data base that meets the needs of diverse users must be able to provide nutrient calculations for dietary intake data documented at different levels of specificity.

The NCC has met this need for flexibility by providing procedures that capture the highest level of detail (such as the brand names, preparation methods, and salt additions) or revert to default values when the higher levels of detail are not specified. Nutrient values for the default or "unknown" assignments are based either on weighted averages of values for the items that fall into that general category or on a single item that is representative of the items in that category.

Guidelines for creating defaults using weighted nutrient values or selected representative values are based on food intake patterns of specific study populations. Determination of defaults for fats used in food preparation methods takes into consideration whether the item was commercially processed, prepared at home, or prepared in a restaurant; if the latter, the default assignments are based on the price range of the restaurant.

The Need for Flexibility in Specifying Food Quantities for Data Input

Researchers need to be able to report dietary data as described by study participants without having to transform food quantities into specified units. The NCC Food Table meets this need by maintaining densities and/or weights of food-specific units. For entries that contain density data, food quantities can be reported using any cubic or household measure of volume. The nutrient calculation programmes convert volume measurements to a gram weight using the food density. For foods that are not easily described in common volume measurements, such as stalks of celery, slices of bread, or pieces of pie, weights are provided for food-specific servings. Dimensions are described for each food-specific serving.