Data Warehousing - PowerPoint PPT Presentation

data warehousing n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Data Warehousing PowerPoint Presentation
Download Presentation
Data Warehousing

play fullscreen
1 / 5
Data Warehousing
89 Views
Download Presentation
chas
Download Presentation

Data Warehousing

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  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