Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 21 Jul 2000 @ 16:57:15 GMT

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

Subj:   Re: Oracle vs Teradata DBA maintenance
From:   Sam Sterling

I've been a DBA and implementation lead on many Teradata warehouses (including some very BIG and some very SMALL systems). I have some Oracle experience and work with Oracle DBA's very often. Oracle almost always co-exists, often sources, and sometimes hosts target data marts. DBA's who aren't inordinately biased towards one or the other usually end up saying that the workload on them is much less with Teradata and performance is better. But it is highly dependant on the data model implemented and the application.

Oracle is very strong in OLTP - Teradata isn't. They're both competent, but one clearly excels. The same is true in decision support with 3NF models and queries with joins. They're both competent, but one clearly excels. Both do OK in a Star Schema, but realize the limitations of the schema - if you don't put it in, you can't get it out (as a dimension that is). You can't conveniently add or subtract dimensions or add subject areas.

Hope this helps.

Sam Sterling

Admin Comment: When last tried, the URL in this Post no longer functioned.

  <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: 15 Jun 2023