Patterns of Data Modeling (Paperback)

Introduction
What Is a Model?
Modeling Notation
What Is a Pattern?
Why are Patterns Important?
Drawbacks of Patterns
Pattern vs. Seed Model
Aspects of Pattern Technology

MATHEMATICAL TEMPLATES

Tree Template
Hardcoded Tree Template
Simple Tree Template
Structured Tree Template
Overlapping Trees Template
Tree Changing Over Time Template
Degenerate Node and Edge Template

Directed Graph Template
Simple Directed Graph Template
Structured Directed Graph Template
Node and Edge Directed Graph Template
Connection Directed Graph Template
Simple DG Changing Over Time Template
Node and Edge DG Changing Over Time Template

Undirected Graph Template
Node and Edge Undirected Graph Template
Connection Undirected Graph Template
Undirected Graph Changing Over Time Template

Item Description Template
Item Description Template
Homomorphism Template

Star Schema Template
Star Schema Template

Summary of Templates

ANTIPATTERNS

Universal Antipatterns
Symmetric Relationship Antipattern
Dead Elements Antipattern
Disguised Fields Antipattern
Artificial Hardcoded Levels Antipattern
Excessive Generalization Antipattern
Disconnected Entity Types Antipattern
Modeling Errors Antipattern
Multiple Inheritance Antipattern
Paradigm Degradation Antipattern

Non-Data-Warehouse Antipatterns

Derived Data Antipattern
Parallel Attributes Antipattern
Parallel Relationships Antipattern
Combined Entity Types Antipattern

ARCHETYPES

Archetypes
Account
Actor
Address
Asset
Contract
Course
Customer
Document
Event
Flight
Item
Location
Opportunity
Part
Payment
Position
Product
Role
Transaction
Vendor

IDENTITY

Identity
Intrinsic Identity
Names
Surrogate Identity
Structured Fields
Master Applications
Merging Data

CANONICAL MODELS

Language Translation
Alternative Architectures
Attribute Translation in Place
Phrase-to-Phrase Translation
Language-Neutral Translation

Softcoded Values
UML Model
IDEF1X Model
Architecture
Softcoding Variations

Generic Diagrams
Generic Diagram Examples
Diagram Subject Area
Model Subject Area
Model?Diagram Binding Subject Area
Diagram Type Subject Area
Diagram Example, Revisited

State Diagrams
State Diagrams
Scenarios

RELATIONAL DATABASE DESIGN

Relational Database Design
Mapping: Entity Types
Mapping: Non-Qualified Relationships
Mapping Qualified Relationships
Mapping: Generalizations
Design Identity
Referential Integrity
Miscellaneous Database Constraints
Indexes
Generating SQL Code

APPENDICES

Explanation of the UML Notation
Entity Type
Relationships
Generalization

Explanation of the IDEF1X Notation
Entity Type
Relationships
Generalization

Glossary
Index

All chapters conclude with a chapter summary; most include bibliographic notes & references