71,15 €*
Versandkostenfrei per Post / DHL
Lieferzeit 2-3 Wochen
-Dr. Graeme Simsion, author of Data Modeling Essentials and Data Modeling Theory and Practice
This third volume of the bestselling Data Model Resource Book series revolutionizes the data modeling discipline by answering the question "How can you save significant time while improving the quality of any type of data modeling effort?" In contrast to the first two volumes, this new volume focuses on the fundamental, underlying patterns that affect over 50 percent of most data modeling efforts. These patterns can be used to considerably reduce modeling time and cost, to jump-start data modeling efforts, as standards and guidelines to increase data model consistency and quality, and as an objective source against which an enterprise can evaluate data models.
For each pattern, numerous alternatives are provided, ranging from very specific to very generalized ways of modeling. Len Silverston and Paul Agnew point out the pros and cons of these alternatives and provide guidelines to help you make appropriate decisions depending on the set of circumstances faced. In developing and documenting these patterns, the authors share an invaluable set of foundational tools for anyone involved in data modeling, from the novice to the expert. The authors show you how to:
* Model the most prevalent data modeling constructs such as ways to model roles, hierarchies, classifications, statuses, contact information, and business rules
* Re-use a powerful library of core patterns for data modeling
* Model at different levels of generalization
* Evaluate the pros and cons of specific versus generalized models
* Apply the patterns in many types of data modeling efforts, such as prototypes, applications, enterprise data models, data warehouses, and master data management efforts
* Gain buy-in regarding the use of patterns and/or standardizing on these patterns
-Dr. Graeme Simsion, author of Data Modeling Essentials and Data Modeling Theory and Practice
This third volume of the bestselling Data Model Resource Book series revolutionizes the data modeling discipline by answering the question "How can you save significant time while improving the quality of any type of data modeling effort?" In contrast to the first two volumes, this new volume focuses on the fundamental, underlying patterns that affect over 50 percent of most data modeling efforts. These patterns can be used to considerably reduce modeling time and cost, to jump-start data modeling efforts, as standards and guidelines to increase data model consistency and quality, and as an objective source against which an enterprise can evaluate data models.
For each pattern, numerous alternatives are provided, ranging from very specific to very generalized ways of modeling. Len Silverston and Paul Agnew point out the pros and cons of these alternatives and provide guidelines to help you make appropriate decisions depending on the set of circumstances faced. In developing and documenting these patterns, the authors share an invaluable set of foundational tools for anyone involved in data modeling, from the novice to the expert. The authors show you how to:
* Model the most prevalent data modeling constructs such as ways to model roles, hierarchies, classifications, statuses, contact information, and business rules
* Re-use a powerful library of core patterns for data modeling
* Model at different levels of generalization
* Evaluate the pros and cons of specific versus generalized models
* Apply the patterns in many types of data modeling efforts, such as prototypes, applications, enterprise data models, data warehouses, and master data management efforts
* Gain buy-in regarding the use of patterns and/or standardizing on these patterns
Paul Agnew is an author and consultant with more than 17 years of experience in the data management field in many different industries. He is an expert in data modeling, architecture, and integration. He is a senior partner at Universal Data Models, LLC ([...]
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
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
How Does This Pattern Work? 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
How Does This Pattern Work? 48
When Should This Pattern Be Used? 53
What Are the Weaknesses of the Pattern? 54
Synopsis 55
Level 3 Declarative Role Pattern 56
Why Do We Need This Pattern? 56
How Does This Pattern Work? 57
When Should This Pattern Be Used? 63
What Are the Weaknesses of the Pattern? 64
Synopsis 65
Summary of Patterns 65
References 69
Chapter 3 Using Roles: How Parties Are Involved 71
What Is the Significance of This Type of Pattern? 72
What Is in This Chapter? 72
What Is a Contextual Role? 73
Level 1 Contextual Role Pattern, Attributes 74
Why Do We Need This Pattern? 74
How Does This Pattern Work? 76
When Should This Pattern Be Used? 78
What Are the Weaknesses of the Pattern? 79
Synopsis 80
Level 1 Contextual Role Pattern, Relationships 80
Why Do We Need This Pattern? 81
How Does This Pattern Work? 81
When Should This Pattern Be Used? 87
What Are the Weaknesses of the Pattern? 87
Synopsis 88
Level 2 Contextual Role Pattern 88
Why Do We Need This Pattern? 89
How Does This Pattern Work? 89
When Should This Pattern Be Used? 97
What Are the Weaknesses of the Pattern? 98
Synopsis 99
Level 2 Contextual Role Pattern, PARTY Only Alternative 99
Why Do We Need This Pattern? 100
How Does This Pattern Work? 100
When Should This Pattern Be Used? 106
What Are the Weaknesses of the Pattern? 106
Synopsis 107
Level 3 Contextual Role Pattern 107
Why Do We Need This Pattern? 108
How Does This Pattern Work? 108
When Should This Pattern Be Used? 114
What Are the Weaknesses of the Pattern? 115
Synopsis 116
Hybrid Contextual Role Pattern 117
Why Do We Need This Pattern? 117
How Does This Pattern Work? 118
When Should This Pattern Be Used? 123
What Are the Weaknesses of the Pattern? 123
Synopsis 124
Summary of Patterns 124
References 131
Chapter 4 Hierarchies, Aggregations, and Peer-to-Peer Relationships: The Organization of Similar Data 133
What Is the Significance of This Type of Pattern? 133
What Is in This Chapter? 134
What Is a Recursive Relationship and How Is Data Organized by Recursive Relationships? 134
Level 1 Recursive Pattern 138
Why Do We Need This Pattern? 138
How Does This Pattern Work? 139
When Should This Pattern Be Used? 144
What Are the Weaknesses of the Pattern? 145
Synopsis 145
Level 2 Recursive Pattern 146
Why Do We Need This Pattern? 146
How Does This Pattern Work? 147
When Should This Pattern Be Used? 152
What Are the Weaknesses of the Pattern? 153
Synopsis 154
Level 2 Expanded Recursive Pattern 155
Why Do We Need This Pattern? 155
How Does This Pattern Work? 156
When Should This Pattern Be Used? 162
What Are the Weaknesses of the Pattern? 162
Synopsis 163
Level 3 Recursive Pattern 164
Why Do We Need This Pattern? 165
How Does This Pattern Work? 165
When Should This Pattern Be Used? 170
What Are the Weaknesses of the Pattern? 171
Synopsis 172
Level 3 Recursive Pattern with Rules 173
Why Do We Need This Pattern? 173
How Does This Pattern Work? 174
When Should This Pattern Be Used? 179
What Are the Weaknesses of the Pattern? 180
Synopsis 180
Summary of Patterns 180
References 186
Chapter 5 Types and Categories: the Classification of Data 187
What Is the Significance of This Type of Pattern? 187
What Is in This Chapter? 188
What Are Types, Categorizations, and Taxonomies? 189
Level 1 Classification Pattern 190
Why Do We Need This Pattern? 190
How Does This Pattern Work? 190
When Should This Pattern Be Used? 195
What Are the Weaknesses of the Pattern? 196
Synopsis 197
Level 2 Classification Pattern 197
Why Do We Need This Pattern? 197
How Does This Pattern Work? 198
When Should This Pattern Be Used? 205
What Are the Weaknesses of the Pattern? 206
Synopsis 207
Level 3 Classification Pattern 208
Why Do We Need This Pattern? 208
How Does This Pattern Work? 208
When Should This Pattern Be Used? 219
What Are the Weaknesses of the Pattern? 220
Synopsis 221
Level 3 Classification Pattern with Rollups and Schemes 222
Why Do We Need This Pattern? 222
How Does This Pattern Work? 223
When Should This Pattern Be Used? 229
What Are the Weaknesses of the Pattern? 230
Synopsis 230
Summary of Patterns 230
References 235
Chapter 6 Status: The States of Data 237
What Is the Significance of This Type of Pattern? 238
What Is in This Chapter? 239
What Is a Status? 240
Level 1 Status Pattern 244
Why Do We Need This Pattern? 245
How Does This Pattern Work? 246
When Should This Pattern Be Used? 251
What Are the Weaknesses of the Pattern? 253
Synopsis 253
Level 2 Status Pattern, Current Status 254
Why Do We Need This Pattern? 255
How Does This Pattern Work? 255
When Should This Pattern Be Used? 260
What Are the Weaknesses of the Pattern? 260
Synopsis 261
Level 3 Status Pattern 261
Why Do We Need This Pattern? 261
How Does This Pattern Work? 262
When Should This Pattern Be Used? 267
What Are the Weaknesses of the Pattern? 267
Synopsis 268
Level 4 Status Pattern 269
Why Do We Need This Pattern? 269
How Does This Pattern Work? 269
When Should This Pattern Be Used? 277
What Are the Weaknesses of the Pattern? 278
Synopsis 279
Status Category Pattern 280
Why Do We Need This Pattern? 280
How Does This Pattern Work? 280
When Should This Pattern Be Used? 282
What Are the Weaknesses of the Pattern? 285
Synopsis 285
Status Type with Multi Rollup and Rules Pattern 286
Why Do We Need This Pattern? 286
How Does This Pattern Work? 287
When Should This Pattern Be Used? 293
What Are the Weaknesses of the Pattern? 294
Synopsis 294
Summary of Patterns 294
References 301
Chapter 7 Contact Mechanisms: How to Get in Touch 303
What Is the Significance of This Type of Pattern? 303
What Is in This Chapter? 304
What Is a Contact Mechanism? 305
Level 1 Contact Mechanism Pattern 308
Why Do We Need This Pattern? 309
How Does This Pattern Work? 310
When Should This Pattern Be Used? 321
What Are the Weaknesses of the Pattern? 322
Synopsis 323
Level 2 Contact Mechanism Pattern 324
Why Do We Need This Pattern? 325
How Does This Pattern Work? 325
When Should This Pattern Be Used? 342
What Are the Weaknesses of the Pattern? 343
Synopsis 344
Level 3 Contact Mechanism Pattern 345
Why Do We Need This Pattern? 346
How Does This Pattern Work? 346
When Should This Pattern Be Used? 361
What Are the Weaknesses of the Pattern? 361
Synopsis 362
Level 4 Contact Mechanism Pattern 364
Why Do We Need This Pattern? 364
How Does This Pattern Work? 364
When Should This Pattern Be Used? 378
What Are the Weaknesses of the Pattern? 378
Synopsis 379
Contact Mechanism Pattern with Geographic Boundary 380
Why Do We Need This Pattern? 381
How Does This Pattern Work? 384
When Should This Pattern Be Used? 389
What Are the Weaknesses of the Pattern? 390
Synopsis 390
Contact Mechanism with Flexible Address Parts Pattern 391
Why Do We Need This Pattern? 393
How Does This Pattern Work? 394
When Should This Pattern Be Used? 398
What Are the Weaknesses of the Pattern? 398
Synopsis 399
Other Common Contact Mechanism Data 399
Non-Solicitation 400
Instructions 401
Directions 402
Telephone Extensions 402
Synopsis 403
Summary of Patterns 403
References 410
Chapter 8 Business Rules: How Things Should...
| Erscheinungsjahr: | 2008 |
|---|---|
| Genre: | Importe, Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| ISBN-13: | 9780470178454 |
| ISBN-10: | 0470178450 |
| Sprache: | Englisch |
| Herstellernummer: | 14517845000 |
| Einband: | Kartoniert / Broschiert |
| Autor: |
Silverston, Len
Agnew, Paul |
| Hersteller: |
Wiley
John Wiley & Sons |
| Verantwortliche Person für die EU: | Libri GmbH, Europaallee 1, D-36244 Bad Hersfeld, gpsr@libri.de |
| Maße: | 235 x 191 x 35 mm |
| Von/Mit: | Len Silverston (u. a.) |
| Erscheinungsdatum: | 01.12.2008 |
| Gewicht: | 1,18 kg |
Paul Agnew is an author and consultant with more than 17 years of experience in the data management field in many different industries. He is an expert in data modeling, architecture, and integration. He is a senior partner at Universal Data Models, LLC ([...]
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
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
How Does This Pattern Work? 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
How Does This Pattern Work? 48
When Should This Pattern Be Used? 53
What Are the Weaknesses of the Pattern? 54
Synopsis 55
Level 3 Declarative Role Pattern 56
Why Do We Need This Pattern? 56
How Does This Pattern Work? 57
When Should This Pattern Be Used? 63
What Are the Weaknesses of the Pattern? 64
Synopsis 65
Summary of Patterns 65
References 69
Chapter 3 Using Roles: How Parties Are Involved 71
What Is the Significance of This Type of Pattern? 72
What Is in This Chapter? 72
What Is a Contextual Role? 73
Level 1 Contextual Role Pattern, Attributes 74
Why Do We Need This Pattern? 74
How Does This Pattern Work? 76
When Should This Pattern Be Used? 78
What Are the Weaknesses of the Pattern? 79
Synopsis 80
Level 1 Contextual Role Pattern, Relationships 80
Why Do We Need This Pattern? 81
How Does This Pattern Work? 81
When Should This Pattern Be Used? 87
What Are the Weaknesses of the Pattern? 87
Synopsis 88
Level 2 Contextual Role Pattern 88
Why Do We Need This Pattern? 89
How Does This Pattern Work? 89
When Should This Pattern Be Used? 97
What Are the Weaknesses of the Pattern? 98
Synopsis 99
Level 2 Contextual Role Pattern, PARTY Only Alternative 99
Why Do We Need This Pattern? 100
How Does This Pattern Work? 100
When Should This Pattern Be Used? 106
What Are the Weaknesses of the Pattern? 106
Synopsis 107
Level 3 Contextual Role Pattern 107
Why Do We Need This Pattern? 108
How Does This Pattern Work? 108
When Should This Pattern Be Used? 114
What Are the Weaknesses of the Pattern? 115
Synopsis 116
Hybrid Contextual Role Pattern 117
Why Do We Need This Pattern? 117
How Does This Pattern Work? 118
When Should This Pattern Be Used? 123
What Are the Weaknesses of the Pattern? 123
Synopsis 124
Summary of Patterns 124
References 131
Chapter 4 Hierarchies, Aggregations, and Peer-to-Peer Relationships: The Organization of Similar Data 133
What Is the Significance of This Type of Pattern? 133
What Is in This Chapter? 134
What Is a Recursive Relationship and How Is Data Organized by Recursive Relationships? 134
Level 1 Recursive Pattern 138
Why Do We Need This Pattern? 138
How Does This Pattern Work? 139
When Should This Pattern Be Used? 144
What Are the Weaknesses of the Pattern? 145
Synopsis 145
Level 2 Recursive Pattern 146
Why Do We Need This Pattern? 146
How Does This Pattern Work? 147
When Should This Pattern Be Used? 152
What Are the Weaknesses of the Pattern? 153
Synopsis 154
Level 2 Expanded Recursive Pattern 155
Why Do We Need This Pattern? 155
How Does This Pattern Work? 156
When Should This Pattern Be Used? 162
What Are the Weaknesses of the Pattern? 162
Synopsis 163
Level 3 Recursive Pattern 164
Why Do We Need This Pattern? 165
How Does This Pattern Work? 165
When Should This Pattern Be Used? 170
What Are the Weaknesses of the Pattern? 171
Synopsis 172
Level 3 Recursive Pattern with Rules 173
Why Do We Need This Pattern? 173
How Does This Pattern Work? 174
When Should This Pattern Be Used? 179
What Are the Weaknesses of the Pattern? 180
Synopsis 180
Summary of Patterns 180
References 186
Chapter 5 Types and Categories: the Classification of Data 187
What Is the Significance of This Type of Pattern? 187
What Is in This Chapter? 188
What Are Types, Categorizations, and Taxonomies? 189
Level 1 Classification Pattern 190
Why Do We Need This Pattern? 190
How Does This Pattern Work? 190
When Should This Pattern Be Used? 195
What Are the Weaknesses of the Pattern? 196
Synopsis 197
Level 2 Classification Pattern 197
Why Do We Need This Pattern? 197
How Does This Pattern Work? 198
When Should This Pattern Be Used? 205
What Are the Weaknesses of the Pattern? 206
Synopsis 207
Level 3 Classification Pattern 208
Why Do We Need This Pattern? 208
How Does This Pattern Work? 208
When Should This Pattern Be Used? 219
What Are the Weaknesses of the Pattern? 220
Synopsis 221
Level 3 Classification Pattern with Rollups and Schemes 222
Why Do We Need This Pattern? 222
How Does This Pattern Work? 223
When Should This Pattern Be Used? 229
What Are the Weaknesses of the Pattern? 230
Synopsis 230
Summary of Patterns 230
References 235
Chapter 6 Status: The States of Data 237
What Is the Significance of This Type of Pattern? 238
What Is in This Chapter? 239
What Is a Status? 240
Level 1 Status Pattern 244
Why Do We Need This Pattern? 245
How Does This Pattern Work? 246
When Should This Pattern Be Used? 251
What Are the Weaknesses of the Pattern? 253
Synopsis 253
Level 2 Status Pattern, Current Status 254
Why Do We Need This Pattern? 255
How Does This Pattern Work? 255
When Should This Pattern Be Used? 260
What Are the Weaknesses of the Pattern? 260
Synopsis 261
Level 3 Status Pattern 261
Why Do We Need This Pattern? 261
How Does This Pattern Work? 262
When Should This Pattern Be Used? 267
What Are the Weaknesses of the Pattern? 267
Synopsis 268
Level 4 Status Pattern 269
Why Do We Need This Pattern? 269
How Does This Pattern Work? 269
When Should This Pattern Be Used? 277
What Are the Weaknesses of the Pattern? 278
Synopsis 279
Status Category Pattern 280
Why Do We Need This Pattern? 280
How Does This Pattern Work? 280
When Should This Pattern Be Used? 282
What Are the Weaknesses of the Pattern? 285
Synopsis 285
Status Type with Multi Rollup and Rules Pattern 286
Why Do We Need This Pattern? 286
How Does This Pattern Work? 287
When Should This Pattern Be Used? 293
What Are the Weaknesses of the Pattern? 294
Synopsis 294
Summary of Patterns 294
References 301
Chapter 7 Contact Mechanisms: How to Get in Touch 303
What Is the Significance of This Type of Pattern? 303
What Is in This Chapter? 304
What Is a Contact Mechanism? 305
Level 1 Contact Mechanism Pattern 308
Why Do We Need This Pattern? 309
How Does This Pattern Work? 310
When Should This Pattern Be Used? 321
What Are the Weaknesses of the Pattern? 322
Synopsis 323
Level 2 Contact Mechanism Pattern 324
Why Do We Need This Pattern? 325
How Does This Pattern Work? 325
When Should This Pattern Be Used? 342
What Are the Weaknesses of the Pattern? 343
Synopsis 344
Level 3 Contact Mechanism Pattern 345
Why Do We Need This Pattern? 346
How Does This Pattern Work? 346
When Should This Pattern Be Used? 361
What Are the Weaknesses of the Pattern? 361
Synopsis 362
Level 4 Contact Mechanism Pattern 364
Why Do We Need This Pattern? 364
How Does This Pattern Work? 364
When Should This Pattern Be Used? 378
What Are the Weaknesses of the Pattern? 378
Synopsis 379
Contact Mechanism Pattern with Geographic Boundary 380
Why Do We Need This Pattern? 381
How Does This Pattern Work? 384
When Should This Pattern Be Used? 389
What Are the Weaknesses of the Pattern? 390
Synopsis 390
Contact Mechanism with Flexible Address Parts Pattern 391
Why Do We Need This Pattern? 393
How Does This Pattern Work? 394
When Should This Pattern Be Used? 398
What Are the Weaknesses of the Pattern? 398
Synopsis 399
Other Common Contact Mechanism Data 399
Non-Solicitation 400
Instructions 401
Directions 402
Telephone Extensions 402
Synopsis 403
Summary of Patterns 403
References 410
Chapter 8 Business Rules: How Things Should...
| Erscheinungsjahr: | 2008 |
|---|---|
| Genre: | Importe, Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| ISBN-13: | 9780470178454 |
| ISBN-10: | 0470178450 |
| Sprache: | Englisch |
| Herstellernummer: | 14517845000 |
| Einband: | Kartoniert / Broschiert |
| Autor: |
Silverston, Len
Agnew, Paul |
| Hersteller: |
Wiley
John Wiley & Sons |
| Verantwortliche Person für die EU: | Libri GmbH, Europaallee 1, D-36244 Bad Hersfeld, gpsr@libri.de |
| Maße: | 235 x 191 x 35 mm |
| Von/Mit: | Len Silverston (u. a.) |
| Erscheinungsdatum: | 01.12.2008 |
| Gewicht: | 1,18 kg |
Ähnliche Produkte
Lieferzeit 1-2 Wochen
Lieferzeit 2-4 Werktage
Lieferzeit 1-2 Wochen
Lieferzeit 1-2 Wochen
Lieferzeit 1-2 Wochen
Lieferzeit 1-2 Wochen
