SQL Server 2005 Data Modeling - Part 1
page 2 of 4
by Manjusree Akkineni
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 20891/ 39

What is a Dimensional Model?

A Dimensional model is made up of a central fact table (or tables) and its associated dimensions. The dimensional model is also called Star Schema because it looks like a star with the fact table in the middle and the dimensions serving as the points on the star.

From a relational data modeling perspective, the dimensional model consists of a normalized fact table with de-normalized dimensional tables.


View Entire Article

User Comments

Title: Mr   
Name: RoD
Date: 2009-02-23 6:30:09 PM
Comment:
Very Informative
Title: Mr   
Name: Ram
Date: 2008-09-30 11:18:42 AM
Comment:
Hi. This was very much useful information. Clear and consistent.
Title: mr.   
Name: chandrasekar.v.
Date: 2008-08-28 2:06:52 AM
Comment:
thanks...for posting this article, really good.
Title: MONSIUER   
Name: DUBONNET
Date: 2008-07-30 11:58:01 AM
Comment:
GREAT!
Title: Mr.   
Name: Sohail
Date: 2008-07-30 7:56:59 AM
Comment:
Good work. Article is really very useful in all aspects.
Title: list all asp example (adoconnections)   
Name: ramesh
Date: 2008-05-19 3:42:45 AM
Comment:
hello this website is very useful for us to more knowledge developed from this.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-29 11:27:20 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search