DM532: Principles of Database Systems (5 ECTS)
STADS: 15005001Level
Bachelor course
Teaching period
The course is offered in the autumn semester.
1st quarter
Teacher responsible
No responsible teachers found, contact the department if necessary
Timetable
| Group | Type | Day | Time | Classroom | Weeks | Comment |
|---|---|---|---|---|---|---|
| Common | I | Monday | 14-16 | U24 | 35-40 | |
| Common | I | Monday | 14-15 | U24 | 41 | |
| Common | I | Wednesday | 10-12 | U49C | 35-36, 38, 40 | |
| S1 | TE | Tuesday | 12-13 | U24 | 35 | |
| S1 | TE | Tuesday | 12-14 | U24 | 36-41 | |
| S1 | TE | Friday | 10-12 | U89a | 36 | |
| S1 | TE | Friday | 10-12 | U28 | 37, 39, 41 |
Show personal time table for this course.
Comment:
Ansvarlig lærer: Yongluan Zhou, adjunkt.
Ubegrænset deltagerantal
Prerequisites:
None
Academic preconditions:
The content of DM505 and DM507 should be known.
Course introduction
The main purpose of this course is to give the participants an understanding of the implementation issues of database systems, with focus on query optimization, transaction processing, and the ACID properties (Atomicity, Consistency, Isolation, Durability). As a minor topic, we consider alternatives to the SQL and relational algebra query formalisms.
Expected learning outcome
At the end of the course the student is expected to be able to:
- explain the foundations and techniques for evaluating an SQL query
- explain the process of optimizing an SQL query
- account for the ingredients of a transaction model and determine whether or not the ACID properties hold
- explain how each of the ACID properties can be fulfilled by a structured transaction implementation
- account for the relationships between relational algebra and SQL versus their alternatives
Subject overview
Query processing and optimization, database tuning, properties and implementation of ACID models of transactions, alternative formalisms for query languages, selected topics from object databases, distributed databases, XML, and OLAP.
Literature
- Meddeles ved kursets start..
Syllabus
See syllabus.
Website
This course uses e-learn (blackboard).
Prerequisites for participating in the exam
None
Assessment and marking:
Oral examination, grades according to the dansih 7-point scale and external censorship.
Reexamination after 2. quarter.
Expected working hours
The teaching method is based on three phase model.
Forelæsninger: 21 timer
Eksaminatorietimer/opgaveregning: 21 timer
Educational activities
Language
This course is taught in English.
Course enrollment
See deadline of enrolment.
Tuition fees for single courses
See fees for single courses.
