TQuEST: threshold query execution for large sets of time series

  • Authors:
  • Johannes Aßfalg;Hans-Peter Kriegel;Peer Kröger;Peter Kunath;Alexey Pryakhin;Matthias Renz

  • Affiliations:
  • Institute for Computer Science, University of Munich;Institute for Computer Science, University of Munich;Institute for Computer Science, University of Munich;Institute for Computer Science, University of Munich;Institute for Computer Science, University of Munich;Institute for Computer Science, University of Munich

  • Venue:
  • EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

Effective and efficient data mining in time series databases is essential in many application domains as for instance in financial analysis, medicine, meteorology, and environmental observation. In particular, temporal dependencies between time series are of capital importance for these applications. In this paper, we present TQuEST, a powerful query processor for time series databases. TQuEST supports a novel but very useful class of queries which we call threshold queries. Threshold queries enable searches for time series whose values are above a user defined threshold at certain time intervals. Example queries are ”report all ozone curves which are above their daily mean value at the same time as a given temperature curve exceeds 28°C” or ”report all blood value curves from patients whose values exceed a certain threshold one hour after the new medication was taken”. TQuEST is based on a novel representation of time series which allows the query processor to access only the relevant parts of the time series. This enables an efficient execution of threshold queries. In particular, queries can be readjusted with interactive response times.