Abstract:Scalable subsequence matching is critical for supporting analytics on big time series from mining, prediction to hypothesis testing. However, state-of-the-art subsequence matching techniques do not scale well to TB-scale datasets. Not only does index construction become prohibitively expensive, but also the query response time deteriorates quickly as the length of the query subsequence exceeds several 100s of data points. Although Locality Sensitive Hashing (LSH) has emerged as a promising solution for indexing long time series, it relies on expensive hash functions that perform multiple passes over the data and thus is impractical for big time series. In this work, we propose a lightweight distributed indexing framework, called ChainLink, that supports approximate kNN queries over TB-scale time series data. As a foundation of ChainLink, we design a novel hashing technique, called Single Pass Signature (SPS), that successfully tackles the above problem. In particular, we prove theoretically and demonstrate experimentally that the similarity proximity of the indexed subsequences is preserved by our proposed single-pass SPS scheme. Leveraging this SPS innovation, Chainlink then adopts a three-step approach for scalable index building: (1) in-place data re-organization within each partition to enable efficient record-level random access to all subsequences, (2) parallel building of hash-based local indices on top of the re-organized data using our SPS scheme for efficient search within each partition, and (3) efficient aggregation of the local indices to construct a centralized yet highly compact global index for effective pruning of irrelevant partitions during query processing. ChainLink achieves the above three steps in one single map-reduce process. Our experimental evaluation shows that ChainLink indices are compact at less than 2% of dataset size while state-of-the-art index sizes tend to be almost the same size as the dataset. Better still, ChainLink is up to 2 orders of magnitude faster in its index construction time compared to state-of-the-art techniques, while improving both the final query response time by up to 10 fold and the result accuracy by 15%.

Blink-hash: an Adaptive Hybrid Index for In-Memory Time-Series Databases

TSCache

The HV-tree: a memory hierarchy aware version index

The HV-tree

The AHA-Tree: An Adaptive Index for HTAP Workloads

Adaptive Hybrid Indexes

ChainLink: Indexing Big Time Series Data For Long Subsequence Matching

An Adaptive Hotspot-Aware Index for Oscillating Write-Heavy and Read-Heavy Workloads

A High Effective Indexing and Retrieval Method Providing Block-Level Timely Recovery to Any Point-in-Time

Using Bitmap Index to Accelerate Accessing Large Scale Scientific Data on Demand

Griffin: Fast Transactional Database Index with Hash and B+-Tree

A High Throughput B+tree for SIMD Architectures

Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes

An Efficient and Compact Indexing Scheme for Large-Scale Data Store.

A Comprehensive Performance Evaluation of Modern In-Memory Indices

AB-Tree: A Write-Optimized Adaptive Index Structure on Solid State Disk

Utilizing the column imprints to accelerate no‐partitioning hash joins in large‐scale edge systems

CUBIT: Concurrent Updatable Bitmap Indexing (Extended Version)

CUBIT: Concurrent Updatable Bitmap Indexing

Hash Synopsis Forest Index Schema Based on HBase

An Efficient B+ Tree Index Mechanism for Flash-based Database