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