3 ms·
It’s much smaller than the original table. If you compute lots of these, then voila, you have an OLAP cube.
by georgewfraser 5y ago
It’s much smaller than the original table. If you compute lots of these, then voila, you have an OLAP cube.
- mulmen 5y agoWell the size savings is a function of the number of included dimensions and the original table grain. I wouldn’t call this an “OLAP Cube”. It’s just an aggregated fact table. A collection of those with their corresponding dimensions is a “data mart”.
- georgewfraser 5y agoA data mart is a logical organization of data to help humans understand the schema. What I am describing is a physical optimization, extremely similar to what an OLAP cube would do, but implemented on top of a SQL data warehouse. It’s an orthogonal concept to a data mart.
- mulmen 5y agoI guess I still don’t know what an OLAP Cube is.