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 .. 16 17 18 19 20 21 < 22 > 23 24 25 26 27 28 .. 76 >> Next

QryConfig Displays the current database software logical configuration.
QrySessn Displays session status information.
RcvManager Displays recovery status.
Rebuild Reconstructs tables from fallback copies (only works when fallback is used).
Reconfig Redistributes disk data automatically whenever AMP vprocs are added or removed.
Showlocks Displays host utility (HUT) locks on databases and tables.
SysInit Initializes the Teradata system tables and all user tables.
xmppconfig Sets up and updates configurations. Use this utility to specify the physical configuration before running pdeconfig. Must be run prior to pdeconfig for MPP systems.
DIP Executes one or more of the standard DIP (Database Initialization Program) SQL scripts packaged with the RDBMS

2-38

Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture

Database Utility Software

Utility Name Function
XPT Installs multiple copies of the same software across all nodes of an MPP system.
xperfstate Provides real time display of PDE system performance, including system-wide CPU utilization and disk utilization.

Introduction to the Teradata RDBMS for UNIX

2-39
Teradata RDBMS Architecture

Teradata Manager

Teradata Manager

Teradata Manager is a PC-based package that provides easy access Introduction 2 to resource usage information in the Teradata Data Dictionary. The

PC supporting Teradata Manager must be running the Windows NT operating system.

The Teradata Manager Performance Monitor uses two commands to Performance Analysis 2 monitor the performance of the Teradata RDBMS.

The commands are:

• MONITOR CONFIG

• MONITOR SUMMARY

You can specify date sampling rates and durations and the Teradata Manager collects and analyzes the data for you. Results of data analyses can be displayed in a text window.

The Locking Logger feature permits you to determine whether an application mix is causing delays because of database lock contention.

Teradata Manager provides facilities for:

Session Information 2

• Setting session rates

• Monitoring sessions

• Identifying sessions

• Aborting sessions

Teradata Manager provides facilities for:

Statistical Information 2

• Detecting which tables have statistics

• Create statistics for columns and indexes

• Drop statistics by table or column/index

• Refresh statistics for:

• Entire Teradata RDBMS

• Database

• Table

• Column/Index

2-40

Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture

For More Information

For More Information

For more information on the topics presented in this chapter, see the following Teradata RDBMS manuals.

IF you want to learn more about . . . THEN see this manual . . .
System process flows Teradata RDBMS for UNIX Database Design and Administration
Teradata SQL Teradata RDBMS for UNIX SQL Reference
General Teradata software architecture Teradata RDBMS for UNIX Database Design and Administration
The TDP Teradata TDP Reference
Preprocessor2 Teradata Application Programming Using Embedded SQL
Embedded SQL Teradata RDBMS for UNIX SQL Reference Teradata Application Programming Using Embedded SQL for C, COBOL, and PL/I
Teradata Manager Teradata Manager Reference Guide
ODBC Teradata ODBC Driver for Windows Installation and User’s Guide

Introduction to the Teradata RDBMS for UNIX

2-41
Teradata RDBMS Architecture

For More Information

2-42

Introduction to the Teradata RDBMS for UNIX
The Relational Model

Chapter 3

The Relational Model

Introduction to the Teradata RDBMS for UNIX
The Relational Model

Introduction to the Teradata RDBMS for UNIX
The Relational Model

About This Chapter

Introduction

What is a Relational Database?

About This Chapter

This chapter reviews the relational model for database management. The chapter also describes issues like normalization, referential integrity, and macros.

The relational model for database management is based on concepts derived from the mathematical theory of sets. This chapter touches on the relational model from that viewpoint to establish its solid foundation in mathematics. By way of comparison, database management products based on the hierarchical, network, and object-oriented architectures are not based on rigorous theoretical foundations and so their behavior is not as predictable as are relational products.

Database management systems based on the hierarchical, network, and object-oriented models use different languages to define and manipulate the database, and none provides the capability for making ad hoc queries.

The chapter describes the process of further normalization of a database, then describes macros in the Teradata environment.

A relational database is a database that is perceived by its users as a collection of tables and nothing but tables. This deceptively simple concept permits information to be created and maintained without any kind of anomalies as well as providing users with a simple presentation of data which can, in turn, be manipulated with ease.
Previous << 1 .. 16 17 18 19 20 21 < 22 > 23 24 25 26 27 28 .. 76 >> Next