Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Michael Blaha
Patterns of Data Modeling
Cover
Preliminaries
Preface
Who Should Read This Book?
What You Will Find
Comparison with Other Books
Acknowledgments
Chapter 1 Introduction
1.1 What Is a Model?
1.2 Modeling Notation
1.2.1 UML
1.2.2 IDEF1X
1.2.3 Using Both Notations
1.3 What Is a Pattern?
1.4 Why Are Patterns Important?
1.5 Drawbacks of Patterns
1.6 Pattern vs. Seed Model
1.7 Aspects of Pattern Technology
1.8 Chapter Summary
Bibliographic Notes
References
Table 1.1
Table 1.1
Part I Mathematical Templates
Chapter 2 Tree Template
2.1 Hardcoded Tree Template
2.1.1 UML Template
2.1.2 IDEF1X Template
2.1.3 SQL Queries
2.1.4 Sample Populated Tables
2.1.5 Examples
2.2 Simple Tree Template
2.2.1 UML Template
2.2.2 IDEF1X Template
2.2.3 SQL Queries
2.2.4 Sample Populated Tables
2.2.5 Examples
2.3 Structured Tree Template
2.3.1 UML Template
2.3.2 IDEF1X Template
2.3.3 SQL Queries
2.3.4 Sample Populated Tables
2.3.5 Examples
2.4 Overlapping Trees Template
2.4.1 UML Template
2.4.2 IDEF1X Template
2.4.3 SQL Queries
2.4.4 Sample Populated Tables
2.4.5 Example
2.5 Tree Changing over Time Template
2.5.1 UML Template
2.5.2 IDEF1X Template
2.5.3 SQL Queries
2.5.4 Sample Populated Tables
2.5.5 Example
2.6 Degenerate Node and Edge Template
2.6.1 UML Template
2.6.2 IDEF1X Template
2.6.3 SQL Queries
2.6.4 Sample Populated Tables
2.6.5 Example
2.7 Chapter Summary
Bibliographic Notes
References
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
Table 2.1
Chapter 3 Directed Graph Template
3.1 Simple Directed Graph Template
3.1.1 UML Template
3.1.2 IDEF1X Template
3.1.3 SQL Queries
3.1.4 Sample Populated Tables
3.1.5 Example
3.2 Structured Directed Graph Template
3.2.1 UML Template
3.2.2 IDEF1X Template
3.2.3 SQL Queries
3.2.4 Sample Populated Tables
3.2.5 Examples
3.3 Node and Edge Directed Graph Template
3.3.1 UML Template
3.3.2 IDEF1X Template
3.3.3 SQL Queries
3.3.4 Sample Populated Tables
3.3.5 Examples
3.4 Connection Directed Graph Template
3.4.1 UML Template
3.4.2 IDEF1X Template
3.4.3 SQL Queries
3.4.4 Sample Populated Tables
3.4.5 Example
3.5 Simple DG Changing over Time Template
3.5.1 UML Template
3.5.2 IDEF1X Template
3.5.3 SQL Queries
3.5.4 Sample Populated Tables
3.5.5 Example
3.6 Node and Edge DG Changing over Time Template
3.6.1 UML Template
3.6.2 IDEF1X Template
3.6.3 SQL Queries
3.6.4 Sample Populated Tables
3.6.5 Examples
3.7 Chapter Summary
Bibliographic Notes
References
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
Table 3.1
Chapter 4 Undirected Graph Template
4.1 Node and Edge Undirected Graph Template
4.1.1 UML Template
4.1.2 IDEF1X Template
4.1.3 SQL Queries
4.1.4 Sample Populated Tables
4.1.5 Examples
4.2 Connection Undirected Graph Template
4.2.1 UML Template
4.2.2 IDEF1X Template
4.2.3 SQL Queries
4.2.4 Sample Populated Tables
4.2.5 Examples
4.3 Undirected Graph Changing over Time Template
4.3.1 UML Template
4.3.2 IDEF1X Template
4.3.3 SQL Queries
4.3.4 Sample Populated Tables
4.3.5 Example
4.4 Chapter Summary
Figure 4.1
Figure 4.1
Figure 4.2
Figure 4.3
Figure 4.4
Figure 4.5
Figure 4.6
Figure 4.7
Figure 4.8
Figure 4.9
Figure 4.10
Figure 4.11
Figure 4.12
Figure 4.13
Figure 4.14
Figure 4.15
Figure 4.16
Figure 4.17
Figure 4.18
Figure 4.19
Figure 4.20
Table 4.1
Table 4.1
Chapter 5 Item Description Template
5.1 Item Description Template
5.1.1 UML Template
5.1.2 IDEF1X Template
5.1.3 SQL Queries
5.1.4 Sample Populated Tables
5.1.5 Examples
5.2 Homomorphism Template
5.2.1 UML Template
5.2.2 IDEF1X Template
5.2.3 SQL Queries
5.2.4 Sample Populated Tables
5.2.5 Examples
5.3 Chapter Summary
Bibliographic Notes
References
Figure 5.1
Figure 5.1
Figure 5.2
Figure 5.3
Figure 5.4
Figure 5.5
Figure 5.6
Figure 5.7
Figure 5.8
Figure 5.9
Figure 5.10
Figure 5.11
Figure 5.12
Figure 5.13
Figure 5.14
Figure 5.15
Table 5.1
Table 5.1
Table 5.2
Chapter 6 Star Schema Template
6.1 Star Schema Template
6.1.1 UML Template
6.1.2 IDEF1X Template
6.1.3 SQL Queries
6.1.4 Sample Populated Tables
6.1.5 Examples
6.2 Chapter Summary
Bibliographic Notes
References
Figure 6.1
Figure 6.1
Figure 6.2
Figure 6.3
Figure 6.4
Figure 6.5
Figure 6.6
Figure 6.7
Table 6.1
Table 6.1
Chapter 7 Summary of Templates
Table 7.1
Table 7.1
Table 7.2
Table 7.3
Table 7.4
Table 7.5
Part II Antipatterns
Chapter 8 Universal Antipatterns
8.1 Symmetric Relationship Antipattern
8.1.1 Observation
8.1.2 Exceptions
8.1.3 Resolution
8.1.4 Examples
8.2 Dead Elements Antipattern
8.2.1 Observation
8.2.2 Exceptions
8.2.3 Resolution
8.2.4 Examples
8.3 Disguised Fields Antipattern
8.3.1 Observation
8.3.2 Exceptions
8.3.3 Resolution
8.3.4 Examples
8.4 Artificial Hardcoded Levels Antipattern
8.4.1 Observation
8.4.2 Exceptions
8.4.3 Resolution
8.4.4 Example
8.5 Excessive Generalization Antipattern
8.5.1 Observation
8.5.2 Exceptions
8.5.3 Resolution
8.5.4 Examples
8.6 Disconnected Entity Types Antipattern
8.6.1 Observation
8.6.2 Exceptions
8.6.3 Resolution
8.6.4 Example
8.7 Modeling Errors Antipattern
8.7.1 Observations
8.7.2 Exceptions
8.7.3 Resolution
8.7.4 Examples
8.8 Multiple Inheritance Antipattern
8.8.1 Observation
8.8.2 Exceptions
8.8.3 Resolutions
8.8.4 Example
8.9 Paradigm Degradation Antipattern
8.9.1 Observation
8.9.2 Exceptions
8.9.3 Resolution
8.9.4 Examples
8.10 Chapter Summary
Bibliographic Notes
References
Figure 8.1
Figure 8.1
Figure 8.2
Figure 8.3
Figure 8.4
Figure 8.5
Figure 8.6
Figure 8.7
Figure 8.8
Figure 8.9
Figure 8.10
Figure 8.11
Figure 8.12
Figure 8.13
Table 8.1
Table 8.1
Chapter 9 Non-Data-Warehouse Antipatterns
9.1 Derived Data Antipattern
9.1.1 Observation
9.1.2 Exceptions
9.1.3 Resolution
9.1.4 Examples
9.2 Parallel Attributes Antipattern
9.2.1 Observation
9.2.2 Exceptions
9.2.3 Resolution
9.2.4 Examples
9.3 Parallel Relationships Antipattern
9.3.1 Observation
9.3.2 Exceptions
9.3.3 Resolution
9.3.4 Example
9.4 Combined Entity Types Antipattern
9.4.1 Observation
9.4.2 Exceptions
9.4.3 Resolution
9.4.4 Example
9.5 Chapter Summary
Figure 9.1
Figure 9.1
Figure 9.2
Figure 9.3
Figure 9.4
Figure 9.5
Figure 9.6
Figure 9.7
Figure 9.8
Figure 9.9
Figure 9.10
Figure 9.11
Table 9.1
Table 9.1
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
Table 10.1
Table 10.2
Part IV Identity
Chapter 11 Identity
11.1 Intrinsic Identity
11.1.1 Candidate Keys
11.1.2 UML Qualifiers
11.1.3 Logical Horizon
11.2 Names
11.3 Surrogate Identity
11.4 Structured Fields
11.5 Master Applications
11.6 Merging Data
11.7 Chapter Summary
Bibliographic Notes
References
Figure 11.1
Figure 11.1
Figure 11.2
Figure 11.3
Table 11.1
Table 11.1
Part V Canonical Models
Chapter 12 Language Translation
12.1 Alternative Architectures
12.2 Attribute Translation in Place
12.3 Phrase-to-Phrase Translation
12.4 Language-Neutral Translation
12.5 Chapter Summary
Bibliographic Notes
References
Figure 12.1
Figure 12.1
Figure 12.2
Figure 12.3
Figure 12.4
Figure 12.5
Figure 12.6
Figure 12.7
Figure 12.8
Table 12.1
Table 12.1
Table 12.2
Chapter 13 Softcoded Values
13.1 UML Model
13.1.1 Data
13.1.2 Metadata
13.2 IDEF1X Model
13.3 Architecture
13.3.1 Using Softcoded Values in an Application
13.3.2 Hardcoded Model for Populating Metadata
13.3.3 Mixing Hardcoded and Softcoded Attributes
13.3.4 Database Performance
13.3.5 User Interface
13.4 Softcoding Variations
13.4.1 Add Value Metadata
13.4.2 Cut Metadata
13.4.3 Store All SoftcodedValues as Strings
13.4.4 Subtype by Data Type
13.4.5 Require All Attributes to be Enumerated
13.4.6 Enable Time History
13.4.7 Support Weakly Typed Entities
13.4.8 Combine Variations
13.5 Chapter Summary
Bibliographic Notes
References
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
Table 13.1
Chapter 14 Generic Diagrams
14.1 Generic Diagram Examples
14.2 Diagram Subject Area
14.3 Model Subject Area
14.4 Model-Diagram Binding Subject Area
14.5 DiagramType Subject Area
14.6 Diagram Example, Revisited
14.7 Chapter Summary
Bibliographic Notes
Figure 14.1
Figure 14.1
Figure 14.2
Figure 14.3
Figure 14.4
Figure 14.5
Figure 14.6
Figure 14.7
Figure 14.8
Figure 14.9
Figure 14.10
Figure 14.11
Figure 14.12
Figure 14.13
Figure 14.14
Figure 14.15
Chapter 15 State Diagrams
15.1 State Diagrams
15.2 Scenarios
15.3 Chapter Summary
Bibliographic Notes
References
Figure 15.1
Figure 15.1
Figure 15.2
Figure 15.3
Figure 15.4
Figure 15.5
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.7.1 SQL Triggers
16.7.2 General SQL Constraints
16.8 Indexes
16.9 Generating SQL Code
16.10 Chapter Summary
Bibliographic Notes
References
Figure 16.1
Figure 16.1
Figure 16.2
Figure 16.3
Figure 16.4
Figure 16.5
Figure 16.6
Figure 16.7
Figure 16.8
Figure 16.9
Figure 16.10
Figure 16.11
Figure 16.12
Figure 16.13
Figure 16.14
Figure 16.15
Figure 16.16
Figure 16.17
Figure 16.18
Table 16.1
Table 16.1
Table 16.2
Appendix A Explanation of the UML Notation
Entity Type
Relationships
Generalization
Bibliographic Notes
References
Figure A1.1
Figure A1.1
Figure A1.2
Figure A1.3
Figure A1.4
Figure A1.5
Figure A1.6
Figure A1.7
Figure A1.8
Figure A1.9
Figure A1.10
Appendix B Explanation of the IDEF1X Notation
Entity Type
Relationships
Generalization
Bibliographic Notes
References
Figure B1.1
Figure B1.1
Figure B1.2
Figure B1.3
Figure B1.4
Figure B1.5
Figure B1.6
Figure B1.7
Appendix C Glossary
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Patterns of Data Modeling
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset