Cassandra vs MongoDB For Time Series Data

Re:Cassandra vs MongoDB For Time Series Data by snowwindwaves on Wednesday August 21, 2013 @02:09PM (#6252237)

i work on scada systems which usually come with a time series database built in so that operators can do some basic plotting. Often these products have a 10 or 15 year legacy.

The scada vendors seem to be careful to avoid making the time series database and plotting tools which come with the HMI packages too powerful, as this might cut in to their sales of Historian type products.

If it wasn't a commodity already, the rash of startups which all seem to write their own tools for storing and plotting metrics from the operations of their servers and software services has certainly made the guts of a capable historian readily available for free.

for storing data open tsdb, based on hbase+hadoop, http://opentsdb.net/ kairosdb, based on cassandra, https://code.google.com/p/kairosdb/ timeseriesframework http://timeseriesframework.codeplex.com/

for plotting data I am hoping to find a library that allows for real time plotting and zooming, scrolling with the mouse wheel. so far I have found openhistorian http://openhistorian.codeplex.com/ kst http://sourceforge.net/projects/kst/ veusz http://home.gna.org/veusz/ chaco http://docs.enthought.com/chaco/ guiqwt https://code.google.com/p/guiqwt/ pyqtgraph http://www.pyqtgraph.org/ lots of D3 based libraries: http://selection.datavisualization.ch/

so there are lots of tools out there if you've got the patience to figure out which one is right for your application and glue it together

[ Parent | on HN ]

Re:Cassandra vs MongoDB For Time Series Data by Nate75Sanders on Wednesday August 21, 2013 @04:11PM (#6253008)

I had to look up "scada".

http://en.wikipedia.org/wiki/SCADA for those of you in the same boat

[ Parent | on HN ]

Re:Cassandra vs MongoDB For Time Series Data by Ecio78 on Thursday August 22, 2013 @03:03AM (#6255570)

What about Graphite http://graphite.wikidot.com/faq ? I've never tried but it is described as "Scalable Realtime Graphing". It seems to use an internal database so maybe it's not ok for you..

EDIT: I read another comment from you, you said it's rrd-like so it gets rid of old data, not what you're looking for..

[ Parent | on HN ]

Re:Cassandra vs MongoDB For Time Series Data by drather19 on Thursday August 22, 2013 @11:26AM (#6257701)

The standard 1s time resolution on Graphite/Whisper also seemed to be a limiting factor for use with some of these systems, where you want to observe things on the order of milliseconds (or beyond).

[ Parent | on HN ]

Re:Cassandra vs MongoDB For Time Series Data by dpeck on Wednesday August 21, 2013 @03:00PM (#6252569)

Might be interested in Cube that square released a few years ago. http://corner.squareup.com/2011/09/cube.html

edit: cube, not cuba :)

[ Parent | on HN ]

Re:Cassandra vs MongoDB For Time Series Data by ericb on Wednesday August 21, 2013 @09:14PM (#6254466)

With something like Kairos, how do you segment the time series data? Like if I wanted to use it to keep track of stats for 2 different customers, how would that work?

[ Parent | on HN ]