: Louis Davidson, Kevin Kline, Scott Klein, Kurt Windisch
: Pro SQL Server 2008 Relational Database Design and Implementation
: Apress
: 9781430208679
: 1
: CHF 50.60
:
: Informatik
: English
: 665
: Wasserzeichen/DRM
: PC/MAC/eReader/Tablet
: PDF
Learn effective and scalable database design techniques in a SQL Server environment.Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authorsLouis Davidson,Kev n Kline,Scott Klein, andKurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data.

  • Solid foundation in best practices and relational theory
  • Maximize SQL Server features to enhance security, performance, scalability
  • Thorough treatment from conceptual design to an effective, physical implementation


Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology (Compass.net) in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.
Contents at a Glance5
Contents6
Foreword14
About the Author15
About the Contributing Authors15
About the Technical Reviewers16
Acknowledgments17
Introduction19
Purpose of Database Design20
Structure of This Book21
Introduction to Database Concepts23
Database Design Phases24
Relational Data Structures29
Relationship Between Entities45
Data Access Language (SQL)51
Understanding Dependencies52
Summary54
The Language of Data Modeling55
Introduction to Data Modeling55
Entities57
Attributes60
Relationships68
Descriptive Information83
Alternative Modeling Methodologies84
Best Practices90
Summary91
Conceptual Data Modeling93
Understanding the Requirements94
Documenting the Process95
Requirements Gathering96
Identifying Objects and Processes104
Identifying Business Rules and Processes130
Finishing the Conceptual Model134
Best Practices137
Summary137
The Normalization Process138
Why Normalize?139
How Far to Normalize?141
The Process of Normalization141
Entity and Attribute Shape: First Normal Form142
Relationships Between Attributes155
Multivalued Dependencies in Entities172
Denormalization187
Best Practices188
Summary188
Bonus Example189
The Story of the Book So Far196
Implementing the Base Table Structures197
Reviewing the Logical Design201
Transforming the Design201
Implementing the Design231
Best Practices290
Summary291
Protecting the Integrity of Your Data292
Best Practices293
Automatic Data Protection295
Manual Data Protection349
More Best Practices356
Summary357
Patterns and Query Techniques358
Precalculated Values359
Binary Large Valued Objects (BLOB)376
Storing User-Specified Data379
Commonly Implemented Objects392
Anti-patterns393
Summary402
The Continuing Story of the Book So Far403
Securing Access to the Data404
Principals and Securables406
Database Security Overview407
Controlling Object Access Via T-SQL Coded Objects424
Views and Table-Valued Functions438
Obfuscating Data445
Monitoring and Auditing448
Best Practices462
Summary463
Table Structures and Indexing465
Physical Database Structure466
Indexes Overview478
Basic Index Structure478
Index Types480
Basics of Index Creation486
Basic Index Usage Patterns488
Advanced Index Usage Scenarios505
Best Practices513
Summary514
Coding for Concurrency516
What Is Concurrency?517
Query Optimization Basics518
OS and Hardware Issues521
Transactions522
SQL Server Concurrency Controls539
Coding for Integrity and Concurrency556
Best Practices569
Summary570
Considering Data Access Strategies571
Ad Hoc SQL573
Stored Procedures585
T-SQL and the CLR600
Best Practices608
Summary610
Codd s 12 Rules for an RDBMS611
Rule 1: The Information Rule611
Rule 2: Guaranteed Access Rule612
Rule 3: Systematic Treatment of NULL Values612
Rule 4: Dynamic Online Catalog Based on the Relational Model612
Rule 5: Comprehensive Data Sublanguage Rule613
Rule 6: View Updating Rule613
Rule 7: High-Level Insert, Update, and Delete614
Rule 8: Physical Data Independence614
Rule 9: Logical Data Independence615
Rule 10: Integrity Independence616
Rule 11: Distribution Independence616
Rule 12: Non-Subversion Rule616
Summary617
Scalar Datatype Reference618
Precise Numeric Data620
Date and Time Data628
Character Strings634
Binary Data638
Other Datatypes640
Not Simply Scalar Datatypes648
Index650