作者:Rebecca M. Riordan
出版日期:January 10, 2005
出版社:Addison Wesley
页数:384
ISBN:0-321-29093-3
文件格式:CHM
World-renowned expert Rebecca M. Riordan has written the definitivedatabase design book for working developers who aren't databaseexperts. No matter how messy or complex your business challenge,Designing Effective Database Systems shows you how to design aneffective, high-performance database to solve it.
Riordan begins by thoroughly demystifying the principles ofrelational design, making them accessible to every professionaldeveloper. Next, she offers the field's clearest introduction todimensional database modeling: practical insight for designing today'sincreasingly important analytical applications.
One task at a time, Riordan illuminates every facet of databaseanalysis and design for both OLAP and OLTP, showing how to avoid commonarchitectural pitfalls that complicate development and reduceextensibility. The book concludes with comprehensive, expert guidanceon designing databases for maximum usability. This book will teach youhow to
Understand relational database models, structures, relationships, and data integrity principles
Define database system goals, criteria, scope, and work processes
Construct accurate conceptual models: relationships, entities, domain analysis, and normalization
Build efficient, secure database schema
Master the elements of OLAP design: fact tables, dimension tables, snowflaking, and more
Architect and construct easy, efficient interfaces for querying and reporting
Learn from practice examples based on Microsoft's Northwind sample database
Riordan has helped thousands of professionals master database designand development, earning Microsoft's coveted MVP honor for herexceptional contributions. Nobody's more qualified to help you masterdatabase designand apply it in your real-world environment.