Topics

• Ex01 - DBMSs, PostgreSQL

• Ex02 - Storage Management, Catalogs

• Ex03 - Disks, Files, Pages, Tuples

• Ex04 - Relational Operations and Buffer Pool

• Ex05 - Implementing Sorting and Projection

• Ex06 - Implementing Selection on One Attribute (1-d)

• Ex07 - Implementing Selection on Multiple Attributes (n-d)

• Ex08 - Implementing Join: Nested-loop, Sort-merge, Hash

• Ex09 - Query Optimisation and Execution

• Ex10 - Transaction Processing, Concurrency, Recovery