- Cover
- Preliminaries
- Preface
- Chapter 1 Introduction
- Table 1.1
- Part I Mathematical Templates
- Chapter 2 Tree Template
- 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
- Chapter 3 Directed Graph Template
- 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
- Chapter 4 Undirected Graph Template
- Figure 4.1
- Table 4.1
- Chapter 5 Item Description Template
- Figure 5.1
- Table 5.1
- Chapter 6 Star Schema Template
- Figure 6.1
- Table 6.1
- Chapter 7 Summary of Templates
- Table 7.1
- 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
- Figure 8.1
- Table 8.1
- Chapter 9 Non-Data-Warehouse Antipatterns
- Figure 9.1
- Table 9.1
- Chapter 8 Universal Antipatterns
- 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
- Chapter 10 Archetypes
- Part IV Identity
- Part V Canonical Models
- Chapter 12 Language Translation
- Figure 12.1
- Table 12.1
- Chapter 13 Softcoded Values
- 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
- Chapter 14 Generic Diagrams
- Figure 14.1
- Chapter 15 State Diagrams
- Figure 15.1
- 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
- Figure 16.1
- Table 16.1
- Appendix A Explanation of the UML Notation
- Figure A1.1
- Appendix B Explanation of the IDEF1X Notation
- Figure B1.1
- Appendix C Glossary
- Chapter 16 Relational Database Design
EMERGING DIRECTIONS IN DATABASE SYSTEMS AND APPLICATIONS
Series Editor
Sham Navathe
Professor
Georgia Institute of Technology
College of Computing
Atlanta, Georgia, U.S.A.
Patterns of Data Modeling, Michael Blaha
Forthcoming Publications
Advanced Data Management, Edward Omiecinski
Bioinformatics Database Systems, Jason T.L. Wang and Katherine G. Herbert
Techniques for Automated Physical Database Design, Nicolas Bruno and Surajit Chaudhuri
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.