Teradata

About

Teradata is a full parallel query system.

Articles Related

Architecture

AMP

The AMP is a unit of parallelism:

• Storing and retrieving data rows using the file system
• Aggregating data
• Joining processing between multiple tables
• Sorting and formatting output data

SQL Operation

Insert

Parallel Query

Find all orders from today, along with the items ordered

SELECT *
FROM Orders o, Lines i
WHERE o.order= i.order
AND o.date = today()