Andyblg's Blog

January 29, 2010

Correlation between a star/snowflake schema and the elements of a dimensional model

Filed under: OLAP — andyblg @ 14:23
Tags: ,

If your source data is in a star/snowflake schema, then you have the elements of a dimensional model:

  • Fact tables correspond to cubes.
  • Data columns in the fact tables correspond to measures.
  • Foreign key constraints in the fact tables identify the dimension tables.
  • Dimension tables identify the dimensions.
  • Primary keys in the dimension tables identify the base-level dimension members.
  • Parent columns in the dimension tables identify the higher level dimension members.
  • Columns in the dimension tables containing descriptions and characteristics of the dimension members identify the attributes.

/ Oracle OLAP Application Developer’s Guide 10gR2

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: