O'Reilly logo

Data Modeling Made Simple: A Practical Guide for Business and IT Professionals 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 What are physical data models?

Let’s get PhysicalCompromise the LogicalEfficiency rules

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

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

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

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 of software and ...

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