Database Systems Prof. Dr. Jens Dittrich, Marcel Maltry, Immanuel Haffner

News

22.11.2022

Student Mail Address in CMS

Dear students,

some of you still use a mail address different from your student mail address in the CMS.  To make this very clear: you must set your student mail address in CMS and you must be assigned to your group's GitLab repository. Otherwise, you will not... Read more

Dear students,

some of you still use a mail address different from your student mail address in the CMS.  To make this very clear: you must set your student mail address in CMS and you must be assigned to your group's GitLab repository. Otherwise, you will not receive any points for the milestones!

Update your mail addresses, join your team in CMS, and then send me a mail with [dbsys22] in the topic.

Regards,

Immanuel

16.11.2022

Update of the Project Skeleton

Dear students,

we updated the skeleton project to fix issues related to linking errors and building on macOS.  To update your project, please follow these steps:

$ git fetch skeleton
$ git merge skeleton/main
$ git push

If you encounter merge... Read more

Dear students,

we updated the skeleton project to fix issues related to linking errors and building on macOS.  To update your project, please follow these steps:

$ git fetch skeleton
$ git merge skeleton/main
$ git push

If you encounter merge conflicts during the merge, this means that you modified a CMakeLists.txt file. Abort the merge with git merge --abort, undo your changes to the CMakeLists.txt file(s), and rerun the merge.

Note, that only one member of your group needs to perform this action.  After doing so, the other team members can simply do git pull to update their local repository.  Should you encounter any issues, please seek help in the forums.

 

Regards,

Immanuel

16.11.2022

Deadline Extension for Milestone 1

Dear students,

due to some technical issues related to Gitlab and the project in general, we decided to extend the deadline for milestone 1 by one week.

The new deadline for milestone 1 is December 6, 2022 at 23:59 UTC+1.

Note that this does not shorten the... Read more

Dear students,

due to some technical issues related to Gitlab and the project in general, we decided to extend the deadline for milestone 1 by one week.

The new deadline for milestone 1 is December 6, 2022 at 23:59 UTC+1.

Note that this does not shorten the time for the remaining milestones.

Best regards,

Marcel

07.11.2022

Room Change for This Week’s Lecture

Dear Students,

this week's lecture will be held in the lecture hall on the ground floor of the Max-Planck-Institut für Softwaresysteme (Building E1 5).

Best regards,

Marcel

03.11.2022

Lecture Recordings

Dear all,

the recording of yesterday's lecture is available here: https://youtu.be/VlgrNmRg-uo
In contrast to what I announced initially, I will record the lectures (not the labs) and make them available soon after each lecture. However, I cannot guarantee that... Read more

Dear all,

the recording of yesterday's lecture is available here: https://youtu.be/VlgrNmRg-uo
In contrast to what I announced initially, I will record the lectures (not the labs) and make them available soon after each lecture. However, I cannot guarantee that these recordings will work 100% of the time (it is very easy to run into audio issues with these recordings).

Best regards,

Jens Dittrich

30.10.2022

Tutorial Assignment

Dear all,

we just finalized the tutorial assignment. You find the tutorial you were assigned to on your personal status page.

Tutorials are starting tomorrow. We will discuss the solution to Assignment 00 which will also be uploaded to the CMS later that... Read more

Dear all,

we just finalized the tutorial assignment. You find the tutorial you were assigned to on your personal status page.

Tutorials are starting tomorrow. We will discuss the solution to Assignment 00 which will also be uploaded to the CMS later that day.

Best regards,

Marcel

27.10.2022

Finding a Team

Dear all,

if you are looking for a team to do the programming assignments with, we suggest you take a look at the forum. If you decide to open a thread, please use the appropriate categories. Once you found a team, indicate this in the thread so we can close... Read more

Dear all,

if you are looking for a team to do the programming assignments with, we suggest you take a look at the forum. If you decide to open a thread, please use the appropriate categories. Once you found a team, indicate this in the thread so we can close it.

You must also register your team on your personal status page in CMS. For those not familiar with CMS, we will explain the process in the upcoming lab.

Best regards,

Marcel

Show all
 

Database Systems

Database Systems is a core lecture worth 9 CPs which builds upon the foundations of the Big Data Engineering lecture. If you have never attended an introductory lecture on databases so far, this will most likely not be the right course for you. We also expect you to have profound programming skills in C++.

The topics covered include:

  • How to handle large amounts of data?
  • Which hardware and storage layouts are suitable in which scenarios?
  • How can we speed up data access using index structures?
  • Which optimization tricks can be played to speed up query processing?

The course consists of a weekly lecture, a weekly lab, weekly tutorials, and a software project. In the lab, we recap lecture material and you can work on exercises under supervision. In the tutorials, where we present sample solutions to these exercises. The project will be implemented in C++, however an introduction to C++ or programming in general will not be part of this course. We therefore expect students taking this course to have some basic programming experience.

Lecture

The lecture is held every Wednesday noon, 12:15 p.m. in E2 2, GHH. However, there are two exceptions around Christmas where the lecture will be streamed on YouTube. We will provide details in the lectures.

Lab

The lab is held every Friday, 10:15 a.m. in E1 3, HS II. We will recap the content of Wednesday's lecture so you can catch up on content you did not understand and ask questions. Further, we will provide exercises that you will solve in small groups. These exercises allow you to practice and prepare for the exam. Although the lab is not mandatory, we highly encourage you to participate. The lab is your primary source of practice and preparation for the exam.

Tutorials

Tutorials are held in every Monday in E1 1, R3.06 (third floor). In the tutorials, we will present sample solutions to the exercises handed out after each lecture on which you will work during the lab. There are three tutorials at different time slots such that you can choose the one that fits best into your schedule.

Software Project

The lecture is accompanied by a software project, where you will work in teams of three people to implement specific components of a database system. The project is split into three functional milestones and one performance evaluation, which you will be working on during the lecture period. Each milestone asks you to implement a particular database component, which is integrated into our system mutable. Based on a pre-defined set of tests, your implementation is evaluated for both functional correctness and performance and graded accordingly. You can achieve up to 5 points per milestone plus 5 points in the performance evaluation. This means, you can achieve up to 3 * 5 + 5 = 20 points in the project. You must achieve at least 10 points in the first three milestones to be admitted to the exams.

Exam and Grade

At the end of the course, you have to give a final exam and/or a re-exam. Each exam takes two hours. The better of your final and re-exam is counted and makes up 60% of your course grade, the project makes up the remaining 40% of the grade. You will be notified about your project results at least one week before the exam. The final exam will be held on February 8, 2022, at 12 p.m. Februay 17, at 10 a.m., the re-exam later on March 30, 2023, at 10 a.m.. To participate in either exam, you must register at least one week in advance via HIS/POS.

Current Situation

The ongoing pandemic and energy crisis affect our daily lives and lectures are no exception. Except for the two lectures around Christmas, we currently plan to hold the lecture in presence. Should the university make other specifications in the course of the semester, we reserve the right to switch lectures, labs, and tutorials completely to online.



Privacy Policy | Legal Notice
If you encounter technical problems, please contact the administrators