Database Glossary – P
Useful Terms For Working With Data

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

P

Parent Table

See: Table, Parent.

Parse; Parsing

Intelligently separating a field value or string into its component parts (e.g. parsing a Full Name into its five characteristic components: Prefix, First Name, Middle Name[or Initial], Last Name and Suffix). The opposite action is called concatenation.

Partial Dependency

The value of a non-key field is dependent on only part of the key (usually on one field of a multi-field key).

Persistent Query

See: Query, Persistent.

Post; Posting

An operation that adds, subtracts or replaces values in one table using values in another.

Primary Key

See: Key, Primary.

Procedural Language

See: Language, Procedural.

Project [DB Asst]

In DB Assistant’s context, a project is central operational denominator, that encapsulates, and saves for reuse, a user defined assortment of tables, tasks, results
and reports.

Purge; Purging

Also called deduping by the mailing industry, purging, removes duplicate records from within a single file, table (or mailing list), or those shared among several files,
tables or lists.

See also: Matchcode.