Life Cycle of a Teradata Query

Teradata users or any other applications submit a query in the form of SQL (Structure Query Language) and receive the answer. But behind the scene, it has to pass many tests which determine its fate. Below are the steps which … Read more »

Know your Teradata system configuration

It may come to your mind that how many Nodes, Amps, PEs are there in your development and production Teradata system in which you are working on daily basis. Know your Teradata system configuration as below. To check the Teradata system … Read more »

Teradata Installation Guide

Do you want to install Teradata in your PC and start practicing today? Here is the  Teradata installation guide with screenshots. Teradata releases pre-installed image for Teradata Express for Vmware Workstation/Player. By installing this, you can access teradata from your … Read more »

Teradata Architecture

The main components of Teradata Architecture are PE(Parsing Engine), BYNET, AMP(Access Module Processor), Virtual Disk. Following is the logical view of the architecture: Parsing Engine When a user fires an SQL query it first gets connected to the PE (Parsing … Read more »

Introduction to Teradata

What is Teradata? Teradata is a RDBMS (relational database management system) which includes below features: It’s built on completely parallel architecture which means single task will be divided into smaller chunks and compute simultaneously hence faster execution. Teradata system is … Read more »