[go: up one dir, main page]
Scribd
Upload
153 views3 pages

Teradata Architecture Overview

Teradata uses a massively parallel processing (MPP) architecture with symmetric multiprocessing (SMP) nodes. Each node contains multiple CPUs sharing memory. Multiple SMP nodes are connected via the BYNET, which allows virtual processors on different nodes to communicate. The shared nothing architecture means each virtual processor manages its own dedicated memory and disk space independently from other processors for high parallel performance. Nodes are grouped into cliques that share disk arrays.

Uploaded by

Hari Nath
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
153 views3 pages

Teradata Architecture Overview

Teradata uses a massively parallel processing (MPP) architecture with symmetric multiprocessing (SMP) nodes. Each node contains multiple CPUs sharing memory. Multiple SMP nodes are connected via the BYNET, which allows virtual processors on different nodes to communicate. The shared nothing architecture means each virtual processor manages its own dedicated memory and disk space independently from other processors for high parallel performance. Nodes are grouped into cliques that share disk arrays.

Uploaded by

Hari Nath
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Teradata Architecture

Symmetric multiprocessing (SMP) - A single node that contains multiple CPUs sharing a memory pool.

Massively parallel processing (MPP) - Multiple SMP nodes working together comprise a larger
configuration. The nodes are connected using the BYNET, which allows multiple virtual processors on
multiple system nodes to communicate with each other.

Shared Nothing Architecture(MPP) - means that each vproc(Access Module Processors and Parsing
Engines are Virtual processors) is responsible for its own portion of the database and do not share
common components.each AMP manages its own dedicated memory space and the data on its own vdisk
-- these are not shared with other AMPs. Each AMP uses system resources independently of the other
AMPs so they can all work in parallel for high system performance overall

A node is made up of various hardware and softwares

A clique is a set of Teradata nodes that share a common set of disk arrays. Cabling a subset of nodes to
the same disk arrays creates a clique.

A disk array is a configuration of disk drives that utilizes specialized controllers to manage and distribute
data and parity acroos the disks while providing fast access and data integrity

RAID 5 Data and parity protection striped across multiple disks

RAID 1 Each disk has a physical mirror replicating the data

Open Source Web Content Management

-----------------------------------

Teradata Storage Process

The Parsing Engine interprets the SQL command and converts the data record from the host into an
AMP message

The BYNET distributes the row to the appropriate AMP

The AMP formats the row and writes it to its associated disks

The disk holds the row for subsequent access

Sample covering letters for Permanent Jobs

-----------------------------------

Teradata Retrieval Process

The Parsing Engine dispatches a request to retrieve one or more rows


The BYNET ensures that appropriate AMP(s) are activated

The AMPs locate and retrieve desired rows in parallel access and will sort, aggregate or format if needed

The BYNET returns retrieved rows to parsing engine

The Parsing Engine returns row(s) to requesting client application

Free Online College Degree

-----------------------------------

The BYNET is responsible for

Point-to-point communications between nodes and virtual processors

Merging answer sets back to the PE

making Teradata parallelism possible

Free Employment Aptitude Test

-----------------------------------

The Parsing Engine is responsible for

Managing Individual sessions (up to 120)

Parsing and optimizing SQL requests

Dispatching the optimized plan to the AMPs

Sending the answer set response back to the requesting client

Software Testing jobs? Jobs For Freshers

-----------------------------------

The AMPs is responsible for

Storing and retrieving rows to and from the disks

Lock Management

Sorting rows and aggregating columns

Join Processing

Output conversions and formatting


Creating answer sets for clients

Disk space management and accounting

You might also like