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