|Name||Cr||Method of study||Time||Location||Organiser|
|Transaction Management and Query Optimization||5 Cr||Lecture Course||12.3.2019 - 2.5.2019|
|Transaction Management and Query Optimization||5 Cr||Course exam||6.5.2019 - 6.5.2019|
|Transaction Management and Query Optimization (HT/U)||5 Cr||General Examination||14.6.2019 - 14.6.2019|
Master's Programme in Computer Science is responsible for the course
CSM14000 - Software Systems study track
The course is available to students from other degree programmes (this course can be available with Master of Data Science)
The course is not offered every year. It is offered every two years, alternatively in Spring.
Transactions and locking. Optimistic concurrency control. Transaction recovery. Degrees of consistency. Multi-model databases. Query plan and query optimization. XML twig pattern processing.
Activities and teaching methods in support of learning
Fundamentals of database systems (Chapter 16, 17, 19, 20, 21, 22)
An introduction to database systems (Chapter 15, 16, 18)
Assessment practices and criteria
The separate exams do not require course participation. But the students are required to submit the answers for all exercises and hands-on tasks before the examination.
Recommended optional studies
Introduction to Big Data Management
A separate exam can be taken with an independent study, but the submission of exercise and hands-on task answers is required.