Series: Subject: Topic:
Question: 132 of 200

What is the difference between Oracle and Teradata?

Asked by: Interview Candidate | Asked on: May 15th, 2007
Showing Answers 1 - 3 of 3 Answers

Answered On : Feb 24th, 2010

View all answers by pavanch

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.

Login to rate this answer.

Answered On : 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

Login to rate this answer.
Martin Alvarez

Answered On : Mar 18th, 2012

View all answers by Martin Alvarez

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.

Yes  1 User has rated as useful.
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions



twitter fb Linkedin GPlus RSS


Question Categories

Abinitio Interview Questions

Analysis services Interview Questions

Data Warehousing Basics

BO Designer Interview Questions

Business Intelligence Interview Questions

Business Objects Interview Questions

Cognos Interview Questions

Data Warehousing Concepts

BO Data Integration

DataStage Interview Questions

ETL Interview Questions

Hyperion Interview Questions

Impromptu Interview Questions

Informatica Interview Questions

MicroStrategy Interview Questions

Reportnet Interview Questions

Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.