  Step
5 - Index Installation
DBINSTAL is the Omnidex utility that installs the Omnidex indexes on
an Environment. This section describes DBINSTAL in detail as well as two
additional Omnidex utilities, VIEWGEN and SNOWGEN, that can assist with
the index installation.
Once the Omnidex Index Installation has been designed and the Omnidex
Environment Catalog has been created, the Omnidex indexes must be installed
and built.
For maximum retrieval performance, two special utilities, Viewgen and
Snowgen, are provided for data warehouse retrieval systems using DISC's
flat file structures. These optional utilities are generally initially
setup by the DISC Consulting Services personnel.
After running these utilities, run DBINSTAL.
For all other database installations, begin with DBINSTAL.
VIEWGEN
VIEWGEN creates specialized
composite view of a star schema for very high-speed access
SNOWGEN
SNOWGEN creates snowflake
tables for a star schema.
DBINSTAL
The DBINSTAL utility
is used to install and build the Omnidex indexes. It is designed to operate
either interactively or with a command script file.
During the initial index installation, DBINSTAL should be run interactively.
After one or more prototype index specifications are made using DBINSTAL
in interactive mode, the input sequence of instructions is then generally
stored in a command script file generated with OAHELPER. This script file
can then be modified using any text editor, and re-used whenever it is
necessary to re-index and re-install the indexes.
The install script will initially be combined with the build script but
can be moved to a separate file if desired. The install and build scripts
are generally suffixed with 'in' and 'bld' respectively.
Top
|
