Glossary

An Environment, also know as an Omnidex Environment is the combination of:

• An Omnidex Environment File containing metadata
• Connection to one or more databases or raw data files
• One or more sets of Omnidex index files.

• A file that contains compiled environment information about how Omnidex source data is organized, what users can access it, and how they can access it.
• Environment Catalogs are created using the OACOMP utility from and Environment Source file.
• Environment Catalogs are using stored in files with a .env file suffix.
• Environment Catalogs are still supported but as of version 5.1, CREATE statements from OdxSQL is the typical approach to creating and maintaining Omnidex metadata information which is stored in the Omnidex Environment File.

• A physical operating system file that contains Omnidex metadata information.
• Environment Files are created using the CREATE ENVIRONMENT DDL statement.
• Environment Files use an xml layoug and are typically stored with an .xml file suffix.
• As of Omnidex Version 5.1, Environment Files are preferred over compiled Environment Catalogs.

• An ASCII file containing words to exclude from indexing. Also called an excluded words file.

• Words specified through OmniUtil for exclusion from the Omnidex indexes.

• XL; the location of the Omnidex intrinsics and call conversion procedures in native mode versions of Omnidex;

the HPPA native mode library of callable routines.

• Specific data selected and retrieved from an existing database, usually from an OLTP system for use in data warehousing. See OLTP and data warehouse.

SQL function that “extracts” specific parts of a date. ODXSQL function that creates SQL insert, update, and delete statements for a table to allow a user to restore a table to its original state.

• Detailed description of the Omnidex SQL data access plan to facilitate optimization operations to improve retrieval speed.

• Columns that are derived from a SQL Expression that can be indexed by Omnidex. The column does not physically exist in the table but is still available for indexing.

  These columns are specified in the CREATE TABLE statement.

  CREATE TABLE mytable
   ...
   (col1
     city_initial character(1) as "substring(city from 1 for 1)" omnidex, 
   ...