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 < 2 > 3 4 5 6 7 8 .. 76 >> Next


Chapter 8, “Application Development,” introduces application development in the Teradata RDBMS environment, including the use of embedded SQL and CLI calls in client programming languages.

Chapter 9, “Fault Tolerance,” describes fault tolerance in the Teradata RDBMS, including both hardware and software elements.

Chapter 10, “Concurrency Control and Recovery,” introduces the topic of concurrency control and transactions. Object locking, serializability of transactions, and the two-phase commit protocol for distributed databases are among the subjects described.

Chapter 11, “Security and Integrity,” discusses security and integrity in the Teradata RDBMS environment.

Chapter 12, “System Administration,” introduces system administration of the Teradata RDBMS. Topics include user and space allocation, accounting, monitoring, and server-resident utilities.

Chapter 13, “Operating and Configuration Specifications,” describes the capacities of and requirements for the Teradata RDBMS.

Appendix A, “How the Teradata RDBMS for UNIX Differs from the Teradata RDBMS for TOS,” describes the differences between Version 1 and Version 2 Teradata database management systems.

The “Glossary” defines frequently used terms in the Teradata RDBMS environment.

You should be familiar with basic computer technology, NCR system hardware, the Teradata RDBMS, the system console environment, and X Windows.

It may be helpful to review the following books:

• Introduction to Teradata RDBMS for UNIX

• Teradata RDBMS for UNIX Support Utilities Reference

ii

Introduction to the Teradata RDBMS for UNIX
Preface

Changes to This Book

Changes to This Book

Changes made to the Introduction to the Teradata RDBMS for UNIX are focused on DR maintenance and include:

Join Index DR 37060

Join Index represents a new type of indexing structure. For introductory information on Join Index see page 4-10 and page 4-17.

For general information on Join Index, see the Teradata RDBMS for UNIX V2R2.1 Base System Release Definition and Transmittal Document. For usage information see the section on Join Index in the Teradata RDBMS for UNIX Database Design and Administration Manual.

RFC to provide ESCON mainframe channel connectivity

DCR 7030

This DR addresses changes to the mainframe physical connection to the Teradata server. Pages in this document that are impacted: page 2-3, page 2-4, page 2-5 and page 2-11.

Hash Join

DR 39131

Hash Join is an alternative join scheme and is introduced on page 5-13.

Decimal 18 Default is Regression Problem

DR 39789

The increase of the maximum Decimal value for TotalDigits from 15 to 18 has caused regression problems some customer applications and third party vendor processes. This DR is addressed in page 4-2 and page 4-2.

Introduction to the Teradata RDBMS for UNIX
Preface

Changes to This Book

Teradata RDBMS Year 2000 Qualification

DR 38139

Throughout this reference, there is frequent mention of the DATE parameter in a 2-digit year format ‘YY/MM/DD'.

Teradata RDBMS V2R2.1 introduces the use of a system-wide default called the CenturyBreak parameter which the RDBMS software will use to internally convert 2-digit dates (‘YY') to the correct 4-digit date (‘XXYY'). This new parameter is a new general field in the DBS control record.

For more information on the CenturyBreak parameter see Chapter 14, “Setting Up, Creating, and Modifying the Database Structure,” of the Teradata RDBMS for UNIX Database Design and Administration Manual.

iv

Introduction to the Teradata RDBMS for UNIX
Preface

List of Acronyms

List of Acronyms

The following acronyms, listed in alphabetical order, are used in this

book:
1NF First Normal Form
2NF Second Normal Form
2PC Two-Phase Commit
3NF Third Normal Form
4NF Fourth Normal Form
5NF Fifth Normal Form
AMP Access Module Process
ANSI American National Standards Institute
API Application Programming Interface
ASCII American Standard Code for Information Interchange
ASF2 Archive Storage Facility 2
AWS Administrative Workstation
BCNF Boyce-Codd Normal Form
BTEQ Basic Teradata Query Facility
CICS Customer Information Control System
CLIv2 Call-Level Interface, Version 2
CMS Conversational Monitor System
CNS Console Subsystem
DB2 DATABASE 2
DBC Database Computer
DBS Database System
DBW Database Window
DD Data Dictionary
DDL Data Definition Language
DML Data Manipulation Language
EBCDIC Extended Binary Coded Decimal Interchange Code
FIPS Federal Information Processing Standards

Introduction to the Teradata RDBMS for UNIX

v
Preface

List of Acronyms

IBM International Business Machines Corporation
I/O Input/Output
JBOD Just a Bunch Of Disks
MOSI Micro Operating System Interface
MPP Massively Parallel Processing
MTDP Micro Teradata Director Program
MVS Multiple Virtual Storage
NIST National Institute of Standards and Technology
NUPI Nonunique Primary Index
Previous << 1 < 2 > 3 4 5 6 7 8 .. 76 >> Next