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.
it has only one type of index while oracle has many types of indexes especially there bitmap index.
==> TD has several types of indexes (primary index, unique secondary index, non unique secondary index, value ordered index, join index, hash index...)
teradata does not have materialize view. oracle has materialize view which decrease the IO band width and makes system more scalable.
==> TD does have materialized views (view + join index on the view)
Oracle has very wide variety of analytic functions for Sql.
==> TD too and they're all ANSI compliant
3 types of partitioning and in oracle 11g there are some new addition in partitioning
==> horizontal partitionning is possible in TD (since V2R5) and vertical partitionning is part of the design of TD.
the largest databases in the world run on Oracle
==> fair enough but in this case size does not matter... it's the ability to manipulate a large amount of data that maters.
Thanks and Regards,
Afzal
-----0-----------------
www.24tasmahiti.com
No comments:
Post a Comment