News

Re-Exam Results and Inspection

Written on 30.03.23 by Marcel Maltry

Dear students,

we just published the re-exam results. You can find your points and final grade on your personal status page in CMS.

Re-Exam Inspection

The inspection will be next Thursday, April 6 from 11:00 to 12:30 in E1 1, SR 3.06. Due to fewer participants, no registration is required… Read more

Dear students,

we just published the re-exam results. You can find your points and final grade on your personal status page in CMS.

Re-Exam Inspection

The inspection will be next Thursday, April 6 from 11:00 to 12:30 in E1 1, SR 3.06. Due to fewer participants, no registration is required this time. Please come at least 15 minutes before the end.

Kind regards,

Marcel

Re-Exam Registration Issues (continued)

Written on 28.03.23 by Marcel Maltry

Dear students,

we imported all registrations again into CMS. If you are registered in LSF but your registration does not show up in CMS, please contact us as soon as possible and provide us with a screenshot of your registration.

You cannot attend the reexam, if you are not registered in… Read more

Dear students,

we imported all registrations again into CMS. If you are registered in LSF but your registration does not show up in CMS, please contact us as soon as possible and provide us with a screenshot of your registration.

You cannot attend the reexam, if you are not registered in CMS!

Kind regards,

Marcel

Re-Exam Information

Written on 24.03.23 by Marcel Maltry

Dear students,

we re-imported all registrations from LSF into CMS and will do so again on Monday. If you are registered in LSF but don't see your registation in CMS by Tuesday, please contact us.

The re-exam will take place next Thursday at 10am in E2 2, GHH (only one lecture hall this time).… Read more

Dear students,

we re-imported all registrations from LSF into CMS and will do so again on Monday. If you are registered in LSF but don't see your registation in CMS by Tuesday, please contact us.

The re-exam will take place next Thursday at 10am in E2 2, GHH (only one lecture hall this time). The same rules apply as for the exam, so bring your cheat sheet and non-programmable calculator. If you have further questions, please use the forum.

Kind regards,

Marcel

Re-Exam Registration Issues

Written on 23.03.23 by Marcel Maltry

Dear students,

we are aware of an issue regarding the re-exam registration via LSF. We just imported all registrations and you should now see your registration status on your personal status page. If you had issues registering and are not registered, please contact your examination office with us… Read more

Dear students,

we are aware of an issue regarding the re-exam registration via LSF. We just imported all registrations and you should now see your registration status on your personal status page. If you had issues registering and are not registered, please contact your examination office with us in CC as we have no control over the LSF.

Kind regards,

Marcel

Grades in HIS/POS and Re-Exam Registration

Written on 17.03.23 by Marcel Maltry

Dear students,

grades should now be available in HIS/POS and registration for the re-exam is open. Note that registration closes one week ahead of the re-exam, i.e. next Wednesday, March 22 at 11:59pm. A subsequent registration after the deadline is not possible.

We will import the registrations… Read more

Dear students,

grades should now be available in HIS/POS and registration for the re-exam is open. Note that registration closes one week ahead of the re-exam, i.e. next Wednesday, March 22 at 11:59pm. A subsequent registration after the deadline is not possible.

We will import the registrations to CMS once the deadline has passed. You won't see your registration status in CMS prior to us importing the registrations.

If you cannot register in HIS/POS due to your subject of studies (e.g. Erasmus), please reach out to me and I will register you manually. In all other cases, please contact the study coordination directly.

Kind regards,

Marcel

Exam Inspection

Written on 03.03.23 by Marcel Maltry

Dear students,

the exam inspection will be on Thursday, 16 March from 10:00 to 12:00 in E1 1, SR 3.06. Please register on your personal status page for one of the four time slots. This makes it easier for us to prepare the exams. Also bring your student ID.

See you then and kind regards,

Marcel

Performance Evaluation and Grades

Written on 03.03.23 by Marcel Maltry

Dear students,

Performance Evaluation

performance evaluation took less time than expected. The respective points are now visible on your personal status page. A detailed explanation on how points were assigned can be found in the forums.

Grades

Furthermore, we decided on a grade table and… Read more

Dear students,

Performance Evaluation

performance evaluation took less time than expected. The respective points are now visible on your personal status page. A detailed explanation on how points were assigned can be found in the forums.

