PPT Slide
- Star schema: combination of fact table and dimension tables.
- Fact table:
- relates the dimensions to the measure of interest
- is usually very large
- contains bulk of data
- has no redundancy
- usually in BCNF
- to minimize the size of the fact table, dimension identifiers are system generated
- Summary tables:
- generated from original tables with precomputed summaries
- purpose: to improve interactive response time
- design issue: which summary tables to be materialized?