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

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
Very Informative
Title: Mr   
Name: Ram
Date: 2008-09-30 11:18:42 AM
Hi. This was very much useful information. Clear and consistent.
Title: mr.   
Name: chandrasekar.v.
Date: 2008-08-28 2:06:52 AM
thanks...for posting this article, really good.
Title: MONSIUER   
Date: 2008-07-30 11:58:01 AM
Title: Mr.   
Name: Sohail
Date: 2008-07-30 7:56:59 AM
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
hello this website is very useful for us to more knowledge developed from this.

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

©Copyright 1998-2020 ASPAlliance.com  |  Page Processed at 2020-01-26 4:52:27 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search