/1 ππ’π¦π-πππ«π’ππ¬ ππ (TSDB) in 20 lines. What is ππ’π¦π-πππ«π’ππ¬ ππ (TSDB)? How is it ππ’ππππ«ππ§π from Relational DB?
/2 A couple of weeks ago, I had a great discussion with the CEO of TDengine @jhtao about time-series databases. This sparked my interest in learning more about this topic. The diagram below shows the π’π§πππ«π§ππ₯ ππππ π¦π¨πππ₯ of a typical Time-Series DB.
/3 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].
πΉ 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].
/4 πΉ 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
πΉ Typical usage:
- Trades and market data updates in a market
- Server metrics
- Application performance monitoring
- Network data
- Sensor data
- Events
- Clicks streams
/5 π Over to you: Have you used TSDB before, and what did you use it for? Whatβs your favorite TSDB?
Loading suggestions...