Red Hat Database
Graphical Tools Guide
Copyright
© 2002 by Red Hat, Inc.
ISBN: N/A
Table of Contents
1.
Introduction to the Red Hat Database Graphical Tools
2.
Installing RHDB Administrator and Visual Explain
Requirements
Installing the Graphical Tools on a Client Machine
After the Installation
Installing the Source Code
3.
RHDB Administrator
Starting RHDB Administrator
Using RHDB Administrator
Navigating RHDB Administrator
Tutorial
Adding a Cluster
Creating a Database
Creating a Table
Creating Users and Groups
Creating Groups
Dropping Database Objects
Troubleshooting RHDB Administrator
Startup Problems
Case-Sensitivity Problems
4.
RHDB Administrator Reference
Aggregates
Analyze
ANALYZE DATABASE
ANALYZE TABLE
Clusters
Adding a New Cluster
Editing an Existing Cluster
Removing a Cluster
Columns
Constraints
Primary Key Constraints
Unique Constraints
Check Constraints
Foreign Key (FK) Constraints
Databases
Data Types
Functions
Creating a Function Written in SQL
Creating a Function Written in C
Groups
Indexes
Languages
Creating a New Language
Operators
Creating an Operator
Privileges
Rules
Sequences
Tables
Creating Tables Using CREATE TABLE
Defining Columns
Table Constraints
Options
Privileges
Creating Tables Using CREATE TABLE AS
Triggers
Users
Vacuum
VACUUM DATABASE
VACUUM TABLE
Views
5.
Visual Explain
Starting Visual Explain
Configuring Visual Explain
Configuring Visual Explain's Operation
Configuring a Connection to a Database
Deleting a Connection to a Database
Using Visual Explain
Running and Storing SQL Commands
An Example: Analyzing the regression Database
Understanding the Visual Explain Output
Manipulating the Visual Explain Display
Troubleshooting Visual Explain
Index
Next
Introduction to the Red Hat Database Graphical Tools