Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
#SQLServer 46
SQL Server 44
SSRS EXPERT 41
BI 36
#BI 33
brh 28
SSIS BEST PRACTICES 23
TSQL 19
MS BI STACKS 18
SSRS 17

Archive · View All
March 2011 24
July 2011 17
February 2011 15
April 2010 13
June 2011 11
May 2011 11
April 2011 11
July 2010 11
March 2010 8
December 2011 7

MS BI Workshop #6 – Dimensional Model VS Normalized Model

Jul 4 2011 1:39AM by Sherry Li   

Here is my notes #6.

It’ll be redundant to write down all my notes because there are endless information about dimensional modeling. I’ll just write down the highlights from my notes.

  1. Both 3NF models and dimensional models can be represented in ERDs.
  2. The key difference is the degree of normalization.
  3. To minimize confusions we do not refer to 3NF models as ER models; instead, the industry commonly calls them normalized models.
  4. When the dimensional model is based on a relational database, then these dimensionally modeled tables are referred to as star schemas.
  5. If it is based on a multidimensional database or OLAP technology, then the data is stored in cubes.

I am also listing 3 links to my previous blog posts on this topic.

Difference between 3NF and dimensional models

Data Modeling

SQL – Denormalization & Normalization

Tags: #SQLServer, SQL Server, BI, brh, #BI, MS BI STACKS,


Sherry Li
14 · 12% · 3827
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

1  Comments  

  • Notes on Normalization.. More to come along the way http://consultguru.me/post/2011/07/31/Normalization-before-Normalization.aspx

    commented on Jul 31 2011 3:05PM
    bgcharan
    2388 · 0% · 5

Your Comment


Sign Up or Login to post a comment.

"MS BI Workshop #6 – Dimensional Model VS Normalized Model" rated 5 out of 5 by 1 readers
MS BI Workshop #6 – Dimensional Model VS Normalized Model , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]