Home | Previous Page | Next Page   Dimensional Databases >

Building a Dimensional Data Model

In This Chapter
Overview of Data Warehousing
Why Build a Dimensional Database?
What Is Dimensional Data?
Concepts of Dimensional Data Modeling
The Fact Table
Dimensions of the Data Model
Dimension Elements
Dimension Attributes
Dimension Tables
Building a Dimensional Data Model
Choosing a Business Process
Summary of a Business Process
Determining the Granularity of the Fact Table
How Granularity Affects the Size of the Database
Using the Business Process to Determine the Granularity
Identifying the Dimensions and Hierarchies
Choosing the Measures for the Fact Table
Using Keys to Join the Fact Table with the Dimension Tables
Resisting Normalization
Choosing the Attributes for the Dimension Tables
Handling Common Dimensional Data-Modeling Problems
Minimizing the Number of Attributes in a Dimension Table
Handling Dimensions That Occasionally Change
Using the Snowflake Schema
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]