News
17.03.2023
|
Grades in HIS/POS and Re-Exam RegistrationDear 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... 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 |
03.03.2023
|
Exam InspectionDear 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... Read more 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 |
03.03.2023
|
Performance Evaluation and GradesDear 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 ... 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 |
02.03.2023
|
Exam Results PublishedDear 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... 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 |
14.02.2023
|
Deadline: Performance EvaluationDear 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... 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 |
13.02.2023
|
Exam Registrations Imported Into CMS and Exam SeatingDear 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... 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 |
07.02.2023
|
Register for Trial Exam PrintoutDear 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, |
02.02.2023
|
Exam and Trial Exam InformationDear students, in the following, we provide you with the most important information on the upcoming exam. Time Dear students, in the following, we provide you with the most important information on the upcoming exam. Time Location Permitted Materials What to expect? Registration
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
|
01.02.2023
|
Reminder: Exam RegistrationDear 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... 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. |
24.01.2023
|
Benchmarks for Milestone 3 are now availableDear 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. 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. You can use the Milestone 3 executable
I suggest that you focus on functional correctness for Milestone 3 before tackling performance (and potentially more complex plan enumeration algorithms). Good luck, Immanuel |
14.01.2023
|
Release of Milestone 3Dear 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,... 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 |
11.01.2023
|
Course EvaluationDear 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,... 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 |
16.12.2022
|
Online TeachingDear 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):
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):
First week of January (January 2 to 6):
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
|
16.12.2022
|
Milestone 2 Deadline postponedDear 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... 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 |
08.12.2022
|
Milestone 1 finished & Milestone 2 releasedDear 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... 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 |
07.12.2022
|
GitLab and Forum currently offline, Deadline postponedDear 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... 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 |
22.11.2022
|
Student Mail Address in CMSDear 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 Regards, Immanuel |
16.11.2022
|
Update of the Project SkeletonDear 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 Note, that only one member of your group needs to perform this action. After doing so, the other team members can simply do
Regards, Immanuel |
16.11.2022
|
Deadline Extension for Milestone 1Dear 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 LectureDear 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 RecordingsDear all, the recording of yesterday's lecture is available here: https://youtu.be/VlgrNmRg-uo Dear all, the recording of yesterday's lecture is available here: https://youtu.be/VlgrNmRg-uo Best regards, Jens Dittrich |
30.10.2022
|
Tutorial AssignmentDear 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 TeamDear 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 |
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.