- ホーム
- > 洋書
- > 英文書
- > Computer / General
Full Description
"A Developer's Guide to Data Modeling for SQL Server explains the concepts and practice of data modeling with a clarity that makes the technology accessible to anyone building databases and data-driven applications."Eric Johnson and Joshua Jones combine a deep understanding of the science of data modeling with the art that comes with years of experience. If you're new to data modeling, or find the need to brush up on its concepts, this book is for you."-Peter Varhol, Executive Editor, Redmond MagazineModel SQL Server Databases That Work Better, Do More, and Evolve More Smoothly Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL Server's unique real-world strengths and weaknesses often lead to disastrous performance. A Developer's Guide to Data Modeling for SQL Server is a practical, SQL Server-specific guide to data modeling for every developer, architect, and administrator. This book offers you invaluable start-to-finish guidance for designing new databases, redesigning existing SQL Server data models, and migrating databases from other platforms. You'll begin with a concise, practical overview of the core data modeling techniques. Next, you'll walk through requirements gathering and discover how to convert requirements into effective SQL Server logical models. Finally, you'll systematically transform those logical models into physical models that make the most of SQL Server's extended functionality. All of this book's many examples are available for download from a companion Web site. This book enables you toUnderstand your data model's physical elements, from storage to referential integrity Provide programmability via stored procedures, user-defined functions, triggers, and .NET CLR integration Normalize data models, one step at a time Gather and interpret requirements more effectively Learn an effective methodology for creating logical models Overcome modeling problems related to entities, attribute, data types, storage overhead, performance, and relationships Create physical models-from establishing naming guidelines through implementing business rules and constraints Use SQL Server's unique indexing capabilities, and overcome their limitations Create abstraction layers that enhance security, extensibility, and flexibility
Contents
Preface xvAcknowledgments xviiAbout the Authors xixPART I: Data Modeling Theory 1Chapter 1: Data Modeling Overview 3Databases 4Why a Sound Data Model Is Important 6Data Consistency 6The Process of Data Modeling 14Summary 21Chapter 2: Elements Used in Logical Data Models 23Entities 23Attributes 24Referential Integrity 32Relationships 35Relationship Types 35Relationship Options 40Cardinality 41Using Subtypes and Supertypes 42Supertypes and Subtypes Defined 42When to Use Subtype Clusters 44Summary 44Chapter 3: Physical Elements of Data Models 45Physical Storage 45Referential Integrity 59Programming 71Implementing Supertypes and Subtypes 75Summary 79PART II: Business Requirements 95Chapter 5: Requirements Gathering 97Requirements Gathering Overview 98Gathering Requirements Step by Step 98Business Needs 111Balancing Technical Limitations with Business Needs 112Gathering Usage Data 112Summary 116Chapter 6: Interpreting Requirements 117Mountain View Music 117Compiling Requirements Data 119Determining Model Requirements 121Determining the Business Rules 138Requirements Documentation 141Looking Ahead: The Business Review 143Summary 145PART III: Creating the Logical Model 147Chapter 7: Creating the Logical Model 149Diagramming a Data Model 149Using Requirements to Build the Model 157Building the Model 164Summary 170Chapter 8: Common Data Modeling Problems 171Entity Problems 171Attribute Problems 176Relationship Problems 182Summary 185PART IV: Creating the Physical Model 187Chapter 9: Creating the Physical Model with SQL Server 189Naming Guidelines 189Deriving the Physical Model 198Implementing Business Rules in the Physical Model 211Summary 219Chapter 10: Indexing Considerations 221Indexing Overview 221Database Usage Requirements 230Determining the Appropriate Indexes 233Implementing Indexes in SQL Server 236Summary 239Chapter 11: Creating an Abstraction Layer in SQL Server 241What Is an Abstraction Layer? 241Why Use an Abstraction Layer? 242An Abstraction Layer's Relationship to the Logical Model 245An Abstraction Layer's Relationship to Object-Oriented Programming 246Implementing an Abstraction Layer 247Summary 254Appendix A: Sample Logical Model 255Appendix B: Sample Physical Model 261Appendix C: SQL Server 2008 Reserved Words 267Appendix D: Recommended Naming Standards 269Index 271
