Data Warehousing and Business Intelligence

13 March 2011

The Word “Fact” – Terminology Clarification

Filed under: Data Warehousing — Vincent Rainardi @ 10:31 am
Tags:

In dimensional data warehousing, the word “Fact” in means a measure, i.e. a single numeric column.

The word “Fact Table” means a database table or view that contains the Fact or Measure columns.

Above are what Ralph Kimball and Margy Ross used in their Toolkit book (link).

Lately, I heard people use the word “Fact” to refer to a fact table. For example “A fact has measures”. I’m not saying it’s wrong, as people can term it as they like. I’m saying that it is not standard. I put a post here so that the community is not surprised when you heard the word “Fact” used in that way.

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

Create a free website or blog at WordPress.com.

%d bloggers like this: