ONLINE IT TRAINING FOR TERADATA IN WORLD WIDE

What is the Teradata Database?

Teradata is a relational database management system (RDBMS) that is:
• Teradata is an open system, running on a UNIX MP-RAS or Windows server platform.
• Teradata is capable of supporting many concurrent users from various client platforms.
• Teradata is compatible with industry standards (ANSI compliant).
• Teradata is completely built on a parallel architecture.

Why Teradata?

There have plenty of reasons why customers like to choose Teradata.

·         Teradata supports more larger warehouse data than all competitors combined.

·         Teradata Database can scale from 100 gigabytes to over 100+ petabytes of data on a single system without losing any performance .This is called Scalability.

·         Provides a parallel-aware Optimizer that makes query tuning unnecessary to get a query to run.

·         Automatic and even data distribution eliminates complex indexing schemes or time-consuming reorganizations .

·         Teradata Database can handle the most concurrent users, who are often running multiple, complex queries.

·         Designed and built with parallelism.

·         Supports ad-hoc queries using SQL

·         Single point of control for the DBA (Teradata Manager).

·         Unconditional parallelism (parallel architecture)

·         Teradata provides the lowest total cost (TCO) of ownership

·         High availability of data because there is no single point of failure – fault tolerance is built-in to the system.

Teradata Database can be used as 

·         Enterprise data warehousing

·         Active data warehousing

·         Customer relationship management

·         Internet and E-­Business

·         Data marts

Architecture of Teradata 

Teradata relies on three architectural components.

·         Parsing Engine(PE) or Optimizer

·         Access Module Processors(AMPs)

·         BYNETs

·         Disks

Parsing Engine (PE)
The Parsing Engine (PE) is a component that interprets SQL requests, receives input records, and passes data. It sends the messages through the BYNET to the AMPs.

BYNETs
The BYNET act as message-passing layer. It decides which AMP should receive a message.