Register now or log in to join your professional community.
Oracle is good for OLTP. But can not retrieve data efficiently. It actually will not work when volumes are high. Teradata will allow you high number of concurrent queries on large volumes. At one of my shop we had a table over 2 PB and performance was great.
Do not use it for OLTP as its designed for Denormalized Data Models.
because Teradata provide big data analysis and its organizing and quering.
Teradata with parallel processing capability leads in performance than Oracle in OLAP.
Teradata now supports mixed workload environment as well i.e. you can run both small loads and manipulations and large batch loads at the same time.
Juber,
What is your understanding for Oracle conventional SQL Tool? As a matter of fact, from a SQL sintax point of view, there is no difference between Oracle and Teradata - ok, I'll accept that there is might have a small difference between them, since Teradata uses SQL ANSI. Keep in mind that the Teradata is meant for huge datasets, so it's internal architecture is different, called MPP (Massive Parallel Processing) which is designed to maximize the database queries. That is the reason why Teradata does not fits a transactional application - where the system processes transactions by updating various files and returning confirmations. It implies a regular, high-volume stream of records entering the system. Teradata, instead, is built for an analytical environment: it can be used for business analysis, data warehouses that can track company data, such as sales, customer preferences, product placement, etc.Hope it helps
