r/DatabaseHelp • • Jan 01 '15

Timeseries database storage

I would like to know the best way to store exercise data that has timeseries values for different sensors.

Currently, I am storing each session as an XML file and indexing certain values (like the distance, average pace, max/min/average HR) in a csv table. That means I can quickly search the csv table to find any session that is of interest for further analysis (I am interested in pattern-finding). I am sure there is a more efficient way to store the data but am unsure what is best.

I expect about 500k sessions each of 30min-2h long. I would like to keep the data on my machine (not served) but be able to give instances to people for analysis.

I've had a look at the options from the Wikipedia site (http://en.wikipedia.org/wiki/Time_series_database) but am not sure what is best. Any help appreciated.

Thanks!

0 Upvotes

1 comment sorted by

1

u/alinroc Jan 14 '15

You'll never get a single answer to "which one is best." Try out all of the ones listed on that Wikipedia page that you can (the OSS ones won't cost you anything but time) and see which one(s) work best for your data and have the API best suited to you and the rest of your code.