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()