There's a bunch of things we do, but when we do things like transformations, then they generally aren't temporary, so we generate new transformed series of data. There's some aggregations where we use SQL to do some basic stats, but a lot of transformations are done via application level transformations which can essentially do anything with any set of data to produce new data.

The most interesting thing about Chronix, to me, seems to be data size ( would be interesting to see what the performance is like too ). I think I'll do an experiment and spit a bunch of data into it and see how it does.