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 .. 56 57 58 59 60 61 < 62 > 63 64 65 66 67 68 .. 76 >> Next

NCR System 3000 CLIent interface UNIX V, Release 4
CLIent for OS/2 OS/2
CLIent for Macintosh Macintosh operating systems
WinCLI • MS-DOS • Microsoft Windows
ODBC Driver for Teradata Database System • Windows • Windows NT

NCR makes available custom ports of the Teradata client system to other platforms.

Introduction

Supported Software Environments

Introduction to the Teradata RDBMS for UNIX

13-5
Operating and Configuration Specifications

For More Information

For More Information

For more information on the topics presented in this chapter, see the following Teradata RDBMS manuals.

IF you want to learn more about . . . THEN see this manual . . .
Configuration specifications Teradata RDBMS for UNIX Field Support Guide
Gateway configuration Teradata RDBMS Gateway Control Utility Reference Manual

13-6

Introduction to the Teradata RDBMS for UNIX
How the Teradata RDBMS for UNIX Differs from the Teradata DBS for TOS

Appendix A

How the Teradata RDBMS for UNIX Differs from the Teradata DBS for TOS

Introduction to the Teradata RDBMS for UNIX
How the Teradata RDBMS for UNIX Differs from the Teradata DBS for TOS

Introduction to the Teradata RDBMS for UNIX
How the Teradata RDBMS for UNIX Differs from the Teradata RDBMS for TOS

About This Appendix

About This Appendix

The first section of this appendix discusses the major feature differences between the Teradata DBS for TOS and the Teradata RDBMS for UNIX).

A table summarizes the feature differences and references the Teradata RDBMS customer documents in which technical information for each Teradata RDBMS for UNIX feature can be found. (For the publication number of each document, please see the “Teradata RDBMS for UNIX Library” in the Preface.)

Introduction to the Teradata RDBMS for UNIX

A-1
How the Teradata RDBMS for UNIX Differs from the Teradata RDBMS for TOS

Teradata RDBMS for UNIX Differences

Open System with Less Dependence on Hardware

Teradata RDBMS for UNIX Differences

The Teradata Relational Database Management System for UNIX is significantly different from previous releases of the Teradata DBS for TOS.

The two most significant differences between the two Teradata RDBMS versions include the following:

• The Teradata DBS for TOS requires the proprietary Teradata operating system (TOS) installed on a massively parallel processing (MPP) NCR System 3600 or DBC/1012 computing platform.

With the Parallel Database Extensions (PDE) for UNIX, the Teradata RDBMS for UNIX runs on the standard UNIX operating system that comes pre-installed on the general purpose NCR server computers.

• The Teradata DBS for TOS takes advantage of a large number of special purpose hardware processors to provide unmatched parallel performance.

The Teradata RDBMS for UNIX provides this same parallel performance using virtual processors (vprocs) on both Symmetric Multiprocessing (System 3500 and 5100S) and Massively Parallel Processing (System 5100M) systems. Vprocs are described in more detail in Chapter 2.

These differences mean that the Teradata RDBMS, the world's most powerful parallel relational database system, provides entry-level, medium-size, and the world's largest decision enabling solutions using databases ranging from several gigabytes to terabytes. The Teradata RDBMS for UNIX system also provides a low-price replacement for small to moderate scale Teradata users with Model 2 or Model 3 DBC/ 1012s.

A-2

Introduction to the Teradata RDBMS for UNIX
How the Teradata RDBMS for UNIX Differs from the Teradata RDBMS for TOS

Additional Specific Improvements

Improved Performance and Added Features

Increased Number of Hash Buckets

Additional Specific Improvements

In addition to the major differences described above, The Teradata RDBMS for UNIX includes many differences that enhance Teradata RDBMS performance and functionality, including the following:

• An increased number of hash buckets

• Executable versus interpretive row evaluation

• File System improvements

• General improvements and added features

These differences are described in more detail in the following passages.

The number of hash buckets has increased from 3643 in the Teradata DBS for TOS to 65,536 in the Teradata RDBMS for UNIX. The larger number of hash buckets provides the following improvements:

• A decrease in the possibility of two rows of data with different index values hashing to the same hash-id, making much less likely the possibility of a query having to read multiple blocks of data to find a specified row.

• An improvement in lock granularity, since fewer rows are locked when a single row is accessed.

• The allowance of data to be distributed more evenly across the AMPs, taking even more advantage of the power and performance of parallel processing.

With 3643 hash buckets, there is always an uneven number of buckets assigned across the AMPs, because 3643 is a prime number.
Previous << 1 .. 56 57 58 59 60 61 < 62 > 63 64 65 66 67 68 .. 76 >> Next