Teradata

About

Teradata is a full parallel query system.

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

_


Powered by ComboStrap