In facility management for plants and buildings, needs of facility diagnosis for saving energy or facility management cost by analyzing time series data from sensors of equipments in facilities have been increasing. This paper proposes a relation-based stream query language TPQL (Trend Pattern Query Language) for expressing constraints in time series data for anomalies detection in facilities. The features of TPQL are the following. (1) TPQL introduces a convolution operator into a stream query language in order to describe constraints over sliding window. A convolution operator which takes a window function as an argument can express various domain dependent functions extracting feature over sliding windows such as duration constraint and hunting constraint. (2) TPQL introduces time-interval based join into stream query language in order to join time series data with different sampling rates.
[1]
Lukasz Golab,et al.
Issues in data stream management
,
2003,
SGMD.
[2]
Giuseppe Psaila,et al.
Querying Shapes of Histories
,
1995,
VLDB.
[3]
Richard T. Snodgrass,et al.
The TSQL2 Temporal Query Language
,
1995
.
[4]
Andrew Heybey,et al.
Tribeca: A System for Managing Large Databases of Network Traffic
,
1998,
USENIX Annual Technical Conference.
[5]
Jennifer Widom,et al.
The CQL continuous query language: semantic foundations and query execution
,
2006,
The VLDB Journal.
[6]
A. Prasad Sistla,et al.
A query processor for prediction-based monitoring of data streams
,
2009,
EDBT '09.
[7]
Michael Stonebraker,et al.
Monitoring Streams - A New Class of Data Management Applications
,
2002,
VLDB.