DM532: Principles of Database Systems (5 ECTS)

STADS: 15012601

Level
Bachelor course

Teaching period
The course is offered in the autumn semester.
1st. and 2nd quarter

Teacher responsible
No responsible teachers found, contact the department if necessary

Timetable
Show entire timetable
Show personal time table for this course.

Revison of timetable:
: Forelæsninger uge 35 flyttet

Comment:
Ubegrænset deltagerantal. 1.+2. kvartal

Prerequisites:
None

Academic preconditions:
The content of DM505 Database design and Programing and DM507 Algorithms and Data Structures 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 and transaction processing. As a minor topic, we consider advanced concepts and techniques of database systems, such as distributed databases and OLAP.

Expected learning outcome
At the end of the course the student is expected to be able to:
• explain the techniques of data storage and indexing
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 advanced techniques of online data analysis and distributed data management.

 

Subject overview
Data storage and indexing, query processing and optimization, database tuning, properties and implementation of ACID models of transactions, alternative formalisms for query languages, selected topics from distributed databases and OLAP.

Literature
There isn't any litterature for the course at the moment.

Website
This course uses e-learn (blackboard).

Prerequisites for participating in the exam
None

Assessment and marking:
(a) Project assignment. Pass/fail, internal evaluation by teacher. The project accounts for 1 ECTS of the 5 ECTS for the course. The project must be approved before the oral exam can be taken.
(b) Oral exam. External examiner, 7-point grading scale. (4 ECTS)

Reexamination after 2nd quarter.

Expected working hours
The teaching method is based on three phase model.

Forelæsninger: 20 timer
Eksaminatorietimer/opgaveregning: 22 timer
Educational activities

Language
This course is taught in Danish or English, depending on the lecturer. However, if international students participate, the teaching language will always be English.

Course enrollment
See deadline of enrolment.

Tuition fees for single courses
See fees for single courses.