CS-E4230 (5 ECTS)
(previously known as T-106.5221)Goals of the Course: Following the course, the student will understand the significance and the goals of transaction management on both logical and physical levels. The student is taught how to take into account the implementation techniques used in transaction management when designing a database.
Contents: Logical databases and database transactions. Log maintenance and buffer management. Rollback of transactions and database recovery. Transaction isolation and concurrency control, locking techniques. Recovery of physical database structures.
Course Instructor: Prof. Eljas Soisalon-Soininen. Email: userid part is eljas.soisalon-soininen, domain part is aalto.fi
Lectures: Wednesdays 12:15pm to 3pm at TUAS class room TU5 (1199)
Course Assistant: Sami El-Mahgary (Lic. Tech.). Email: userid part is sami.mahgary, domain part is aalto.fi
Language of Instruction: English (unless everyone present in class understands Finnish).
Required Reading: Chapters 1-6 and Chapter 9 (Advanced Locking Protocols) excluding Sections 6.7, 9.3, 9.6 and Section 9.7. There will also be a short, max. 2-pages of extra-material on deadlock avoidance (Wait-die and Wound-or-Wait.)
Requirements to Pass the Course: In order to pass the course, you need to pass the exam. There are optional homework assignments for which you can get additional extra-credit points (a total of six points) that are then added up to your exam score, *as long as the exam score as such is passing*.
Tutorials: In the tutorials (Thursdays 12:15 pm tp 2pm. TUAS/TU5), example problems are solved to help you understand key concepts and be able to deal with the optional homework. Please see the page on Tutorials for more info.