Patterns of Data Modeling

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