Glossary - O

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

object

• an entity within the Environment that can be accessed and manipulated, a column definition, for example.

ODBC

• Open Database Connectivity; (1) a standard for accessing different databases from PCs or other small workstations, providing a common SQL-based method for translating requests into the database tool's native SQL (2) software developed by Microsoft that enables Windows applications to connect to various databases.

ODBC Administrator

• software written by both Microsoft and the ODBC Driver software company to create and maintain Data Sources.

ODBC Driver

• software written by DISC specifically for Omnidex-enhanced databases;
• the Omnidex module that sends ODBC calls to the Omnidex retrieval engine that accesses the database, attached to a container application by Driver Manager.

ODBC-aware applications

• an application that uses Microsoft's ODBC technology to access databases.

ODS

• Operational Data Store; an integrated collection of data that is subject- oriented and volatile, designed specifically for daily operations analysis.

OLAP

• On-line Analytical Processing; a method of data analysis used in data warehouses involving viewing data through multiple dimensions, aggregations, relationships, patterns, trends, and exceptions.

OLE

• Object Linking and Embedding; Microsoft Corporation's API for data access that manipulates data as objects and which supports Microsoft Corporation's Distributed Component Object Model (COM).

OLTP

• On-line Transactional Processing; routine recording and analysis of daily business activity, e.g., order processing, accounting, manufacturing, etc.; also known as operational processing.

Omnidex

• an advanced indexing product from Dynamic Information Systems Corporation (DISC), providing greater query flexibility than native database methods and accelerating database search and retrieval by reducing I/O.

Omnidex Access

• the Omnidex open systems API that performs the index look-ups, qualifying counts, and data retrievals, including the routines oaqualify, oaselect, and oafetch. Also known as OmniAccess.

Omnidex condition word

• word 11 of the status array, which contains an error code if a call to an Omnidex intrinsic failed.

Omnidex detail

• a detail set linked to an Omnidex master by an Omnidex SI (search item).

Omnidex domain

• see Domain.

Omnidex error indicator

• the word of the status array that indicates whether an error has occurred. This word differs between default (active) error handling and passive error handling.

Omnidex ID

• a binary integer (I2, J2, or K2) value that is used to identify records during keyword searches (for Multiple keys);
• the arbitrary sequential ID of a record assigned by Omnidex.
• Also known as ODXID or ODX ID

Omnidex indexes

• the indexed columns or composite indexes designated for Omnidex keyword or sorted indexing through the DBINSTAL installation utility program.

Omnidex Intrinsic Interface

• Omnidex intrinsics that provide retrieval access to Multiple and Sorted key indexes and maintenance to Omnidex indexes.

Omnidex master

• a master data set that contains one or more fields specified for Omnidex keyword retrieval, or a master that is linked by the Omnidex SI to a detail that contains one or more Multiple keys.

Omnidex root file

• the index file that contains information about the database structure, including which fields are specified for Omnidex retrieval.

Omnidex Search Item

• the search item field in an Omnidex master which may also be the Omnidex ID for the set (that is, the SI-ID). See Search Item.

one-to-many relationship

• refers to data entities where one entity corresponds to many other entities, as in the case of a search item value to many detail records.

one-to-one relationship

• refers to data entities where one entity corresponds to only one other entity, as in the case of a search item value to a master record.

operator

• any special character or token used in Omnidex retrievals, for example, the Multifind operator (&).

OR criteria

• Multiple criteria values or predicates that records must match one or more of, but not all.

outer join

• A join that includes all rows from joined tables that meet the specified search criteria. Rows without matching records in the joined table are matched with null values.

OSF

• Open Software Foundation;
• a foundation created by nine computer vendors;
• the computer operating system developed by the OSF.

Top