对应的书籍章节
lecture | |
---|---|
Course Introduction and the Relational Model | Chapters 1-2 |
Advanced SQL | Chapters 3-5 |
Database Storage I && II | Chapter 12.1-12.5 13.2-13.3 |
Buffer Pools | Chapter 13.2-13.5 |
Hash Tables | Chapter 14.5 24.5 |
Trees Indexes I && II | Chapter 14.1-14.4 |
Index Concurrency Control | Chapter 18.10.2 |
Sorting + Aggregations | Chapter 15.4-15.5 |
Joins Algorithms | Chapter 15.4-15.6 |
Query Execution I && II | Chapter 15.1-15.3, 15.7 Chapter 22 |
Query Planning & Optimization I&& II | Chapter 16 |
Concurrency Control Theory | Chapter 18 |
Two-Phase Locking Concurrency Control | Chapter 18.1-18.3, 18.9 |
Timestamp Ordering Concurrency Control | Chapter 18.5-18.6 |
Multi-Version Concurrency Control | Chapter 18.7-18.8 |
Logging Protocols + Schemes | Chapter 19.1-19.8 |
Crash Recovery Algorithms | Chapter 19.1-19.9 |
Introduction to Distributed Databases | Chapter 20.4-20.5, 21,23.1-23.4 |
Distributed OLTP Database Systems | Chapter 20.4-20.5, 21,23.1-23.4 |
Distributed OLAP Database Systems | Chapter 20.7 22.9 |
1-5
12.1-12.5
13.2-13.5
14.1-14.5
15.1-15.6
16
18(18.10.2)
19
20.4 20.7
21
22
23.1-23.4
24.5