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


Automatic Detection of Cylinder Fragmentation.................A-5

Introduction to the Teradata RDBMS for UNIX xxv
Table of Contents

Uniqueness Code Carried in the Cylinder Index................A-5

More Efficient Internal Format of Data Blocks................A-5

Larger Maximum Multi-Row Data Block Size.....................A-6

Table-Level Attributes.......................................A-6

Optional Look-Ahead Reads....................................A-7

Optional Page Release........................................A-7

User-Tunable Cache Threshold for Data Block Caching ........A-7

Additional General Improvements.................................A-8

How the Teradata RDBMS for UNIX Differs from the Teradata DBS for TOS...............................A-11

Glossary

Glossary........................................................Glossary-1

Index

Index...............................................................Index-1

xxvi

Introduction to the Teradata RDBMS for UNIX
List of Figures

List of Figures

Chapter 1 Overview

Figure 1-1 Teradata RDBMS Shared Information Architecture.. 1-3

Figure 1-2 Process Flow of a SQL Statement Through the Teradata

RDBMS..............................................1-5

Chapter 2

Teradata RDBMS Architecture

Figure 2-1 PE Software Components..............................2-10

Figure 2-2 AMP Software Components.............................2-10

Figure 2-3 PE Routing of Teradata SQL Request Messages.........2-15

Figure 2-4 How the BYNET connects individual SMP nodes.. 2-25

Chapter 3

The Relational Model

Figure 3-1 Layers of normalization......................................3-4

Chapter 9

Fault Tolerance

Figure 9-1 vproc Migration............................................9-3

Figure 9-2 Unclustered AMPs With Fallback.............................9-4

Figure 9-3 Clustered AMPs With Fallback...............................9-5

Figure 9-4 Four Node Clique..........................................9-10

Figure 9-5 How Vprocs Migrate After a Node Failure.................. 9-11

Introduction to the Teradata RDBMS for UNIX xxvii
List of Figures

Chapter 10

Concurrency Control and Recovery

Figure 10-1 Lost Update Anomaly..................................10-6

Figure 10-2 Two-phase Commit Processing.........................10-13

Figure 10-3 Two-phase Commit Processing as a

Function of Time....................................10-15

Chapter 12

System Administration

Figure 12-1 Hierarchy of Users, Databases,

and Space Allocation..................................12-3

xxviii

Introduction to the Teradata RDBMS for UNIX
Revision Record

Revision Record

Date Description
November 1996 Initial printing. Supports Teradata RDBMS for UNIX V2R2.0.
May 29, 1998 Supports Teradata RDBMS for UNIX V2R2.1.0

Introduction to the Teradata RDBMS for UNIX

xxix
xxx
Overview

Chapter 1

Overview

Introduction to the Teradata RDBMS for UNIX
Overview

Introduction to the Teradata RDBMS for UNIX
Overview About This Chapter

About This Chapter

Introduction

This chapter presents an overview of the Teradata Relational Database Management System (RDBMS), including perspectives on its design and brief reviews of the hardware and software systems that comprise the Teradata RDBMS.

Design Perspectives

The topic on design perspectives for the Teradata RDBMS includes descriptions of the following:

• Research ideas leading to the eventual design

• Design philosophy and goals

• Scalability

• Shared information architecture

Teradata Database Software

The topic on Teradata software includes descriptions of the following:

• The structured query language (SQL) and its uses for application programming and interactive database queries

• The Teradata database management system

• The Teradata file system and disk handling system

Client Software

The topic on client software includes descriptions of the following:

• The request handler (Call Level Interface, or CLI)

• The data communications component (Teradata Director Program, or TDP)

• Application development services, including:

• A SQL preprocessor

• CLI

• Third party query front ends, gateways, and fourth generation languages

• Data loading utilities

• The archive/restore utility

Introduction to the Teradata RDBMS for UNIX

1-1
Overview

Design Perspectives

Introduction

Charter for the Teradata Database System

Research Ideas Leading to the Design of the Teradata Database System

Shared Information Architecture

Design Perspectives

This topic describes the considerations that went into the design of the original Teradata Database System. The topic also explains the overall perspectives behind the system.

The original charter for development of the Teradata RDBMS included the following goals:

• Large capacity database system with thousands of MIPS capable of storing terabytes of data and billions of rows
Previous << 1 .. 5 6 7 8 9 10 < 11 > 12 13 14 15 16 17 .. 76 >> Next