Dear all,<p>time series DBs are a hot topic these days but given the focus on IoT -- or more generally measurement data -- the underlying data model typically assumes that for one time series there is only one data point per period of time, so it's really just one dimensional.
However, if you work for example with forecast data (say for a stock price) you might wanna store every version of a forecast and not overwrite the previous forecast.
What are in your experience the best time series databases that (natively) support two or more dimensions and also allowing queries on these other dimensions like "get forecast for delivery-time from x to y where forecast_time = z"?<p>Thanks!
sambucini
<a href="https://spotify.github.io/heroic/" rel="nofollow">https://spotify.github.io/heroic/</a> is a multi dimensional timeseries database with a rich query language.
I have been using the ELK stack as a time series database for a long time, I know it isn't built for it but there's so much documentation and resources online that makes it a very "easy" choice, it's very easy to scale any part of it, use the elastic as a nosql database, have kibana to visualize and easily query. Curator to move old data to cold storage / shrink. It's been a no brainer.