January 2009
Beginner to intermediate
641 pages
26h 48m
English
book
The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
by Paul Agnew, Len Silverston
Content preview from The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Silverston ftoc.tex V2 - 11/26/2008 6:50pm Page xv
Contents
Foreword xxv
Chapter 1 Introduction 1
Why Is There a Need for This Book? 1
Extending the Discipline of Data Modeling 4
What Is a Pattern and What Is a Universal Pattern? 5
What Is the Significance of Patterns? 6
Approach of This Book 6
The Different Pattern Levels 7
Who Is the Intended Audience for This Book? 14
What Is in This Book 15
Other Patterns for Data Modeling 17
Conventions and Standards Used in This Book 18
Entities 18
Subtypes and Supertypes 19
Attributes 20
Relationships 22
Relationship Optionality 23
Relationship Cardinality 25
Foreign Key Relationships 26
Associative Entities to Handle Many-to-Many
Relationships 26
Exclusive Arcs 27
Example Data in Illustration Tables 28
Data Modeling Notation 29
Summary 33
References 33
xv
Silverston ftoc.tex V2 - 11/26/2008 6:50pm Page xvi
xvi Contents
Chapter 2 Setting Up Roles: What Parties Do 35
What Is the Significance of This Type of Pattern? 36
What Is in This Chapter? 36
What Is a Declarative Role? 37
Level 1 Declarative Role Pattern 38
Why Do We Need This Pattern? 40
HowDoesThisPatternWork? 41
When Should This Pattern Be Used? 44
What Are the Weaknesses of the Pattern? 45
Synopsis 46
Level 2 Declarative Role Pattern 47
Why Do We Need This Pattern? 48
HowDoesThisPatternWork? 48
When Should This Pattern Be Used? ...