Documenting FCDBs in EuroFIR network

1
Documenting FCDBs in EuroFIR network
Jayne Ireland Anders Møller Danish Food
Information
2
FCDB for EuroFIR Web servicesFCDB designed
specially for Web services, only those entities
and fields needed
3
EuroFIR FCD Standard documents

• Documents available on the EuroFIR Technical
  website (http//www.eurofir.org/eurofir/default.a
  sp)
• I Description of the standard
• Guidelines for EuroFIR component value
  documentation (2007-02-28).pdf
• EuroFIR Standard description (2007-07-13).pdf
• EuroFIR Standard annex (2007-11-05).pdf
• II Standard Vocabularies (thesauri)
• EuroFIR_Component_Thesaurus
• EuroFIR_Acquisition Type Thesaurus
• EuroFIR_Matrix_Unit Thesaurus
• EuroFIR_Method_Indicator Thesaurus
• EuroFIR_Method_Type Thesaurus
• EuroFIR_Reference Type Thesaurus
• EuroFIR_Unit_Thesaurus
• EuroFIR_Value_Type Thesaurus
• LanguaL Thesaurus
• ISO language codes, country codes

4
Food identification

• Food ID
• Food name
• Natural language
• English translation
• Other properties
• Scientific name
• Default NCF and FACF
• National food classification
• LanguaL indexing (food code, LanguaL code)

• Problems encountered
• Original food name in other script
• Default coefficients not provided
• Different food IDs in Food table and in LanguaL
  description table
• Foods indexed but with no data, or foods with
  data but no LanguaL indexing

5
Component identification

• Component code in database
• EuroFIR component identifier
• Component name in original language
• Component name in English
• Optional
• Default unit and matrix unit
• Default Method Type and Method Indicator

• Problems encountered
• No component codes
• Errors in EuroFIR identifiers
• Components without EuroFIR identifiers
• No component name in original language
• Unit not in thesaurus

6
VALUE entity

• Food code (link to Food entity)
• Component code, Component name, EuroFIR component
  ID
• Unit, Matrix unit (mg/100g, g/100 ml)
• Selected value
• Value type ("median", "logical zero", "less
  than", "trace")
• Acquisition type ("food composition table", "own
  system")
• Date of generation, Date of evaluation
• Nb of contributing values
• Min, Max
• Method Type ("analytical result(s)", "calculated
  as recipe", unknown")
• Method Indicator ("Spectrometry" , "Water by
  difference)
• Parameter (NCF, FACF)
• Method ID (link to Method Specification entity)

• Problems encountered
• Data in spreadsheet format
• Mixed information in same spreadsheet
• Matrix units not specified
• Significant figures
• Decimal points
• Incoherent Value Type (LZ, TR, UD, N)
• Incorrect or incoherent Acquisition Type
• Incoherent Method Indicator Method Type
• NCF missing for Protein values

7
EuroFIR FCD Standard
Value description

• Method Specification entity
• Method ID
• Official Method
• General Description
• Method Reference (link to Reference entity)
• Optional
• Analytical key steps
• Extraction
• Separation
• Identification
• Detection
• Quantification
• Laboratory Performance
• Analytical Performance Details
• Accuracy
• Applicability
• Precision
• Repeatability, Reproducibility
• Recovery, Selectivity

• Value entity
• Food ID
• Component ID
• Selected value
• Value type
• Method Type
• Method Indicator
• Method ID

8
REFERENCE entity

• Problems encountered
• No reference code
• Missing Acquisition Types, Reference Types,
  and/or Citations
• Mixture of References, Value Types (LZ),
  Acquisition Types (report, product information)
  and Reference Types (book)
• Generic references (Report, Website)

• Original reference code
• Acquisition Type
• Reference Type
• Citation
• optional
• link to CiteXplore
• Authors
• Title in English
• Original title
• Original language (ISO code)
• Publication date

9
REFERENCE_LINKS

• Problems encountered
• No links provided
• Links only at food level
• Specified Reference code(s) missing from
  REFERENCE table
• Multiple reference codes given in same field
• Reference(s) incoherent with Acquisition Type of
  VALUE

• Original food code
• Original component code
• Original reference code
• gt allows multiple references for same ltfood,
  componentgt couple

10
Thank you for your participation

• And good luck with your data documentation!