You use the Physical Data Model (PDM) to describe how the information represented in the Logical Data Model is actually implemented in the systems architecture view. The Physical Data Model describes the database in terms of Tables and Constraints (lines) between the Tables. The Tables are populated with Columns, and their Type and Length.
You can build a Physical Data Model with a specific Database Management System (DBMS) in mind. When you model in the Physical Data Model, you model with a property set specific to the DBMS that you have chosen.
You can map a Logical Data Model to and from a Physical Data Model.
You can specify the target databases that you want to model with in the Physical Data Model.
Relationships to DoDAF 2 Metamodel (DM2)
▪Tables can be associated with any DM2 element via the Association property on the DoDAF 2 tab. Tables can be associated with a list of rules via the Rules property on the DoDAF 2 tab.
▪Columns can be associated with any DM2 element via the Association property on the DoDAF 2 tab.
