CHAPTER 8
Conceptual Data Models
Need the Big Picture?
No common definitions?
Hero, build a CDM!
The highlighted row in Table 8.1 shows the focus of this chapter – the conceptual data model (CDM).
Table 8.1 The Conceptual 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 CDM shows the key concepts in a particular area and how these concepts interact with each other. This chapter defines a concept, followed by an explanation of the importance of the conceptual data model and concept definitions. Then both relational and dimensional CDMs will be discussed. Then we provide a summary of the ten-step approach to building a conceptual data model. We conclude this chapter with a description of the support provided by ER/Studio for CDMs, and a couple of exercises to reinforce what you’ve learned.