I'm looking for a tool that will let me precompute expensive aggregations some time after rows have been inserted into a MySQL database. For example, if I often run a SUM()
on a column, I'd like to instead store a running sum in a separate table that can be queried instead of the raw data.
My use case is for heavily-read live stat data (graphs, etc.).
Are there more extensive options beyond materialized views? The thought behind finding a system like this is to reduce the amount of raw sql required to create materialized views as the users of the system would like to specify aggregations without SQL (as new aggregations and stats are being created constantly).