'What is the best way to query aggregate columns on historical data, which change when the time goes on?
I want to aggregate some data which is collected for example for 20 years.
Then i would aggregate data for 1 Year, 2 Years, 5 Years and 20 Years. So if the time goes on this aggregated data get changed.
The important goal is that when i query the data it is still fast and don't need much time, because it will getting query quite often.
My first solution would be, that i would calculate the data by hand and save it to the db when then time goes on. This way i could query it, fast without aggregate it again and again.
Right now i didn't choose any database type, because i'm not sure what makes most sense for this problem.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|