A developer's guide to data modeling for SQL server: covering SQL server 2005 and 2008
(PDF 英文版)
By Eric Johnson, Joshua Jones
Published: Jun 24, 2008 (Addison-Wesley Professional)
Pages: 304
ISBN-10: 0-321-49764-3
ISBN-13: 978-0-321-49764-2
Model SQL Server Databases That Work Better, Do More, and Evolve More Smoothly
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 and constraints
Use SQL Server’s unique indexing capabilities, and overcome their limitations
Create abstraction layers that enhance security, extensibility, and flexibility
详细介绍在此:http://www.informit.com/store/product.aspx?isbn=0321497643