TERADATA ONLINE TRAINING

    TERADATA

Teradata Database is an information repository supported by tools and utilities that make it a complete and active relational database management system. 

Teradata developers designed Teradata Database from mostly off-the-shelf hardware components. The result was an inexpensive, high-quality system that exceeded the performance of conventional relational database management systems. The hardware components of Teradata Database evolved from those of a simple parallel database computer into those of a general-purpose, massively parallel computer running the database. 

The architecture supports both single-node, Symmetric Multiprocessing (SMP) systems and multi node, Massively Parallel Processing (MPP) systems in which the distributed functions communicate by means of a fast interconnect structure. The interconnect structure is the BYNET for MPP systems and the board less BYNET for SMP systems. 

The Teradata RDBMS was developed to allow users to view and manage large amounts of data as a collection of related tables. The goal of the Teradata RDBMS is to provide the benefits of a flexible relational database to its users. 

Teradata RDBMS is a complete relational database management system. The system is based on off-the-shelf Symmetric Multiprocessing (SMP) technology combined with a communication network connecting the SMP systems to form a Massively Parallel Processing (MMP) system. 

BYNET is a hardware inter-processor network to link SMP nodes. All processors in a same SMP node are connected by a virtual BYNET. 

A design goal of Teradata Database was to provide a single data store for a variety of client architectures. This approach greatly reduces data duplication and inaccuracies that can creep into data that is maintained in multiple stores. 

This approach to data storage is known as the single version of the business, and Teradata Database implements this through heterogeneous client access. Clients can access a single copy of enterprise data and Teradata Database takes care of such things as data type translation, connections, concurrency, and workload management. 

Teradata RDBMS supports the UCS Transformation Format 8-bit form (UTF-8) UNICODE client character set on Teradata clients on a per session basis. One- to three-byte UTF-8 UNICODE characters from the client are stored on Teradata RDBMS as two-byte UNICODE characters. By supporting UNICODE, the Teradata RDMBS can:

• Support data in multiple languages in the same session

• Support non-Latin data, for example, Japanese, Chinese, and so forth, on all systems

Teradata RDBMS supports running with or without a channel or network attached client. The following table describes the available client software, recognizing that the "client" may be the system running the Teradata RDBMS