Abstract:We study a new type of queries called the k-nearest neighbor temporal aggregate (kNNTA) query. Given a query point and a time interval, it returns the top-k locations that have the smallest weighted sums of (i) the spatial distance to the query point and (ii) a temporal aggregate on a certain attribute over the time interval. For example, find a nearby club that has the largest number of people visiting in the last hour. This type of queries has emerging applications in location-based social networks, location-based mobile advertising and social event recommendation. It is a great challenge to efficiently answer the query due to the highly dynamic nature and the large volume of the data and queries. To address this challenge, we propose an index named TAR-tree, which organizes locations by integrating the spatial and temporal aggregate information. We perform a detailed analysis on the cost of processing kNNTA queries using the TAR-tree. The analysis shows that the TAR-tree results in much fewer node accesses than alternatives. Furthermore, we propose two enhancements for the kNNTA query: (i) an algorithm suggesting the least amount of weights to be adjusted to explore different query results and (ii) a collective processing scheme to share index traversal among a batch of queries. We conduct extensive experiments using real-world data sets. The results validate the accuracy of the cost analysis and show that the TAR-tree outperforms alternatives by up to ten times in node accesses. The results also show that the weight adjustment algorithm and collective processing scheme outperform their baselines by significant margins.

Indexing Temporal Relations for Range-Duration Queries

Durable Queries over Historical Time Series

A bitemporal RDF index based on skip list

Road-Aware Indexing for Trajectory Range Queries

Exact Indexing for Massive Time Series Databases under Time Warping Distance

iRangeGraph: Improvising Range-dedicated Graphs for Range-filtering Nearest Neighbor Search

Time series indexing by dynamic covering with cross-range constraints

Improved Time and Space Bounds for Dynamic Range Mode

Efficiently Labeling and Retrieving Temporal Anomalies in Relational Databases

Durable Queries over Non-synchronized Temporal Data

A Spacialtemporal Index Based on R*-tree

Durable top-k search in document archives

An Efficient Indexing Structure for Multidimensional Categorical Range Aggregation Query

RR-tree: A New Relational Approach of Multi-dimension Index

K-Nearest Neighbor Temporal Aggregate Queries.

KV-match: An Efficient Subsequence Matching Approach for Large Scale Time Series.

The TM-RTree: an Index on Generic Moving Objects for Range Queries

Preferences in Temporal Relational Databases

Mining frequent temporal duration-based patterns on time interval sequential database

Hierarchical Bitmap Indexing for Range and Membership Queries on Multidimensional Arrays

GDCRT: In-Memory 2D Geographical Dynamic Cascading Range Tree