Time Series DB (TSDB) in 20 Lines

What is Time-Series DB (TSDB)? How is it different from Relational DB?

The diagram above shows the internal data model of a typical Time-Series DB.

A TSDB is a database optimized for time series data.

• • From the users’ perspective, the data looks similar to the relational DB table. But behind the scenes, the weather table is stored in 4 TSMs (Time-Structured Merge Trees) in the format of \[Measurement, Tag, Field Name].

• • In this way, we can quickly aggregate and analyze data based on time and tags.

• • Typical usage:

* Trades and market data updates in a market

* Server metrics

* Application performance monitoring

* Network data

* Sensor data

* Events

* Clicks streams