An integrated database management system for Taiwanese food composition and related dietary assessment databases: The NUFOOD System

Li-Ching Lyu, Jin Yuan Ho, Fang Hsin Chang, I. Ling Hsu

Research output: Contribution to journalArticle

4 Citations (Scopus)

Abstract

Managing complex food composition data from various sources for dietary assessment studies is a challenge in developing countries. We used Microsoft Visual Basic 6.0 to develop a graphic user interface (GUI) with linkages to Microsoft Access 97 databases to manage three main inter-reactive databases including an ingredient database, a recipe database, and a dietary supplement database. This system consists of automatic quality control procedures for (1) nutrient range, (2) date for updates, and (3) missing values and completion rate tracking for each nutrient and reference source. Food items in the ingredient database need to have complete nutrient profiles yet remain a single entry with limited numbers in order to be manageable. There is little published information on the nutrient contents of local pickled vegetables, cured meats, and plant extracts. The recipe database determines the primary and secondary levels for mixed dishes and multiple food-grouping systems. Moreover, 13 cooking methods for recipe development were summarized to calibrate nutrient loss during working, because most ingredients only have nutrient levels for uncooked quality. Processed foods and household recipes present the most-difficult tasks for building up the database. Since dietary supplement data such as there on most Chinese traditional herbs are not available, future collection of dietary components including flavonoids and carotenoids are important for nutritional epidemiological studies. Information technology and rapidly developing PC software applications provide an opportunity for developing useful management tools for food composition and related databases. In addition, future cooperation with food scientists and food companies is essential for long-term development of food composition research and applications.

Original languageEnglish
Pages (from-to)268-276
Number of pages9
JournalNutritional Sciences Journal
Volume26
Issue number4
Publication statusPublished - 2001 Dec 1

Fingerprint

Database Management Systems
food composition
management systems
Databases
Food
nutrients
ingredients
dietary supplements
pickled vegetables
meat extracts
Dietary Supplements
cured meats
user interface
information technology
processed foods
plant extracts
epidemiological studies
quality control
food industry
developing countries

Keywords

  • Database management system
  • Dietary supplement
  • Food ingredient
  • Recipe
  • Taiwanese food and nutrient composition

ASJC Scopus subject areas

  • Medicine (miscellaneous)
  • Nutrition and Dietetics

Cite this

An integrated database management system for Taiwanese food composition and related dietary assessment databases : The NUFOOD System. / Lyu, Li-Ching; Ho, Jin Yuan; Chang, Fang Hsin; Hsu, I. Ling.

In: Nutritional Sciences Journal, Vol. 26, No. 4, 01.12.2001, p. 268-276.

Research output: Contribution to journalArticle

@article{81bab0b117364be9b661764e496304f8,
title = "An integrated database management system for Taiwanese food composition and related dietary assessment databases: The NUFOOD System",
abstract = "Managing complex food composition data from various sources for dietary assessment studies is a challenge in developing countries. We used Microsoft Visual Basic 6.0 to develop a graphic user interface (GUI) with linkages to Microsoft Access 97 databases to manage three main inter-reactive databases including an ingredient database, a recipe database, and a dietary supplement database. This system consists of automatic quality control procedures for (1) nutrient range, (2) date for updates, and (3) missing values and completion rate tracking for each nutrient and reference source. Food items in the ingredient database need to have complete nutrient profiles yet remain a single entry with limited numbers in order to be manageable. There is little published information on the nutrient contents of local pickled vegetables, cured meats, and plant extracts. The recipe database determines the primary and secondary levels for mixed dishes and multiple food-grouping systems. Moreover, 13 cooking methods for recipe development were summarized to calibrate nutrient loss during working, because most ingredients only have nutrient levels for uncooked quality. Processed foods and household recipes present the most-difficult tasks for building up the database. Since dietary supplement data such as there on most Chinese traditional herbs are not available, future collection of dietary components including flavonoids and carotenoids are important for nutritional epidemiological studies. Information technology and rapidly developing PC software applications provide an opportunity for developing useful management tools for food composition and related databases. In addition, future cooperation with food scientists and food companies is essential for long-term development of food composition research and applications.",
keywords = "Database management system, Dietary supplement, Food ingredient, Recipe, Taiwanese food and nutrient composition",
author = "Li-Ching Lyu and Ho, {Jin Yuan} and Chang, {Fang Hsin} and Hsu, {I. Ling}",
year = "2001",
month = "12",
day = "1",
language = "English",
volume = "26",
pages = "268--276",
journal = "Nutritional Sciences Journal",
issn = "1011-6958",
publisher = "臺灣營養學會",
number = "4",

}

