Advanced Course on Databases

Department of Information Technology
University of Turku, FINLAND

Fall 2015, period 1

General information

• Form: Self-study course
• Teacher: Jukka Teuhola, email: jukka.teuhola (at) utu.fi
• Starting lecture: Tuesday, Sep 8th at 8:15-10 in Beta.
• Homework: 10 short exercises; personal solutions must be submitted before the exam as a single bunch (not one by one) by paper or email to the teacher. Minimum: 50% of the tasks must be ‘acceptably’ solved. 
• Preliminary knowledge: Databases I-II
• Examination dates: 23.11.2015, Jan 2016 and Feb 2016
• Credits: 5 sp 

Course description

The course consists of two main parts:

1. Functions of a database management system, such as query optimization, indexing, transaction
   processing, concurrency control, recovery from failures, and database security.
2. Modern database technologies, such as object-oriented databases, object-relational
   databases, distributed databases, data warehouses, semi-structured databases, and more.

Literature

• R. Elmasri, S.B. Navathe: "Fundamentals of Database Systems",
  4rd/5th/6th edition, Pearson/Addison-Wesley.
• Lecture slides are available to the students.

If you have difficulties to get the textbook, there is an alternative that is freely electronically available:
Paolo Atzeni, Stefano Ceri, Stefano Paraboschi and Riccardo Torlone: Database Systems - Concepts, Languages and Architectures, McGraw-Hill, Parts III and IV.