A Demonstration of Benchmarking Time Series Management Systems in the Cloud

10/29/2021
by   Prabhav Arora, et al.
0

Time Series Management Systems (TSMS) are Database Management Systems that have been configured with the primary objective of processing and storing time series data. With the IoT expanding at exponential rates and there becoming increasingly more time series data to process and analyze, several TSMS have been proposed and are used in practice. Each system has its own architecture and storage mechanisms and factors such as the dimensionality of the dataset or the nature of the operators a user wishes to execute can cause differences in system performance. This makes it highly challenging for practitioners to determine the most optimal TSMS for their use case. To remedy this several TSMS benchmarks have been proposed, yet these benchmarks focus primary on simple and supported operators, largely disregarding the advanced analytical operators (ie. Normalization, Clustering, etc) that constitute a large part of the use cases in practice. In this demo, we introduce a new benchmark that enables users to evaluate the performance of four prominent TSMS (TimescaleDB, MonetDB, ExtremeDB, Kairos-H2) in their handling of over 13 advanced analytical operators. In a simple and interactive manner, users can specify the TSMS(s) to compare, the advanced analytical operator(s) to execute, and the dataset(s) to utilize for the comparison. Users can choose from over eight real-world datasets with varying dimensions or upload their own dataset. The tool then provides a report and recommendation of the most optimal TSMS for the parameters chosen.

READ FULL TEXT
research
08/15/2019

SAX Navigator: Time Series Exploration through Hierarchical Clustering

Comparing many long time series is challenging to do by hand. Clustering...
research
11/20/2018

Castor: Contextual IoT Time Series Data and Model Management at Scale

We demonstrate Castor, a cloud-based system for contextual IoT time seri...
research
04/20/2022

SciTS: A Benchmark for Time-Series Databases in Scientific Experiments and Industrial Internet of Things

Time-series data has an increasingly growing usage in Industrial Interne...
research
04/16/2021

Data Generating Process to Evaluate Causal Discovery Techniques for Time Series Data

Going beyond correlations, the understanding and identification of causa...
research
10/03/2017

Time Series Management Systems: A Survey

The collection of time series data increases as more monitoring and auto...
research
01/09/2021

FlashP: An Analytical Pipeline for Real-time Forecasting of Time-Series Relational Data

Interactive response time is important in analytical pipelines for users...
research
05/01/2023

LST-Bench: Benchmarking Log-Structured Tables in the Cloud

Log-Structured Tables (LSTs), also commonly referred to as table formats...

Please sign up or login with your details

Forgot password? Click here to reset