Archives of the TeradataForum
Message Posted: Fri, 21 Jul 2000 @ 16:57:15 GMT
| 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
www.ssterling.com
Admin Comment: When last tried, the URL in this Post no longer functioned.
| 
