I'm trying to develop a deeper understanding of Multidimentional Databases, particularly, the one created by SSAS/MS-SQL. I am not sure how physically a cube's storage is different than that of pages that hold tables.
Please bear in mind that I'm fully knowledgable of how the relationships and purposes of Relational and Multidimensional Relationships differ, conceptually I'm 100% clear. I am just having difficulty understanding how is the implementation of a Relational Database differs from that of a Multidimensional Database? (particularly physical implementation and data structure differences)
**Please do not cite conceptual designs such as "Star/Snowflake Schemas" or concepts given here: Relational vs. Dimensional Databases, what's the difference?
I'm already familiar with the concepts... Thank you