Publisher: Addison-Wesley Professional; 1 book (July 4, 2008)
Language: English
ISBN-10: 0321497643
ISBN-13: 978-0321497642
A Developer’s Guide to Data Modeling for SQL Server is the practical, SQL Server-specific beam to interpretation displaying for each developer, architect, as well as administrator. This book offers we useful start-to-finish superintendence for conceptualizing brand new databases, redesigning existent SQL Server interpretation models, as well as migrating databases from alternative platforms.
You’ll proceed with the concise, unsentimental general outlook of the core interpretation displaying techniques. Next, you’ll travel by mandate entertainment as well as find how to modify mandate in to in effect SQL Server judicious models. Finally, you’ll evenly renovate those judicious models in to earthy models which have the most of SQL Server’s lengthened functionality. All of this book’s most examples have been accessible for download from the messenger Web site.
This book enables we to
Understand your interpretation model’s earthy elements, from storage to referential integrity
Provide programmability around stored procedures, user-defined functions, triggers, as well as .NET CLR integration
Normalize interpretation models, the single step during the time
Gather as well as appreciate mandate some-more effectively
Learn an in effect methodology for formulating judicious models
Overcome displaying problems associated to entities, attribute, interpretation types, storage overhead, performance, as well as relationships
Create earthy models—from substantiating fixing discipline by implementing commercial operation manners as well as constraints
Use SQL Server’s singular indexing capabilities, as well as strike their limitations
Create condensation layers which raise security, extensibility, as well as flexibility
No comments:
Post a Comment