- Cover
- Preliminaries
- Preface
- Chapter 1 Introduction
- Table 1.1
- Part I Mathematical Templates
- Chapter 2 Tree Template
- Figure 2.1
- Figure 2.1
- Figure 2.2
- Figure 2.3
- Figure 2.4
- Figure 2.5
- Figure 2.6
- Figure 2.7
- Figure 2.8
- Figure 2.9
- Figure 2.10
- Figure 2.11
- Figure 2.12
- Figure 2.13
- Figure 2.14
- Figure 2.15
- Figure 2.16
- Figure 2.17
- Figure 2.18
- Figure 2.19
- Figure 2.20
- Figure 2.21
- Figure 2.22
- Figure 2.23
- Figure 2.24
- Figure 2.25
- Figure 2.26
- Figure 2.27
- Figure 2.28
- Figure 2.29
- Figure 2.30
- Figure 2.31
- Figure 2.32
- Figure 2.33
- Figure 2.34
- Figure 2.35
- Figure 2.36
- Figure 2.37
- Figure 2.38
- Figure 2.39
- Figure 2.40
- Figure 2.41
- Figure 2.42
- Figure 2.43
- Figure 2.44
- Figure 2.45
- Figure 2.46
- Table 2.1
- Chapter 3 Directed Graph Template
- Figure 3.1
- Figure 3.1
- Figure 3.2
- Figure 3.3
- Figure 3.4
- Figure 3.5
- Figure 3.6
- Figure 3.7
- Figure 3.8
- Figure 3.9
- Figure 3.10
- Figure 3.11
- Figure 3.12
- Figure 3.13
- Figure 3.14
- Figure 3.15
- Figure 3.16
- Figure 3.17
- Figure 3.18
- Figure 3.19
- Figure 3.20
- Figure 3.21
- Figure 3.22
- Figure 3.23
- Figure 3.24
- Figure 3.25
- Figure 3.26
- Figure 3.27
- Figure 3.28
- Figure 3.29
- Figure 3.30
- Figure 3.31
- Figure 3.32
- Figure 3.33
- Figure 3.34
- Figure 3.35
- Figure 3.36
- Figure 3.37
- Figure 3.38
- Figure 3.39
- Figure 3.40
- Figure 3.41
- Figure 3.42
- Figure 3.43
- Figure 3.44
- Figure 3.45
- Figure 3.46
- Figure 3.47
- Figure 3.48
- Table 3.1
- Chapter 4 Undirected Graph Template
- Figure 4.1
- Table 4.1
- Chapter 5 Item Description Template
- Figure 5.1
- Table 5.1
- Chapter 6 Star Schema Template
- Figure 6.1
- Table 6.1
- Chapter 7 Summary of Templates
- Table 7.1
- Part II Antipatterns
- Chapter 8 Universal Antipatterns
- 8.1 Symmetric Relationship Antipattern
- 8.2 Dead Elements Antipattern
- 8.3 Disguised Fields Antipattern
- 8.4 Artificial Hardcoded Levels Antipattern
- 8.5 Excessive Generalization Antipattern
- 8.6 Disconnected Entity Types Antipattern
- 8.7 Modeling Errors Antipattern
- 8.8 Multiple Inheritance Antipattern
- 8.9 Paradigm Degradation Antipattern
- 8.10 Chapter Summary
- Bibliographic Notes
- References
- Figure 8.1
- Table 8.1
- Chapter 9 Non-Data-Warehouse Antipatterns
- Figure 9.1
- Table 9.1
- Chapter 8 Universal Antipatterns
- Part III Archetypes
- Chapter 10 Archetypes
- 10.1 Account
- 10.2 Actor
- 10.3 Address
- 10.4 Asset
- 10.5 Contract
- 10.6 Course
- 10.7 Customer
- 10.8 Document
- 10.9 Event
- 10.10 Flight
- 10.11 Item
- 10.12 Location
- 10.13 Opportunity
- 10.14 Part
- 10.15 Payment
- 10.16 Position
- 10.17 Product
- 10.18 Role
- 10.19 Transaction
- 10.20 Vendor
- 10.21 Chapter Summary
- Bibliographic Notes
- References
- Figure 10.1
- Figure 10.1
- Figure 10.2
- Figure 10.3
- Figure 10.4
- Figure 10.5
- Figure 10.6
- Figure 10.7
- Figure 10.8
- Figure 10.9
- Figure 10.10
- Figure 10.11
- Figure 10.12
- Figure 10.13
- Figure 10.14
- Figure 10.15
- Figure 10.16
- Figure 10.17
- Figure 10.18
- Figure 10.19
- Figure 10.20
- Figure 10.21
- Figure 10.22
- Figure 10.23
- Figure 10.24
- Figure 10.25
- Figure 10.26
- Figure 10.27
- Figure 10.28
- Figure 10.29
- Figure 10.30
- Figure 10.31
- Figure 10.32
- Figure 10.33
- Figure 10.34
- Figure 10.35
- Figure 10.36
- Figure 10.37
- Figure 10.38
- Figure 10.39
- Figure 10.40
- Table 10.1
- Chapter 10 Archetypes
- Part IV Identity
- Part V Canonical Models
- Chapter 12 Language Translation
- Figure 12.1
- Table 12.1
- Chapter 13 Softcoded Values
- Figure 13.1
- Figure 13.1
- Figure 13.2
- Figure 13.3
- Figure 13.4
- Figure 13.5
- Figure 13.6
- Figure 13.7
- Figure 13.8
- Figure 13.9
- Figure 13.10
- Figure 13.11
- Figure 13.12
- Figure 13.13
- Figure 13.14
- Figure 13.15
- Figure 13.16
- Figure 13.17
- Figure 13.18
- Figure 13.19
- Figure 13.20
- Figure 13.21
- Figure 13.22
- Figure 13.23
- Figure 13.24
- Table 13.1
- Chapter 14 Generic Diagrams
- Figure 14.1
- Chapter 15 State Diagrams
- Figure 15.1
- Part VI Relational Database Design
- Chapter 16 Relational Database Design
- 16.1 Mapping: Entity Types
- 16.2 Mapping: Non-Qualified Relationships
- 16.3 Mapping Qualified Relationships
- 16.4 Mapping: Generalizations
- 16.5 Design Identity
- 16.6 Referential Integrity
- 16.7 Miscellaneous Database Constraints
- 16.8 Indexes
- 16.9 Generating SQL Code
- 16.10 Chapter Summary
- Bibliographic Notes
- References
- Figure 16.1
- Table 16.1
- Appendix A Explanation of the UML Notation
- Figure A1.1
- Appendix B Explanation of the IDEF1X Notation
- Figure B1.1
- Appendix C Glossary
- Chapter 16 Relational Database Design
Part IV
Identity
Identity is the property that distinguishes an entity from all others. Identity is a prominent concern in databases because developers must be able to find and reference data. This chapter focuses on conceptual aspects of identity and minimizes the discussion of implementation.
Identity is relevant to patterns, because identity deeply pervades models and thinking about models. There are three purposes of data models: to define data structure, to constrain data, and to provide a blueprint for accessing data. Identity is important for all three. Identifying fields are prominent in the declaration of data structure. Identity is by its very nature a constraint on uniqueness. And finally, unique fields and unique combinations of fields are anchor points for starting navigation of a database to access data.
I debated whether or not to include a chapter on identity. I decided to include the chapter because identity is such an important aspect of modeling. Identity pervades both conceptual models (unique keys and traversals of models—this chapter) as well as design models (different approaches to defining primary keys—Chapter 16).
-
No Comment