Book description
Helping readers avoid common mistakes and build better models, this is one of the first books to apply the popular patterns perspective to database systems and the data models that are used to design state-of-the-art, efficient database systems. Best-selling author and database expert Dr. Michael Blaha provides detailed data model patterns as a basis for expertly building data models. Since most commercial software is built around a database, he focuses on databases rather than programming. He emphasizes how database representation sets the path for the software, determines its flexibility, affects its quality, and influences whether the software succeeds or fails.
Table of contents
- Cover
- Preliminaries
- Preface
- Chapter 1 Introduction
-
Part I Mathematical Templates
- Chapter 2 Tree Template
-
- 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
- Chapter 3 Directed Graph Template
-
- 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
- Chapter 4 Undirected Graph Template
- Chapter 5 Item Description Template
- Chapter 6 Star Schema Template
- Chapter 7 Summary of Templates
-
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
- Chapter 9 Non-Data-Warehouse Antipatterns
-
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.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
-
Chapter 10 Archetypes
- Part IV Identity
-
Part V Canonical Models
- Chapter 12 Language Translation
- Chapter 13 Softcoded Values
-
- 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
- Chapter 14 Generic Diagrams
- Chapter 15 State Diagrams
-
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
- Appendix A Explanation of the UML Notation
- Appendix B Explanation of the IDEF1X Notation
- Appendix C Glossary
-
Chapter 16 Relational Database Design
Product information
- Title: Patterns of Data Modeling
- Author(s):
- Release date: June 2010
- Publisher(s): CRC Press
- ISBN: 9781439819906
You might also like
book
Data Model Patterns
This is the digital version of the printed book (Copyright © 1996). Learning the basics of …
video
Learning Data Modeling
In this Learning Data Modeling training course, expert author Michael Blaha will teach you how to …
book
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business …
book
Data Mesh
We're at an inflection point in data, where our data management solutions no longer match the …