Re: transparent use of pre-aggregated value for very large datasets

In my project I encounter the same problem.

I use separate table for aggregated data per day and month. And use
triggers for update aggregated data when raw data inserted. It is
incorrect for relational database paradigm, but work fine for me.

--
Olleg Samoylov