MySQL Forums
Forum List  »  Data Warehouse

Using rollup tables to aggregate data in large datasets
Posted by: Matthias Mullie
Date: July 16, 2013 04:18AM

Recently, I was working with a considerable amount of data, for which the usual aggregate functions may eventually lead to scalability issues.

I've set up rollup tables & looked at how to best (and in a generic way, without having to code specific paths per change) keep the rollup data in sync with the atomic data.

I've written a small article about my approach: http://www.mullie.eu/aggregate-data-large-datasets-rollup-tables/

Options: ReplyQuote


Subject
Views
Written By
Posted
Using rollup tables to aggregate data in large datasets
7347
July 16, 2013 04:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.