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.
Omnidex QUICKTEXT and FULLTEXT Index Types parse a column along 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.
The Omnidex SQL PARTITION statement is very useful in creating multiple partitions.
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 /Port No / Port Number
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.
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.
Progressive qualifying
performing several keyword searches in succession against the same table to narrow the qualified subset of rows. Also called a “drill-down” search.