teradata and oracle architecture

Database
Enthusiast

teradata and oracle architecture

What is the difference between teradata's shared nothing architecture and oracle's distributed architecture.
5 REPLIES

Re: teradata and oracle architecture

The basic difference is that in teradata we have the concept of AMPs which takes care of the part of database virtually assigned to it. It takes care of all the operation relating to the data which is in that AMP. This is not the case of oracle

Even though oracle supports SMP and MPP it doesn't have shared nothing architecture but a distributed architecture.

for more information refer the attachment.

Re: teradata and oracle architecture

yes
WAQ
Enthusiast

Re: teradata and oracle architecture

In oracle (G versions) there is a full support for parallelism. Then what is the difference between the two? Is oracle (G versions) based on MPP?
By the way there is no attachment.

Re: teradata and oracle architecture

Hi,

Thanks balaji. did not see the attchments !
Teradata Employee

Re: teradata and oracle architecture

In Oracle Hexadata there is parallelism in the top of the architecture, but there is a bottleneck behind it and it's not parallelism from this part to the core. Pls, have a look in the Oracle Hexadata Architecture and you can see it.