---

Lectures are scheduled from September 26, 2011 to December 20, 2011, in via Ariosto 25, classroom B2.

---

Week	Wednesday (15:45 - 17:15)	Thursday (08:30 - 10:00)	Thursday (10:15 - 11:45)
01 (Sep 26)	Lectures 1,2 - Course overview - Architecture of a DBMS - The notion of transaction	Lectures 3,4 - The notion of schedules - Serializability - Anomalies	------
02 (Oct 03)	Lectures 5,6 - View serializability	Lectures 7 - Properties of view serializability	------
03 (Oct 10)	Lectures 8,9 - Conflict-serializability	Lectures 10,11 - Exercises on conflict-serializability and view-serializability	Lectures 12,13 - Properties of conflict-serializability
04 (Oct 17)	Lectures 14,15 - Conflict-serializability theorem	------	------
05 (Oct 24)	------	------	------
06 (Oct 31)	Lectures 16,17 - Conflict-serializability theorem	Lectures 18,19 - Concurrency control based on locking	Lectures 20,21 - Two phase locking (2PL) - Properties of 2PL - Exercises on concurrency control - 1
07 (Nov 07)	Lectures 22,23 - Deadlock management - Recoverability	Lectures 24,25 - Strictness, strict 2PL protocol, and strong strict "PL	Lectures 26,27 - Timestamp-based concurrency control
08 (Nov 14)	Lectures 28,29 - Multiversion timestamp-based concurrency control	Lectures 30,31 - Buffer management in a DBMS	Lectures 32,33 - Introduction to recovery - Exercises on concurrency control - 2
09 (Nov 21)	------	Lectures 34,35 - Warm and cold restart	Lectures 36,37 - Introduction to file organizations
10 (Nov 28)	Lectures 38,39 - Heap file, sorted file, hashed file	Lectures 40,41 - Introduction to indexes	Lectures 42,43 - Exercises on concurrency control
11 (Dec 05)	Lectures 44,45 - Properties of indexes - Introduction on tree-based indexes	------	------
12 (Dec 12)	Lectures 46,47 - Tree-based indexes	Lectures 48,49 - Hash-based indexes	Lectures 50,51 - Evaluation of relational algebra
12 (Dec 19)	------	Lectures 52,53 - Exercises of physical organization	Lectures 54,55 - Exercises of physical organization