Read more
Informationen zum Autor Len Silverston 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. 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 (www.universaldatamodels.com). Klappentext "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."-Dr. Graeme Simsion, author of Data Modeling Essentials and Data Modeling Theory and PracticeThis 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 Zusammenfassung Learn how to customize existing data models and create new data models with the information in The Data Model Resource Book: Universal Patterns for Data Modeling, Volume 3, a guide to universal data patterns that are applicable across a wide variety of organizations. Inhaltsverzeichnis 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 Refere...
