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 9 10 11 .. 76 >> Next


Why SQL?........................................................2-18

SQL Flagger.....................................................2-18

SQL Lexicon.....................................................2-19

Character Sets..................................................2-22

Query Facilities....................................................2-23

Introduction....................................................2-23

BTEQ............................................................2-23

The BYNET...........................................................2-24

Introduction....................................................2-24

BYNET Functions.................................................2-24

Virtual Processor Connectivity in Single Node Systems..........2-25

The Access Module Process...........................................2-26

Introduction....................................................2-26

AMP Functions...................................................2-26

Scalability and Performance.....................................2-26

The Disk Subsystem..............................................2-26

AMP Clusters....................................................2-26

xiv

Introduction to the Teradata RDBMS for UNIX
Table of Contents

Request Packaging and Unpackaging................................2-27

Introduction.................................................2-27

Facilities for Packaging and Unpackaging

SQL Requests and Results..................................2-27

Data Communications Management in the

Teradata RDBMS Environment.....................................2-28

Introduction.................................................2-28

The TDP......................................................2-28

The Micro TDP................................................2-28

Application Programming Facilities...............................2-29

Introduction.................................................2-29

Embedded SQL.................................................2-29

Call-Level Interface.........................................2-29

ODBC.........................................................2-30

Archiving and Data Loading Utilities.............................2-31

Introduction.................................................2-31

Archive and Restore Utility and ASF2.........................2-31

BulkLoad.....................................................2-31

FastLoad.....................................................2-31

MultiLoad....................................................2-31

FastExport...................................................2-31

Administrative Workstation.......................................2-32

Database Window..................................................2-33

Introduction.................................................2-33

Workstation Types and Available Platforms....................2-33

Database Window Communication................................2-33

Functions Provided by the Database Window....................2-34

Supervisor Subwindow.........................................2-34

Utilities Available from the Supervisor Subwindow............2-34

Supervisor Commands Available from the Database Window..........

2-34

RDBMS Gateway....................................................2-36

Database Utility Software........................................2-37

Teradata Manager.................................................2-40

Introduction.................................................2-40

Performance Analysis.........................................2-40

Session Information..........................................2-40

Statistical Information......................................2-40

For More Information.............................................2-41

Introduction to the Teradata RDBMS for UNIX xv
Table of Contents

Chapter 3

The Relational Model

About This Chapter..................................................3-1

Introduction....................................................3-1

What is a Relational Database?..................................3-1

Some Other Definitions..........................................3-2

Normalization.......................................................3-4

Introduction....................................................3-4

First, Second, and Third Normal Forms...............................3-6

Introduction....................................................3-6

First Normal Form...............................................3-6

Second Normal Form..............................................3-6

Third Normal Form...............................................3-7

Boyce-Codd and Higher Normal Forms..................................3-8

Introduction....................................................3-8

Boyce-Codd Normal Form..........................................3-8
Previous << 1 .. 2 3 4 < 5 > 6 7 8 9 10 11 .. 76 >> Next