Project

Back to overview

Tameus: Managing Time-Varying Measurement Sets in Databases

Applicant Böhlen Michael
Number 135361
Funding scheme Project funding (Div. I-III)
Research institution Institut für Informatik Universität Zürich
Institution of higher education University of Zurich - ZH
Main discipline Information Technology
Start/End 01.09.2011 - 31.03.2015
Approved amount 316'845.00
Show all

All Disciplines (2)

Discipline
Information Technology
Agricultural Engineering

Keywords (8)

Swiss Feed Database; measurement sets; temporal compatibility; temporal aggregation; data warehouse; online analytical processing; density summaries; data collection

Lay Summary (English)

Lead
Lay summary
The Swiss Feed Database is a public service for companies, private farmers and research institutions. Feed data characterizes the quality of grown, imported and synthetic feed types, and originates from feed samples collected from all parts of Switzerland. Feed quality comprises feed properties, nutrient content and derived nutritive values of feedstuffs used for livestock. The essence of feed data are nutrient measurements that are multi-valued, sparse, and highly correlated. The Tameus project is an SNF supported collaboration between the University of Zürich and Agroscope. Our goal is to design and implement new database techniques for modeling, aggregating and analyzing feed data and to establish a reference for current and historical feed data. We evolve the Swiss Feed Database towards a multi-dimensional model that supports the aggregation and analysis of time-varying feed data for different time periods and for various biological, technical and spatial properties.
Direct link to Lay Summary Last update: 21.02.2013

Responsible applicant and co-applicants

Employees

Publications

Publication
Efficient Evaluation of Ad-hoc Range Aggregates
Ammendola C, Bohlen M, Gamper J (2013), Efficient Evaluation of Ad-hoc Range Aggregates, in 15th International Conference on Data Warehousing and Knowledge Discovery, Prague, Czech Republic.
Graphical Analysis of spatio-temporal Patterns in Forage Quality
Bracher A, Bohlen M, Taliun A, Cafagna F (2013), Graphical Analysis of spatio-temporal Patterns in Forage Quality, in 22nd International Grasslands Congress, Sydney, Australia.
Query time scaling of attribute values in interval timestamped databases
Dignös A, Böhlen M, Gamper J (2013), Query time scaling of attribute values in interval timestamped databases, in 29th IEEE International Conference on Data Engineering (ICDE 2013), Brisbane, Australia1304-1307, 1304-1307.
A GIS-based Data Analysis Platform for Analyzing the Time-Varying Quality of Animal Feed and its Impact on the Environment
Taliun A, Bohlen M, Bracher A, Cafagna F (2012), A GIS-based Data Analysis Platform for Analyzing the Time-Varying Quality of Animal Feed and its Impact on the Environment, in International Congress on Environmental Modelling and Software, Leipzig, Germany.
Die Schweizerische Futtermitteldatenbank www.feedbase.ch
Boltshauser M, Bracher A, Bohlen M, Cafagna F, Taliun A (2012), Die Schweizerische Futtermitteldatenbank www.feedbase.ch, in AGRARFORSCHUNG SCHWEIZ, 3(2), 112-114.
Parsimonious temporal aggregation
Gordevicius J, Gamper J, Bohlen M (2012), Parsimonious temporal aggregation, in VLDB JOURNAL, 21(3), 309-332.
Sequenced spatiotemporal aggregation for coarse query granularities
Timko I, Bohlen M, Gamper J (2011), Sequenced spatiotemporal aggregation for coarse query granularities, in VLDB JOURNAL, 20(5), 721-741.

Collaboration

Group / person Country
Types of collaboration
Agridea Lindau Switzerland (Europe)
- in-depth/constructive exchanges on approaches, methods or results
- Industry/business/other use-inspired collaboration
Agroscope Liebefeld-Posieux ALP Switzerland (Europe)
- in-depth/constructive exchanges on approaches, methods or results
- Publication
- Industry/business/other use-inspired collaboration
ETH Zurich, Department of Computer Science Switzerland (Europe)
- in-depth/constructive exchanges on approaches, methods or results

Scientific events

Active participation

Title Type of contribution Title of article or contribution Date Place Persons involved
The 64th annual meeting of European Federation of animal science (EAAP) Talk given at a conference The Swiss feed database a GIS-based analysis platform 26.08.2013 Nantes, France Taliun Andrej; Böhlen Michael; Cafagna Francesco;
6th International Congress on Environmental Modelling and Software Talk given at a conference A GIS-based Data Analysis Platform for Analyzing the Time-Varying Quality of Animal Feed and its Impact on the Environment 01.07.2012 Leipzig, Germany , Germany Böhlen Michael; Taliun Andrej; Cafagna Francesco;


