9 ms·
Vertica has this functionality and it has been there for years. Fully functional database and you can do time series joins, gap filling with linear interpolatio
by car10s 8y ago
Vertica has this functionality and it has been there for years. Fully functional database and you can do time series joins, gap filling with linear interpolation or constant. You can define the intervals at what you want the data points. And you can scale from a few gigs to petabytes of data. https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AnalyzingData/TimeSeries/UsingTimeSeriesAnalytics.htm%3FTocPath%3DAnalyzing%2520Data%7CTime%2520Series%2520Analytics%7C_____0 https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/...
- ghc 8y agoI agree! Vertica's temporal capabilities are marvelous and the engineers who worked on the planner optimizations for the time extensions are brilliant. There are of course trade-offs to the approach Vertica takes -- look at StreamBase for a very different take on the problem, another Stonebraker project. Any of course historians represent yet another take, optimized for point-in time queries that are native and don't need the processing extensions Vertica uses.