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 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 (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 is a database administration interface for DBA's
Teradata Call-Level Interface (CLIv2) is an interface between applications and the Teradata Gateway
Teradata Database administration, monitoring and other tools
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 (Archive and Recovery) utility provides tape archive and recovery process for the Teradata Databases
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.
The Teradata MLoad tutorial guides through the process of importing, updating and deleting data on Teradata RDBMS using Teradata MultiLoad loading tool. The tutorial recommends...
The 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...
The 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 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 Meta Data Services (Teradata MDS) is an application which helps manage both business and technical metadata in an Enterprise Data Warehouse environment. The article...
Vendors information on the robust Teradata enterprise business intelligence framework. It provides high level information on the new features of the latest version, such as...
A good Teradata tutorial which is divided into the following sections: Teradata components and introduction to Teradata database model Fundamental information on Teradata SQL...
A 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...
A 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...
A quick tutorial on Select Queries in Teradata SQL. It describes the syntax of select statement, its use, a few useful examples and users' comments....