Home Up PDF Prof. Dr. Ingo Claßen
Timeseries

Timeseries

  • timescale: What Is a Time Series and How Is It Used? (link)

  • influx: Time Series Data Analysis (link)

  • duckdb: Temporal Analysis with Stream Windowing Functions in DuckDB (link)

  • timescale: Counter Analytics in PostgreSQL: Beyond Simple Data Denormalization (link)

  • timescale: Real-Time Analytics for Time Series: A Dev’s Intro to Continuous Aggregates (link)

  • What is real-time analytics? (link)

  • tdengine: Characteristics of Time Series Data (link)

High Cardinality

  • timescale: What Is High Cardinality? (link)

  • timescale: How Different Databases Handle High-Cardinality Data (link)

  • last9: Performance Impact of High Cardinality in Time-Series DBs (link)

  • last9: What is High Cardinality? (link)

  • aaa (link)

TimeseriesDB

  • questdb: Master the Time-series Database (TSDB) (link)

  • timescale: Time-Series Database: An Explainer (link)

  • clickhouse: An intro to time-series databases (link)

  • alibaba: Key Concepts and Features of Time Series Databases (link)

  • tdengine: What Is a Time-Series Database and Why Do I Need One? (link)

  • timescale: How to Write Better Queries for Time-Series Data Analysis With Custom SQL Functions (link)

  • timescale: The Best Time-Series Databases Compared (link)

  • timescale: Time-series data: Why (and how) to use a relational database instead of NoSQL (link)

Use Cases

  • timescale: How to Set Up a Dashboard for Global Energy Data Analytics (link)

  • timescale: How to Build an IoT Pipeline for Real-Time Analytics in PostgreSQL (link)

  • timescale: IoT Renewable Energy Models (link)

  • aaa (link)

Benchmarks

Systems

InfluxDB

  • InfluxDB 3.0 Under the Hood (link)

  • InfluxDB 3 Core and Enterprise Architecture Highlights (link)

  • alibaba: A Comprehensive Analysis of Open-Source Time Series Databases (3) (link)

Prometheus

  • Home (link)

  • Docs (link)

  • alibaba: A Comprehensive Analysis of Open-Source Time Series Databases (4) (link)

Kdb+

Graphite

  • Home (link)

  • Doc (link)

  • Monitoring with Graphite: Architecture and Concepts (link)

  • What is Graphite? (link)

  • The Architecture of Open Source Applications (Volume 1) Graphite (link)

  • aaa (link)

TimescaleDB

  • Timescale architecture for real-time analytics (link)

  • Real-time Analytics in Postgres: Why It’s Hard (and How to Solve It) (link)

  • PostgreSQL Indexes for Columnstore: 1,185x Faster Lookup Queries, 224x Faster Inserts in TimescaleDB (link)

  • PostgreSQL + TimescaleDB: 1,000x Faster Queries, 90 % Data Compression, and Much More (link)

  • Pg_partman vs. Hypertables for Postgres Partitioning (link)

  • Increase Your Storage Savings With TimescaleDB 2.6: Introducing Compression for Continuous Aggregates (link)

QuestDB

Apache Druid

GridDB

TDengine

ClickHouse

  • ClickHouse Architecture 101—A Comprehensive Overview (2025) (link)

  • Building a product analytics solution with ClickHouse (link)

  • Building an Observability Solution with ClickHouse at Dash0 (link)

  • ClickHouse and OpenTelemetry (link)

  • aaa (link)

Misc