O'Reilly logo

Data Modeling Made Simple with ER/Studio Data Architect by Steve Hoberman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 10

Physical Data Models

Lets get Physical

Consider technology

Time to make it real

The highlighted row in Table 10.1 shows the focus of this chapter, which is the physical data model (PDM).

Table 10.1 The Physical Data Model is the focus of this chapter

 

Relational

Dimensional

Conceptual Data Model (CDM)

One-pager on business rules

One-pager on navigation

Logical Data Model (LDM)

Detailed business solution on business rules

Detailed business solution on navigation

Physical Data Model (PDM)

Detailed technical solution on business rules

Detailed technical solution on navigation

A PDM takes the business solution defined on a logical data model to the next level of a technical solution. That is, once you solve the problem independent ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required