Back to glossary

Physical Data Model

A representation of a data design as implemented, or intended to be implemented, in a database management system.

Categoryai

Overview

A Physical Data Model (PDM) represents how the model will be built in the database. A PDM shows all table structures, including column names, column data types, column constraints, primary key, foreign key, and relationships between tables.

Implementation Details

  • Table names
  • Column names and data types
  • Indexes
  • Partitioning strategies
  • Storage parameters

Related Terms

Data ModelingConceptual Data ModelLogical Data Model