Modern Data Stores
Where data lives: OLTP and OLAP, warehouses and lakehouses, NoSQL, streaming, vector databases and how to choose.
- Lesson 1
Start here: Modern Data Stores
Modern data management encompasses a diverse ecosystem of specialized technologies, ranging from document-based platforms like MongoDB to high-performance analytic engines like ClickHouse.
- Lesson 2
OLTP vs OLAP
Why transactional (OLTP) and analytical (OLAP) databases are built so differently, from row versus column storage to how each runs queries.
- Lesson 3
Warehouse vs Lake vs Lakehouse
Warehouses, data lakes and lakehouses compared, and how open table formats like Apache Iceberg and Delta bring database features to files on S3.
- Lesson 4
NoSQL Families
Modern distributed databases and key-value stores, such as Amazon DynamoDB, Redis, ScyllaDB, MongoDB, PostgreSQL, and Neo4j, utilize diverse architecture patterns and data modeling strategies to achieve high…
- Lesson 5
Streaming and Event-Driven Data
Modern data architectures increasingly rely on event streaming and change data capture to synchronize and process information across distributed systems.
- Lesson 6
Vector Databases
How vector databases store and search embeddings, how their indexes trade accuracy for speed, and when Postgres with pgvector is enough.
- Lesson 7
Running Data Stores in Production
What goes wrong once a database is live: replication, failover, backups and concurrency, and how distributed databases fail in production.
- Lesson 8
Choosing a Data Store
Modern data architecture requires balancing system stability and operational simplicity against the desire for advanced technical features.