Patterns of Data Modeling

Patterns of Data Modeling. Michael Blaha. CRC Press. 2010

• 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.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
• Part I: Mathematical Templates
  • Chapter 2: Tree Template
  • Chapter 3: Directed Graph Template
  • 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
  • Chapter 9: Non-Data-Warehouse Antipatterns
• Part III: Archetypes
  • Chapter 10: Archetypes
• Part IV: Identity
  • Chapter 11 Identity
• Part V: Canonical Models
  • Chapter 12 Language Translation
  • Chapter 13 Softcoded Values
  • Chapter 14: Generic Diagrams
  • Chapter 15: State Diagrams
• Part VI: Relational Database Design
  • Chapter 16 Relational Database Design
• Appendix A: Explanation of the UML Notation
  • Entity Type
  • Relationships
  • Generalization
  • Bibliographic Notes
  • References
• Appendix B: Explanation of the IDEF1X Notation
  • Entity Type
  • Relationships
  • Generalization
  • Bibliographic Notes
  • References
• Appendix C: Glossary
  • Index

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.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

Part I: Mathematical Templates

Chapter 2: Tree Template

2.1 Hardcoded Tree Template

2.2 Simple Tree Template

2.3 Structured Tree Template

2.4 Overlapping Trees Template

2.5 Tree Changing over Time Template

2.6 Degenerate Node and Edge Template

2.7 Chapter Summary

Bibliographic Notes

References

Chapter 3: Directed Graph Template

3.1 Simple Directed Graph Template

3.2 Structured Directed Graph Template

3.3 Node and Edge Directed Graph Template

3.4 Connection Directed Graph Template

3.5 Simple DG Changing over Time Template

3.6 Node and Edge DG Changing over Time Template

3.7 Chapter Summary

Bibliographic Notes

References

Chapter 4: Undirected Graph Template

4.1 Node and Edge Undirected Graph Template

4.2 Connection Undirected Graph Template

4.3 Undirected Graph Changing over Time Template

4.4 Chapter Summary

Chapter 5: Item Description Template

5.1 Item Description Template

5.2 Homomorphism Template

5.3 Chapter Summary

Bibliographic Notes

References

Chapter 6: Star Schema Template

6.1 Star Schema Template

6.2 Chapter Summary

Bibliographic Notes

References

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

9.1 Derived Data Antipattern

9.2 Parallel Attributes Antipattern

9.3 Parallel Relationships Antipattern

9.4 Combined Entity Types Antipattern

9.5 Chapter Summary

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

Part IV: Identity

Chapter 11 Identity

11.1 Intrinsic Identity

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

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

Chapter 13 Softcoded Values

13.1 UML Model

13.2 IDEF1X Model

13.3 Architecture

13.4 Softcoding Variations

13.5 Chapter Summary

Bibliographic Notes

References

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

Chapter 15: State Diagrams

15.1 State Diagrams

15.2 Scenarios

15.3 Chapter Summary

Bibliographic Notes

References

Contents

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

Entity Type

Relationships

Generalization

Bibliographic Notes

References

Appendix B: Explanation of the IDEF1X Notation

Entity Type

Relationships

Generalization

Bibliographic Notes

References

Appendix C: Glossary

Index