Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 08 Oct 2002 @ 17:49:11 GMT

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

Subj:   Re: Fastexport-Outmod and RDBMS-Restarts
From:   Thomas Buehlmann


The answer to the first question is it depends....(cf below)

The answer to the 2nd question is a clear no.

1) From what I have seen (and hopefully I do not cause a religious war here) Oracle warehouses are fine up to some size. The critical size I would estimate to be around 1 TB usable data. Clearly this limit depends on what and how you plan to use the warehouse. The TD system is a lot more expensive a purchase but shows a lot less DBA effort. As far as this is concerned, I saw about a 5:1 reduction for a warehouse that is used for data mining purposes, size about 1TB usable. The other difference is that TD is definitely not trimmed for transactional types of load patterns.

2) TD is tied to a specific set of hardware the current options you have is custom hardware from NCR (they use a Unix flavor as operating system and some custom built hardware architecture; very fast, not cheap) and a Win2K/NT based system. The latter is cheaper but has more limitations.

I suggest to get more info from NCR directly on this....



Thomas Buehlmann

  <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