We have a need to query on "activities" which exist over a period of time. EG Consider a user tracking their time online, if we want to track efficiency and show trends over time of working vs messing about on distracting sites, which datastores are good for this? I was looking at Druid https://en.wikipedia.org/wiki/Druid_(open-source_data_store)
And ElasticSearch. Elasticsearch is a fulltext search first and happens to be able to do some of this but it can't really calculate things based on data. Eg if for 10 minute buckets I want to capture productivity % and then be able to also recalculate productivity % at 20 minute buckets, hour buckets, and show trends over time, I need to recalculate the productivity %. I'm wondering if there is a good set of tools for doing this. This isn't my forte so really appreciate some direction.