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

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 2 3 4 5 6 < 7 > 8 9 10 11 12 13 .. 218 >> Next


Changing Data Representation................................................................................2-62

Converting to Relational Data Structures...............................................................2-62

Identifying Design Similarities.................................................................................2-63

Modifying Applications............................................................................................2-63

Conversion Steps........................................................................................................2-64

Populating Tables..........................................................................................................2-65

Loading Tables with Triggers...................................................................................2-65

Loading Tables with PPIs..........................................................................................2-65

Using an Identity Column.........................................................................................2-66

Controlling Identity Numbering Parameters.........................................................2-66

Identity Column Numbering Considerations........................................................2-67

Excluding Duplicates.................................................................................................2-68

Bulk Loading Identity Column Tables....................................................................2-69

Managing Identity Column Tables..........................................................................2-69

Triggers...........................................................................................................................2-71

Firing Triggers............................................................................................................2-71

Trigger Functionality.................................................................................................2-71

Restrictions on Using Triggers.................................................................................2-72

Macros............................................................................................................................. 2-73

Views...............................................................................................................................2-74

Benefits of Using Views.............................................................................................2-74

Stored Procedures.........................................................................................................2-75

Functionality...............................................................................................................2-75

Features........................................................................................................................2-75

Supporting Client Utilities........................................................................................2-76

Administrative Considerations................................................................................2-77

Permanent Journals.......................................................................................................2-78

Journaling Protection.................................................................................................2-78

Journal Location..........................................................................................................2-78

Rollback with Before-Image Journals......................................................................2-79

Rollforward with After-Image Journals..................................................................2-79

Using Journals with PPIs...........................................................................................2-79

Journal Subtables........................................................................................................2-80

xxviii Teradata RDBMS Database Administration Contents

Permanent Journal Archive or Recovery................................................................2-81

Recovery with Permanent Journals.........................................................................2-81

Location of Change Images.......................................................................................2-82

Creating or Deleting a Permanent Journal..............................................................2-82

Assigning a Permanent Journal................................................................................2-83

Chapter 3:

Space Considerations

Defining Permanent Space Limits.................................................................................3-2

Permanent Space Allocation.......................................................................................3-2

Permanent Space Availability.....................................................................................3-3
Previous << 1 .. 2 3 4 5 6 < 7 > 8 9 10 11 12 13 .. 218 >> Next