Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 Mar 2005 @ 17:34:21 GMT

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

Subj:   Re: Denormalized Data Structures
From:   Victor Sokovin

  Through various conversations with Teradata, their claim to fame is that their DBMS can handle any kind of report and/or adhoc query with optimal performance using the third normal form data structure. After reviewing various architectures using other DBMS's, denormalized data structures are spun off the DW to gain performance. Does this happen in the Teradata world and if so, is it because of performance or business needs.  

It does and should happen in the Teradata DWH, except perhaps for some relatively small databases used as examples in marketing literature. The aggregates serve both technical and business needs. It is sometimes difficult to separate them.

I believe there is nothing wrong with building and using denormalized data structures. I don't know why the opposite is sometimes used for selling TD to new customers. It seems a wrong marketing strategy to me, and TD does not really need it. Just my opinion. Will I be flamed?



  <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: 28 Jun 2020