对应的书籍章节

    lecture pdf
    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