Database Glossary – M
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

M

Major Entity

See: Entity, Major.

Many-to-Many Relationship

See: Relationship, Many-to-Many.

Master Table

See: Table, Master.

Matchcode

Primarily used for identifying duplicate records either contained in the same table, or shared between several tables or lists. A specialized composite key , a matchcode is typically a collection of name and address components that best represent the unique identity of each whole record and the entity it represents. A matchcode might consist of combined First Name, Last Name, Company, Address and ZIP Code field elements, concatenated into matchcode “keys,” which can be compared during the deduping or purging process.

Merging

See: Consolidation.

Metabase [DB Asst]

The metabase is an internal DB Assistant component (although technically an external database) that stores metadata, tasks, and system configuration variables, required by DB Assistant, as well as all imported and created tables.

Metadata

Data about data and the data’s structure within a database. Technical metadata reflects the description of the structure, content, keys, and indexes of data and their source of origin, while business metadata reflects definitions about measures (facts) using calculations.

Migration, Field [DB Asst]

See: Field Migration.