Rod Stephens

Beginning Database Design Solutions (eBook, PDF)

Understanding and Implementing Database Design Concepts for the Cloud and Beyond

• Format: PDF

Produktbeschreibung

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.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons
• Seitenzahl: 736
• Erscheinungstermin: 22. Februar 2023
• Englisch
• ISBN-13: 9781394155842
• Artikelnr.: 67516419

Autorenporträt

ROD STEPHENS is a professional programmer, sought-after technical speaker, instructor, and author. He's written 37 books and over 250 magazine articles on C#, Java, and other programming languages. He runs the popular C# Helper and VB Helper websites which have helped millions of programmers with tips, tricks, and useful example code.

Inhaltsangabe

Introduction xxv

Part 1: Introduction to Databases and Database Design

Chapter 1: Database Design Goals 3

The Importance of Design 4

Information Containers 6

Strengths and Weaknesses of Information Containers 8

Desirable Database Features 9

Crud 10

Retrieval 10

Consistency 11

Validity 11

Easy Error Correction 12

Speed 13

Atomic Transactions 13

Acid 14

Base 16

NewSQL 17

Persistence and Backups 17

Low Cost and Extensibility 18

Ease of Use 19

Portability 19

Security 20

Sharing 21

Ability to Perform Complex Calculations 21

CAP Theorem 22

Cloud Considerations 22

Legal and Security Considerations 23

Consequences of Good and Bad Design 24

Summary 26

Chapter 2: Relational Overview 29

Picking a Database 30

Relational Points of View 31

Table, Rows, and Columns 32

Relations, Attributes, and Tuples 34

Keys 34

Indexes 36

Constraints 37

Domain Constraints 37

Check Constraints 37

Primary Key Constraints 38

Unique Constraints 38

Foreign Key Constraints 38

Database Operations 40

Popular RDBs 41

Spreadsheets 43

Summary 44

Chapter 3: NoSQL OVERVIEW 47

The Cloud 47

Picking a Database 50

NoSQL Philosophy 50

NoSQL Databases 50

Document Databases 51

Key- Value Database 52

Column- Oriented Databases 53

Graph Databases 53

Street Networks 54

Communication Networks 55

Social Media Apps 55

E- Commerce Programs 55

Algorithms 56

Hierarchical Databases 56

Less Exotic Options 59

Flat Files 59

XML Files 60

XML Basics 61

XML Practices 64

XML Summary 66

JSON Files 67

Spreadsheets 69

More Exotic Options 70

Object 70

Deductive 70

Dimensional 70

Temporal 71

Database Pros and Cons 72

Relational 72

General NoSQL 73

Quick Guidelines 74

Summary 76

Part 2: Database Design Process and Techniques

Chapter 4: Understanding User Needs 83

Make a Plan 84

Bring a List of Questions 85

Functionality 85

Data Needs 86

Data Integrity 86

Security 87

Environment 88

Meet the Customers 88

Learn Who's Who 89

Pick the Customers' Brains 93

Walk a Mile in the User's Shoes 93

Study Current Operations 94

Brainstorm 94

Look to the Future 95

Understand the Customers' Reasoning 96

Learn What the Customers Really Need 97

Prioritize 98

Verify Your Understanding 99

Create the Requirements Document 101

Make Use Cases 102

Decide Feasibility 106

Summary 106

Chapter 5: Translating User Needs Into Data Models 111

What Are Data Models? 112

User Interface Models 114

Semantic Object Models 118

Classes and Objects 119

Cardinality 120

Identifiers 120

Putting It Together 121

Semantic Views 122

Class Types 124

Simple Objects 124

Composite Objects 124
&n