Databases Reference
In-Depth Information
Dimension Diagram Notation
Fact Group Diagram Notation
Attribute
Dimension
Attribute For
Level of Detail
Indicates relationship
between attributes
Lowest Level
Detail
Attribute
Future
Attribute
1
Name of
Fact Group
Derived
Attribute
Slowly
Changing Attr.
Version
Cluster of
Future
Attributes
Figure 7-25
Notation summary
Taking the Model Forward
Now that the business dimensional model has been reviewed and approved
by the business community, it is time to move forward into more traditional
systems activities. While this is not intended to provide full technical detail of
such activities, it will highlight the steps needed to take the model forward.
This section is intended to assist the project team in understanding what
happens next on the project.
Translating the Business Dimensional Model
The business dimensional model can be implemented in a variety of tech-
nologies. If all of the data will be loaded into a multi-dimensional cube or
other proprietary database, then no logical table design is needed, but it may
be necessary to decide at which levels of detail you want to store the facts.
If the business dimensional model is to be implemented in a typical rela-
tional database, then additional design decisions must be made. The business
dimensional model must be translated into logical table structures. The next
