Creative Aggs Part V : Incremental Aggs

I wasn’t originally planning on including an article on Incremental Aggs as part of this series, but I like the idea, and it seems like a good fit for the series, so here goes. The series so far Introduction to Aggs Horizontal Aggs Mixing Agg and base table to produce a single value Accordion Aggs Continue reading Creative Aggs Part V : Incremental Aggs

Creative Aggs Part III : Accordion Aggs

Introduction to Aggs Horizontal Aggs Mixing Agg and base table to produce a single value Accordion Aggs (this article) Variable grain aggs in a single table for extra flexibility Filtered Aggs Using Composite Models to keep recent data in memory, and older data in the source to optimise the model size Incremental Aggs A smart Continue reading Creative Aggs Part III : Accordion Aggs

Creative Aggs Part II : Horizontal Aggs

Introduction to Aggs Horizontal Aggs (this article) Mixing Agg and base table to produce a single value Accordion Aggs Variable grain aggs in a single table for extra flexibility Filtered Aggs Using Composite Models to keep recent data in memory, and older data in the source to optimise the model size Incremental Aggs A smart Continue reading Creative Aggs Part II : Horizontal Aggs