Search CTRL + K

Time Series Database

时许数据库(time series database) 指专门为时序分析(time series analytics)优化的数据库,时序数据是指按时间顺序排布的数据点。

时序数据库与 OLAP 数据库存在如下差异:

What is time series

In mathematics, a time series is a series of data points indexed (or listed or graphed) in time order.

Time series analysis comprises methods for analyzing time series data in order to extract meaningful statistics and other characteristics of the data.[1]

What is time series database

A time series database is a software system that is optimized for storing and serving time series through associated pairs of time(s) and value(s).[2]

Create difference between OLAP and time series database

Time series databases are very write-heavy. The volume of writes can be as high as 10s of millions of writes per second. While OLAP databases are write heavy, the number of writes per second is not O(millions). As a result, at large write volumes, OLAP databases tend to prefer batch ingestion instead of an event stream ingestion.[3]

Use cases between OLAP and Timeseries database

Use cases with heavy use of filters and aggregations (slice and dice) over several dimensions is, imho, a OLAP use case.

Use timeseries if the timestamp is the most important feature and you seldomly aggregate/filter over other dimensions.[4]
-- ZenCoding


  1. https://en.wikipedia.org/wiki/Time_series ↩︎

  2. https://en.wikipedia.org/wiki/Time_series_database ↩︎

  3. https://medium.com/@itz100ji/time-series-databases-vs-olap-57e8d70309c8 ↩︎

  4. https://www.reddit.com/r/dataengineering/comments/10zf6rn/comment/j83aaj9/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button ↩︎