Star Schema Design
Single fact table surrounded by denormalized dimension tables
The fact table primary key is the composite of the foreign keys (primary keys of dimension tables)
Fact table contains transaction type information.
Many star schemas in a data mart
Easily understood by end users, more disk storage required
No comments:
Post a Comment