Self-organised

Title Date Place
Regular Meeting 06.03.2015 Zürich, Switzerland
Regular Meeting 19.12.2014 Zürich, Switzerland
Regular Meeting 21.03.2014 Zürich, Switzerland
Regular Meeting 17.01.2014 Zürich, Switzerland
Regular Meeting 06.12.2013 Zürich, Switzerland
Regular Meeting 15.11.2013 Zürich, Switzerland
Regular Meeting 11.10.2013 Zürich, Switzerland
Regular Meeting 22.08.2013 Zürich, Switzerland
Regular Meeting 26.07.2013 University of Zurich, Department of Informatics, Switzerland
2nd Tameus Workshop 08.07.2013 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 07.06.2013 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 12.05.2013 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 12.05.2013 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 15.03.2013 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 22.02.2013 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 18.01.2013 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 07.12.2012 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 09.11.2012 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 03.09.2012 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 27.07.2012 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 08.06.2012 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 11.05.2012 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 29.03.2012 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 03.02.2012 University of Zurich, Department of Informatics, Switzerland
1st Tameus Workshop 20.01.2012 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 16.12.2011 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 18.11.2011 University of Zurich, Department of Informatics, Switzerland
Regular Meeting 21.10.2011 University of Zurich, Department of Informatics, Switzerland

Knowledge transfer events



Self-organised

Title Date Place
Dürrfutterenquête und Schweizerische Futtermitteldatenbank 15.05.2012 Agroscope Liebefeld-Posieux ALP, Switzerland

Communication with the public

Communication Title Media Place Year
Media relations: print media, online media www.feedbase.ch: Die erweiterte Futtermitteldatenbank BauernZeitung Western Switzerland German-speaking Switzerland 2013
Media relations: print media, online media Feeding Time! International Innovation International 2012

Abstract

The Swiss Feed Database is a public service for companies, private farmers and research institutions. The feed data characterizes the quality of grown, imported and synthetic feed types and is derived from feed samples collected from all parts of Switzerland. The information in the Swiss Feed Database is critical for planning healthy, effective and cheap animal feed.The essence of feed data are measurements of nutrients that are derived from field samples through chemical analyses. Measurements exhibit a number of unique properties. Firstly, measurements are often not single-valued but sets of values, i.e., measurement sets. Secondly, the granularity of the data is multi-granular, i.e., the granularity at which individual measurement sets are recorded differs. Thirdly, time-varying measurement sets are sparse, either because a specific component was not needed for the project that initiated the analysis or because it was omitted for cost reasons. In this project we want to develop new database techniques for modeling, aggregating and analyzing time-varying measurement sets.The Swiss Feed Database is the outcome of a collaboration between Agroscope Liebefeld-Posieux and ETH Zürich. The database is accessible through a public web-based user interface and contains up-to-date summaries of measurement sets of more than one hundred nutrients and six hundred feed types. A total of several hundred users consisting of private users, feed industry, research institutions, federal and provincial administration, agricultural schools, and universities actively use the feed database. Prof. H. Hinterberger from ETH Zürich, who has been responsible for the design and operation of the Swiss Feed Database during the past four years, is retiring. Triggered by this, the University of Zürich and Agroscope investigated the potential for joint research and want to establish a collaboration to $1)$ tackle the research challenges put forward by time-varying measurement sets, $2)$ incorporate the Swiss Feed Database into the teaching activities of the University of Zürich, and $3)$ continue the public service offered by the Swiss Feed Database.The concrete research goal of the Tameus project is to evolve the Swiss Feed Database towards a multi-dimensional model that supports the aggregation and analysis of time-varying measurement sets for different time periods and for various biological, technical and spatial properties. We have planned to structure our work into six work packages. WP0 is for project coordination. WP1 addresses the temporal design of a database that supports time-varying measurement sets and their up-to-date summarization, i.e., the computation of time-invariant summaries from relevant measurement sets of the recent past. In WP2 we want to develop new techniques to aggregate multi-granular measurement sets and support approximate aggregation techniques that allow to control the balance between the cardinality of the result and the precision. In WP3 we determine and use time-varying correlations to reduce the aggregation error in time periods when measurement sets are sparse. WP4 uses data warehouse techniques to design a Swiss Feed Data Warehouse with enhanced multi-dimensional analysis capabilities for measurement sets with spatial, biological and technical properties. WP5 focuses on the data collection. We want to refine and expand the data collection and pre-processing process to ensure a high quality database with carefully curated feed information for Switzerland.
-