Show Contents / Index / Search

DMSII vs. Relational Database Terminology

Before you begin the data mapping process, it may be helpful to review the terminology that each environment uses to describe structures.

DMSII Term

Relational Database Term

Data set

Table

DMS item (data element, field)

Column (data item)

Record

Row (record)

Set

Index

Note: A relational database index is a set of column names that is used to efficiently access a row (of a table).

Key

Key