Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Time Series Graph DB

Tags:

neo4j

Anybody know of any Graph DB's that support time series data?

Ideally we're looking for one that will scale well, and ideally use Cassandra or HBase as their persistent store.

like image 711
user2612462 Avatar asked Jun 30 '15 04:06

user2612462


2 Answers

One convenient way of doing that is to build a tree structure, with a common root, years as children, months as children of each year and down to the desired granularity. At the end you attach the events nodes as leaf to this tree, and that give you the possibility to make many types of queries, from single point in time, to ranges, and also reverse, from the event to the timestamp...

Here is an example of this concept and an implementation within Neo4j

like image 76
hariseldon78 Avatar answered Oct 13 '22 19:10

hariseldon78


Why would you want to do that? Best practice would be to store the dependency graph (in other words, the "Model" of the time series data) in a graphdb, but the actual time series in something more suited to that. Eg a KV store or a log-specific tool like Splunk...

See the KNMI (Dutch Weather Service) example for a case study: http://vimeopro.com/neo4j/graphconnect-europe-2015/video/128351859

Cheers!

Rik

like image 29
Rik Van Bruggen Avatar answered Oct 13 '22 18:10

Rik Van Bruggen