Embedded Data Sets
An embedded data set is a DMSII representation of a hierarchical relationship or tree structure. When a DMSII data set contains another data set as an item, that data set is called an embedded data set. The data set in which it is declared is called the parent of the embedded structure. You can think of the embedded data set as the "child" of the "parent" data set.
To represent this parent-child relationship in a relational database, the DATABridge Client uses a foreign key that points to the parent data set. This foreign key is represented by the value in the parent_aa column in the table that corresponds to the embedded data set. The parent_aa column holds the parent record’s key.
DMSII DASDL Showing an Embedded Data Set
The following is an excerpt from a DMSII DASDL that shows how an embedded data set is defined.
GENEALOGY DATA SET
The following examples are for Microsoft SQL Server.
Ignoring any set definition, the resulting relational database tables are as follows: