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

Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR

Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1

Author: NCR
Publishers: NCR
Year of publication: 1998
Number of pages: 315
Read: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
Download: inntroduktionteradata1998.pdf

Introduction to the Teradata® RDBMS for UNIX®

Version 2 Release 2.1.0 BD10-4955-B
(30 NCR

Introduction to the Teradata® RDBMS for UNIX®

Version 2 Release 2.1

BD10-4955-B 01.00.00 May 29, 1998
The product described in this book is a licensed product of NCR Corporation.

BYNET is a registered trademark of Teradata Corporation

CICS, CICS/ESA, CICS/VS, DATABASE2, DB2, IBM, MVS/ESA, MVS/XA, QMS, RACF, SQL/DS, VM/XA, and VTAM are trademarks or registered trademarks of International Business Machines Corporation in the U. S. and other countries. DBC/1012 is a registered trademark of Teradata Corporation.

DEC, VAX, MicroVax, and VMS are registered trademarks of Digital Equipment Corporation.

EXCELAN is a trademark of Excelan, Incorporated.

HEWLETT-PACKARD is a registered trademark of Hewlett-Packard Company,

INTELLECT and KBMS are trademarks of Trinzic Corporation.

INTERTEST is a registered trademark of Computer Associates International, Inc.

ISO is a trademark of International Standards Organization.

MICROSOFT, MS-DOS, DOS/V, Windows, Windows 95, and Windows NT are registered trademarks of Microsoft Corporation.

SABRE is a trademark of Seagate Technology, Inc.

SAS and SAS/C are registered trademarks of SAS Institute Inc.

SUN and SUN OS are trademarks of Sun Microsystems, Incorporated.

TCP/IP protocol is a United States Department of Defense Standard ARPANET protocol.

TERADATA is a registered trademark of Teradata Corporation.

UNIX is a registered trademark of UNIX System Laboratories.

YNET is a registered trademark of Teradata Corporation.

X/Open and the X device are trademarks of X/Open Company Limited.

XNS is a trademark of Xerox Corporation.

It is the policy of NCR Corporation (NCR) to improve products as new technology, components, software, and firmware become available. NCR, therefore, reserves the right to change specifications without prior notice.

All features, functions, and operations described herein may not be marketed by NCR in all parts of the world. In some instances, photographs are of equipment prototypes. Therefore, before using this document, consult with your NCR representative or NCR office for information that is applicable and current.

To maintain the quality of our information products, we need your comments on the accuracy, clarity, organization, and value of this book. Please complete the User Feedback Form and mail or e-mail the form to:

Information Engineering

NCR Corporation

100 North Sepulveda Boulevard

El Segundo, CA 90245-4361


Copyright © 1998 By NCR Corporation Dayton, Ohio U.S.A.

All Rights Reserved Printed in U.S.A.

About This Book

About This Book

Note: The name of the Teradata Database System (DBS) has been changed to the Teradata Relational Database Management System (RDBMS) to more accurately reflect the true nature of the product. This change will take place over a period of time in documentation, product names, and screen displays. In the meantime, all occurrences of “Teradata Database System,” “Teradata DBS,” or “DBS” should be read as referring to the “Teradata Relational Database Management System.”


This book provides an introduction to the Teradata RDBMS for UNIX.


This book is intended for anybody who uses the Teradata RDBMS for UNIX.

How This Book Is Organized

This book contains thirteen chapters, one appendix and a glossary:

Chapter 1, “Overview,” introduces the Teradata RDBMS, including its design philosophy and goals, its shared information architecture, and its scalability.

Chapter 2, “Teradata RDBMS Architecture,” introduces the hardware and software architecture that supports the Teradata RDBMS, including both client and server software. System 3500, System 4500, and System 5100 (WorldMark) hardware is described.

Chapter 3, “The Relational Model,” presents an overview of the relational model for database management, including an introduction to normalization and a brief discussion of Teradata RDBMS macros.

Chapter 4, “Data Definition,” describes the data definition capabilities of Teradata SQL, the Structured Query Language, including how to create, change, and delete databases, tables, indexes, and macros.

Chapter 5, “Data Manipulation,” describes the data manipulation capabilities of Teradata SQL, including the SELECT, INSERT, UPDATE, and DELETE statements.

Chapter 6, “Views,” introduces the concept of the view, emphasizing that views are virtual, not base tables. The chapter also describes why views are the recommended means by which to present base table information to end users.

Introduction to the Teradata RDBMS for UNIX

About This Book


Chapter 7, “Data Dictionary,” describes the Data Dictionary (DD), the system catalog for the Teradata RDBMS. The DD includes definitions for the database objects, user characteristics, and much more.
< 1 > 2 3 4 5 6 7 .. 76 >> Next