In Chapter 2, we introduced data warehousing and described, at a high level, how we might approach a design. The approach we adopted follows the style of some of the major luminaries in the development of data warehousing generally. This approach to design can be given the general description of dimensional. Star schemes and snowflake schemes are both examples of a dimensional data model.
The dimensional approach was adopted in our introduction for the following reasons:
Dimensional data models are easy to understand. Therefore, they provide an ideal introduction to the subject.
They are unambiguous.
They reflect the way that business people perceive their businesses.
Most RDBMS products now provide direct support for dimensional ...