3 ms·
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
by snowwindwaves 13y ago
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/ http://opentsdb.net/
kairosdb, based on cassandra, https://code.google.com/p/kairosdb/ https://code.google.com/p/kairosdb/
timeseriesframework http://timeseriesframework.codeplex.com/ 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/ http://openhistorian.codeplex.com/
kst http://sourceforge.net/projects/kst/ http://sourceforge.net/projects/kst/
veusz http://home.gna.org/veusz/ http://home.gna.org/veusz/
chaco http://docs.enthought.com/chaco/ http://docs.enthought.com/chaco/
guiqwt https://code.google.com/p/guiqwt/ https://code.google.com/p/guiqwt/
pyqtgraph http://www.pyqtgraph.org/ http://www.pyqtgraph.org/
lots of D3 based libraries: http://selection.datavisualization.ch/ 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
- Nate75Sanders 13y agoI had to look up "scada". http://en.wikipedia.org/wiki/SCADA http://en.wikipedia.org/wiki/SCADA for those of you in the same boat
- dpeck 13y agoMight be interested in Cube that square released a few years ago. http://corner.squareup.com/2011/09/cube.html http://corner.squareup.com/2011/09/cube.html edit: cube, not cuba :)
- ericb 13y agoWith 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?
- Ecio78 13y agoWhat about Graphite http://graphite.wikidot.com/faq 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..
- drather19 13y agoThe 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).