An intro to time-series databases

Mark Needham

This video provides an overview of time series data and its storage in databases. It explains the characteristics of time series data, how it's produced, and the requirements for efficiently managing and analyzing it.

Key points covered:

• Definition and types of time series data (regular intervals vs. event-driven)
• Importance of timestamps and analyzing changes over time
• Database requirements for handling time series data efficiently
• Categories of time series databases, including purpose-built solutions and analytics platforms
• Demonstration of querying time series data using ClickHouse SQL playground

The video concludes with practical examples of analyzing large-scale time series datasets, showcasing ClickHouse's performance in handling billions of rows quickly.

• Explainer - https://clickhouse.com/engineering-resources/what-is-time-series-database
• Docs -https://clickhouse.com/docs/use-cases/time-series