A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 an

石头

作者：Eric Johnson, Joshua Jones
出版日期：July 4, 2008
出版社：Addison Wesley
页数：304
ISBN：ISBN-10: 0321497643 ISBN-13: 978-0321497642
文件格式：PDF


Product Description
“Eric and Joshua do an excellent job explaining the importance of datamodeling and how to do it correctly. Rather than relying only onacademic concepts, they use real-world examples to illustrate theimportant concepts that many database and application developers tendto ignore. The writing style is conversational and accessible to bothdatabase design novices and seasoned pros alike. Readers who areresponsible for designing, implementing, and managing databases willbenefit greatly from Joshua’s and Eric’s expertise.”
—Anil Desai, Consultant, Anil Desai, Inc.
“Almost every IT project involves data storage of some kind, and formost that means a relational database management system (RDBMS). Thisbook is written for a database-centric audience (database modelers,architects, designers, developers, etc.). The authors do a great job ofshowing us how to take a project from its initial stages ofrequirements gathering all the way through to implementation. Along theway we learn how to handle some of the real-world design issues thattypically surface as we go through the process.
“The bottom line here is simple. This is the book you want to havejust finished reading when your boss says ‘We have a new project Iwould like your help with.’”
—Ronald Landers, Technical Consultant, IT Professionals, Inc.
“The Data Model is the foundation of the application. I’m pleased tosee additional books being written to address this critical phase. Thisbook presents a balanced and pragmatic view with the right prioritiesto get your SQL server project off to a great start and a long life.”
—Paul Nielsen, SQL Server MVP, SQLServerBible.com
“This is a truly excellent introduction to the database designmethodology that will work for both novices and advanced designers. Theauthors do a good job at explaining the basics of relational databasemodeling and how they fit into modern business architecture. This bookteaches us how to identify the business problems that have to besatisfied by a database and then proceeds to explain how to build asolid solution from scratch.”
—Alexzander N. Nepomnjashiy, Microsoft SQL Server DBA, NeoSystems North-West, Inc.
“A Developer’s Guide to Data Modeling for SQL Serverexplains the concepts and practice of data modeling with a clarity thatmakes the technology accessible to anyone building databases anddata-driven applications.
“Eric Johnson and Joshua Jones combine a deep understanding of thescience of data modeling with the art that comes with years ofexperience. If you’re new to data modeling, or find the need to brushup on its concepts, this book is for you.”
—Peter Varhol, Executive Editor, Redmond Magazine
Model SQL Server Databases That Work Better, Do More, and Evolve More Smoothly
Effective data modeling is essential to ensuring that your databaseswill perform well, scale well, and evolve to meet changingrequirements. However, if you’re modeling databases to run on MicrosoftSQL Server 2008 or 2005, theoretical or platform-agnostic data modelingknowledge isn’t enough: models that don’t reflect SQL Server’s uniquereal-world strengths and weaknesses often lead to disastrousperformance.
A Developer’s Guide to Data Modeling for SQL Server isa practical, SQL Server-specific guide to data modeling for everydeveloper, architect, and administrator. This book offers youinvaluable start-to-finish guidance for designing new databases,redesigning existing SQL Server data models, and migrating databasesfrom other platforms.
You’ll begin with a concise, practical overview of the core datamodeling techniques. Next, you’ll walk through requirements gatheringand discover how to convert requirements into effective SQL Serverlogical models. Finally, you’ll systematically transform those logicalmodels into physical models that make the most of SQL Server’s extendedfunctionality. All of this book’s many examples are available fordownload 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 and constraints
• Use SQL Server’s unique indexing capabilities, and overcome their limitations
• Create abstraction layers that enhance security, extensibility, and flexibility

About the Author
Eric Johnson (Microsoft SQL MVP)is the co-founder ofConsortio Services and the primary database technologies consultant.His background in information technology is diverse, ranging fromoperating systems and hardware to specialized applications anddevelopment. He has even done his fair share of work on networks.Because IT is a way to support business processes, Eric has alsoacquired an MBA. All in all, he has ten years of experience with IT,much of it working with Microsoft SQL Server. Eric has managed anddesigned databases of all shapes and sizes. He has delivered numerousSQL Server training classes and Webcasts as well as presentations atnational technology conferences. Most recently, he presented atTechMentor on SQL Server 2005 replication, reporting services, andintegration services. In addition, he is active in the local SQL Servercommunity, serving as the president of the Colorado Springs SQL ServerUsers Group. He is also the co-host of CS Techcast, a weekly podcast for IT professionals at www.cstechcast.com. You can find Eric’s blog at www.consortioservices.com/blog.
Joshua Jones (MCTS, SQL Server 2005; MCITP,Database Administrator) is operating systems and database systemsconsultant with Consortio Services in Colorado Springs. There heprovides training, administration, analysis, and design support forcustomers using SQL Server 2000 and 2005. In his seven years as an ITprofessional, he has worked in many areas of information technology,including Windows desktop support, Windows 2000 and 2003 serverinfrastructure design and support (AD, DNS, MS Exchange), telephonyswitch support, and network support. Josh has spoken at various PASSsponsored events about SQL Server topics such as 64-bit SQL Serverimplementation, reporting services administration, and performancetuning. He is also a co-host of CS Techcast, a weekly podcast for IT professionals at www.cstechcast.com.

Jamesliu2009