pavanch

 Profile Answers by pavanch 

• Feb 24th, 2010

 

Both Oracle and Teradata are RDBMS databases. However, teradata is specially designed for Dataware house. The data retrieval is much faster in teradata which is the major advantage.  Its architecture is different from Oracle.

Divya

• Jan 6th, 2012

 

Oracle and Teradata are RDBMS databases. But the main difference is Terdata supports parallelism and it allows more data 10 to power 12 Gb where it increases scability when compared to Oracle

Martin Alvarez

 Profile Answers by Martin Alvarez 

• Mar 18th, 2012

 

Teradata and Oracle produce relational database management systems. What the previous answers do not provide are important facts about both platforms.

Teradata products are a "combo" of hardware + software, in other words what some call a "Database Appliance" (some Teradata veterans hated this term but they gave in when Netezza successfully started to win deals to Teradata by selling "appliances"). By building their solution as a marriage between specialized hardware and software, Teradata has been successfully selling their solutions in the Data Warehouse niche for over 25 years, achieving the kind of performance on Very Large Databases that Oracle struggled to obtain in Commodity hardware. However, in 2008 Oracle introduced the Oracle Exadata Database Server, an appliance solution that achieves outstanding performance using Massive Parallel Processing and Intelligent Storage Servers (Exadata Storage Servers). Like Teradata, this solution is not as cheap as buying the Oracle software and installing it on commodity hardware, but it is a great solution for very large databases that demand great performance with complex queries (Oracle Exadata easily scales to more than 9 Petabytes). Of course you will have Teradata Marketing telling you that Oracle is not as good as Teradata (spurring all sorts of technical details) and Oracle Marketing will do the same, so I advise you to get informed and compare these 2 platforms from the requirements and demands of your Business Intelligence solution.

Oracle does provide some interesting advantages generally speaking over Teradata:

1) Mixed Workloads: Oracle is the only Data Warehouse appliance capable of running OLTP and OLAP databases on the same platform. Something Teradata cannot do. This gives Oracle a better performance under most mixed workload scenarios. Pure OLAP worloads in Data Warehouses are not common.

2) Compression: Teradata has improved substantially their compression through Teradata 13 and now 14, but they are still way behind what you can achieve with Exadatas Hybrid Columnar Compression.

3) Exadata runs Oracle: Teradata likes to say that Exadata is "still Oracle"... and that is good from the perspective that by running Oracle 11gR2, you have a wide arrange of security and management tools Teradata does not have. Also, it is easier to find skilled professional resources in Oracle that it is with Teradata.

Do your research and read through the marketing.

Priyanka Sathe

• May 8th, 2018

 

Teradata is a RDBMS used specially to build data warehousing applications.
The biggest strength of TD is parellelism.
TD distributes its workload evenly across its system and process it in parallel which makes it much faster than other databases.