Data Warehousing

1
Data Warehousing

• DSCI 4103
• Dr. Mennecke

Chapter 3
2
Data Warehouse Bus Architecture

• The DW bus architecture implies that dimensions
  in the data warehouse will be conformed
• Conformed dimensions use common column names and
  definitions
• The implication is that data in one data mart can
  be used interchangeably with fact tables in other
  data marts

3
The data warehouse bus architecture

• Rows are business processes and will be built
  into first-level data marts
• Columns represent the common business dimensions
• Shaded cells show which dimensions will be used
  in each data mart

4
Consolidated Data Marts

• Data marts that cross business processes
• Beneficial for supporting complex decision making
• Difficult to manage and load

5
Conformed dimensions

• Conformed dimensions have
• Consistent dimension keys
• Consistent attribute column names
• Consistent attribute definitions
• Consistent attribute values
• Conformed dimensions can be easily applied to
  multiple data marts across the enterprise
• Although dimensions can be replicated in
  different data marts, the components of these
  dimensions should be built once in the staging
  area