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 ...

Get Data Modeling Made Simple: A Practical Guide for Business and IT Professionals now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.