3 ms·
1TB of data per year is small in today's terms. Seconding a lot of other comments here, the easiest option would be to just use redshift (amazon) or bigquery (g
by chetanahuja 10y ago
1TB of data per year is small in today's terms. Seconding a lot of other comments here, the easiest option would be to just use redshift (amazon) or bigquery (google). You'll have to do some initial work to load this data up into one of those cloud databases but again, 1TB is not a lot. AWS and Google cloud both have some special handling of data for HIPAA compliance too
https://aws.amazon.com/compliance/hipaa-compliance/ https://aws.amazon.com/compliance/hipaa-compliance/
https://cloud.google.com/security/compliance https://cloud.google.com/security/compliance
Finally, for this amount of data, you could easily build SSD based servers, load it up with lots of RAM and slap any open source DB on them too. It'll most likely be sufficient for your purposes.