Cargando…

Patterns of data modeling /

"" ... should be on the shelf of every database, software, and systems architect. The book captures decades of experience, presenting distilled knowledge in a concise and easy-to-understand format. The breadth of coverage is enormous, ranging from basic data structures through star schema,...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Blaha, Michael
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Boca Raton : CRC Press, ©2010.
©2010
Colección:Emerging directions in database systems and applications.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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. IDEFIX 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. Diagram Binding Subject Area
  • 14.5. Diagram Type 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
  • 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.