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