Teradata

What is Teradata?

Teradata is a Relational Database Management System (RDBMS) that drives a company’s data warehouse.

Teradata is an open system, compliant with industry ANSI standards.

It is currently available for the following operating systems:

• UNIX MP-RAS
• Windows 2000

The ability to manage terabytes of data is accomplished using the concept of parallelism, wherein many individual processors perform smaller tasks concurrently to accomplish an operation against a huge repository of data.

To date, only parallel architectures can handle databases of this size.

Why Teradata?

There are many reasons to choose Teradata as the preferred platform for enterprise data warehousing:

Supports easy scalability from a small (10 GB) to a massive (100+TB) database.

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

Designed and built with parallelism from day one .

Single operational view of the entire MPP system and single point of control for the DBA (Teradata Manager).

Teradata has been doing data warehousing longer than any other vendor.

Teradata Architecture

In order to understand how queries execute on a Teradata System, it is important to have an understanding of the parallel architecture of Teradata and how the components making up the system are interacting with each other.

The Teradata architecture described is the same for each relevant release of Teradata. Additional features introduced over time are not covered as they do not give to the general understanding of the system architecture.

I will not go into great detail here. If you are interested in more detailed information, I recommend reading the Teradata Manuals which you can download for free. I will limit this post to information sufficient to understand parallelism on Teradata.

• Parsing Engine (PE)
• BYNET
• Access Module Processor (AMP)
• Virtual Disks

The Parsing Engine

The parsing engine is a process responsible for the following tasks:

• Session handling (session authorization, log on, log off)
• Parsing the SQL statement (syntax checking, looking up the used database objects)
• Optimization of the SQL statement (statistics are crucial at this time)
• Creation of the execution plan
• Dispatching the execution plan to the AMPs
• some other tasks like character set conversion etc. which are not relevant for our purpose of understanding how SQL statements are executed.

The Parsing Engine is the piece of software communicating with the client applications (SQL Assistant, BTEQ, etc.)

Each Teradata System has several Parsing Engines executed at the same time. The number of Parsing Engines can be increased dynamically by the system if needed. Each Parsing Engine can only handle a limited amount of sessions.

AMPS and Parallelism

AMPs are the foundation for parallelism on Teradata. The goal of each Teradata system is to distribute work evenly across all available AMPs. If we can reach this aim, we will have a performance-optimized system regarding parallelism.

What you will learn in This Training?

• All about Teradata, its architecture and components and how it compares to RDBMS
• The Teradata indexing mechanism and handling and manipulation of data
• Advanced SQL operations and using sub-queries, OLAP functions and others
• Advanced Database objects and using them to perform performance tuning and optimization
• Application utilities provided by Teradata such as FastLoad and MultiLoad
• How to protect data in Teradata

Is this course right for you?

Database administrators, developers, data analysts, and professionals contributing in areas of business intelligence will find this course useful.

What are the Prerequisites to learn Teradata?

Participants are expected to have basic Knowledge in SQL, general relational database knowledge and basic Unix commands.

Scheduling Demo With Trainer:

If you would like to take the online demo for Teradata trainer can you please make an inquiry or fill the form for demo registration, one of our executives will arrange a meeting with the expert trainer.

Course Finished Certificate :

After finish, the course we provide Teradata course finished certificate of kits technologies looks like