Archives of the TeradataForum
Message Posted: Thu, 03 Mar 2005 @ 17:34:21 GMT
| 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
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?