Archives of the TeradataForum

Message Posted: Thu, 20 Feb 2003 @ 12:49:41 GMT

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

Let me try to give this a shot from my side (others may disagree or better add additional info...)

Parallel Processing

not related at all. The TD system is based on data distribution based on hash keys. Oracle may distribute the data based on DBA defined partitions. As such the (data) parallelism is ingrained in Teradata and propped onto Oracle. Makes a huge difference!

Query Optimization

Not sure what to answer here...my gut statement would have been that TD is really optimized for Data Warehousing whereas Oracle comes from the transactional side. As such, I personally do not think TD is extremely great to handle transactional type of loads..but enormously fast for large or complex queries. Oracle is exactly the other way around. (This still leaves the question why open...?)

ETL Tools

There are a lot of tools available. Any serious tool for Data Warehousing does support the load into either Oracle or TD. If looking into tools, make sure they can make use of the utilities of either RDBMS, i.e., you need to have a way to use bulk data handling.

Examples that include these capabilities are Informatica, Datastage, AbInitio, Acta etc.

Cost

I assume you will not be able to come across good numbers for this. The reason is that a lot of the TD deals are on a case by case basis. (At least in my experience.) What I suggest is to take the TPC values and calculate backwards....this, in theory, should allow you to get similar or at least comparable values. Look at www.tpc.org.

DBMS

Check the www.info.ncr.com for details about the architecture. It is fundamentally different. As said above, one is optimized for OLTP the other one for Data Warehouses. These are fundamentally different types of activities, one deals with many short transactions, the other one with large loads followed by ad-hoc queries and reporting queries. Often load and queries are mutually exclusive. Today, both systems start converging.

tb

Thomas Buehlmann
Accenture
Phoenix, AZ 85016

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