Teradata



Teradata Data Warehouse system components

Teradata Database Server

Teradata Database Server is optimized for viewing and managing large amounts of data. It is fully scalable, implements parallel processing, is fault tolerant and ensures integrity of the data.

The Teradata Database is comprised of a number of modules which are represented by:

Teradata Database Window
Database Window application controls the operation of the Teradata Database
Teradata Gateway
Teradata Gateway provides and controls communications, client messages and encryption
Parallel Data Extensions
Parallel Data Extensions (PDE) is a software that enables parallel processing in the Teradata database
Teradata Database management software
Teradata Database management software includes Parsing Engine (PE), Access module processor (AMP) and the Teradata file system

Teradata Tools and Utilities (TTU)

TTU is a set of client applications to facilitate access to the Teradata Database. The most widely used Teradata client tools are:

Teradata SQL Assistant
Teradata SQL Assistant - a graphical tool that provides quick and easy database development and administration access
BTEQ
BTEQ (Basic Teradata Query) is a batch query processing facility
Teradata loading tools
The Teradata loading and unloading applications include MultiLoad (MLoad), TPump, FastExport, FastLoad, Parallel Transporter
Teradata ODBC driver
ODBC Teradata Driver is used to access Teradata Database from other tools and environments. An JDBC Interface for accessing Java applications is also available
Teradata OLE DB
Teradata OLE DB Provider is an interface for manipulating data
Teradata Administrator
Teradata Administrator is a database administration interface for DBA's
Teradata CLIv2
Teradata Call-Level Interface (CLIv2) is an interface between applications and the Teradata Gateway

Teradata Database administration, monitoring and other tools

Teradata Manager
Teradata Manager is a set of graphical database management and controlling tools
Teradata Performance Monitor
Teradata Performance Monitor is an application used for monitoring database sessions, resources usage and performance statistics
Teradata Visual Explain
Teradata Visual Explain produces graphical presentation of SQL scripts
Teradata Index Wizard
Teradata Index Wizard tool helps increase the indexes performance
Teradata Statistics Wizard
Teradata Statistics Wizard automates statistics generation
Teradata ARC
Teradata ARC (Archive and Recovery) utility provides tape archive and recovery process for the Teradata Databases
Teradata MDS
Teradata MDS (Meta Data Services) is a metadata management system. The components of MDS include centrally managed Metadata Repository, an MDS engine, Metamodels and Teradata MetaSurf web based view into the metadata repository.
Teradata Warehouse Builder
Teradata Warehouse Builder (Teradata WB) is an object-oriented software system that executes multiple instances of ETL (extract-transform-load) processes in a scalable, parallel Teradata environment.

Teradata Resources

Teradata MultiLoad Guide
Teradata MultiLoad GuideThe Teradata MLoad tutorial guides through the process of importing, updating and deleting data on Teradata RDBMS using Teradata MultiLoad loading tool. The tutorial recommends...
Teradata TPump Tutorial
Teradata TPump TutorialThe Teradata tutorial presentation of using Teradata TPump in an Active Data Warehouse Environment shows the use, features and architecture of using TPump in great detail. It...
Teradata Presentation
Teradata PresentationThe Teradata presentation starts with a brief overview of data warehousing concepts and is followed by a complete illustration of the Teradata RDBMS architecture with an overview...
Teradata
TeradataTeradata Express Edition is a free developer version of Teradata Software for Evaluation and Development, testing and learning. It is a fully featured installation of teradata. ...
Teradata MDS
Teradata MDSTeradata Meta Data Services (Teradata MDS) is an application which helps manage both business and technical metadata in an Enterprise Data Warehouse environment. The article...

Teradata EDW - Enterprise Data Warehouse
Teradata EDW - Enterprise Data WarehouseVendors information on the robust Teradata enterprise business intelligence framework. It provides high level information on the new features of the latest version, such as...
Teradata tutorial
Teradata tutorialA good Teradata tutorial which is divided into the following sections: Teradata components and introduction to Teradata database model Fundamental information on Teradata SQL...
String operations in Teradata
String operations in TeradataA tutorial article on how to handle character variables (strings) in Teradata SQL. The tutorial show how to concatenate strings, convert strings to hexadecimal value using...
Date and time manipulation in Teradata
Date and time manipulation in TeradataA tutorial article on how to handle date and time variables in Teradata (including discrapancies listing between V2R4 and V2R5). It contains information on timestamp data type...