Glossary

• the column within a parent table that uniquely identifies rows or records containing the same values.
• Also known as Primary Key.
• See also: key

• a table where any row is uniquely identifiable by the contents of a single field (a key); Parent tables are often superior to child tables, typically in a one-to-many relationship.

• separating a character string into individual keywords.
• Omnidex QUICKTEXT and FULLTEXT Index Types parse a column along individual keywords.

• refers to an ASK Index or MDK Index retrieval where a partially specified search argument is used to retrieve one or more records.

• An Omnidex Databases that has been partitioned into multiple smaller subsets to facilitate retrieval performance.

• An Omnidex Table that has been partitioned into multiple smaller tables to facilitate retrieval performance.

• The Omnidex SQL PARTITION statement is very useful in creating multiple partitions.

• the dividing or grouping of data in a database across storage media such as a disk drive, or across nodes in a distributed computer or network environment in order to speed processes by concurrently processing I/O.

• Information included with a file name that tells the location of the file. How you specify a path is dependent on the operating system.
• In Windows, a path is a directory\subdirectory\subdirectory\…filename.
• In UNIX, a path is directory/subdirectory/subdirectory/…filename.
• In MPE, a path is filename.group.account.
• In VAX/VMS, a path is node::device:[directory.subdirectory.subdirectory…]filename.

• specifying wildcard notation, for example, asterisks (*), pound signs (#), percent symbols(%), and so on, in a value which represents single or multiple characters in that value.

• Port is a TCP/IP Sockets Port number and is typically needed to connect from a client machine to a server running the Omnidex Network Services process called OdxNet. The default port number used by OdxNet is 7555 if no port number is specified.

Port Numbers are used in the OdxSQL CONNECT command.

• Omnidex's PowerSearch feature allows misspellings, synonyms, word variations, phonetics and transpositions during searches.

• tables that were linked together during OMNIDEX installation using KEY values declared in the OMNIDEX environment catalog. Prejoining tables optimizes OMNIDEX join operations between them.

• performing several keyword searches in succession against the same table to narrow the qualified subset of rows. Also called a “drill-down” search.