News
Endterm Retake DateWritten on 17.12.24 by Marcel Maltry Dear Students, The endterm retake has been scheduled for March 21, 2025, from 10:00 to 11:30. Kind regards, |
Midterm Retake RegistrationWritten on 17.12.24 by Marcel Maltry Dear Students, Registration for the midterm retake is now open and will close on January 7, 2025, at 23:59. Please note that this is also the day of the midterm inspection. As always, late registration will not be possible. Kind regards, Marcel |
Midterm Inspection RegistrationWritten on 17.12.24 by Marcel Maltry Dear Students, As previously announced, the midterm inspection will take place on January 7, 2025, from 16:00 to 17:30 in E1 1, Room R3.06. To participate, please register for one of the three available time slots on your personal status page. This will allow us to prepare your exam and ensure a… Read more Dear Students, As previously announced, the midterm inspection will take place on January 7, 2025, from 16:00 to 17:30 in E1 1, Room R3.06. To participate, please register for one of the three available time slots on your personal status page. This will allow us to prepare your exam and ensure a smooth process. Kind regards, |
Midterm Results and InspectionWritten on 14.12.24 by Marcel Maltry Dear students, The midterm results are now available and can be viewed on your personal status page in the CMS. Please note that we have published the points you earned. The grade scale will be announced along with the results of the endterm at the end of the semester. An inspection for the… Read more Dear students, The midterm results are now available and can be viewed on your personal status page in the CMS. Please note that we have published the points you earned. The grade scale will be announced along with the results of the endterm at the end of the semester. An inspection for the midterm is scheduled for Tuesday, January 7, 2025, from 16:00 to 17:30. This will be organized in three time slots. A separate announcement will follow when the registration for these time slots opens. While no new assignment was released this week, next week’s tutorials will still take place as usual. During these sessions, we will focus on discussing the midterm. Cheers, Marcel |
Midterm Lecture Hall AssignmentWritten on 10.12.24 by Marcel Maltry Dear Students, I have assigned you to lecture halls for the midterm exam this Saturday. Please note the following important details:
Dear Students, I have assigned you to lecture halls for the midterm exam this Saturday. Please note the following important details:
When entering the lecture hall, kindly:
Kindly revisit the earlier announcement for additional information. Thank you for your cooperation! Kind regards, |
Midterm Registration: Final CallWritten on 07.12.24 by Marcel Maltry Dear Students, The registration for the midterm is open until midnight. Late registrations are not possible. Kind regards, |
Scope of the Midterm and Midterm RetakeWritten on 06.12.24 by Marcel Maltry Dear Students, It seems there has been some confusion regarding the scope of the midterm and the midterm retake. Both exams will cover material up to and including today's lecture. This includes Slides 01 to 09a (including the guest lecture on RMIs) and Assignments 01 to 06. For more details on… Read more Dear Students, It seems there has been some confusion regarding the scope of the midterm and the midterm retake. Both exams will cover material up to and including today's lecture. This includes Slides 01 to 09a (including the guest lecture on RMIs) and Assignments 01 to 06. For more details on what to expect, please refer to our earlier announcement. Kind regards, Marcel |
Guest Lecture TomorrowWritten on 28.11.24 by Marcel Maltry Dear students, Tomorrow’s lecture will be a guest lecture on Recursive Model Indexes, featuring very recent and unpublished research. For this reason, the lecture will not be recorded. We encourage you to attend the session in person to get the most out of the material and participate in… Read more Dear students, Tomorrow’s lecture will be a guest lecture on Recursive Model Indexes, featuring very recent and unpublished research. For this reason, the lecture will not be recorded. We encourage you to attend the session in person to get the most out of the material and participate in discussions. Thank you for your understanding. Best regards, Marcel |
Update: Midterm RegistrationWritten on 27.11.24 by Marcel Maltry Dear Students, Please note that, contrary to last week’s midterm announcement, registration will only be possible via CMS. Registration is open until one week before the exam. Participation is only allowed if you are registered. Late registrations will not be accepted. Dear Students, Please note that, contrary to last week’s midterm announcement, registration will only be possible via CMS. Registration is open until one week before the exam. Participation is only allowed if you are registered. Late registrations will not be accepted. The previous midterm announcement has been updated accordingly. Kind regards, |
Midterm AnnouncementWritten on 25.11.24 (last change on 27.11.24) by Marcel Maltry Dear students, The midterm is approaching, and we want to provide you with all the necessary information. Please read this announcement carefully and post any questions on the forums. TimeThe midterm will take place on Saturday, December 14, at 12:15.
Dear students, The midterm is approaching, and we want to provide you with all the necessary information. Please read this announcement carefully and post any questions on the forums. TimeThe midterm will take place on Saturday, December 14, at 12:15.
RegistrationRegister for the midterm via CMS. Registration is open until one week before the exam. Participation is only possible if you are registered. Late registrations will not be accepted. Room AllocationThe midterm will take place in GHH and E2 5, HS I. After registration is finalized, we will assign each student to a lecture hall. Your assigned hall will be visible on your personal status page in CMS. You must take the midterm in the lecture hall assigned to you. Permitted MaterialsYou are allowed to bring:
No additional materials are permitted. We will provide sufficient paper, so please do not bring your own. What to ExpectThe midterm will consist of three exercises similar to those in the assignments. Each exercise is designed to take approximately 30 minutes. The exam will cover all material up to and including the week before the exam, as well as the content of Assignment 6. You are not expected to write Python code or memorize the implementations shown in the lecture. However, you may be asked to write pseudo-code to convey algorithmic ideas. If you have further questions, feel free to email me or post them on the forums. Wishing you much success, |
Repetition ExercisesWritten on 08.11.24 by Marcel Maltry Dear students, This week's assignment introduces repetition exercises that build on material from the base lecture and are closely related to recent topics. While the topics covered in these exercises are not directly relevant for the exam, you should be able to solve them based on the prior… Read more Dear students, This week's assignment introduces repetition exercises that build on material from the base lecture and are closely related to recent topics. While the topics covered in these exercises are not directly relevant for the exam, you should be able to solve them based on the prior knowledge expected for this course. Kind regards, Marcel |
No Tutorials Next WeekWritten on 30.10.24 (last change on 30.10.24) by Marcel Maltry Dear students, Since there will be no lecture this week, there won’t be a new assignment. As a result, we have decided to cancel next week’s tutorials. Kind regards, Marcel |
No lecture on Oct 30thWritten on 29.10.24 by Jens Dittrich Dear all: I have been sick since last weekend and therefore won't be able to give the lecture tomorrow. The next lecture will be on Wednesday, Nov 6th. Best regards, jd |
Room Change: Tuesday TutorialWritten on 28.10.24 by Marcel Maltry Dear Students, Please note that the Tuesday tutorial session will now be held in E2 1, Room 001 (Bioinformatics). Kind regards, |
Registration ClosedWritten on 23.10.24 by Marcel Maltry Dear Students, Since the registration closed last Sunday, I have received numerous emails from students still wishing to participate in the course. The registration deadline was announced well in advance, and tutorials have already been assigned. Any further registrations would require manual… Read more Dear Students, Since the registration closed last Sunday, I have received numerous emails from students still wishing to participate in the course. The registration deadline was announced well in advance, and tutorials have already been assigned. Any further registrations would require manual intervention on my part. Therefore, we will no longer accept registrations via email. Thank you for your understanding. Kind regards, Marcel |
Tutorial AssignmentsWritten on 21.10.24 by Marcel Maltry Dear students, You have been assigned to your tutorials, and you can view the details on your personal status page. Tutorial slots are flexible, so if you are unable to attend your assigned time in any given week, feel free to choose another available slot, as long as seats are available. Kind regards, |
Tutorial Preference ReminderWritten on 18.10.24 by Marcel Maltry Dear students, Please remember to submit your preferences for tutorial slots by Sunday, 20 October, 23:59, to be considered in the distribution process. If you decide not to continue with this course, kindly deregister. Course materials will remain publicly available, even after… Read more Dear students, Please remember to submit your preferences for tutorial slots by Sunday, 20 October, 23:59, to be considered in the distribution process. If you decide not to continue with this course, kindly deregister. Course materials will remain publicly available, even after deregistration. Kind regards, Marcel |
Course Registration and Tutorial Preference ReminderWritten on 11.10.24 by Marcel Maltry Dear students, Please complete your course registration by 20 October, 23:59, and select your preferred tutorial slot via your personal status page. If you have already chosen your tutorial slots, kindly double-check you selection, as we had to adjust the Tuesday slot. In the tutorials, we will… Read more Dear students, Please complete your course registration by 20 October, 23:59, and select your preferred tutorial slot via your personal status page. If you have already chosen your tutorial slots, kindly double-check you selection, as we had to adjust the Tuesday slot. In the tutorials, we will primarily review sample solutions for the assignments distributed the previous week. These solutions will also be made available in the CMS. If you do not plan to attend any tutorial, please select the "No Tutorial" option. Best regards, Marcel |
Database Systems (Core Lecture)
Objectives of this Lecture
- Learn basic techniques in Database Systems conceptually: Slides, algorithms, system, exercises
- Learn to apply algorithms in the field of Database Systems
- Help you not to reinvent the wheel: learn to map new problems to existing problems and solve them with established techniques.
- Sensitize for problems of important applications: scalability, performance problems, durability, isolation
- Sensitize for solutions of important applications: effort, performance, robustness, extensibility, maintainability
Distinction to Big Data Engineering (Undergrad Lecture)
Big Data Engineering: Focus on principles, design patterns and application of Big Data technologies, in particular Data Engineering.
vs
This lecture: Deeper dive into the underlying techniques, in particular the systems aspect of Database Management Systems.
Administrative Details
All information about assignments, tutorials, lecture mode, topics, registration, etc. will be explained in the first lecture on Wednesday, October 16th, 10:15 in E1 3, HS II. Tentative exam dates can already be found in the calendar.