Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 13 Nov 2002 @ 11:28:22 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: 3NF vs Dimensional modelling
 
From:   Ken Hansen

Duncan, thanks for your reminder - I was indeed thinking of 3NF EDW as compared to cubes in multidimensional DBMS's. A Dimensional model in a relational database is far better and may suffice if, as you say, "the enterprise is not complex".

Neil, apologies for thinking of cubes but, perhaps because I am primarily a data user rather than a modeller, my experience runs counter to assertions that Dimensional Models reflect the way business people think - the very reason that I advocate 3NF EDW is that, although Dimensional Models may reflect the way business people think of particular report(s) at one moment of time, that thinking will evolve rapidly and often. That is why the enterprise is best served by holding core data at atomic level in the core DW - sooner or later someone is likely to want/need that analysed and/or summarised by changed or new dimensions that may not yet be identifiable.

Ken Hansen



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023