in black and white
Main menu
Share a book About us Home
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics

Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR

NCR Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR, 1998. - 315 p.
Download (direct link): inntroduktionteradata1998.pdf
Previous << 1 .. 13 14 15 16 17 18 < 19 > 20 21 22 23 24 25 .. 76 >> Next

AMP Functions

Each AMP controls the following set of functions:

• BYNET (or Vnet) interface

• Database manager





Output data conversion

Disk space management



File system and disk management

Scalability and Performance

You can increase the performance of a Teradata RDBMS by adding SMP nodes to your system. Performance increases at a nearly linear rate with the addition of SMP nodes to a 5100M configuration.

The Disk Subsystem

Each AMP supports one virtual disk unit, using either RAID1 (mirroring) or RAID5 (parity striping) technology.

AMPs are grouped into logical clusters to enhance the fault tolerant AMP Clusters 2 capabilities of the Teradata RDBMS. This method of creating

additional fault tolerance in your system is discussed further in Chapter 9, “Fault Tolerance.”


Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture

Request Packaging and Unpackaging


Facilities for Packaging and Unpackaging SQL Requests and Results

Request Packaging and Unpackaging

Any SQL statement must be packaged before being transmitted to the server-based database where it is executed. The returned response must then be unpackaged and presented to the requesting terminal or application program.

This topic discusses the mechanism for request handling used by the Teradata RDBMS.

The Call-Level Interface (CLI) is the primary mechanism the Teradata RDBMS uses to package and unpackage SQL requests and results. It is the principal API for the Teradata RDBMS.

The CLI packages queries into uniform blocks that are routed to the server by the Teradata Director Program (TDP) in IBM mainframe configurations or by the MTDP in other configurations.

Result tables returned to the requesting terminal or application are similarly routed by the TDP to the appropriate requester where they are unpackaged and presented as a results table.

Personal computers running Microsoft Windows® can use the Windows® CLI (WinCLI) package to access the Teradata RDBMS. WinCLI uses the Dynamic Data Exchange (DDE) protocol to communicate with application programs.

The industry-standard ODBC driver to the Teradata RDBMS is another API for packaging and unpackaging SQL requests.

Introduction to the Teradata RDBMS for UNIX

Teradata RDBMS Architecture

Data Communications Management in the Teradata RDBMS Environment

Data Communications Management in the Teradata RDBMS Environment


This topic discusses the Teradata RDBMS component that handles all data communications management: the Teradata Director Program (TDP).


SQL requests from a client-based user, whether made as an interactive query or from an application program, are transmitted in the form of CLI packet messages, as are the responses to the query.

These transmissions are managed by a data communications manager.

In the Teradata RDBMS, the data communications manager is called the Teradata Director Program, or TDP.

The TDP does all of the following:

• Establishes and manages session control

• Routes requests

• Routes logons

• Verifies users

• Initiates recovery and restart processing

• Monitors and controls security

The Teradata RDBMS also provides facilities to enable the TDP to communicate with client application services.

Workstation clients run a version of the TDP called the Micro TDP The Micro TDP 2 (MTDP) and an additional component called the Micro Operating

System Interface (MOSI), which contains libraries of procedures to handle operating system-dependent and communications protocol-dependent services.

The MTDP calls MOSI routines for system services like:

• Interrupt processing

• I/O processing

• Network connection and processing


Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture Application Programming Facilities

Application Programming Facilities

This topic discusses the application programming facilities Introduction 2 provided by the Teradata RDBMS software.

This software falls into several broad categories:

• Embedded SQL

• Call Level Interface


Because SQL is the only language the Teradata RDBMS understands, all application programming facilities ultimately make their queries against the database using the SQL language.

The Teradata RDBMS provides a preprocessing facility that enables Embedded SQL 2 you to include ANSI-compliant SQL statements in your application


The SQL preprocessor parses your application code for SQL statements, converts them to CLI calls, and then comments out the SQL statements. After the application code has been preprocessed by the Teradata RDBMS Preprocessor2, you can submit it to your client application language compiler.

Preprocessor2 supports the following client programming languages.

This programming language . . . Is supported on this platform . . .
Previous << 1 .. 13 14 15 16 17 18 < 19 > 20 21 22 23 24 25 .. 76 >> Next