HP 3000 Manuals

Basic Terms for Getting Started [ IMAGE/SQL Administration Guide ] MPE/iX 5.0 Documentation


IMAGE/SQL Administration Guide

Basic Terms for Getting Started 

The following definitions will get you started.  A complete alphabetical
listing of all terms and their definitions can be found in the glossary
at the end of this guide. 

   *   DBEnvironment - a collection of related files containing one or
       more ALLBASE/SQL databases that share the same logging and
       recovery process.

   *   Table - the basic unit of storage in an ALLBASE/SQL database.
       Tables are made up of rows and columns of data.

   *   Attached Database - a TurboIMAGE/XL database whose data can be
       accessed with ALLBASE/SQL. Information about the attached
       TurboIMAGE/XL database is stored in the DBEnvironment.

   *   Detached Database - a TurboIMAGE/XL database whose data cannot be
       accessed with ALLBASE/SQL. No information about the TurboIMAGE/XL
       database is stored in the DBEnvironment.  A TurboIMAGE/XL database
       must be detached from a DBEnvironment before it is restructured.

   *   Mapping - the process IMAGE/SQL uses to allow a TurboIMAGE/XL
       database to emulate a DBEnvironment database.  Mapping takes place
       for TurboIMAGE/XL names, data sets, data items, data item types,
       and data security.

   *   Mapped Table - a table defined in the DBEnvironment based on a
       TurboIMAGE/XL data set.  Data set characteristics are mapped by
       the IMAGE/SQL utility to ALLBASE/SQL characteristics.

   *   DBC (Database Creator) - the creator of the TurboIMAGE/XL
       database.  You must be either the database creator or give the
       TurboIMAGE/XL database maintenance word to attach the database to
       a DBEnvironment.  Commands that add users, or view or modify user
       information can only be executed by the DBC.

   *   DBECreator - the individual who originally configured the
       DBEnvironment.

   *   DBA (Database Administrator) - a database administrator of the
       DBEnvironment.  You must be a DBA of the DBEnvironment to which
       the TurboIMAGE/XL database is attached to issue most IMAGE/SQL
       utility commands.  The creator of the DBEnvironment is
       automatically a DBA. Other ALLBASE/SQL users can be granted DBA
       authority by a DBA. 

   *   DBECon file - DBEnvironment Configuration File, or DBECon file,
       contains basic information that is used every time the
       DBEnvironment is opened.  When you create a DBEnvironment,
       IMAGE/SQL creates the DBECon file with the same name as the
       DBEnvironment itself.  The DBECon file points to the other
       DBEnvironment components.



MPE/iX 5.0 Documentation