Table of Contents
Preface
Part 1: Introduction to Databases
1
SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs
Understanding databases and data models
Exploring the relational data model (SQL databases)
Tables, rows, and columns
Normalization
Structured Query Language (SQL)
ACID transactions
Navigating the document data model (NoSQL databases)
Data models in NoSQL
Types of NoSQL databases
Key-value stores
Document stores
Column-family stores
Graph databases
Applying the CAP theorem and NoSQL design choices
Consistency
Availability
Partition tolerance
Consistency models in NoSQL databases
NoSQL design choices and use cases
Managing transaction management and concurrency control in NoSQL
BASE transactions in NoSQL databases
Reasons ...
Get Database Design and Modeling with PostgreSQL and MySQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
