Physical Data Model

Physical Data Model is the actual model which will be created in the database to store the data. It is the most detailed data model in Data Warehouse data modeling. It includes

1. Tables names
2. All column names of the table along with data type and size
3. Primary keys, Foreign Keys of a table
4. Constraints

e.g.

Physical Data Model of Call Center Data warehouse.

Physical Data Model can be converted to actual SQL DDL statement by using different tools. ERWIN is the famous tool to do this.

Did you enjoy this article? Please subscribe to Email or RSS to receive all the FREE updates!

Related posts:

1. Semantic Data Model
2. Logical Data Model
3. Conceptual Data Model

Tagged as: Data Warehousing Concepts, Physical Data Model