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 13 14 .. 76 >> Next


Supervisory User Views..........................................7-3

Administrator Views.............................................7-4

Recovery Control User Views.....................................7-5

Using the Data Dictionary...........................................7-6

Introduction....................................................7-6

Why Use the Data Dictionary?....................................7-6

How do you Access the Data Dictionary?..........................7-6

For More Information................................................7-8

Chapter 8

Application Development

About This Chapter................................................8-1

Introduction..................................................8-1

Explicit SQL Development......................................8-1

Implicit SQL Development......................................8-1

Writing Embedded SQL Applications.................................8-2

Introduction..................................................8-2

What is Embedded SQL?.........................................8-2

How Does an Application Program Use Embedded SQL?.............8-2

Supported Languages and Platforms.............................8-3

Using Macros as SQL Applications..................................8-4

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

Creating a Macro..............................................8-4

Using a Macro.................................................8-5

Modifying a Macro.............................................8-5

Deleting a Macro..............................................8-5

Using the EXPLAIN Statement As a Tool To

Optimize Your SQL Code..........................................8-6

Introduction..................................................8-6

xx

Introduction to the Teradata RDBMS for UNIX
Table of Contents

Using EXPLAIN: First Example................................8-7

Using EXPLAIN: Second Example...............................8-8

Using the Call-Level Interface to Develop Applications..........8-9

Introduction................................................8-9

What is the CLI?............................................8-9

What is ODBC?..............................................8-10

Using TS/API to Develop Applications for the

Teradata RDBMS...............................................8-11

Introduction...............................................8-11

TS/API Products............................................8-11

Compatible Third Party Software Products...................8-11

For More Information...........................................8-12

Chapter 9

Fault Tolerance

About This Chapter....................................................9-1

Introduction......................................................9-1

Software Fault Tolerance..........................................9-1

Hardware Fault Tolerance..........................................9-1

Software Fault Tolerance..............................................9-2

Introduction......................................................9-2

vproc Migration...................................................9-2

Fallback Tables...................................................9-3

AMP Clusters......................................................9-4

Journaling........................................................9-6

Tape Archive and Restore/Recovery Utilities...........................9-7

Introduction......................................................9-7

Archiving Data....................................................9-7

Restoring Data....................................................9-7

Recovering Data...................................................9-7

Table Rebuild Facility................................................9-8

Introduction......................................................9-8

Table Rebuild Facility............................................9-8

Restrictions......................................................9-8

Hardware Fault Tolerance..............................................9-9

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

Dual BYNETs.......................................................9-9

RAID Disk Units...................................................9-9

Multiple Channel and LAN Connections..............................9-9

Isolation From Client Hardware Defects............................9-9

Battery Backup....................................................9-9

Introduction to the Teradata RDBMS for UNIX xxi
Table of Contents

Redundant Power Supplies and Fans..............................9-10

Hot Swap Capability for Node Components........................9-10

Cliques........................................................9-10

Single AWS System View.........................................9-12
Previous << 1 .. 2 3 4 5 6 7 < 8 > 9 10 11 12 13 14 .. 76 >> Next