Data Warehouse Architecture

6/28/00


Click here to start


Table of Contents

Data Warehouse Architecture

Some Acronyms/Terms

Some Acronyms/Terms

Some Acronyms/Terms

Data Structures/Databases

Modeling Methods

Entity-Relationship Modeling

Dimensional Modeling

Dimensional Models

The “Cube”

Star Schema

Snowflake Schema

Dimension Tables

Dimension Tables (cont…)

Dimension Tables (cont…)

Dimension Tables - Granularity

Dimension Tables - “Types”

Dimension Tables - Time

Dimension Tables - Degenerate

Dimension Tables - “Junk”

Fact Tables

Facts - Additive

Facts - Semi-additive/non-additive

Closing

Author: Slavko Stemberger

Email: slavko-stemberger@home.com

Other information:
Phone: (416)208-7847

Download presentation source