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

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 .. 8 9 10 11 12 13 < 14 > 15 16 17 18 19 20 .. 76 >> Next

8 mm tape drive 10 gigabytes
CD-ROM drive 1
19-inch VGA monitor 1
Keyboard and mouse 1
Modem 1

2-4

Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture

About This Chapter

System Component Minimum Maximum
5100M Per Node
SMP Nodes 2 128
Pentium CPU 8 4096
Clock rate 133 Mhz 166 Mhz
EDAC Memory 256 megabytes 4 gigabytes
System disks 2 4
Data disk storage capacities • 2.56 terabytes (RAID1) • 4 terabytes (RAID5)
Serial (ESCON) and/or parallel (Bus & Tag) channel connection 1 64
LAN connections 1200 sessions
Per Cabinet
8 mm tape drive 1 10 gigabytes
CD-ROM drive 1
Per System
AWS
BYNET 16 2 16
BYNET 32 0 8

Introduction to the Teradata RDBMS for UNIX

2-5
Teradata RDBMS Architecture

About This Chapter

Client Software

The SMP and MPP hardware supports the Teradata RDBMS running both with and without a channel- or network-attached client.

The following table describes the available client software, recognizing that the “client” may be the 3500/4100/4500/5100 machine itself. These products can also be used to access a Teradata RDBMS for TOS running on an NCR 3600 or DBC/1012 platform.

Contact your NCR representative for information on supported platforms for each product and for custom ports to other platforms.

Software Description Supported Access
BTEQ Interactive and batch query processor/report generator All channel- and network-attached clients
C Preprocessor Permits embedding SQL in C programs. All channel- and network-attached clients
COBOL Preprocessor Permits embedding SQL in COBOL programs. Channel-attached clients Some network-attached clients
PL/I Preprocessor Permits embedding SQL in PL/I programs. Channel-attached clients
CLI Packages and unpackages requests. Can be embedded in application programs using function calls. All channel- and network-attached clients
TDP Data communication management. Handles sessions, logging, recovery, restarts, physical I/O from the PEs, and security. Channel-attached clients
MTDP/MOSI Data communication management. Handles logging, recovery, restarts, and physical I/O from the PEs. Session and security management are handled by the Gateway software on the server. Network-attached clients

2-6

Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture

About This Chapter

Software Description Supported Access
Archive/ Restore Archives data to tape; restores taped data to Teradata RDBMS Channel-attached clients
ASF/2 (with REELlibrarian) Archives data to tape; restores taped data to Teradata RDBMS SMP and MPP platforms.
FastExport Extracts large volumes of data from the Teradata RDBMS. All channel- and network-attached clients
FastLoad Performs high performance data loading into empty tables. All channel- and network-attached clients
MultiLoad Performs high performance data loading, including inserts, updates, and deletions, against up to 5 existing tables. All channel- and network-attached clients

Introduction to the Teradata RDBMS for UNIX

2-7
Teradata RDBMS Architecture

About This Chapter

Server Software

The server software includes all the following:

• The Database Window

• The RDBMS Gateway

• A SQL parser and syntaxer

• A request dispatcher

• A session controller

• Facilities to control load balancing over the communications network

• The Teradata database management software

• The Teradata file system

• Teradata Parallel Database Extensions (PDE)

• The UNIX operating system

A server may also contain data loading utilities such as MultiLoad and FastLoad, data export utilities like FastExport, and the SQL data access utility BTEQ.

2-8

Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture

Virtual Processors

Introduction

PEs

Virtual Processors

The versatility of the Teradata RDBMS is based on virtual processors (vprocs), which eliminate dependency on specialized physical processors.

This is made possible by the Parallel Database Extensions (PDE) for UNIX. The PDE is an interface layer between the Teradata RDBMS and the standard UNIX operating system that runs on the NCR server.

A vproc is a collection of tasks running under the multitasking environment of the UNIX operating system. The tasks in a vproc share resources with other tasks in the same vproc. Multiple vprocs can run on an SMP platform or a node.

The vprocs and the tasks running under them communicate using unique-address messaging, as if they were physically isolated from each other. This message communication is done using the Vnet software on single node platforms and using the BYNET and BYNET Driver Software on multinode platforms.

There are two types of vprocs:

Type Description
PE Performs session control and dispatching tasks as well as parsing functions.
AMP Manages the distribution and retrieval of data on the virtual disks (vdisks), which are defined at system configuration time with the pdeconfig utility.
Previous << 1 .. 8 9 10 11 12 13 < 14 > 15 16 17 18 19 20 .. 76 >> Next