2 ms·
Well 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 aggre
by mulmen 5y ago
Well 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.