Database Glossary – P
Useful Terms For Working With Data
See: Table, Parent.
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.
The value of a non-key field is dependent on only part of the key (usually on one field of a multi-field key).
See: Query, Persistent.
An operation that adds, subtracts or replaces values in one table using values in another.
See: Key, Primary.
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
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.