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

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 2 3 < 4 > 5 6 7 8 9 10 .. 218 >> Next


The Teradata consoles:

On an NCR WorldMark MPP platform, the Administrative Workstation (AWS)

The Database Window (DB Window, or DBW)

On Windows 2000, the Teradata MultiTool

To understand the terms and concepts in this book, you should review:

Introduction to Teradata RDBMS

I Teradata RDBMS Database Design

Teradata Basic Teradata Query Reference

The following publications are directly related to the subject matter in this book and you may find it helpful to have them available for reference:

Teradata RDBMS Utilities

Teradata RDBMS Security Administration

Teradata RDBMS Data Dictionary

Teradata RDBMS Performance Optimization

The suite of Teradata Tools and Utilities (TTU) client documents, especially:

Teradata Archive/Recovery Utility Reference

Teradata Manager User Guide

Teradata Index Wizard User Guide

Also, if your responsibilities include creating users, databases, and/or tables, you should also review and have handy for reference:

The chapter titled "SQL Data Definition, Control, and Manipulation" in Teradata RDBMS SQL Reference, Volume 1

Teradata RDBMS SQL Reference, Volume 4

vi

Teradata RDBMS Database Administration Preface

List of Acronyms

List of Acronyms

This book uses acronyms, which the following table lists in alphabetical order:

2PC Two-Phase Commit
ACI Applicant Coordinator Interface
AMP Access Module Process
ANSI American National Standards Institute
API Applicant Participant Interface
ARC Archive and Recovery
ASE Account String Expansion
AWS Administration Workstation
BLM BYNET Link Manager
BTEQ Basic Teradata Query
BYNET Banyan Network
CICS Customer Information Control System
CJ Changed Row Journal
CLI Call Level Interface
CLIv2 Call Level Interface Version 2
CMIC Cabinet Management Interface Controller
COBOL Common Business Oriented Language
CPI Coordinator Participant Interface
CPU Central Processing Unit
CR Cylinder Read
CSP Copy Save Program
DAC Disk Array Controller
DBQL Database Query Logging
DBW Database Window
DCL Data Control Language
DD Data Dictionary
DDL Data Definition Language

Teradata RDBMS Database Administration ix Preface

List of Acronyms

DIP

DML

DMP

DSS

DSU

DUL

DULTAPE I FDL

FIFO FK GDO HI HUT HUTCNS

I ID

nameID IMS I/O JI

LAN LSN LUN

I MLoad

MOSI MPP MTDP

I NPPI

NUPI

I NUPPI

NUSI OJ

Database Initialization Program Data Manipulation Language Dump Memory Program Decision Support System Data Storage Unit Dump Unload/Load Dump Unload/Load Tape Fast Data Load, FastLoad First In First Out Foreign Key

Globally Distributed Object Hash Index

Host Utility (in particular, ARC and ASF2) Host Utility Console Subsystem Identity Column Identifier

Information Management System

Input/Output

Join Index

Local Area Network

Logon Sequence Number

Logical Unit

MultiLoad

Micro Operating System Interface Massively Parallel Processing Micro Teradata Director Program Non-Partitioned Primary Index Non-Unique Primary Index Non-Unique Partitioned Primary Index Non-Unique Secondary Index Ordered System Change Journal

Teradata RDBMS Database Administration ix Preface

List of Acronyms

OLTP Online Transaction Processing
OS Operating system
OSCJ Ordered System Change Journal
PCI Participant Coordinator Interface
PDE Parallel Database Extensions
PDN Package Distribution Node
PE Parsing Engine
PI Primary Index
PJ Permanent Journal
PK Primary Key
PL/I Programming Language/1
PM/API Performance Monitor Application Programming Interface
PPI Partitioned Primary Index
PSA Priority Scheduler Administrator
QCD Query Capture Database
QCF Query Capture Feature
RAID Redundant Array of Independent Disks
RCT Resource Check Tools
RDAC Redundant Disk Array Controller
RDBMS Relational Database Management System
RI Referential Integrity
SCSI Small Computer System Interface
SI Secondary Index
SMP Symmetric Multi-Processing
SQL Structured Query Language
SSO Single Sign On
SUS Startup Subsystem
TDP Teradata Director Program
TDQM Teradata Dynamic Query Manager
TJ Transient Journal
TSET Teradata System Emulation Tool

Teradata RDBMS Database Administration

ix Preface

List of Acronyms

TLE Target-Level Emulation

TPA Trusted Parallel Application (always a Teradata RDBMS)

TPump Teradata Parallel Data Pump

TSC Teradata Support Center

TSET Teradata System Emulation Tool

TTU Teradata Tools and Utilities client software and documentation

TUVT Teradata Utilities Verification Tool

UPI Unique Primary Index

UPPI Unique Partitioned Primary Index

USI Unique Secondary Index

VEComp Visual Explain and Compare

vdisk Virtual Disk

vproc Virtual Processor

x

Teradata RDBMS Database Administration ix Preface

Technical Information on the Web

Technical Information on the Web

The NCR home page ( http://www.ncr.com) provides links to numerous sources of information about Teradata. Among the links provided are sites that deal with the following subjects:
Previous << 1 .. 2 3 < 4 > 5 6 7 8 9 10 .. 218 >> Next