DM556: Principles of Database Systems (10 ECTS)
STADS: 15017101
Level
Bachelor course
Teaching period
The course is offered in the autumn semester.
Teacher responsible
Email: zhou@imada.sdu.dk
Timetable
Group |
Type |
Day |
Time |
Classroom |
Weeks |
Comment |
Common |
I |
Tuesday |
10-12 |
U23A |
5-7,9-11,14-20 |
|
Common |
I |
Wednesday |
14-16 |
U10 |
5,7,10,16,18,20 |
|
Common |
I |
Wednesday |
14-16 |
U69A |
14 |
|
H1 |
TE |
Tuesday |
12-14 |
U10 |
18 |
|
H1 |
TE |
Wednesday |
14-16 |
U10 |
6,9,11,15,17,19 |
|
H1 |
TE |
Thursday |
12-14 |
U17 |
5-7,9-11,13-17,19-20 |
|
H1 |
TE |
Friday |
10-12 |
U14 |
18 |
|
Show entire timetable
Show personal time table for this course.
Comment:
Ubegrænset deltagerantal.
Prerequisites:
None
Academic preconditions:
The content of DM505 Database design and Programing and DM507 Algorithms and Data Structures should be known.
Course introductionThe 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, advanced concepts and techniques of database systems, such as distributed databases and OLAP.
Expected learning outcomeAt 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
- explain and analyze the techniques of data partitioning and replication
- Describe the process of optimizing distributed or parallel queries
- Explain and analyze the techniques of distributed concurrency control
Subject overviewData storage and indexing, query processing and optimization, database tuning, properties and implementation of ACID models of transactions, distributed databases and OLAP.
LiteratureMeddeles ved kursets start.
Website
This course uses
e-learn (blackboard).
Prerequisites for participating in the exam
A project that contains several parts is a prerequisite for attending exam parts a and b. Pass/fail, evaluation by teacher.
Assessment and marking:
- Oral exam based on the project. Pass/fail, internal evaluation by teacher (3 ECTS).
- Oral exam. External examiner, Danish 7-mark scale (7 ECTS).
Reexamination in the same exam period or immediately thereafter
Expected working hours
The teaching method is based on three phase model.
Intro phase: 40 hours
Skills training phase: 40 hours
Educational activities
Study phase: 40 hours
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.