Teradata

> Database

1 - About

Teradata is a full parallel query system.

3 - Architecture

3.1 - 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
Advertising

4 - SQL Operation

4.1 - Insert

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