Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 May 2003 @ 00:02:28 GMT


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


Subj:   Re: Need some information about the DBA Support..
 
From:   Thomas Buehlmann

My rule of thumb from experience using single data warehouses larger than 1 TB usable data

Oracle, DB2, Sybase approx 5 DBAs
Teradata approx 1 DBA

This furthermore assumes that the queries are non predictable. If you have predictable queries, the effort on the traditional RDBMS side goes substantially down. Also, there are slight variations between ORCL, DB2 etc. but overall there is significant more need to handle the indices and details with DBs from the transactional side of the world than for traditional Data warehouses with TD.

Taking similar numbers it is actually rather easy to guestimate the break even point for the higher capital investment for TD versus the runtime cost.

Again, this things only work in order of magnitude, they are not scientifical formulas.

Thomas

Thomas Buehlmann
Accenture
Phoenix, AZ 85016



     
  <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: 27 Dec 2016