Archives of the TeradataForum

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

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

Summary:

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

Cheers

Thomas

Thomas Buehlmann

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