Data Warehouse Design

• How do you organize the data?

• Keep it Simple

  • goal is fast data access
  • goal is ease of use

• Star schema

  • Fact Tables - contain the detail data
  • Dimension Tables - look-up information
  • Summary Tables - pre-summarized results

Previous slide

Next slide

Back to first slide

View graphic version