Archives of the TeradataForum

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

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

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>>