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 .. 218 >> Next


Contacting technical support

Enrolling in customer education courses

Ordering and downloading product documentation

Accessing case studies of customer experiences with Teradata

Accessing third party industry analyses of Teradata data warehousing products

Accessing white papers

Viewing or subscribing to various online periodicals

xii Teradata RDBMS Database Administration

Preface

Technical Information on the Web

xii

Teradata RDBMS Database Administration Contents

Preface

Supported Software Release ............................................................................................ i

Changes to This Book ....................................................................................................... i

About This Book.................................................................................................................iv

List of Acronyms ...............................................................................................................vii

Technical Information on the Web................................................................................... xi

Chapter 1: Database Hierarchy

Database Hierarchy Overview......................................................................................1-2

The Initial Teradata Database........................................................................................1-3

DBC Contents................................................................................................................ 1-3

SysAdmin Contents.....................................................................................................1-4

SystemFE Contents.......................................................................................................1-4

Other Databases/Users...............................................................................................1-5

Administrative User........................................................................................................1-7

Databases versus Users..................................................................................................1-9

Owners, Parents, and Children...................................................................................1-13

Creator versus Owner...................................................................................................1-14

Ownership versus Creator Privileges......................................................................1-15

Explicit, Automatic, and Implicit Privileges...........................................................1-15

Changing the Hierarchy with GIVE ..........................................................................1-17

Transfer of Ownership...............................................................................................1-17

Removing a Hierarchy Level....................................................................................1-17

DELETE/DROP Statements........................................................................................1-19

Chapter 2:

Building the Teradata RDBMS

Databases and Users.......................................................................................................2-2

Creating a Database or User.......................................................................................2-2

Dropping an Empty Database or User......................................................................2-3

Tables ................................................................................................................................ 2-4

Creating Tables.............................................................................................................2-4

Copying Tables.............................................................................................................2-6

Teradata RDBMS Database Administration 1 - 1 Contents

Dropping Tables...........................................................................................................2-6

Changing a Table Definition.......................................................................................2-7

Recreating a Table........................................................................................................2-9

Planning Tables...........................................................................................................2-10

COMPRESS: State of Presence Bits per Column....................................................2-15

Global Temporary and Volatile Tables......................................................................2-17

Global Temporary Tables..........................................................................................2-17

Materializing Global Temporary Tables.................................................................2-18

Volatile Tables.............................................................................................................2-18
Previous << 1 .. 2 3 4 < 5 > 6 7 8 9 10 11 .. 218 >> Next