O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing the Dimensional Model

The dimensional model, as described in the preceding section, is a logical model. To house data, the logical model must be physically implemented. This is done using both relational and multidimensional database technologies.

The Relational Data Warehouse

Using a relational database platform, such as Microsoft SQL Server 2008 Database Engine Services, the dimensional model is implemented as a collection of tables. Dimensions are translated into dimension tables with columns housing attribute values. Likewise, facts are implemented as fact tables with columns housing fact measure values. Foreign keys within the fact tables record the relationships between facts and dimensions. Collectively, these objects form the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required