Your browser doesn't support the features required by impress.js, so you are presented with a simplified version of this presentation.

For the best experience please use the latest Chrome, Safari or Firefox browser.





















So this talk is about Time Series Databases AKA Temporal Databases you might see them referred to as TSDB or TSDS

Now if your job is very boring (or perhaps on the contrary extremly exciting!) you may have met those as "Operational Historians or Enterprise Historians "

This very short talk is a public service of sorts from the BuzzProphets.

Those of you who know me know I have my ear firmly stuck to the ground.

OH probably the vast majority doesn't know me so...

Hello my name is Ori Pekelman. I am OriPekelman everywhere (twitter/github/linked-in).

My blog is on

My company, Constellation Matrix, does software architecture and I made myself a nice logo.


Back to our business of holding one's ear to the ground in a very uncomfortbale position. And to TSDS's

Ear To Ground

So a Time Series Database is a speciality thing, a domain specific piece of software. These has been around for a while.

You can see them in control and industrial systems to record every last damn thing that is happening.

In financial systems, in energy. Companies like GE and Honywell produce this kind of software.

Something that has a boring yet intimidating web page like this

Screen Shot 2013 10 23 At 22.01.19

There are even guys in this domain that get to have a 2 letters .com domain..

So what kind of data is Time Series Data?

OPTION A: Web Logs

OPTION B: Stock Prices

OPTION C: Everything

I will posit that all data is Time Series Data.

This is a very short talk so I can't really delve into this. But consider that the only operation we know how to do, reliably, in a distributed system is insert.

Because we only know how to insert

We can basically always suceed in writing somewhere

User A has Expressed Intent B on Data Piece C

your operations or binary log, your write side cache, your append only file.. whatever.

But this information is basically useless if we don't put this in a timeframe. User

A has Expressed Intent B on Data Piece C at moment D

If I can't convince you all data is time series data

At least you'd agree that all "big data" is time series data. Right?



And time is I believe going to have a very good 2014

Screen Shot 2013 10 23 At 17.57.57

Screen Shot 2013 10 23 At 17.58.23

Did you see how all the colors disappeared?

And Google doesn't show interest...

Screen Shot 2013 10 23 At 14.55.50

Screen Shot 2013 10 23 At 14.56.15

Yet I think that everybody is kind of going to wake up in the coming months slapping their fronts and saying, we are all implementing at a stupidly low level the same patterns over the same types of data. Can't we get something off the shelf for this?

I got interested in this while thinking about the following: On an e-commerce site, how do I identify, in real-time, customers that are hesitating. Considering they have probably multiple tabs open.

You can see this emerge already with the very intersting way ElasticSearch is developing (look at Kibana3 if you haven't)

Screen Shot 2013 10 23 At 22.25.29

Very recently went out

Screen Shot 2013 11 20 At 17.09.52

Look at what is a first class object with them Screen Shot 2013 11 20 At 17.05.23

This is the canonical example on their homepage

Screen Shot 2013 11 20 At 17.27.46

More of the purists, look at Screen Shot 2013 11 20 At 17.08.44

You can see this also in very interesting projects like and this will probably be even a stronger trend, Time Series Databases for behavioural data.

Screen Shot 2013 10 23 At 22.24.15

Because the whole big data thing... well its around that right? is another service geared specifically to analytics.

Screen Shot 2013 11 20 At 17.07.43

You might also want to have a look at the two years old MongoDB based solution from Square Cube

There are of course OpenTSDB and Kairo (respectively for Hbase and Cassandra) we even see emerging the "as a service crowd" (have a look at TempoDB, Keen) on this segment.

You know its cool when even the Zindoz guyz have one

What makes a Time Series Databases a cool thing?


Ultima Necat.. Well I ran out of time...

I am OriPekelman everywhere (twitter/github/linked-in).