Grades

Furthermore, we decided on a grade table and your grades are now also visible on your personal status page. An explanation on how the final points were computed can be found on the forums. You need 50 points to pass the course.

Exam Inspection

We will write another news as soon as we fixed a date.

Best regards,

Marcel

Exam Results Published

Written on 02.03.23 by Marcel Maltry

Dear students,

we just published the exam results. You can find your points on your personal status page in CMS.

Performance Evaluation and Grades

Our chair is at a conference next week. Thus, points for performance evaluation will be added to the CMS in the week of 13 March. We will decide… Read more

Dear students,

we just published the exam results. You can find your points on your personal status page in CMS.

Performance Evaluation and Grades

Our chair is at a conference next week. Thus, points for performance evaluation will be added to the CMS in the week of 13 March. We will decide on a grade table after performance evaluation is done.

Exam Inspection

Due to the conference, exam inspection will likely also happen in the week of 13 March. We will send another email once there is a fixed date.

Kind regards,

Marcel

Deadline: Performance Evaluation

Written on 14.02.23 by Immanuel Haffner

Dear all,

we have fixed the deadline of the performance evaluation to Feb 28, 23:59 o'clock. The grading is performed by relating your project's performance to that of the reference. As a rule of thumb, if your performance is within 1.5x of the reference, you will achieve full points. The… Read more

Dear all,

we have fixed the deadline of the performance evaluation to Feb 28, 23:59 o'clock. The grading is performed by relating your project's performance to that of the reference. As a rule of thumb, if your performance is within 1.5x of the reference, you will achieve full points. The performance is evaluated for each milestone individually, where Milestone 1 is weighted 1 point and Milestones 2 & 3 are weighted 2 points each. This makes a total of 5 points for the performance evaluation. If you have questions, please ask them in the forums.

Good luck in the exam.

Regards,

Immanuel

Exam Registrations Imported Into CMS and Exam Seating

Written on 13.02.23 by Marcel Maltry

Dear students,

we imported the exam registrations from HISPOS and ViPa into the CMS and your personal status page should now show whether you registered. Please note that a subsequent registration is not possible.

We also assigned you to lecture halls for the exam. You can find the lecture hall… Read more

Dear students,

we imported the exam registrations from HISPOS and ViPa into the CMS and your personal status page should now show whether you registered. Please note that a subsequent registration is not possible.

We also assigned you to lecture halls for the exam. You can find the lecture hall you were assigned to on your personal status page. Pleas ignore row and seat.

Kind regards,

Marcel

Register for Trial Exam Printout

Written on 07.02.23 by Marcel Maltry

Dear students,

please register on your personal status page if you want us to print a trial exam for you. The registration is open until tomorrow morning 8am. The trial exam will also be available digitally via CMS.

Best regards,
Marcel

Exam and Trial Exam Information

Written on 02.02.23 (last change on 06.02.23) by Marcel Maltry

Dear students,

in the following, we provide you with the most important information on the upcoming exam.

Time
Friday, February 17 at 10:00. Please be there at least 15 minutes ahead of time. The exam will take 2 hours. You are not allowed to leave the lecture hall early during the last 30… Read more

Dear students,

in the following, we provide you with the most important information on the upcoming exam.

Time
Friday, February 17 at 10:00. Please be there at least 15 minutes ahead of time. The exam will take 2 hours. You are not allowed to leave the lecture hall early during the last 30 minutes of the exam.

Location
E2 2 GHH and E1 3 HSII. You will be assigned to either lecture hall via CMS before the exam after the registration period has ended. We will send a news once the assignment is done.

Permitted Materials
You are allowed to (and should) bring one A4 sheet of hand-written notes (front and back) and a non-programmable calculator. Please use a document-safe pen such as a ballpoint pen. No additional materials are permitted. We will provide you with enough paper so don't bring your own!

What to expect?
The exam consists of four exercises similar to the ones on the assignments. Each exercises should take you roughly 30 minutes.

Registration
Please refer to yesterday's news with regards to exam registration. You should now see on your personal status page whether you are admitted to the exam. Whether you are registered, will only be visible in CMS after the registration deadline once we imported the registrations from HISPOS and ViPa.

 

Trial Exam

