Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 08 Jan 2001 @ 20:50:03 GMT

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

Subj:   Re: Technical Data Modelling
From:   Paul Johnson

One of the many strengths of Teradata is the ability to build a database that largely resembles the logical model. Tweaks/indexes and super-clever DBAs to make it work in an acceptable fashion are the norm in the DB2/Oracle world, but not Teradata. Denormalisation is the curse of a lesser DBMS, imho. Stick with your normalised model for all the classic reasons and you won't go far wrong. A healthy dose of business analysis on top of that basic approach is the tried-and-tested Teradata approach. Those that talk about flattening tables and star schemas are usually out of their depth and not used to dealing with terabyte databases.

Whilst I'm on...can anyone recall the discussion a few weeks ago about Oracle-Teradata migration tools, or did I imagine that? Not content with moving what was allegedly Europe's largest Oracle db onto Teradata, I'm doing it again for another client. We will use the traditional extract/ship/load method unless someone points us at a tool (not ETI et al).


Paul Johnson

  <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