Data Modeling Essentials, Third Edition, covers the basics of data modeling while focusing on developing a facility in techniques, rather than a simple familiarization with "the rules". In order to enable students to apply the basics of data modeling to real models, the book addresses the realities of developing systems in real-world situations by assessing the merits of a variety of possible solutions as well as using language and diagramming methods that represent industry practice.
This revised edition has been given significantly expanded coverage and reorganized for greater reader comprehension even as it retains its distinctive hallmarks of readability and usefulness. Beginning with the basics, the book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management. It includes an entirely new section discussing the development of logical and physical modeling, along with new material describing a powerful technique for model verification. It also provides an excellent resource for additional lectures and exercises.
This text is the ideal reference for data modelers, data architects, database designers, DBAs, and systems analysts, as well as undergraduate and graduate-level students looking for a real-world perspective.
- Thorough coverage of the fundamentals and relevant theory
- Recognition and support for the creative side of the process
- Expanded coverage of applied data modeling includes new chapters on logical and physical database design
- New material describing a powerful technique for model verification
- Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict
Inhaltsverzeichnis
1;Cover;1 2;Title Page;4 3;Copyright Page;5 4;Contents;8 5;Preface;24 6;Part I: The Basics;30 6.1;Chapter 1. What Is Data Modeling?;32 6.1.1;1.1 Introduction;32 6.1.2;1.2 A Data-Centered Perspective;32 6.1.3;1.3 A Simple Example;33 6.1.4;1.4 Design, Choice, and Creativity;35 6.1.5;1.5 Why Is the Data Model Important?;37 6.1.6;1.6 What Makes a Good Data Model?;39 6.1.7;1.7 Performance;44 6.1.8;1.8 Database Design Stages and Deliverables;45 6.1.9;1.9 Where Do Data Models Fit In? 20;49 6.1.10;1.10 Who Should Be Involved in Data Modeling? ;52 6.1.11;1.11 Is Data Modeling Still Relevant? ;53 6.1.12;1.12 Alternative Approaches to Data Modeling ;58 6.1.13;1.13 Terminology;59 6.1.14;1.14 Where to from Here?An Overview of Part I;60 6.1.15;1.15 Summary;61 6.2;Chapter 2. Basics of Sound Structure;62 6.2.1;2.1 Introduction;62 6.2.2;2.2 An Informal Example of Normalization;63 6.2.3;2.3 Relational Notation;65 6.2.4;2.4 A More Complex Example;66 6.2.5;2.5 Determining Columns;69 6.2.6;2.6 Repeating Groups and First Normal Form;72 6.2.7;2.7 Second and Third Normal Forms;76 6.2.8;2.8 Definitions and a Few Refinements;82 6.2.9;2.9 Choice, Creativity, and Normalization;89 6.2.10;2.10 Terminology;91 6.2.11;2.11 Summary;92 6.3;Chapter 3. The Entity-Relationship Approach;94 6.3.1;3.1 Introduction;94 6.3.2;3.2 A Diagrammatic Representation;94 6.3.3;3.3 The Top-Down Approach: Entity-Relationship Modeling;101 6.3.4;3.4 Entity Classes;105 6.3.5;3.5 Relationships;111 6.3.6;3.6 Attributes;133 6.3.7;3.7 Myths and Folklore;134 6.3.8;3.8 Creativity and E-R Modeling;135 6.3.9;3.9 Summary;138 6.4;Chapter 4. Subtypes and Supertypes;140 6.4.1;4.1 Introduction;140 6.4.2;4.2 Different Levels of Generalization;140 6.4.3;4.3 Rules versus Stability;142 6.4.4;4.4 Using Subtypes and Supertypes;144 6.4.5;4.5 Subtypes and Supertypes as Entity Classes;145 6.4.6;4.6 Diagramming Conventions;146 6.4.7;4.7 Definitions;148 6.4.8;4.8 Attributes of Supertypes and Subtypes;148 6.4.9;4.9 Nonoverlapping and Exhaustive;14
9 6.4.10;4.10 Overlapping Subtypes and Roles;152 6.4.11;4.11 Hierarchy of Subtypes;156 6.4.12;4.12 Benefits of Using Subtypes and Supertypes;157 6.4.13;4.13 When Do We Stop Supertyping and Subtyping?;163 6.4.14;4.14 Generalization of Relationships;167 6.4.15;4.15 Theoretical Background;171 6.4.16;4.16 Summary;172 6.5;Chapter 5. Attributes and Columns;174 6.5.1;5.1 Introduction;174 6.5.2;5.2 Attribute Definition;175 6.5.3;5.3 Attribute Disaggregation: One Fact per Attribute;176 6.5.4;5.4 Types of Attributes;181 6.5.5;5.5 Attribute Names;195 6.5.6;5.6 Attribute Generalization;200 6.5.7;5.7 Summary;209 6.6;Chapter 6. Primary Keys and Identity;212 6.6.1;6.1 Basic Requirements and Trade-Offs;212 6.6.2;6.2 Basic Technical Criteria;214 6.6.3;6.3 Surrogate Keys;220 6.6.4;6.4 Structured Keys;223 6.6.5;6.5 Multiple Candidate Keys;230 6.6.6;6.6 Guidelines for Choosing Keys;231 6.6.7;6.7 Partially-Null Keys;233 6.6.8;6.8 Summary;235 6.7;Chapter 7. Extensions and Alternatives;236 6.7.1;7.1 Introduction;236 6.7.2;7.2 Extensions to the Basic E-R Approach;238 6.7.3;7.3 The Chen E-R Approach;245 6.7.4;7.4 Using UML Object Class Diagrams;249 6.7.5;7.5 Object Role Modeling;256 6.7.6;7.6 Summary;257 7;Part II: Putting It Together;258 7.1;Chapter 8. Organizing the Data Modeling Task;260 7.1.1;8.1 Data Modeling in the Real World;260 7.1.2;8.2 Key Issues in Project Organization;262 7.1.3;8.3 Roles and Responsibilities;267 7.1.4;8.4 Partitioning Large Projects;269 7.1.5;8.5 Maintaining the Model;271 7.1.6;8.6 Packaging It Up;277 7.1.7;8.7 Summary;278 7.2;Chapter 9. The Business Requirements;280 7.2.1;9.1 Purpose of the Requirements Phase;280 7.2.2;9.2 The Business Case;282 7.2.3;9.3 Interviews and Workshops;283 7.2.4;9.4 Riding the Trucks;287 7.2.5;9.5 Existing Systems and Reverse Engineering;288 7.2.6;9.6 Process Models;290 7.2.7;9.7 Object Class Hierarchies;290 7.2.8;9.8 Summary;299 7.3;Chapter 10. Conceptual Data Modeling;302 7.3.1;10.1 Designing Real Models;302 7.3.2;10.2 Learning from
Designers in Other Disciplines;304 7.3.3;10.3 Starting the Modeling;305 7.3.4;10.4 Patterns and Generic Models;306 7.3.5;10.5 Bottom-Up Modeling;314 7.3.6;10.6 Top-Down Modeling;317 7.3.7;10.7 When the Problem Is Too Complex;317 7.3.8;10.8 Hierarchies, Networks, and Chains;319 7.3.9;10.9 One-to-One Relationships;324 7.3.10;10.10 Developing Entity Class Definitions;329 7.3.11;10.11 Handling Exceptions;330 7.3.12;10.12 The Right Attitude;331 7.3.13;10.13 Evaluating the Model;334 7.3.14;10.14 Direct Review of Data Model Diagrams;335 7.3.15;10.15 Comparison with the Process Model;337 7.3.16;10.16 Testing the Model with Sample Data;337 7.3.17;10.17 Prototypes;338 7.3.18;10.18 The Assertions Approach;338 7.3.19;10.19 Summary;348 7.4;Chapter 11. Logical Database Design;350 7.4.1;11.1 Introduction;350 7.4.2;11.2 Overview of the Transformations Required;351 7.4.3;11.3 Table Specification;354 7.4.4;11.4 Basic Column Definition;363 7.4.5;11.5 Primary Key Specification;370 7.4.6;11.6 Foreign Key Specification;371 7.4.7;11.7 Table and Column Names;383 7.4.8;11.8 Logical Data Model Notations;384 7.4.9;11.9 Summary;386 7.5;Chapter 12. Physical Database Design;388 7.5.1;12.1 Introduction;388 7.5.2;12.2 Inputs to Database Design;390 7.5.3;12.3 Options Available to the Database Designer;391 7.5.4;12.4 Design Decisions Which Do Not Affect Program Logic;392 7.5.5;12.5 Crafting Queries to Run Faster;401 7.5.6;12.6 Logical Schema Decisions;403 7.5.7;12.7 Views;413 7.5.8;12.8 Summary;415 8;Part III: Advanced Topics;418 8.1;Chapter 13. Advanced Normalization;420 8.1.1;13.1 Introduction;420 8.1.2;13.2 Introduction to the Higher Normal Forms;421 8.1.3;13.3 Boyce-Codd Normal Form;423 8.1.4;13.4 Fourth Normal Form (4NF) and Fifth Normal Form (5NF);427 8.1.5;13.5 Beyond 5NF: Splitting Tables Based on Candidate Keys;436 8.1.6;13.6 Other Normalization Issues;437 8.1.7;13.7 Advanced Normalization in Perspective;444 8.1.8;13.8 Summary;445 8.2;Chapter 14. Modeling Business Rules;446 8.2.1;14.1 Intr
oduction;446 8.2.2;14.2 Types of Business Rules;447 8.2.3;14.3 Discovery and Verification of Business Rules;449 8.2.4;14.4 Documentation of Business Rules;451 8.2.5;14.5 Implementing Business Rules;456 8.2.6;14.6 Rules on Recursive Relationships;475 8.2.7;14.7 Summary;479 8.3;Chapter 15. Time-Dependent Data;480 8.3.1;15.1 The Problem;480 8.3.2;15.2 When Do We Add the Time Dimension?;481 8.3.3;15.3 Audit Trails and Snapshots;481 8.3.4;15.4 Sequences and Versions;491 8.3.5;15.5 Handling Deletions;492 8.3.6;15.6 Archiving;492 8.3.7;15.7 Modeling Time-Dependent Relationships;493 8.3.8;15.8 Date Tables;498 8.3.9;15.9 Temporal Business Rules;498 8.3.10;15.10 Changes to the Data Structure;502 8.3.11;15.11 Putting It into Practice;502 8.3.12;15.12 Summary;503 8.4;Chapter 16. Modeling for Data Warehouses Data Marts;504 8.4.1;16.1 Introduction;504 8.4.2;16.2 Characteristics of Data Warehouses and Data Marts;507 8.4.3;16.3 Quality Criteria for Warehouse and Mart Models;509 8.4.4;16.4 The Basic Design Principle;512 8.4.5;16.5 Modeling for the Data Warehouse;513 8.4.6;16.6 Modeling for the Data Mart;517 8.4.7;16.7 Summary;525 8.5;Chapter 17. Enterprise Data Models and Data Management;528 8.5.1;17.1 Introduction;528 8.5.2;17.2 Data Management;529 8.5.3;17.3 Classification of Existing Data;532 8.5.4;17.4 A Target for Planning;533 8.5.5;17.5 A Context for Specifying New Databases;535 8.5.6;17.6 Guidance for Database Design;537 8.5.7;17.7 Input to Business Planning;537 8.5.8;17.8 Specification of an Enterprise Database;538 8.5.9;17.9 Characteristics of Enterprise Data Models;540 8.5.10;17.10 Developing an Enterprise Data Model;541 8.5.11;17.11 Choice, Creativity, and Enterprise Data Models;545 8.5.12;17.12 Summary;546 9;Further Reading;548