PSV-2
DATABASE SYSTEMS
(taught in English)
10 points, Periods 3 & 4, Fall 1999
Instructor
Goals
- The main objective of this continuation course is to make students
familiar with some advanced fundamental principles and techniques of
database management systems. This means that the lectures themselves
have a slightly theoretical flavour, as they discuss no
particular systems: once the fundamental principles and techniques are
understood, the usage of particular systems is easy, whereas the study of
any such particular systems would not prepare the student for the usage of
other systems or of the better ones that are bound to emerge.
- Some practice of these advanced aspects of database management
systems is acquired through lessons and laboratories.
Lecture Topics & Schedule
Introduction and Reminder I (Thu 4 Nov, 9-11, A114)
Reminder II (Tue 9 Nov, 9-11, A114)
Dependencies, Normal Forms (Wed 10 Nov, 9-11, A114)
Advanced Data Modeling (Tue 16 Nov, 8-10, A114)
Transaction Processing (Wed 17 Nov, 8-10, A114)
Concurrency Control (Wed 24 Nov, 10-12, A144)
Recovery (Wed 1 Dec, 9-11, A114)
Security and Authorisation (Wed 8 Dec, 9-11, A114)
Distribution (Tue 14 Dec, 9-11, A144)
Object-Oriented Databases (Wed 15 Dec, 9-11, A114)
questions & answers (Tue 11 Jan, 9-11, A114)
I hold an office hour immediately after the last lecture
of each week, in my office (A321).
Textbook
Ramez Elmasri and Shamkant B. Navathe.
Fundamentals of Database Systems (2nd and 3rd editions).
Addison-Wesley, 1994 and 2000.
Lessons & Labs
The teaching assistant Zeynep Kiziltan
(http://www.dis.uu.se/~zeykiz/)
has a homepage for the
lessons and labs
of this course, with the schedules and names for groups a, b, c.
She also holds an office hour every week, see her page for details.
Exams
The first exam will be on Fri 14 Jan,
from 8am to noon, in Postscriptum, Room 2,
over the entire course material.
The second exam will be on Sat 29 Jan,
from 9am to 1pm, in Postscriptum, Room 1,
over the entire course material.
Miscellaneous
I use many abbreviations & notations
when writing on the blackboard...
Back to Pierre Flener's homepage.
Last updated 11 January 2000, guess by whom?