what is the use or purpose of a time-series database?

[manjeet kumar]

Hi Folks,

It would be great if group members and spare some of their personal experiences on "what is the use or purpose of a time-series database?"

So far, my understanding goes, i would like to add my two penny on this.

Most important thing we need to consider before using time-series database is that our data is structured as:

1. Series of events.

2. Samples of one or more values distributed as various snapshots taken in various time.

3. Metrics collected from different systems/sources over time.

[Ariel Shtul]

Hello Manjeet,

The reason for using a TSDB is the space efficiency and higher speed a dedicated solution can bring over a generic database.

TSDB are meant for streams of data coming from different sources when usually, the writing load is much higher than the reading load. Sensors, for example, send data routinely but querying them usually occurs at lower rate. For specifically, a server might log CPU and RAM levels every 1 millisecond but will update MIN, MAX and AVERAGE levels only every second.

RedisTimeSeries is able to do some aggregations on the server-side which make aggregations queries super fast and simple. It also allows for automated retirement of data so if data was aggregated into the required measurements, the raw data can be erased.If simple API and speed are what you are looking for, you should consider it.

[manjeet kumar]

Hi Ariel,

Thanks for such a good explanation. Specially analogy was awesome. I think i am able to get picture where and how to use Redis TSDB.

Thanks a lot.
Manjeet

[Pieter Cailliau]

More info also here: https://redislabs.com/blog/redistimeseries-ga-making-4th-dimension-truly-immersive/

[xuef HH]

Thanks for sharing

[fish bowl]

Good explain!

On Thursday, September 26, 2019 at 8:52:39 AM UTC-7, Pieter Cailliau wrote: