News
Re-Exam Results & InspectionWritten on 01.04.21 (last change on 01.04.21) by Christian Schön Dear students, we have finished the correction of the re-exam and uploaded the points you scored to the CMS. Dear students, we have finished the correction of the re-exam and uploaded the points you scored to the CMS. We will offer an exam inspection through Discord next Wednesday, April 7th at 11:00 am. We hope you all enjoyed the course and which you happy easter holidays. |
Re-ExamWritten on 23.03.21 by Christian Schön Dear students, the re-exam has nearly arrived and will start tomorrow at 14:30 CET.
Dear students, the re-exam has nearly arrived and will start tomorrow at 14:30 CET.
For further information, please refer to the "FAQ Final Exam Regulations" linked under materials which is still valid for the re-exam. We wish you good luck! |
Final Exam Grades & Re-exam registrationWritten on 15.03.21 by Christian Schön Dear students, we have entered the grades for the course in the LSF (based on the final exam, including changes of the inspection). This means that you can now register for the re-exam if you haven't been able to do so before. Dear students, we have entered the grades for the course in the LSF (based on the final exam, including changes of the inspection). This means that you can now register for the re-exam if you haven't been able to do so before. In case you take both exams (final and re-exam), the better of the two will be counted. Best regards |
Exam Results, Exam Inspection & Registration Re-ExamWritten on 10.03.21 by Christian Schön Dear students, we have finished the correction of the final exam and uploaded the points you scored to the CMS. Dear students, we have finished the correction of the final exam and uploaded the points you scored to the CMS. We will offer an exam inspection through Discord on Friday during our former Lab time slot, i.e. starting at 12:15 pm. When your time slot starts, please open your personal exam table by clicking on the corresponding “Exam Table” voice channel (as you did to form teams in the Lab). Please do not forget to register for the re-exam in time. As it was the first time we tried an open book, online exam, we would be happy to get some feedback from your side. Best regards |
FAQ Exam RegulationsWritten on 22.02.21 by Christian Schön Dear students, we have just published an FAQ considering the exam regulations for the upcoming final exam. You can find it under Materials. Most information has already been given in the previous announcement, but we still included everything in the FAQ to have a single document with all… Read more Dear students, we have just published an FAQ considering the exam regulations for the upcoming final exam. You can find it under Materials. Most information has already been given in the previous announcement, but we still included everything in the FAQ to have a single document with all relevant information. Please read this document carefully to prepare for the exam. One point is however new: We hope that all questions regarding the exam are now answered and all technical problems resolved. Best regards |
Test Exam SubmissionWritten on 18.02.21 by Christian Schön Dear students, as many of you have noticed, the CMS had problems during the technical test we just conducted. Dear students, as many of you have noticed, the CMS had problems during the technical test we just conducted. To allow everyone to also test the submission process in the CMS, we have extended the submission until 8 pm in the evening, so everyone should have enough time to test it. As we might encounter similar problems during the actual exam, we will discuss internally how to handle submission in case the CMS goes down again. Best regards |
Final Exam Regulations & Technical Test on ThursdayWritten on 16.02.21 (last change on 17.02.21) by Christian Schön Dear students, we have finally determined the exact regulations for the upcoming exam:
Dear students, we have finally determined the exact regulations for the upcoming exam:
To check that everything works as expected, we have organized a small technical test which will be held on Thursday, February 18th on 1 pm CET. You will have half an hour (exactly the extra time in the actual exam) to download your personalized test exam, to write down your name on the front page, to answer a very simple and short exercise (not related to or representative for the actual exam) and to finally upload your solution to a test submission in the CMS. If you have questions regarding these regulations or experience problems during the test, please contact us as soon as possible such that we can solve all these problems before the actual exam starts. Best regards |
Important Update: Exam Mode ChangedWritten on 12.02.21 by Christian Schön Dear students, we are still monitoring the current pandemic situation. We were… Read more Dear students, we are still monitoring the current pandemic situation. We were therefore discussing alternatives to exams held in presence and decided that we will move to an open book exam. The exams will be handed out online and you will submit them online as well after the expected duration of 2 hours (we will most likely grant you a little more time to digitize your solutions). Make sure you have some white paper available at the time of the exam such that you can directly start writing as soon as you have downloaded the exam. Be aware that plagiarism is still strictly forbidden and will result in a failed exam if we encounter fraud of any type! We know that this decision might be a surprise for many of you. Best regards |
Update Exam RegulationsWritten on 05.02.21 by Christian Schön Dear students, the exam phase is now approaching and we want to give you an update on the regulations: The final exam will be on February 24th, the re-exam one month later on March 24th. Dear students, the exam phase is now approaching and we want to give you an update on the regulations: The final exam will be on February 24th, the re-exam one month later on March 24th. We will distribute you to a fixed lecture hall after finishing the registration in the CMS (which allows us to keep track of possible contacts). The university has sent a mail to all students in the beginning of the week stating that they will provide masks for all exams held in presence. You are allowed to bring two double-sided A4 sheets with handwritten notes to the exam, i.e. four pages in total. The exam might cover all topics of the lecture except for the MVCC part (i.e. the second part of the MVCC lecture). The first part of this lecture up to the break (e.g. covering Virtual Memory) is however relevant! As we reached the final week of the lecture period, we will have no more tutorials or labs. We wish you good luck for your exam preparation. |
Results Performance EvaluationWritten on 04.02.21 by Christian Schön Dear students, we have finished the performance evaluation of the project and determined a grading scheme which Immanuel explained in the forum. It will however take some time to enter all… Read more Dear students, we have finished the performance evaluation of the project and determined a grading scheme which Immanuel explained in the forum. It will however take some time to enter all the results in the CMS manually, so please be patient if you do not yet see your points there. Please remember to register for the exam in the CMS, in addition to registrations you have done previously in other systems. Best regards |
Exam RegulationsWritten on 02.02.21 by Christian Schön Dear students, the university has updated the regulations for the upcoming exam phase. Dear students, the university has updated the regulations for the upcoming exam phase. To organize the exams, we have just opened a registration here in CMS (it should be visible on your personal page). We will send you additional information regarding the exams such as the lecture hall you are assigned to, the entrance you should use and other safety rules that apply in the days before the exam. Best regards |
Recap Lecture & LabWritten on 01.02.21 by Christian Schön Dear students, as you might have already noticed in the calendar, this week is the last week of our course (except for the exams). This will… Read more Dear students, as you might have already noticed in the calendar, this week is the last week of our course (except for the exams). This will also affect the lab on Friday which is transformed into an office hour. Best regards |
Assignment 10Written on 27.01.21 by Christian Schön Dear students, the 10th and last assignment sheet is now available under Materials. Dear students, the 10th and last assignment sheet is now available under Materials. Keep in mind that the exam registration in LSF ends today. Best regards |
Possible Problems Regarding Exam AttendanceWritten on 26.01.21 by Christian Schön Dear students, The plan the faculty agreed on in the beginning of the winter term was to hold all lectures online, but the exams in person on our campus in Saarbrücken. Dear students, The plan the faculty agreed on in the beginning of the winter term was to hold all lectures online, but the exams in person on our campus in Saarbrücken. If some of you aren't able to attend the exams in person due to such restrictions, we ask you to get in touch with us until Thursday by sending me a mail stating: a) where you come from and b) why you cannot attend the exams in person (mail address: christian.schoen(at)uni-saarland.de) As far as we know, there are currently no restrictions considering travels inside Germany. Best regards |
Assignment 9 & Exam PreparationWritten on 20.01.21 by Christian Schön Dear students, Assignment 9 is now available under Materials. As we already received some questions regarding the exam, here a few clarifications: The exam will take place on February 24th, the reexam exactly one month later on March 24th. Dear students, Assignment 9 is now available under Materials. As we already received some questions regarding the exam, here a few clarifications: The exam will take place on February 24th, the reexam exactly one month later on March 24th. If you haven't done so, please participate in the Qualis course evaluation as it helps us to improve the course in the future: Evaluation form for the lecture: Best regards |
Assignment 8 & Course EvaluationWritten on 13.01.21 by Christian Schön Dear students, we just published the next assignment sheet. You can find it under Materials, as usual. In addition, you are now given the opportunity to provide us feedback on the course using the university's Qualis evaluation. Due to the current Corona situation, the evaluation will be… Read more Dear students, we just published the next assignment sheet. You can find it under Materials, as usual. In addition, you are now given the opportunity to provide us feedback on the course using the university's Qualis evaluation. Due to the current Corona situation, the evaluation will be conducted online. You are asked to fill out two forms: One for the lecture in general and an additional one for the tutorials. We highly encourage you to use this opportunity to provide feedback as it helps us to improve the course in the future. The evaluation forms will be available until January 29th under the following links: Evaluation form for the lecture: |
Assignment 7 & Milestone 3Written on 06.01.21 by Christian Schön Dear students, Milestone 3 will be due on January 27th, 23:59 UTC+1, i.e. in 3 weeks from now. We wish you good luck! Dear students, Milestone 3 will be due on January 27th, 23:59 UTC+1, i.e. in 3 weeks from now. We wish you good luck! As mentioned on the main CMS page, you will need 50% of the total points to be admitted to the exam, i.e. 10 out of the 20 points you can score in the project. Best regards |
Assignment 6Written on 16.12.20 by Christian Schön Dear students, Assignment 6 is now available under Materials. Best regards Christian |
Milestone 2Written on 14.12.20 by Immanuel Haffner Dear students, we just released Milestone 2. As usual, you find the PDF document in the CMS Materials section. The 2nd milestone is due January 5, 2021, 23:59 UTC+1. To be able to work on Milestone 2, you must update your project with the new contents of the skeleton. To do so, run
Dear students, we just released Milestone 2. As usual, you find the PDF document in the CMS Materials section. The 2nd milestone is due January 5, 2021, 23:59 UTC+1. To be able to work on Milestone 2, you must update your project with the new contents of the skeleton. To do so, run
All the best, Immanuel |
Assignment 5 & Exam registrationWritten on 09.12.20 by Christian Schön Dear students, Assignment 5 is now available in the CMS, covering different join and sorting algorithms. If you haven't noticed: The exam registration is now open in HISPOS/LSF. Dear students, Assignment 5 is now available in the CMS, covering different join and sorting algorithms. If you haven't noticed: The exam registration is now open in HISPOS/LSF. The registration (and unregistration) for the final exam is open until January 27th. Some students (e.g. Business Informatics, Erasmus) might not be eligible to register through the HISPOS/LSF. Please keep in mind that Milestone 1 of the project is due on Sunday evening, so about 4 days left to work on it. Best regards |
Deadline Extension Milestone 1Written on 04.12.20 by Christian Schön Dear students, as we had some bugs in mutable that affected your work on the project, we decided to grant you an extension of the deadline for Milestone 1. The first part of the project is now due Sunday, December 13th 23:59 UTC+1. The release of the second Milestone is also moved to the following… Read more Dear students, as we had some bugs in mutable that affected your work on the project, we decided to grant you an extension of the deadline for Milestone 1. The first part of the project is now due Sunday, December 13th 23:59 UTC+1. The release of the second Milestone is also moved to the following Monday. This gives you an additional 5 days to work on the first project part. Our calendar has been updated accordingly. We really encourage you to make active use of our forum: either to raise questions or to discuss problems with your fellow students. Discussions in the Lab might be fine if you have very specific questions related to your team's implementation, but most of the more general questions might be of interest for all of your fellow students. Asking them in the forum allows everyone to profit from the discussions in the respective thread. And it saves time as the same question does not need to be answered multiple times. So if you have questions, the chance is there that you will already find your answer in the forum. We wish you good luck for the first project part and hope you can benefit from the additional time! Christian |
Assignment 4 & Project EvaluationWritten on 02.12.20 by Christian Schön Dear Students, Assignment 4 is now available under Materials. As some of you might have already noticed, we have also prepared a project evaluation website for you which is linked in the menu under Information. This page provides for each team information about the percentage of tests passed per… Read more Dear Students, Assignment 4 is now available under Materials. As some of you might have already noticed, we have also prepared a project evaluation website for you which is linked in the menu under Information. This page provides for each team information about the percentage of tests passed per Milestone as well as the total number of tests passed over time. This might help you identify points in time were your project implementation made progress (or maybe also a step back). Please keep in mind that the first Milestone is due next Tuesday 23:59 UTC+1, so less than one week remaining. Make sure that you upload your final implementation to the master branch ahead of time (we will not consider implementations available on other branches in your repository). Best regards Christian |
Assignment 3Written on 25.11.20 by Christian Schön Dear students, we have just released the third assignment sheet with exercises related to B-trees, the topic of this week's lecture. You can work on them in the next days as well as in the Lab on Friday before we present the solutions in the tutorials on Monday and Tuesday. Best regards Christian |
GitLab & Project RegistrationWritten on 20.11.20 (last change on 23.11.20) by Christian Schön Dear students, some teams seem to misunderstand the description for the team registration phase. The Milestones 0 & 1 clearly mention that we cannot assign you to your team's repository if you haven't logged in to GitLab at least once before, as your accounts are invisible up to that point. This… Read more Dear students, some teams seem to misunderstand the description for the team registration phase. The Milestones 0 & 1 clearly mention that we cannot assign you to your team's repository if you haven't logged in to GitLab at least once before, as your accounts are invisible up to that point. This requirement does not only affect the team member sending the mail, but also all other team members. As we expect all participants of this course to actively work on the project, we also expect every student to have a GitLab account which we can properly link to the team's repository. Therefore please check that each team member has logged in at least once before sending your team registration by mail. All teams that have already sent a mail, should check for all team members that everyone has been assigned correctly to the team's repository. In case you can not see your repository after logging in to GitLab, get in contact with Immanuel by sending an email including "[dbsys20]" in the subject. Please mention your team name as well as your full name, matriculation number and student email address in the mail content as described in Milestone 1. We might not grade the project for students which do not have a GitLab account properly linked to the team's repository. As the project is not deemed to be done by a single student for the whole team, we consider this as a minimum requirement for project participation which every student must fulfill. If you have any problems signing in to GitLab, let us know through the forum or by mail, we will try to solve these problems. Hope to see you in the Lab at 12:15 pm on Discord or in the tutorials next week on Zoom (links will follow in the calendar). Best regards Christian |
Assignment 2 & Milestone 1Written on 18.11.20 (last change on 18.11.20) by Christian Schön Dear Students, we have just released the Assignment 2 as well as Milestone 1 for the project. Unfortunately, not all students registered in the CMS have also registered with a team for the project. Keep in mind that you can not pass the course without the project. Therefore please check if you… Read more Dear Students, we have just released the Assignment 2 as well as Milestone 1 for the project. Unfortunately, not all students registered in the CMS have also registered with a team for the project. Keep in mind that you can not pass the course without the project. Therefore please check if you can 1) log in to Gitlab sucessfully and 2) see your team's repository. If either of these two steps failed, you have not yet correctly registered for the project. In that case, please follow exactly the registration steps given in Milestone 1. We will then try to (re-)assign you to your repository after receiving your mail. Besides the registration steps, Milestone 1 also contains all necessary information to get you going for the first part of the project in which you will implement a row as well as a column store. Please read the instructions carefully! The deadline for this first milestone is on December 8th, 23:59 UTC+1. The Vagrant file is now also available in the Materials section of the CMS if you need an easy to set up virtual machine for the project. An instruction on how to use Vagrant is also linked under Information. The Assignment 2 covers the content of this week's lecture. We highly recommend to work on these assignments as an exam preparation (e.g. in the upcoming Lab on Friday). The solutions will be presented in next week's tutorials. As always, feel free to use the forum whenever you have questions regarding assignment sheets or project milestones. Our Discord server is available 24/7 if you need a platform to discuss assignments or milestones within your team. Just create a team voice channel and join it with all your team members. Consider locking the voice channel after all members joined it to avoid non-team-members to also join your channel. Keep in mind that sharing solutions across teams is not allowed and will be considered a fraud. We wish you good luck for the first project part and hope to see many of you in the next Lab on Friday. Best regards Christian |
Tutorials moved to ZoomWritten on 16.11.20 by Christian Schön Dear students, the tutorials have been moved to the video conference tool Zoom. Although invitations can be accepted by just clicking on a link, you will need the Zoom client to be able to join a meeting. Please follow the official documentation to install and setup Zoom. After installing the… Read more Dear students, the tutorials have been moved to the video conference tool Zoom. Although invitations can be accepted by just clicking on a link, you will need the Zoom client to be able to join a meeting. Please follow the official documentation to install and setup Zoom. After installing the client, you can test Zoom and familiarize yourself with the tool in advance by joining a test meeting on their website. To join the tutorial itself, it will then later be sufficient to just click on the corresponding links which are given in our calendar. As the link might change per tutorial, we ask you to check the CMS for updated links before each tutorial. The link for today's tutorial with Immanuel (2:15 pm) is already published, the link for tomorrow will follow later. Best regards Christian |
TutorialsWritten on 13.11.20 by Christian Schön Dear Students, as most of you noticed today, screen sharing in Discord is limited to 50 persons. Unfortunately, we are currently unable to increase that limit. As our tutorials on Monday and Tuesday might also be affected by this limit (depending on the number of participants), we are currently… Read more Dear Students, as most of you noticed today, screen sharing in Discord is limited to 50 persons. Unfortunately, we are currently unable to increase that limit. As our tutorials on Monday and Tuesday might also be affected by this limit (depending on the number of participants), we are currently discussing to switch to the video conference tool Zoom. As we have to reorganize the tutorials, I can not provide you the exact credentials for Monday and Tuesday at the moment. Please check our CMS (especially the corresponding events in our calendar) again on Monday before the tutorials start. We will provide you the necessary information by then. We have also discussed the content for the upcoming tutorials and came to the conclusion that it might be better to already discuss the solutions for assignment 1 next week, i.e. on November 16th and 17th. This allows us to focus exclusively on the topics of the first week before new content will be introduced in Wednesday's lecture. Regarding the choice of time slot: We do not plan to assign you to a fixed tutorial at the moment, so you are free to choose the time slot that fits you best. Best regards Christian |
Assignment 1 & Milestone 0Written on 11.11.20 (last change on 11.11.20) by Christian Schön Dear students, we have just released the first assignment sheet and Milestone 0 of the project, you can find both in the menu under Information -- Materials. As we have already announced in the beginning of the course, you will not need to hand in any of the weekly assignment sheets as we will… Read more Dear students, we have just released the first assignment sheet and Milestone 0 of the project, you can find both in the menu under Information -- Materials. As we have already announced in the beginning of the course, you will not need to hand in any of the weekly assignment sheets as we will not grade them. However, these assignment sheets contain exercises that are similar to those that you will encounter in the exam. We therefore highly recommend to spend some time on solving the exercises. The LABs will be held on Discord starting this Friday 12:15 pm, you will find a corresponding text as well as voice channel there. In each week's LAB, we will start with a short, interactive recap of the lecture before you can team up in small groups to work on the assignment sheet of the week (ideally the groups you already formed for the project, but not necessarily). Our team of tutors will be present in the LAB such that you can ask questions regarding the exercises. The solutions will be presented in the tutorials on Monday and Tuesday. As we want to give you at least a full week to work on the exercises, the solutions for assignment 1 will be discussed on November 23rd and 24th. Milestone 0 of the project asks you to form teams of three students and to register for the project. The PDF contains all details necessary to prepare for the first (real) project milestone which is scheduled to be published next week's Wednesday. In each of the upcoming milestones, we will ask you to implement a specific component of a database system in a time period of roughly 3 weeks (excluding holidays). As we need to prepare a few things in the background (e.g. your git repositories), we ask you to register your team no later than November 17th. Details on the steps necessary to register are given in the PDF. All further information regarding the database components to implement, the steps required to do so etc. will be described in the corresponding project milestones which are released at a later point in time. The handouts (i.e. publication dates) and deadlines are included in our calendar, if you already want to schedule team meetings. If you still need team members for the project or have questions regarding the lectures, assignment sheets or project milestones, feel free to use our forum. Best regards Christian |
Lecture StartWritten on 03.11.20 by Christian Schön Dear students, we will start our course Database Systems with our first lecture tomorrow at 12:15 pm on YouTube. All lectures will be streamed live on Prof. Dittrich's channel. We will publish direct links to each week's lecture in our calendar which you can find in the menu under… Read more Dear students, we will start our course Database Systems with our first lecture tomorrow at 12:15 pm on YouTube. All lectures will be streamed live on Prof. Dittrich's channel. We will publish direct links to each week's lecture in our calendar which you can find in the menu under Information. If you have questions during the lecture, you can ask them anonymously using an online tool called frag.jetzt for which a link is also provided in the Information section of the menu. The tool's user interface is provided in German and English, you can toggle the language at the bottom of the page. However, we ask to you formulate your questions in English such that all students understand them. Your questions will be moderated, it might therefore take a second for a question to become visible for all. Besides frag.jetzt, you usually have the opportunity to ask questions in short office hours by Prof. Dittrich during the lecture break or shortly after the lecture. These office hours will be held on Discord. Please follow the Discord Guide linked in the menu under Information to join our server. In addition, we offer you a forum to ask questions that arise after the lecture or to discuss topics with your fellow students and our team. All further information regarding the course and its topics will be given in tomorrow's lecture. Best regards Christian |