Partitioned Databases

Partitioned Tables

Powersearch

Prejoined Indexes

Prejoned Tables

parent key

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

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 MPE, a path is filename.group.account. In VAX/VMS, a path is node::device:[directory.subdirectory.subdirectory…]filename. In UNIX, a path is 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.

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.