Durable queries over historical time series

Hao Wang, Yilun Cai, Yin Yang, Shiming Zhang, Nikos Mamoulis

Research output: Contribution to journalArticle

11 Citations (Scopus)

Abstract

This paper studies the problem of finding objects with durable quality over time in historical time series databases. For example, a sociologist may be interested in the top 10 web search terms during the period of some historical events; the police may seek for vehicles that move close to a suspect 70 percent of the time during a certain time period and so on. Durable top-(k) (DTop-(k)) and nearest neighbor (Dk NN) queries can be viewed as natural extensions of the standard snapshot top-(k) and NN queries to timestamped sequences of values or locations. Although their snapshot counterparts have been studied extensively, to our knowledge, there is little prior work that addresses this new class of durable queries. Existing methods for DTop-(k) processing either apply trivial solutions, or rely on domain-specific properties. Motivated by this, we propose efficient and scalable algorithms for the DTop-(k) and (Dk NN) queries, based on novel indexing and query evaluation techniques. Our experiments show that the proposed algorithms outperform previous and baseline solutions by a wide margin.

Original languageEnglish
Article number6409352
Pages (from-to)595-607
Number of pages13
JournalIEEE Transactions on Knowledge and Data Engineering
Volume26
Issue number3
DOIs
Publication statusPublished - Mar 2014
Externally publishedYes

Fingerprint

Time series
Law enforcement
Processing
Experiments

Keywords

  • Durable query
  • Historical data
  • Spatiotemporal databases
  • Time series

ASJC Scopus subject areas

  • Information Systems
  • Computer Science Applications
  • Computational Theory and Mathematics

Cite this

Durable queries over historical time series. / Wang, Hao; Cai, Yilun; Yang, Yin; Zhang, Shiming; Mamoulis, Nikos.

In: IEEE Transactions on Knowledge and Data Engineering, Vol. 26, No. 3, 6409352, 03.2014, p. 595-607.

Research output: Contribution to journalArticle

Wang, Hao ; Cai, Yilun ; Yang, Yin ; Zhang, Shiming ; Mamoulis, Nikos. / Durable queries over historical time series. In: IEEE Transactions on Knowledge and Data Engineering. 2014 ; Vol. 26, No. 3. pp. 595-607.
@article{78216b6499184d52822ac0711f18ac76,
title = "Durable queries over historical time series",
abstract = "This paper studies the problem of finding objects with durable quality over time in historical time series databases. For example, a sociologist may be interested in the top 10 web search terms during the period of some historical events; the police may seek for vehicles that move close to a suspect 70 percent of the time during a certain time period and so on. Durable top-(k) (DTop-(k)) and nearest neighbor (Dk NN) queries can be viewed as natural extensions of the standard snapshot top-(k) and NN queries to timestamped sequences of values or locations. Although their snapshot counterparts have been studied extensively, to our knowledge, there is little prior work that addresses this new class of durable queries. Existing methods for DTop-(k) processing either apply trivial solutions, or rely on domain-specific properties. Motivated by this, we propose efficient and scalable algorithms for the DTop-(k) and (Dk NN) queries, based on novel indexing and query evaluation techniques. Our experiments show that the proposed algorithms outperform previous and baseline solutions by a wide margin.",
keywords = "Durable query, Historical data, Spatiotemporal databases, Time series",
author = "Hao Wang and Yilun Cai and Yin Yang and Shiming Zhang and Nikos Mamoulis",
year = "2014",
month = "3",
doi = "10.1109/TKDE.2013.10",
language = "English",
volume = "26",
pages = "595--607",
journal = "IEEE Transactions on Knowledge and Data Engineering",
issn = "1041-4347",
publisher = "IEEE Computer Society",
number = "3",

}

TY - JOUR

T1 - Durable queries over historical time series

AU - Wang, Hao

AU - Cai, Yilun

AU - Yang, Yin

AU - Zhang, Shiming

AU - Mamoulis, Nikos

PY - 2014/3

Y1 - 2014/3

N2 - This paper studies the problem of finding objects with durable quality over time in historical time series databases. For example, a sociologist may be interested in the top 10 web search terms during the period of some historical events; the police may seek for vehicles that move close to a suspect 70 percent of the time during a certain time period and so on. Durable top-(k) (DTop-(k)) and nearest neighbor (Dk NN) queries can be viewed as natural extensions of the standard snapshot top-(k) and NN queries to timestamped sequences of values or locations. Although their snapshot counterparts have been studied extensively, to our knowledge, there is little prior work that addresses this new class of durable queries. Existing methods for DTop-(k) processing either apply trivial solutions, or rely on domain-specific properties. Motivated by this, we propose efficient and scalable algorithms for the DTop-(k) and (Dk NN) queries, based on novel indexing and query evaluation techniques. Our experiments show that the proposed algorithms outperform previous and baseline solutions by a wide margin.

AB - This paper studies the problem of finding objects with durable quality over time in historical time series databases. For example, a sociologist may be interested in the top 10 web search terms during the period of some historical events; the police may seek for vehicles that move close to a suspect 70 percent of the time during a certain time period and so on. Durable top-(k) (DTop-(k)) and nearest neighbor (Dk NN) queries can be viewed as natural extensions of the standard snapshot top-(k) and NN queries to timestamped sequences of values or locations. Although their snapshot counterparts have been studied extensively, to our knowledge, there is little prior work that addresses this new class of durable queries. Existing methods for DTop-(k) processing either apply trivial solutions, or rely on domain-specific properties. Motivated by this, we propose efficient and scalable algorithms for the DTop-(k) and (Dk NN) queries, based on novel indexing and query evaluation techniques. Our experiments show that the proposed algorithms outperform previous and baseline solutions by a wide margin.

KW - Durable query

KW - Historical data

KW - Spatiotemporal databases

KW - Time series

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

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

U2 - 10.1109/TKDE.2013.10

DO - 10.1109/TKDE.2013.10

M3 - Article

VL - 26

SP - 595

EP - 607

JO - IEEE Transactions on Knowledge and Data Engineering

JF - IEEE Transactions on Knowledge and Data Engineering

SN - 1041-4347

IS - 3

M1 - 6409352

ER -