Ingres 2006 - Database Administrator Guide

Peter Kitson

ISBN : -

Order a printed copy of this book from Amazon --UNAVAILABLE--


Cover Design - Ingres 2006 - Database Administrator Guide
  

For your free electronic copy of this book please verify the numbers below. 

(We need to do this to make sure you're a person and not a malicious script)

Numbers

 



Sample Chapter From Ingres 2006 - Database Administrator Guide
     Copyright © Ingres Corporation



Chapter 1: Introducing Database Administration


This guide provides Ingres® database administrators with information about creating, maintaining, backing up, and recovering databases, as well as instructions for defining various types of users, authorizing user access, and working with different types of database objects.
Audience

This guide is primarily intended for database administrators. In some cases, however, the responsibilities of the database administrator and the system administrator overlap. Therefore, some of the tasks and responsibilities described in this guide require permissions typically given to the system administrator, but not necessarily given to database administrators. In these cases, you must work with your system administrator to carry out these responsibilities.

What You Need to Know

This guide assumes that you are familiar with the windowing system on the target platform of the installation, including terminology, navigational techniques, and working with standard items, such as menus and dialogs.

Database Administrators

In Ingres, anyone who creates a database becomes the database administrator (DBA) for that database. Furthermore, there is no limit on the number of DBAs that can exist at a site.
Note: Before you can create a database, you must have the createdb privilege.
The DBA has permission to do the following:

  • Create and destroy databases
  • Manage public database objects
  • Manage user access to data through grants on tables, views, procedures, and other objects
  • Maintain database and query performance
  • Monitor locking to maximize concurrency
  • Back up and recover the database
  • Authorize databases to use alternate locations

Query Language Used in this Guide

The industry standard query language, SQL, is used as the standard query language throughout this guide. Ingres is compliant with ISO Entry SQL-92. For details about the settings required to operate in compliance with ISO Entry SQL-92, see the SQL Reference Guide.