DMSII and Relational Database Terms

The following table shows the equivalent terms for DMSII structures and relational database structures:

DMSII

Relational

Data set

Table

DMS item (data element, field)

Column (data item)

Record

Row (records)

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