A Manager's Guide to Data Warehousing by Reeves Laura L

Author:Reeves, Laura L.
Language: eng
Format: epub, pdf
Published: 2009-04-27T16:51:59+00:00

226

Part III ■ Dealing with the Data

Dimension Diagram Notation

Fact Group Diagram Notation

Attribute

Dimension

Indicates relationship

Attribute For

between attributes

Lowest Level

Level of Detail

Detail

Attribute

Future

Attribute

1

Name of

Fact Group

Derived

Attribute

Slowly

Changing Attr.

Connect to more attributes

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

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.