| 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 & weaknesses often lead to disastrous performance.
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 to:
- Understand 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 & constraints;
- Use SQL Server's unique indexing capabilities, and overcome their limitations;
- Create abstraction layers that enhance security, extensibility, and flexibility. | |
