Definitions for "Physical data model"
Physical data models are used to describe how the data is stored at the lowest level.
The physical data model shows in diagram form, the actual representation of the physical tables and views in a database and the relationships between them. Instead of using the more English-like business names for the tables, shorter abbreviated physical table names are used (i.e., “T_PERS_HIST” instead of “Person History”). Because it shows the actual table names, the physical model is a key reference when writing queries directly against the database. ()
A formal representation of data and their relationships in the form of a diagram, depicting the physical placement of data in a database. A physical data model is process dependent, which means that it is denormalized to provide maximum performance efficiency. It is commonly referred to as logical database design or database design schema.
What is actually implemented on a hardware platform. It is derived from the LDM to include changes that accommodate specific platform performance issues such as storage size and access performance.