Introduction to Teradata in the Cloud
Cloud databases are pressuring traditional data warehousing MPP systems.
This blog post will illustrate the reasons for this and outline the pros and cons of each database system.
The Architecture of an MPP Database System
MPP database systems employ a shared-nothing architecture, wherein each node has its own CPU, main memory, and mass storage device.
Other examples of MPP database systems include Netezza, Amazon Redshift, and Microsoft Azure Synapse Analytics.
MPP provides parallel processing, but distribution and scaling depend on design and workload. Hashing does not guarantee evenness, and doubling nodes does not guarantee double speed. Hardware, storage and distribution choices differ across products.
Each manufacturer has devised its own approach.
Teradata can store data in both rows and columns. Additionally, data can be retrieved from a Column Partitioned Table using a Primary Index.
Get the complete Teradata tuning book, free
Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis
206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.
Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.
About the free bookNetezza uses its hardware, FPGA, and zone maps to identify where the searched data is not located and limits the queries to the required columns.
Almost all MPP database systems offer the following three options for distributing data (Netezza, Amazon Redshift, Microsoft Azure Synapse):
- Distribute All
Tables are copied entirely to all nodes. This is ideal for small tables as they are already available for joining on all nodes without the need to copy data (Teradata does not offer this kind of distribution, but it copies whole tables when necessary during query execution for join preparation) - Distribute By Hash
Here the distribution occurs via a key (in Teradata, it is the primary index). - Distribute Randomly
The data of a table is distributed evenly but randomly across all nodes. In Teradata, this is achieved by using so-called NOPI tables.

Advantages of an MPP Database System
- Performance
We can achieve excellent performance by distributing the load across nodes. - MPP provides parallel processing, but distribution and scaling depend on design and workload. Hashing does not guarantee evenness, and doubling nodes does not guarantee double speed. Hardware, storage and distribution choices differ across products.
Disadvantages of an MPP Database System
- Complexity
Most MPP database systems come with hardware that has been specially optimized to achieve the best performance.
These include the BYNET in Teradata, which performs specific tasks (sorting and merging of answer sets), or the special hardware from Netezza to restrict the data being read.
This often makes the system complicated and expensive. - Shared storage does not eliminate execution skew: joins, aggregates and uneven task inputs can concentrate work in Snowflake too. Diagnose the actual plan and workload.
- Scaling behavior is deployment-specific. Teradata VantageCloud Lake provides independent compute clusters and object storage; maps and online movement change traditional redistribution constraints. Blanket downtime, weeks-to-scale and coupled-compute/storage claims are outdated.
- Scaling behavior is deployment-specific. Teradata VantageCloud Lake provides independent compute clusters and object storage; maps and online movement change traditional redistribution constraints. Blanket downtime, weeks-to-scale and coupled-compute/storage claims are outdated.
Deciding what to change in your data platform?
Compare optimisation, modernisation and migration against your workload and business requirements.
Get the complete Teradata tuning book, free
Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis
206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.
Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.
About the free book