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 .. 60 61 62 63 64 65 < 66 > 67 68 69 70 71 72 .. 76 >> Next

Hash buckets = 3,643 Hash buckets = 65,536 Introduction to the Teradata RDBMS for UNIX Teradata RDBMS for UNIX Database Design and Administration
Priority scheduling of sessions (based on CPU usage) Fair Share scheduling of performance groups (based on both CPU usage and I/O usage) Teradata RDBMS for UNIX Database Design and Administration

A-12

Introduction to the Teradata RDBMS for UNIX
How the Teradata RDBMS for UNIX Differs from the Teradata RDBMS for TOS

How the Teradata RDBMS for UNIX Differs from the Teradata DBS for TOS

V1 Feature V2 Feature Documentation sources for information
Teradata File System Teradata File System improvements Automatic detection of cylinder fragmentation Uniqueness code carried in the cylinder index More efficient internal format of data blocks Larger maximum multirow data block size (32 KB) Table-level attributes (data block size and free space percent) Optional look-ahead reads Optional page release User-tunable cache size for spool files User-tunable dictionary cache size User-tunable global default size of permanent and journal data blocks Introduction to the Teradata RDBMS for UNIX Teradata RDBMS for UNIX Support Utilities Teradata RDBMS for UNIX Utilities Reference Teradata RDBMS for UNIX Database Design and Administration

Introduction to the Teradata RDBMS for UNIX

A-13
How the Teradata RDBMS for UNIX Differs from the Teradata RDBMS for TOS

How the Teradata RDBMS for UNIX Differs from the Teradata DBS for TOS

V1 Feature V2 Feature Documentation sources for information
Teradata SQL R5.0, R5.1, R5.2 (except as affected by unsupported features, as detailed at the end of this appendix) Teradata SQL plus Teradata SQL improvements Local after-image permanent journal Table-level attributes (data block size and free space percent) HASH functions for reviewing primary data row distribution CASE expression NOWAIT option to the LOCKING modifier ROW option to the LOCKING modifier (as in V1R5.2) Teradata RDBMS for UNIX Database Design and Administration Teradata RDBMS for UNIX SQL Reference

A-14

Introduction to the Teradata RDBMS for UNIX
How the Teradata RDBMS for UNIX Differs from the Teradata RDBMS for TOS

How the Teradata RDBMS for UNIX Differs from the Teradata DBS for TOS

V1 Feature V2 Feature Documentation sources for information
User-Tunable Fields (Version utility) DeadlockTimeOut User-Tunable Fields (DBS Control and XCTL utilities) DeadlockTimeOut FreeSpacePercent MiniCylPackLowCylProd PermDBSize JournalDBSize DefragLowCylProd DictionaryCacheSize DBSCacheCtrl DBSCacheThr MaxParseTreeSegs ReadAhead StepsSegmentSize FsgCachePercent Introduction to the Teradata RDBMS for UNIX Teradata RDBMS for UNIX Database Design and Administration Teradata RDBMS Support Utilities Teradata RDBMS Support Utilities Reference
ResUsage macros Improved ResUsage macros Introduction to the Teradata RDBMS for UNIX Teradata RDBMS for UNIX Resource Usage Macros and Tables
DB Window (on 3600 Administrative Workstation (AWS)) Expanded DB Window Introduction to the Teradata RDBMS for UNIX Teradata RDBMS for UNIX Database Window Reference

Introduction to the Teradata RDBMS for UNIX

A-15
How the Teradata RDBMS for UNIX Differs from the Teradata RDBMS for TOS

How the Teradata RDBMS for UNIX Differs from the Teradata DBS for TOS

V1 Feature

V2 Feature

Documentation sources for

information

Additional reserved words (keywords):

HASHAMP

HASHBAKAMP

HASHBUCKET

HASHROW

Additional reserved words:

CASE

DATABLOCKSIZE

ELSE

FREESPACE

KILOBYTES

NOWAIT

THEN

WHEN

New utilities:

Ferret

Fair Share Scheduler

Monitor

XCTL

DBS Control Filer

Vproc Manager Database Initialization Program (DIP)

XPT

xperfstate

Teradata RDBMS for UNIX SQL Reference

Teradata RDBMS for UNIX Support Utilities Reference

Teradata RDBMS for UNIX Support Utilities

Teradata RDBMS for UNIX Database Design and Administration

A-16

Introduction to the Teradata RDBMS for UNIX
How the Teradata RDBMS for UNIX Differs from the Teradata RDBMS for TOS

How the Teradata RDBMS for UNIX Differs from the Teradata DBS for TOS

V1 Feature

V2 Feature
New Features:
• CASE expressions
• Correlated subqueries
• EXISTS predicate
• CHECK constraints
• Various ANSI
compliances,
including:
— Transaction semantics
— SQL flagger
— Duplicate rows
permitted
— Entry-level access
rights
— New, compliant data
types
— Column-level rights
— Support for duplicate
rows
— Referential integrity
— Kanji support
— Updatable cursors
— WITH CHECK clause
in views
— DISTINCT qualifier in
views
— Aggregates in views
— CREATE SCHEMA
statement
— Case Specific
character data
— New syntax for these
statements:
— GRANT
— REVOKE
— CREATE TABLE
• New functions and
expressions
• Expanded HELP
statements
• UPPER
• TRIM
• CASE

Documentation sources for information
Previous << 1 .. 60 61 62 63 64 65 < 66 > 67 68 69 70 71 72 .. 76 >> Next