Rittman Mead - Delivered Intelligence

One of our customers sent in some SQL that took ages to run. On the face of it was not doing anything difficult, it just inserted the results of an aggregate query into another table. The select part of the query joined two large partitioned tables on the partition key to restrict the result set […]

Earlier this year Mark Rittman and I briefly discussed the concept of a matching pair of conference papers on aggregation in Business Intelligence. Mark would look at the use of Oracle OLAP as an aggregation technique and I would do something similar on conventional (and maybe less conventional) relational techniques. Both papers would be standalone, […]