- ホーム
- > 洋書
- > 英文書
- > Computer / General
Full Description
A concise introduction to database design concepts, methods, and techniques in and out of the cloud
In the newly revised second edition of Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition, award-winning programming instructor and mathematician Rod Stephens delivers an easy-to-understand guide to designing and implementing databases both in and out of the cloud. Without assuming any prior database design knowledge, the author walks you through the steps you'll need to take to understand, analyze, design, and build databases.
In the book, you'll find clear coverage of foundational database concepts along with hands-on examples that help you practice important techniques so you can apply them to your own database designs, as well as:
Downloadable source code that illustrates the concepts discussed in the book
Best practices for reliable, platform-agnostic database design
Strategies for digital transformation driven by universally accessible database design
An essential resource for database administrators, data management specialists, and database developers seeking expertise in relational, NoSQL, and hybrid database design both in and out of the cloud, Beginning Database Design Solutions is a hands-on guide ideal for students and practicing professionals alike.
Contents
Introduction xxv
Part 1: Introduction to Databases and Database Design
Chapter 1: Database Design Goals 3
Chapter 2: Relational Overview 29
Chapter 3: NoSQL OVERVIEW 47
Part 2: Database Design Process and Techniques
Chapter 4: Understanding User Needs 83
Chapter 5: Translating User Needs Into Data Models 111
Chapter 6: Extracting Business Rules 145
Chapter 7: Normalizing Data 163
Chapter 8: Designing Databases to Support Software 203
Chapter 9: Using Common Design Patterns 215
Chapter 10: Avoiding Common Design Pitfalls 241
Part 3: a Detailed Case Study
Chapter 11: Defining User Needs and Requirements 263
Chapter 12: Building a Data Model 283
Chapter 13: Extracting Business Rules 303
Chapter 14: Normalizing and Refining 313
Part 4: Example Programs
Chapter 15: Example Overview 327
Chapter 16: MariaDB IN PYTHON 339
Chapter 17: MariaDB IN C# 355
Chapter 18: PostgreSQL IN PYTHON 369
Chapter 19: PostgreSQL IN C# 389
Chapter 20: Neo4j AuraDB IN PYTHON 401
Chapter 21: Neo4j AuraDB IN C# 417
Chapter 22: MongoDB ATLAS IN PYTHON 431
Chapter 23: MongoDB ATLAS IN C# 453
Chapter 24: Apache Ignite in Python 467
Chapter 25: Apache Ignite in C# 477
Part 5: Advanced Topics
Chapter 26: Introduction to Sql 489
Chapter 27: Building Databases with Sql Scripts 519
Chapter 28: Database Maintenance 533
Chapter 29: Database Security 545
Appendix A: Exercise Solutions 557
Appendix B: Sample Relational Designs 649
Glossary 671
Index 683
