Exploring Databases
summary
An introduction to how database systems actually work, covering storage and file organization, indexing, query processing, and transaction management. It then explains distributed database topics — replication, consensus, and coordination — to show architectural and engineering techniques that make databases scalable and performant.
AI-written summary · about
chapters (37)
- 0:00Database intro
- 1:25Clever Cloud context
- 3:11Why many databases exist
- 7:12Data gravity in architectures
- 11:03DB production challenges
- 13:11Shift to data-centric
- 15:20DB university goals
- 16:25Technical layers breakdown
- 17:07What is a DBMS
- 22:25DB history before relational
- 24:56Relational model impact
- 27:01NoSQL emergence
- 29:57NewSQL and distributed DBs
- 32:06Data matrix and hardware
- 33:33Transactions prep
- 36:45How DBs store on disk
- 37:28Disk-based DB architecture
- 41:26Blocks, pages and fragmentation
- 50:28OLTP vs OLAP workloads
- 56:14Storage impact on workloads
- 1:01:19Storage engine role
- 1:02:04Buffer pool acceleration
- 1:04:32Write-ahead log for durability
- 1:07:43Storage and DB summary
- 1:08:49Query engine execution
- 1:12:02Demo: custom query engine with Apache Calcite
- 1:29:02Transactions: ACID explained
- 1:37:39Transaction concurrency summary
- 1:38:44Distributed DB intro
- 1:58:44Leader-follower replication issues
- 2:06:43Consensus: Paxos and Raft
- 2:15:39Data partitioning for scaling
- 2:27:40Modern distributed architectures
- 2:32:18Distributed systems challenges
- 2:36:45Jepsen framework and DB testing
- 2:37:39When to use distributed systems
- 2:38:23Q&A
related talks
53mHow Databases Work
44mThe Only Thing That Matters
49mHow Databases Work - For Developers, Accidental DBA's and Managers
40mFundamentals of relational databases
42mHow to Build a Database-like Application
39mThe base problem
42mThe Only Thing That Matters
19mYour database like you've never seen it before