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 12 .. 76 >> Next


Fourth Normal Form..............................................3-8

Fifth Normal Form...............................................3-8

Referential Integrity...............................................3-9

Introduction....................................................3-9

Enforcing RI in the Teradata RDBMS..............................3-9

Primary and Foreign Keys........................................3-9

Indexes.........................................................3-9

How do Primary Keys and Primary Indexes Relate?................3-10

What is Referential Integrity?.................................3-10

The Referential Constraint.....................................3-11

Referential Constraint Checks..................................3-12

Teradata Macros....................................................3-13

Introduction...................................................3-13

What is a Teradata Macro?......................................3-13

Creating a Macro...............................................3-13

Using a Macro..................................................3-13

Modifying a Macro..............................................3-14

Deleting a Macro...............................................3-14

For More Information...............................................3-15

xvi

Introduction to the Teradata RDBMS for UNIX
Table of Contents

Chapter 4

Data Definition

About This Chapter.................................................4-1

Introduction...................................................4-1

Basic Statements...............................................4-1

Teradata SQL Data Types............................................4-2

Introduction...................................................4-2

Teradata SQL Data Types........................................4-2

Teradata SQL Column Attributes.................................4-3

Creating New Tables................................................4-6

Introduction...................................................4-6

Example Database...............................................4-6

Creating the Employee and Department Tables....................4-7

Altering Tables....................................................4-8

Introduction...................................................4-8

Capabilities of the ALTER Statement............................4-8

Example: Adding a Column.......................................4-8

Example: Dropping a Column.....................................4-8

Indexes............................................................4-9

Introduction...................................................4-9

What Is An Index?..............................................4-9

Getting Ideas for Where and When to Index.....................4-10

Primary Indexes vs. Secondary Indexes.........................4-11

Primary Indexes...................................................4-13

Introduction..................................................4-13

Unique Primary Index..........................................4-14

Nonunique Primary Index.......................................4-14

Guidelines for Selecting a Primary Index......................4-14

Secondary Indexes.................................................4-15

Introduction..................................................4-15

Subtables.....................................................4-15

Journaling and Secondary Indexes..............................4-15

Advantages of Secondary Indexes...............................4-16

Unique Secondary Index........................................4-17

Nonunique Secondary Index.....................................4-17

Guidelines for Selecting a Secondary Index....................4-17

Creating an Index for a Table.....................................4-18

Introduction..................................................4-18

Creating a Primary Index......................................4-18

Creating a Secondary Index....................................4-18

Introduction to the Teradata RDBMS for UNIX xvii
Table of Contents

Rule of Thumb for Creating Indexes...........................4-18

Dropping Tables and Indexes.....................................4-19

Introduction.................................................4-19

Dropping a Table.............................................4-19

Dropping an Index............................................4-19

For More Information.............................................4-20

Chapter 5

Data Manipulation

About This Chapter..................................................5-1

Introduction....................................................5-1

What is the Structured Query Language (SQL)?....................5-1

SQL Data Manipulation...........................................5-1

The SELECT Statement................................................5-2
Previous << 1 .. 2 3 4 5 < 6 > 7 8 9 10 11 12 .. 76 >> Next