the column within a parent table that uniquely identifies rows or records containing the same values.
Also known as Primary Key.
See also: key
Parent table
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.
Parsing
separating a character string into individual keywords.
Partial-key retrieval
refers to an ASK Index or MDK Index retrieval where a partially specified search argument is used to retrieve one or more records.
Partitioned Databases
An Omnidex Databases that has been partitioned into multiple smaller subsets to facilitate retrieval performance.
Partitioned Tables
An Omnidex Table that has been partitioned into multiple smaller tables to facilitate retrieval performance.
Partitioning
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.
Path
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.
Pattern matching
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
in a computer network, an identifying number that supports transport between a server and one of several clients.
Powersearch
Omnidex's PowerSearch feature allows misspellings, synonyms, word variations, phonetics and transpositions during searches.
Prejoined Indexes
Prejoined Tables
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.
Progressively qualifying
performing several keyword searches in succession against the same table to narrow the qualified subset of rows. Also called a “drill-down” search.