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 .. 67 68 69 70 71 72 < 73 > 74 75 .. 76 >> Next


utility See host utility program.

Introduction to the Teradata RDBMS for UNIX

Glossary-13
Glossary

view In Teradata SQL, an alternate way of organizing and

V presenting information in the Teradata RDBMS. A view, like a table,

has rows and columns. However, the rows and columns of a view are not directly stored by the Teradata RDBMS, but are derived from the rows and columns of tables (or other views) whenever the view is referenced.

virtual A system resource that can be used by programs but that is not an actual hardware device in the system. A “virtual” resource is simulated by software and “real” hardware resources.

virtual disk (vdisk) One or more physical disk regions that are grouped together to be associated with a virtual processors.

Virtual Machine (VM) One of the primary operating systems (or system control programs) for medium and large IBM computers.

virtual processor (vproc) A collection of processes (tasks) working together that has addressable attributes. The concept of the virtual processor provides the basic unit of parallelism to a Trusted Parallel Application. The parallelism is independent of actual hardware parallelism. The virtual processor allows multiple instances of database functions.

In the Teradata RDBMS, virtual processors assume the identity of AMP and PE. The standard virtual processor type available, independent of the presence of a TPA, is the node.

VM See Virtual Machine.

vproc See virtual processor.

word In Teradata SQL, a string of one to 30 contiguous, nonblank, alphabetic, numeric characters ( $, _, # ).

W

Ynet The interconnection network that allowed high-speed

Y communications between the processor nodes of an NCR System

3600 and DBC/1012.

Glossary-14

Introduction to the Teradata RDBMS for UNIX
Index

Index

Numerics

2PC 10-12

coordinator 10-12 interfaces 10-14 participant 10-12 processing 10-15 sessions supported 10-14 2PL 10-2

A

Access control 11-3 acctid 11-4 client identifiers 11-3 GRANT LOGON statement 11-8 logon policies 11-3 password 11-4 password encryption 11-7 password security 11-5 REVOKE LOGON statement 11-8 TDP security 11-5 tdpid 11-4 user identifiers 11-3 Access Module Processor. See AMP Account String Expansion. See ASE Account usage 12-9 string expansion 12-9 Accounting 12-7

Administrative Workstation. See AWS Aggregate operators 5-4 AVERAGE 5-4 COUNT 5-4 MAXIMUM 5-4 MINIMUM 5-4 SUM 5-4 ALTER statement 4-8 ALTER TABLE statement 9-4 AMP 2-11, 2-14, 2-25 clusters 2-25, 9-4 multiple requests 2-17 receiving steps 2-15

step processing 2-16, 2-17 steps 2-13 Application development 8-1 application generators 8-1 CLI 8-9

embedded SQL 8-2 fourth generation languages 8-1 implicit 8-1 macros 8-4 Preprocessor2 8-3 third party software 8-11 Application programming facilities 2-28 Archive and Restore utility 2-30, 9-1, 9-7

Archive Storage Facility 2. See ASF2 Archive/Recovery utility. See Archive and Restore utility Arithmetic functions 5-7 ABS(arg) 5-7 EXP(arg) 5-7 LN(arg) 5-7 LOG(arg) 5-7 NULLIFZERO 5-7 SQRT(arg) 5-7 Arithmetic operators 5-3 ASE 12-9

DBC.AMPUsage table 12-10 ASF2 2-30 Attribute 3-1 AWS 2-31

B

Basic Teradata Query. See BTEQ Boyce-Codd normal form. See BCNF BTEQ 1-6, 2-11, 2-22 logon string 12-9 BulkLoad utility 2-30 BYNET 1-6, 2-11, 2-14, 2-23, 2-25

Introduction to the Teradata RDBMS for UNIX

Index-1
Index

C

CA-ACF2 11-5 Call Level Interface. See CLI Candidate key 3-2, 3-9 CA-TOP SECRET 11-5 Circular dependencies, elimination of 3-6 CLI 1-1, 1-6, 2-26, 2-28 what is CLI? 8-9 Client

interface 2-11 software 1-1, 2-6 Column 3-1 adding 4-8 attributes 4-3

CASESPECIFIC 4-4 CONSTRAINT 4-4 DEFAULT 4-4 FORMAT 4-4 NOT CASESPECIFIC 4-4 NOT NULL 4-3 TITLE 4-4 UPPERCASE 4-4 Communications management 2-27 Concrete steps 2-14 Concurrency control 10-1 Configuration status 12-12 CREATE MACRO statement 3-13, 8-4 CREATE TABLE statement 9-4 CREATE VIEW statement 6-2 Creating databases 12-2 Creating users 12-2

D

Data

archiving 9-7 controlling access 11-8 conversion 2-12 restoring 9-7 Data Definition Language. See DDL

Data Dictionary. See DD Data Manipulation Language. See DML Data types 4-2 BYTE 4-3 BYTEINT 4-2 DECIMAL 4-2 INTEGER 4-2 SMALLINT 4-2 VARBYTE 4-3 Database

creating 12-2 names 11-3 Database management hierarchical model 3-1 network model 3-1 object-oriented model 3-1 relational model 3-1 Database management system. See Teradata DBS DBC 12-2 DBC database 12-2 DBC.SysSec table defaults 11-6 DBS

database engine 2-25 database manager 2-25 recovery 10-10 views 6-1 DBS. See Teradata DBS DD 7-1, 9-7, 11-5, 12-9 accessing 7-6 administrator views 7-4 end user views 7-3 objects 7-1 RCC views 7-5 structure 7-2 supervisory views 7-3 users 7-1 views 7-2 why use? 7-6 x views 7-2 DDE 2-26 DDL 4-1

Index-2

Introduction to the Teradata RDBMS for UNIX
Index

DecimalMax flag 4-3 DELETE statement 5-19 Design philosophy and goals 1-1 Determinant 3-3 Directory cache 2-13 Disk Subsystem 2-25 Dispatcher 2-14, 2-15 DML
Previous << 1 .. 67 68 69 70 71 72 < 73 > 74 75 .. 76 >> Next