This is an old revision of the document!


Glossary: O

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 DataSources.

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.

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.

Quick Links

 
Back to top
glossary/o.1248324302.txt.gz · Last modified: 2012/10/26 14:41 (external edit)