Basic Terms for Getting Started [ HP IMAGE/SQL Administration Guide ] MPE/iX 5.0 Documentation
HP 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.
MPE/iX 5.0 Documentation