{"product_id":"the-data-model-resource-book-isbn-9780470178454","title":"The Data Model Resource Book","description":"This third volume of the best-selling \"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.  \u003cp\u003e\u003cb\u003e \u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eForeword xxv\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Introduction 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhy Is There a Need for This Book? 1\u003c\/p\u003e \u003cp\u003eExtending the Discipline of Data Modeling 4\u003c\/p\u003e \u003cp\u003eWhat Is a Pattern and What Is a Universal Pattern? 5\u003c\/p\u003e \u003cp\u003eWhat Is the Significance of Patterns? 6\u003c\/p\u003e \u003cp\u003eApproach of This Book 6\u003c\/p\u003e \u003cp\u003eThe Different Pattern Levels 7\u003c\/p\u003e \u003cp\u003eWho Is the Intended Audience for This Book? 14\u003c\/p\u003e \u003cp\u003eWhat Is in This Book 15\u003c\/p\u003e \u003cp\u003eOther Patterns for Data Modeling 17\u003c\/p\u003e \u003cp\u003eConventions and Standards Used in This Book 18\u003c\/p\u003e \u003cp\u003eEntities 18\u003c\/p\u003e \u003cp\u003eSubtypes and Supertypes 19\u003c\/p\u003e \u003cp\u003eAttributes 20\u003c\/p\u003e \u003cp\u003eRelationships 22\u003c\/p\u003e \u003cp\u003eRelationship Optionality 23\u003c\/p\u003e \u003cp\u003eRelationship Cardinality 25\u003c\/p\u003e \u003cp\u003eForeign Key Relationships 26\u003c\/p\u003e \u003cp\u003eAssociative Entities to Handle Many-to-Many Relationships 26\u003c\/p\u003e \u003cp\u003eExclusive Arcs 27\u003c\/p\u003e \u003cp\u003eExample Data in Illustration Tables 28\u003c\/p\u003e \u003cp\u003eData Modeling Notation 29\u003c\/p\u003e \u003cp\u003eSummary 33\u003c\/p\u003e \u003cp\u003eReferences 33\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Setting Up Roles: What Parties Do 35\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is the Significance of This Type of Pattern? 36\u003c\/p\u003e \u003cp\u003eWhat Is in This Chapter? 36\u003c\/p\u003e \u003cp\u003eWhat Is a Declarative Role? 37\u003c\/p\u003e \u003cp\u003eLevel 1 Declarative Role Pattern 38\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 40\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 41\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 44\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 45\u003c\/p\u003e \u003cp\u003eSynopsis 46\u003c\/p\u003e \u003cp\u003eLevel 2 Declarative Role Pattern 47\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 48\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 48\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 53\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 54\u003c\/p\u003e \u003cp\u003eSynopsis 55\u003c\/p\u003e \u003cp\u003eLevel 3 Declarative Role Pattern 56\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 56\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 57\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 63\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 64\u003c\/p\u003e \u003cp\u003eSynopsis 65\u003c\/p\u003e \u003cp\u003eSummary of Patterns 65\u003c\/p\u003e \u003cp\u003eReferences 69\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Using Roles: How Parties Are Involved 71\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is the Significance of This Type of Pattern? 72\u003c\/p\u003e \u003cp\u003eWhat Is in This Chapter? 72\u003c\/p\u003e \u003cp\u003eWhat Is a Contextual Role? 73\u003c\/p\u003e \u003cp\u003eLevel 1 Contextual Role Pattern, Attributes 74\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 74\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 76\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 78\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 79\u003c\/p\u003e \u003cp\u003eSynopsis 80\u003c\/p\u003e \u003cp\u003eLevel 1 Contextual Role Pattern, Relationships 80\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 81\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 81\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 87\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 87\u003c\/p\u003e \u003cp\u003eSynopsis 88\u003c\/p\u003e \u003cp\u003eLevel 2 Contextual Role Pattern 88\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 89\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 89\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 97\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 98\u003c\/p\u003e \u003cp\u003eSynopsis 99\u003c\/p\u003e \u003cp\u003eLevel 2 Contextual Role Pattern, PARTY Only Alternative 99\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 100\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 100\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 106\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 106\u003c\/p\u003e \u003cp\u003eSynopsis 107\u003c\/p\u003e \u003cp\u003eLevel 3 Contextual Role Pattern 107\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 108\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 108\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 114\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 115\u003c\/p\u003e \u003cp\u003eSynopsis 116\u003c\/p\u003e \u003cp\u003eHybrid Contextual Role Pattern 117\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 117\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 118\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 123\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 123\u003c\/p\u003e \u003cp\u003eSynopsis 124\u003c\/p\u003e \u003cp\u003eSummary of Patterns 124\u003c\/p\u003e \u003cp\u003eReferences 131\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Hierarchies, Aggregations, and Peer-to-Peer Relationships: The Organization of Similar Data 133\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is the Significance of This Type of Pattern? 133\u003c\/p\u003e \u003cp\u003eWhat Is in This Chapter? 134\u003c\/p\u003e \u003cp\u003eWhat Is a Recursive Relationship and How Is Data Organized by Recursive Relationships? 134\u003c\/p\u003e \u003cp\u003eLevel 1 Recursive Pattern 138\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 138\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 139\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 144\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 145\u003c\/p\u003e \u003cp\u003eSynopsis 145\u003c\/p\u003e \u003cp\u003eLevel 2 Recursive Pattern 146\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 146\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 147\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 152\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 153\u003c\/p\u003e \u003cp\u003eSynopsis 154\u003c\/p\u003e \u003cp\u003eLevel 2 Expanded Recursive Pattern 155\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 155\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 156\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 162\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 162\u003c\/p\u003e \u003cp\u003eSynopsis 163\u003c\/p\u003e \u003cp\u003eLevel 3 Recursive Pattern 164\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 165\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 165\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 170\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 171\u003c\/p\u003e \u003cp\u003eSynopsis 172\u003c\/p\u003e \u003cp\u003eLevel 3 Recursive Pattern with Rules 173\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 173\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 174\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 179\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 180\u003c\/p\u003e \u003cp\u003eSynopsis 180\u003c\/p\u003e \u003cp\u003eSummary of Patterns 180\u003c\/p\u003e \u003cp\u003eReferences 186\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Types and Categories: the Classification of Data 187\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is the Significance of This Type of Pattern? 187\u003c\/p\u003e \u003cp\u003eWhat Is in This Chapter? 188\u003c\/p\u003e \u003cp\u003eWhat Are Types, Categorizations, and Taxonomies? 189\u003c\/p\u003e \u003cp\u003eLevel 1 Classification Pattern 190\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 190\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 190\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 195\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 196\u003c\/p\u003e \u003cp\u003eSynopsis 197\u003c\/p\u003e \u003cp\u003eLevel 2 Classification Pattern 197\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 197\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 198\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 205\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 206\u003c\/p\u003e \u003cp\u003eSynopsis 207\u003c\/p\u003e \u003cp\u003eLevel 3 Classification Pattern 208\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 208\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 208\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 219\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 220\u003c\/p\u003e \u003cp\u003eSynopsis 221\u003c\/p\u003e \u003cp\u003eLevel 3 Classification Pattern with Rollups and Schemes 222\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 222\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 223\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 229\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 230\u003c\/p\u003e \u003cp\u003eSynopsis 230\u003c\/p\u003e \u003cp\u003eSummary of Patterns 230\u003c\/p\u003e \u003cp\u003eReferences 235\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Status: The States of Data 237\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is the Significance of This Type of Pattern? 238\u003c\/p\u003e \u003cp\u003eWhat Is in This Chapter? 239\u003c\/p\u003e \u003cp\u003eWhat Is a Status? 240\u003c\/p\u003e \u003cp\u003eLevel 1 Status Pattern 244\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 245\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 246\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 251\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 253\u003c\/p\u003e \u003cp\u003eSynopsis 253\u003c\/p\u003e \u003cp\u003eLevel 2 Status Pattern, Current Status 254\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 255\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 255\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 260\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 260\u003c\/p\u003e \u003cp\u003eSynopsis 261\u003c\/p\u003e \u003cp\u003eLevel 3 Status Pattern 261\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 261\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 262\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 267\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 267\u003c\/p\u003e \u003cp\u003eSynopsis 268\u003c\/p\u003e \u003cp\u003eLevel 4 Status Pattern 269\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 269\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 269\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 277\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 278\u003c\/p\u003e \u003cp\u003eSynopsis 279\u003c\/p\u003e \u003cp\u003eStatus Category Pattern 280\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 280\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 280\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 282\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 285\u003c\/p\u003e \u003cp\u003eSynopsis 285\u003c\/p\u003e \u003cp\u003eStatus Type with Multi Rollup and Rules Pattern 286\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 286\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 287\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 293\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 294\u003c\/p\u003e \u003cp\u003eSynopsis 294\u003c\/p\u003e \u003cp\u003eSummary of Patterns 294\u003c\/p\u003e \u003cp\u003eReferences 301\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Contact Mechanisms: How to Get in Touch 303\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is the Significance of This Type of Pattern? 303\u003c\/p\u003e \u003cp\u003eWhat Is in This Chapter? 304\u003c\/p\u003e \u003cp\u003eWhat Is a Contact Mechanism? 305\u003c\/p\u003e \u003cp\u003eLevel 1 Contact Mechanism Pattern 308\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 309\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 310\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 321\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 322\u003c\/p\u003e \u003cp\u003eSynopsis 323\u003c\/p\u003e \u003cp\u003eLevel 2 Contact Mechanism Pattern 324\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 325\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 325\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 342\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 343\u003c\/p\u003e \u003cp\u003eSynopsis 344\u003c\/p\u003e \u003cp\u003eLevel 3 Contact Mechanism Pattern 345\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 346\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 346\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 361\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 361\u003c\/p\u003e \u003cp\u003eSynopsis 362\u003c\/p\u003e \u003cp\u003eLevel 4 Contact Mechanism Pattern 364\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 364\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 364\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 378\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 378\u003c\/p\u003e \u003cp\u003eSynopsis 379\u003c\/p\u003e \u003cp\u003eContact Mechanism Pattern with Geographic Boundary 380\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 381\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 384\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 389\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 390\u003c\/p\u003e \u003cp\u003eSynopsis 390\u003c\/p\u003e \u003cp\u003eContact Mechanism with Flexible Address Parts Pattern 391\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 393\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 394\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 398\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 398\u003c\/p\u003e \u003cp\u003eSynopsis 399\u003c\/p\u003e \u003cp\u003eOther Common Contact Mechanism Data 399\u003c\/p\u003e \u003cp\u003eNon-Solicitation 400\u003c\/p\u003e \u003cp\u003eInstructions 401\u003c\/p\u003e \u003cp\u003eDirections 402\u003c\/p\u003e \u003cp\u003eTelephone Extensions 402\u003c\/p\u003e \u003cp\u003eSynopsis 403\u003c\/p\u003e \u003cp\u003eSummary of Patterns 403\u003c\/p\u003e \u003cp\u003eReferences 410\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Business Rules: How Things Should Work 411\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is the Significance of This Type of Pattern? 411\u003c\/p\u003e \u003cp\u003eWhat Is in This Chapter? 414\u003c\/p\u003e \u003cp\u003eWhat Is a Business Rule? 415\u003c\/p\u003e \u003cp\u003eLevel 2 Business Rules Pattern 417\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 417\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 419\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 442\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 444\u003c\/p\u003e \u003cp\u003eSynopsis 444\u003c\/p\u003e \u003cp\u003eLevel 3 Business Rules Pattern 446\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 446\u003c\/p\u003e \u003cp\u003eHow Does This Pattern Work? 447\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 460\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 461\u003c\/p\u003e \u003cp\u003eSynopsis 461\u003c\/p\u003e \u003cp\u003eBusiness Rules with Party Roles 462\u003c\/p\u003e \u003cp\u003eWhy Do We Need This Pattern? 462\u003c\/p\u003e \u003cp\u003eHow Do These Patterns Work? 463\u003c\/p\u003e \u003cp\u003eWhen Should This Pattern Be Used? 465\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of the Pattern? 465\u003c\/p\u003e \u003cp\u003eSynopsis 465\u003c\/p\u003e \u003cp\u003eSummary of Patterns 465\u003c\/p\u003e \u003cp\u003eReferences 468\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Using the Patterns 469\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is in This Chapter? 470\u003c\/p\u003e \u003cp\u003eThe Scenario 471\u003c\/p\u003e \u003cp\u003ePrototype Models, Scope Statements 472\u003c\/p\u003e \u003cp\u003eThe Scenario for These Models 472\u003c\/p\u003e \u003cp\u003eHow Do These Models Work? 473\u003c\/p\u003e \u003cp\u003eWhy Do We Do It This Way? 478\u003c\/p\u003e \u003cp\u003eWhat Are the Strengths of Using Patterns for the Solution? 481\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of Using Patterns for the Solution? 482\u003c\/p\u003e \u003cp\u003eSynopsis 483\u003c\/p\u003e \u003cp\u003eApplication Data Models 483\u003c\/p\u003e \u003cp\u003eThe Scenario for This Model 484\u003c\/p\u003e \u003cp\u003eHow Do These Models Work? 484\u003c\/p\u003e \u003cp\u003eWhy Do We Do It This Way? 488\u003c\/p\u003e \u003cp\u003eWhat Are the Strengths of Using Patterns for the Solution? 490\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of Using Patterns for the Solution? 491\u003c\/p\u003e \u003cp\u003eSynopsis 492\u003c\/p\u003e \u003cp\u003eEnterprise Data Models 492\u003c\/p\u003e \u003cp\u003eThe Scenario for This Model 495\u003c\/p\u003e \u003cp\u003eHow Do These Models Work? 498\u003c\/p\u003e \u003cp\u003eWhy Do We Do It This Way? 501\u003c\/p\u003e \u003cp\u003eWhat Are the Strengths of Using Patterns for the Solution? 501\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of Using Patterns for the Solution? 502\u003c\/p\u003e \u003cp\u003eSynopsis 502\u003c\/p\u003e \u003cp\u003eData Warehouse Models 503\u003c\/p\u003e \u003cp\u003eThe Scenario for This Model 504\u003c\/p\u003e \u003cp\u003eData Warehouse Data Models — Relational Approach 506\u003c\/p\u003e \u003cp\u003eHow Do These Models Work? 507\u003c\/p\u003e \u003cp\u003eWhy Do We Do It This Way? 513\u003c\/p\u003e \u003cp\u003eWhat Are the Strengths of Using Patterns for the Solution? 514\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of Using Patterns for the Solution? 515\u003c\/p\u003e \u003cp\u003eSynopsis 515\u003c\/p\u003e \u003cp\u003eData Warehouse\/Data Mart Data Models — Star Schemas 516\u003c\/p\u003e \u003cp\u003eHow Do These Models Work? 516\u003c\/p\u003e \u003cp\u003eWhy Do We Do It This Way? 527\u003c\/p\u003e \u003cp\u003eWhat Are the Strengths of Using Patterns for the Solution? 528\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of Using Patterns for the Solution? 529\u003c\/p\u003e \u003cp\u003eSynopsis 530\u003c\/p\u003e \u003cp\u003eMaster Data Management 530\u003c\/p\u003e \u003cp\u003eThe Scenario for This Model 530\u003c\/p\u003e \u003cp\u003eHow Does This Model Work? 534\u003c\/p\u003e \u003cp\u003eWhy Do We Do It This Way? 543\u003c\/p\u003e \u003cp\u003eWhat Are the Strengths of Using Patterns for the Solution? 544\u003c\/p\u003e \u003cp\u003eWhat Are the Weaknesses of Using Patterns for the Solution? 545\u003c\/p\u003e \u003cp\u003eSynopsis 545\u003c\/p\u003e \u003cp\u003eOther Thoughts Regarding Using the Patterns 546\u003c\/p\u003e \u003cp\u003ePhysical Database Design 546\u003c\/p\u003e \u003cp\u003eOther Applications for Patterns 547\u003c\/p\u003e \u003cp\u003eOther Considerations When Using Generalized Patterns 547\u003c\/p\u003e \u003cp\u003eSummary of Using the Patterns 548\u003c\/p\u003e \u003cp\u003eReferences 552\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Socializing the Patterns 553\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is the Significance of Socializing the Patterns? 554\u003c\/p\u003e \u003cp\u003eWhat Is in This Chapter? 554\u003c\/p\u003e \u003cp\u003eExperiences Using and Socializing These Patterns 555\u003c\/p\u003e \u003cp\u003eWhat Makes the Difference In Socializing the Patterns? 558\u003c\/p\u003e \u003cp\u003eUnderstanding Motivations — Why Would Someone Use or Not Use the Patterns? 559\u003c\/p\u003e \u003cp\u003eCreating a Clear, Common, Compelling Purpose and Vision for Using the Patterns 566\u003c\/p\u003e \u003cp\u003eDeveloping Trust so People Can Rely on the Patterns 569\u003c\/p\u003e \u003cp\u003eManaging Resistance and\/or Conflict Regarding Patterns 573\u003c\/p\u003e \u003cp\u003eOther Comments about Socializing the Patterns 580\u003c\/p\u003e \u003cp\u003ePatterns May Need to Be Socialized in Many Types of Circumstances 581\u003c\/p\u003e \u003cp\u003eWhat about Upper-Level Management Commitment? 581\u003c\/p\u003e \u003cp\u003eWhat Is the Return on Investment Regarding Using These Patterns? 582\u003c\/p\u003e \u003cp\u003eSummary 584\u003c\/p\u003e \u003cp\u003eReferences 585\u003c\/p\u003e \u003cp\u003eIndex 587\u003c\/p\u003e  \u003cb\u003eLen Silverston\u003c\/b\u003e is the best-selling author of The Data Model Resource Book (Volumes 1 and 2), a speaker and data management consultant with more than 25 years of experience helping organizations integrate their information and systems. He is the owner and president of Universal Data Models, LLC.  \u003cp\u003e\u003cb\u003ePaul Agnew\u003c\/b\u003e 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 (www.universaldatamodels.com).\u003c\/p\u003e  \u003cp\u003e\"Universal Patterns for Data Modeling is essential reading for anyone undertaking commercial data modeling. The Data Model Resource Book series represents the most important contribution to the data modeling discipline in the last decade.\"\u003cbr\u003e —Dr. Graeme Simsion, author of Data Modeling Essentials and Data Modeling Theory and Practice\u003c\/p\u003e \u003cp\u003eThis 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.\u003c\/p\u003e \u003cp\u003eFor 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:\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eModel the most prevalent data modeling constructs such as ways to model roles, hierarchies, classifications, statuses, contact information, and business rules\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eRe-use a powerful library of core patterns for data modeling\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eModel at different levels of generalization\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eEvaluate the pros and cons of specific versus generalized models\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eApply the patterns in many types of data modeling efforts, such as prototypes, applications, enterprise data models, data warehouses, and master data management efforts\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eGain buy-in regarding the use of patterns and\/or standardizing on these patterns\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47990203842789,"sku":"NP9780470178454","price":79.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470178454.jpg?v=1761786893","url":"https:\/\/k12savings.com\/products\/the-data-model-resource-book-isbn-9780470178454","provider":"K12savings","version":"1.0","type":"link"}