ETH Initiative Project FoodCASE

1
ETH Initiative Project FoodCASE

• Research on Data Quality of Scientific Database
  Systems by Example of Food Composition Databases

Karl Presser
2
Agenda

• Project FoodCASE What and Why?
• Application overview
• Status of the project
• Demo
• Outlook

3
Project FoodCASE What and Why

• FoodCASE Food Composition And System
  Environment
• FoodCASE is a food composition database
  management system
• FoodCASE is a research object for my Ph.D.
  project on IT-technical data quality of
  scientific database systems
• Project FoodCASE has 23 participants who give
  feedback and improve software system

4
Project FoodCASE What and Why

• Collaboration of ETH Zurich and Swiss Federal
  Office of Public Health on food composition for
  about 11 years
• Software is outdated since the proposal of
  EuroFIR standard on food composition data
• Research work on data quality needs to be
  extended and written down

Prof. Dr. Hans Hinterberger
5
FoodCASE Overview
FoodCASE
Main application
Administration application
Module user administration

• Module food component
• Food component list
• Food detail view
• Single component multiple values detail view

• Module contact organisation
• Organisation list
• Organisation detail

PostgreSQL
Module standard vocabulary
Module marker

• Module aggregated food component
• Aggregated food component list
• Aggregated food component detail view
• Process of aggregation

• Module contact person and addresses
• Person list
• Person Address detail

Module component filter
JBoss AS/EJB3
Module information publishing
Module person role

• Module Recipe
• Recipe list
• Recipe detail view
• Process of recipe calculation

Module address type
Interfaces e.g. web service
Programming language Java
6
FoodCASE - Status
FoodCASE
Main application
Administration application
Module user administration

• Module food component
• Food component list
• Food detail view
• Single value detail view

• Module contact organisation
• Organisation list
• Organisation detail

Module standard vocabulary
Module marker

• Module aggregated food component
• Aggregated food component list
• Aggregated food component detail view
• Process of aggregation

• Module contact person and addresses
• Person list
• Person Address detail

Module component filter
Module information publishing
Module person role

• Module Recipe
• Recipe list
• Recipe detail view
• Process of recipe calculation

Module address type
Interfaces e.g. web service
Status 40 done
7
Demo
8
Project FoodCASE Outlook

• More participants are welcome (karl.presser_at_inf.et
  hz.ch)
• Communication will be improved using a website
• Alpha version for participants will be available
  this month
• Final version is planned for autumn 2009

9
Thank you for your attention