Topics

• A - Course Introduction, DBMS Revision, PostgreSQL

• B - Storage: Devices, Files, Pages, Tuples, Buffers, Catalogs

• C - Cost Models, Implementing Scan, Sort, Projection

• D - Implementing Selection on One Attribute

• E - Implementing Selection on Multiple Attributes

• F - Similarity-based Selection

• G - Implementing Join

• H - Query Translation, Optimisation, Execution

• I - Transactions, Concurrency, Recovery

• J - Non-classical DBMSs