The Data Model Resource Book: Volume 3: Universal Patterns for Data ModelingThis 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.
|
Contents
| 4 | |
| 12 | |
| 14 | |
| 15 | |
| 33 | |
How Does This Pattern Work? 89 | 89 |
When Should This Pattern Be Used? | 97 |
Hybrid Contextual Role Pattern | 117 |
References | 235 |
The States of Data | 237 |
Status Type with Multi Rollup and Rules Pattern | 286 |
References | 301 |
How to Get in Touch | 303 |
Contact Mechanism with Flexible Address Parts Pattern | 391 |
References | 410 |
How Things Should Work | 411 |
References | 131 |
The Organization of Similar Data | 133 |
Expanded Recursive Pattern | 155 |
Recursive Pattern | 164 |
Recursive Pattern with Rules | 173 |
References | 186 |
The Classification of Data | 187 |
Classification Pattern with Rollups and Schemes | 222 |
Using the Patterns | 469 |
Prototype Models Scope Statements | 472 |
Data Warehouse Models | 503 |
Socializing the Patterns | 553 |
| 587 | |
| 589 | |
Other editions - View all
Common terms and phrases
allows Andheri associative entity CATEGORY(s Chapter Classification Pattern CONTACT MECHANISM CATEGORY CONTACT MECHANISM ID Contact Mechanism Pattern CONTACT MECHANISM PURPOSE CONTACT MECHANISM TYPE CONTACT MECHANISM USAGE Contextual Role Pattern create data model structure data professional data requirements data team data warehouse ELECTRONIC ADDRESS email address enterprise data model ENTITY TYPE example Figure flexible foreign key ID ENTITY ID FK ID ID FK)(UID ID ID PK instance Kurla level 1 pattern Level 3 Classification maintain many-to-many many-to-many relationship master data management Mobile Phone NAME CHAR one-to-many ORDER ID PARENT PARTY ROLE Peer-to-Peer Relationships phone number POSTAL ADDRESS POSTAL CODE PRODUCT CATEGORY TYPE PRODUCT TYPE PROJECT LEAD PROJECT WORKER provides Recursive Pattern recursive relationships ROLE TYPE ID ROLLUP RULE FACTOR Ship SHIPMENT specific star schema Status Pattern STATUS TYPE CATEGORY subtypes Table TELECOMMUNICATIONS NUMBER Telephone number THRU DATE TYPE entity TYPE ID ID TYPE(s types of contact XYZ Corporation