TY - JOUR

T1 - An integrated database management system for Taiwanese food composition and related dietary assessment databases

T2 - The NUFOOD System

AU - Lyu, Li-Ching

AU - Ho, Jin Yuan

AU - Chang, Fang Hsin

AU - Hsu, I. Ling

PY - 2001/12/1

Y1 - 2001/12/1

N2 - Managing complex food composition data from various sources for dietary assessment studies is a challenge in developing countries. We used Microsoft Visual Basic 6.0 to develop a graphic user interface (GUI) with linkages to Microsoft Access 97 databases to manage three main inter-reactive databases including an ingredient database, a recipe database, and a dietary supplement database. This system consists of automatic quality control procedures for (1) nutrient range, (2) date for updates, and (3) missing values and completion rate tracking for each nutrient and reference source. Food items in the ingredient database need to have complete nutrient profiles yet remain a single entry with limited numbers in order to be manageable. There is little published information on the nutrient contents of local pickled vegetables, cured meats, and plant extracts. The recipe database determines the primary and secondary levels for mixed dishes and multiple food-grouping systems. Moreover, 13 cooking methods for recipe development were summarized to calibrate nutrient loss during working, because most ingredients only have nutrient levels for uncooked quality. Processed foods and household recipes present the most-difficult tasks for building up the database. Since dietary supplement data such as there on most Chinese traditional herbs are not available, future collection of dietary components including flavonoids and carotenoids are important for nutritional epidemiological studies. Information technology and rapidly developing PC software applications provide an opportunity for developing useful management tools for food composition and related databases. In addition, future cooperation with food scientists and food companies is essential for long-term development of food composition research and applications.

AB - Managing complex food composition data from various sources for dietary assessment studies is a challenge in developing countries. We used Microsoft Visual Basic 6.0 to develop a graphic user interface (GUI) with linkages to Microsoft Access 97 databases to manage three main inter-reactive databases including an ingredient database, a recipe database, and a dietary supplement database. This system consists of automatic quality control procedures for (1) nutrient range, (2) date for updates, and (3) missing values and completion rate tracking for each nutrient and reference source. Food items in the ingredient database need to have complete nutrient profiles yet remain a single entry with limited numbers in order to be manageable. There is little published information on the nutrient contents of local pickled vegetables, cured meats, and plant extracts. The recipe database determines the primary and secondary levels for mixed dishes and multiple food-grouping systems. Moreover, 13 cooking methods for recipe development were summarized to calibrate nutrient loss during working, because most ingredients only have nutrient levels for uncooked quality. Processed foods and household recipes present the most-difficult tasks for building up the database. Since dietary supplement data such as there on most Chinese traditional herbs are not available, future collection of dietary components including flavonoids and carotenoids are important for nutritional epidemiological studies. Information technology and rapidly developing PC software applications provide an opportunity for developing useful management tools for food composition and related databases. In addition, future cooperation with food scientists and food companies is essential for long-term development of food composition research and applications.

KW - Database management system

KW - Dietary supplement

KW - Food ingredient

KW - Recipe

KW - Taiwanese food and nutrient composition

UR - http://www.scopus.com/inward/record.url?scp=0035694260&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0035694260&partnerID=8YFLogxK

M3 - Article

AN - SCOPUS:0035694260

VL - 26

SP - 268

EP - 276

JO - Nutritional Sciences Journal

JF - Nutritional Sciences Journal

SN - 1011-6958

IS - 4

ER -