Physical Data Model

 

Definition: A physical data model (a.k.a. database design) is a representation of a data design which takes into account the facilities and constraints of a given database management system. A complete physical data model will include all the database artifacts required to create relationships between tables or achieve performance goals, such as indexes, constraint definitions, linking tables, partitioned tables or clusters. The physical data model can usually be used to calculate storage estimates and may include specific storage allocation details for a given database system.

What This Means: The physical database model is the actual design for a specific software application or a data repository. Each application will have its own physical data model that should be consistent with the education agency’s logical data model (possibly NEDM) and with the agency’s metadata standards as documented and referenced in its Information Systems Architecture.

 

Need another definition?

Please select from the menu above