The trial exam will take place during the regular lecture slot next week. We are trying to simulate a similar setting to the exam but with three exercises (90 minutes) instead of 4. The trial exam will be comprised of exam exercises from previous years. You are free to use any material but we suggest you already bring your cheat sheet and a non-programmable calculator. We will present the solutions to the trial exam during the lab slot on Friday. Both the exercises and solutions will be uploaded to the CMS after the lab.

If you have further questions, please send me an email or write in the forums.

Best regards and good luck,

Marcel

 

Reminder: Exam Registration

Written on 01.02.23 (last change on 02.02.23) by Marcel Maltry

Dear students,

now that the deadline for Milestone 3 has passed, please register for the exam in HIS/POS (or ViPa) by Thrusday, 9 February 2023.

If you cannot register in HIS/POS due to your subject of studies (e.g. Erasmus), please reach out to me and I will register you manually. In all other… Read more

Dear students,

now that the deadline for Milestone 3 has passed, please register for the exam in HIS/POS (or ViPa) by Thrusday, 9 February 2023.

If you cannot register in HIS/POS due to your subject of studies (e.g. Erasmus), please reach out to me and I will register you manually. In all other cases, please contact the study coordination directly.

Note that you are only permitted to participate in the exam if you (1) scored at least 10 points in the first three milestones and (2) registered for the exam in time. There won't be any exceptions!

Kind regards,

Marcel

Update: You should now see on your personal status page whether you are admitted to the exam.

Benchmarks for Milestone 3 are now available

Written on 24.01.23 by Immanuel Haffner

Dear all,

I just added the benchmarks for Milestone 3. You will have to compute optimal plans for five queries. These queries have a particular shape and size and are named accordingly, e.g. chain-12 is a query of 12 relations, joined together in a chain, i.e. T₀ ⋈ T₁ ⋈ ... ⋈ T₁₁.

You can use… Read more

Dear all,

I just added the benchmarks for Milestone 3. You will have to compute optimal plans for five queries. These queries have a particular shape and size and are named accordingly, e.g. chain-12 is a query of 12 relations, joined together in a chain, i.e. T₀ ⋈ T₁ ⋈ ... ⋈ T₁₁.

You can use the Milestone 3 executable build/<TYPE>/bin/milestone3 to visually inspect the query graph and the plan you have computed.  For example, to inspect the chain-12 query, run

$ build/debug/bin/milestone3 resource/schema.sql resource/chain-12.{query.sql,cardinalities.json}

I suggest that you focus on functional correctness for Milestone 3 before tackling performance (and potentially more complex plan enumeration algorithms).

Good luck,

Immanuel

Release of Milestone 3

Written on 14.01.23 by Immanuel Haffner

Dear students,

we have just released Milestone 3. The skeleton has been updated accordingly.

Please be aware that there are no benchmarks for Milestone 3, yet.  I will add them next week.  I might also extend the unit tests.  However, the skeleton, the assignment sheet, and the available unit… Read more

Dear students,

we have just released Milestone 3. The skeleton has been updated accordingly.

Please be aware that there are no benchmarks for Milestone 3, yet.  I will add them next week.  I might also extend the unit tests.  However, the skeleton, the assignment sheet, and the available unit tests should be enough to get started working on the milestone.

Good luck & regards,

Immanuel

Course Evaluation

Written on 11.01.23 by Marcel Maltry

Dear students,

we just added links to the Qualis course evaluation for the lecture and tutorials in the CMS under Information. Constructive criticism plays a crucial role in improving the course. So please take the time! The links are valid until February 2, 2023.

Thank you in advance and best… Read more

Dear students,

we just added links to the Qualis course evaluation for the lecture and tutorials in the CMS under Information. Constructive criticism plays a crucial role in improving the course. So please take the time! The links are valid until February 2, 2023.

Thank you in advance and best regards,

Marcel

Online Teaching

Written on 16.12.22 (last change on 21.12.22) by Marcel Maltry

Dear students,

I just wanted to quickly remind you that all events both next week and the first week of January will be held online. In particular:

Next week (December 19 to 23):

  • Monday: Tutorials will be held via Discord. More on that below.
  • Wednesday: There will be a special Christmas… Read more

Dear students,

I just wanted to quickly remind you that all events both next week and the first week of January will be held online. In particular:

