Physical Data Model

What Does Physical Data Model Mean?

A physical data model defines all of the logical database components and services that are required to build a database or can be the layout of an existing database.

Advertisements

A physical data model consists of the table’s structure, column names and values, foreign and primary keys and the relationships among the tables.

Techopedia Explains Physical Data Model

A physical data model primarily defines all the relational data models and objects of the database. It is created using the native database language of the database management system (DBMS). It can also be created by transforming the logical model. A physical data model is used by database administrators to estimate the size of the database systems and to perform capacity planning. The physical data model constraints such as size, configuration and security can vary based on the underlying database system.

Advertisements

Related Terms

Latest Data Management Terms

Related Reading

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…