Beginning Database Design Solutions - Understanding Implementing Database Design Concepts for Cloud Beyond

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.

List of contents

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

About the author

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.

Summary

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.

Product details

• Authors: Stephens, R Stephens, Rod Stephens, Rod (C# Helper Stephens, Stephens Rod, Vb Helper)
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 01.05.2023
• EAN: 9781394155729
• ISBN: 978-1-394-15572-9
• No. of pages: 736
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > IT; Statistik, Informatik, Datenanalyse, Statistics, computer science, Datenbankentwurf, data analysis, Database & Data Warehousing Technologies, Datenbanken u. Data Warehousing