Next week (December 19 to 23):

  • Monday: Tutorials will be held via Discord. More on that below.
  • Wednesday: There will be a special Christmas lecture via YouTube with a text channel on Discord for you to ask questions. We won't give out an assignment sheet for this lectures, thus, there is no lab on Friday and no tutorial in the first week of January.

First week of January (January 2 to 6):

  • Wednesday: There will be a regular lecture via YouTube with a text channel on Discord for you to ask questions. Since it is a regular lecture, there will be an assignment.
  • Friday: Regular lab via Discord. More on that below.

If you have not yet registered on our Discord, please do so. You find all information here. Channels to be used for the tutorials, the lab, and the lecture are named appropriately within the Database Systems category.

Best regards,

Marcel

 

Milestone 2 Deadline postponed

Written on 16.12.22 by Immanuel Haffner

Dear all,

we were approached by one of your colleagues, who pointed out that there won't be a lab after holidays and before the deadline of Milestone 2.  To provide a lab where you can ask questions related to Milestone 2, we decided to postpone the deadline of Milestone 2 to January 10th. You can… Read more

Dear all,

we were approached by one of your colleagues, who pointed out that there won't be a lab after holidays and before the deadline of Milestone 2.  To provide a lab where you can ask questions related to Milestone 2, we decided to postpone the deadline of Milestone 2 to January 10th. You can join our virtual lab via Discord on Friday, January 6th, to ask questions to Milestone 2. The Timetable and the programming assignmen sheet were updated accordingly.

Milestone 3 will hence be released on January 10th.  The extent of Milestone 3 will be adjusted to three weeks (from four weeks before).

We wish you all a Merry Christmas!

See you next year ;)

Immanuel

Milestone 1 finished & Milestone 2 released

Written on 08.12.22 by Immanuel Haffner

Dear students,

the evaluation of Milestone 1 is finished. You can see your score on the Database Systems Project Evaluation 🔗 website. I will assign the points for Milestone 1 in CMS during the next week.

Further, we have released Milestone 2. The description is available in the CMS →… Read more

Dear students,

the evaluation of Milestone 1 is finished. You can see your score on the Database Systems Project Evaluation 🔗 website. I will assign the points for Milestone 1 in CMS during the next week.

Further, we have released Milestone 2. The description is available in the CMS → Information → Materials.  The skeleton repository has been updated accordingly.

Good luck with Milestone 2.

Immanuel

GitLab and Forum currently offline, Deadline postponed

Written on 07.12.22 by Immanuel Haffner

Dear all,

of course it had to happen: GitLab and the forum went offline just on the day of the deadline for Milestone 1. Both services are unreachable since Dec 6, around 22pm.

We are very sorry for this inconvenience. We are aware that this interferes with your submission of Milestone 1.… Read more

Dear all,

of course it had to happen: GitLab and the forum went offline just on the day of the deadline for Milestone 1. Both services are unreachable since Dec 6, around 22pm.

We are very sorry for this inconvenience. We are aware that this interferes with your submission of Milestone 1. Therefore, we will postpone the deadline of Milestone 1 by one more day. (This is tentative: should GitLab be unavailable for a longer period, then we will further postpone the deadline.) Don't panic if you were unable to push your latest changes yesterday. You will be able to do so when GitLab is back online and before we do the final evaluation of Milestone 1.

As a consequence of GitLab being unavailable, the benchmarks did not run tonight. I will rerun evaluation when GitLab is back online. You will receive mail from the evaluation, as usual.

Please do not send us mail regarding this issue, we are aware of it and working on it.

Kind regards,

Immanuel

Student Mail Address in CMS

Written on 22.11.22 by Immanuel Haffner

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… 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

Update of the Project Skeleton

Written on 16.11.22 by Immanuel Haffner

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… 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

Deadline Extension for Milestone 1

Written on 16.11.22 by Marcel Maltry

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… 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

Room Change for This Week’s Lecture

Written on 07.11.22 by Marcel Maltry

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

Lecture Recordings

Written on 03.11.22 by Jens Dittrich

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… 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

Tutorial Assignment

Written on 30.10.22 by Marcel Maltry

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

Finding a Team

Written on 27.10.22 by Marcel Maltry

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… 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.