Time series data in Infinispan

[ges]

I'm looking into storing some time series data for set of items in Infinispan and looking for any suggestions that you may have in how it could be done.

Example, item1 -> t1, t2, t3, ... tn

item2 -> t1, t2, t3.... tm etc

And appending to it as data becomes available.

One approach could be to just store every data point as an entry in the cache, but this would make querying out a time window of data for a particular item difficult.

Another approach would be capture the time series in a time series data structure which is stores in the cache against an item. But this could prove to be expensive to update the datastructure especially if one is dealing with streaming data.

Is there some kind of an optimized multimap structure in Infinispan that could be used for this purpose?

Thanks,

[ges]

I was hoping that someone from the Infinispan team would have some thoughts on this. Is this an unusual use case?

[mircea.markus]

Hi Ges,

I guess one option would be to store all the time-series related to the same entries in an AtomicMap[1]. this would make querying for al the time series for an entry simpler.

[1] AtomicMap (Infinispan Distribution 5.1.6.FINAL API)

[ges]

Thanks Mircea! I think that would work - I'll try that.

[ges]

Hi Mircea,

I know this is an old question of mine, but thinking about AtomicMaps I was wondering how querying works? Can the values in an AtomicMap be indexed and queried?

Thanks,

Gesly