Archives of the TeradataForum
Message Posted: Thu, 20 Feb 2003 @ 12:49:41 GMT
Let me try to give this a shot from my side (others may disagree or better add additional info...)
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!
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...?)
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.
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.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|