Ask HN: What DB to use for huge time series?

Re:Ask HN: What DB to use for huge time series? by TheAceOfHearts on Thursday September 25, 2014 @02:07PM (#8368607)

If you're up for considering a cloud service, you might want to check out Treasure Data (http://treasuredata.com/).

The free plan allows 10M records per month with a maximum capacity of 150M.

Full disclosure: I work there.

[ Parent | on HN ]

Re:Ask HN: What DB to use for huge time series? by hbs on Thursday September 25, 2014 @02:56PM (#8368964)

Does treasure data have a dedicated storage engine for time series? This kind of data has specific needs which are not met by general purpose storage layers.

[ Parent | on HN ]

Re:Ask HN: What DB to use for huge time series? by TheAceOfHearts on Thursday September 25, 2014 @08:44PM (#8370672)

To an extent, yes. We wrote our time-partitioned columnar storage from scratch: it has row-based storage for more recent data and column-based storage for historical data, and the data is merged from row-based to column-based periodically for performance. We realized from day one that much of "big data" is log/timestamped data, so our query execution engined are optimized for time-windowed queries.

[ Parent | on HN ]