Teradata DBA Training in Hyderabad

Features of Teradata:

• Unlimited Parallelism: Teradata is based on MPP architecture (Massively Parallel Processing) which divides the workload evenly across the entire system. It splits the task among its processes and runs them parallel and this reduces the pressure and task is completed real quick.
• Connectivity: Teradata can connect to mainframe or network attached systems. It supports SQL to interact with data stored in the tables. Also, It provides its own extension.
• Mature Optimizer: Teradata optimizer is very matured and works parallel since the start.
• Linear Scalability: Teradata systems are extremely scalable. They are scalable up to 2048 nodes. One can easily triple the capacity of the system by tripling the number of AMPs.
• Robust Utilities: Teradata supports robust utilities to import/export data Eg: Fast Load, Multi-load, etc..
• Shared Nothing Architecture: Teradata nodes, AMPs work independently without sharing. They work independently.
• Useful for any type of user: It can be customized for any type of users like business users or application users. The SQL of Teradata can be customized for business needs and provides great features for business requirements.

Components of Teradata:

• The major components of Teradata are Parsing Engine, ByNet, and Access Module, Processors. Below are the key components of the system:

Node:

• Every individual server in Teradata is called a node.
• Every node has its own operating system, memory, CPU, disk space and its own copy of Teradata RDBMS.
• A cabinet of a Teradata would contain the number of nodes.

Parsing Engine:

Parsing Engine is used for getting queries from the client and to prepare a clear execution plan. The parsing engine responsibilities are:

• Receiving SQL Query from the client
• Parse the received query into the system and check for any syntactical errors
• Check if the user has required privileges for objects used in the query.
• Prepare a neat execution plan, get the query and pass the SQL query to BYNET.
• To receive the results from AMP and send them to the client

Message Parsing layer:

• This is BYNET and is the networking layer of the Teradata system.
• It is used for communication between nodes, between PE and AMP.

Access Module Processor:

• AMPs are also called as virtual processors. These are the ones that actually stores the data and retrieves the data.

Storage Architecture:

• Database management engines also need to be able to grow with your organization.
• Small businesses may only need limited features or have small amounts of data to manage, but requirements can grow substantially over time, and switching to another database management system can be a hassle.
• This allows you to automate your data management and focus on your core business.