Data Management (academic year 2011/2012) - lecture schedule
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 |