Query Optimization: Past to Present

Dear all,

we have decided on your final course grades.  The course grade is determined to a large degree by your presentation. Your peer summaries and your participation in the Q&A were considered mostly when we had to decide between two grades. You can inspect your grade in your Personal Status page. Should you not find your grade on this page, please contact me immediately.

We provide you the opportunity to get feedback on your presentation. This feedback can clarify our decision for your grade and may provide useful suggestions for improvement that can aid you when preparing your next presentation. This service is optional. If you want to get feedback, please contact your assigned advisor to schedule a meeting. The meeting should take 5-10 minutes. IMPORTANT: To set expectations right, let me clearly say that this is NOT an opportunity for you to negotiate a better grade.

Thanks for this nice seminar. I hope you learned something and became even more passionate about database systems and query optimization than you were already ;)

Kind regards,

Immanuel

Dear all,

we will have the final talks on Monday, August 7th, and Wednesday, August 9th. More precisely, we will have four blocks of talks in total, with one block before lunch break and one block after lunch break on each day.

Schedule

The exact times are as follows:

• Monday, August 7

  • Block Foundational: 11am - 1pm
  • Block Bottom-Up: 2pm - 4pm
• Wednesday, August 9
  • Block Top-Down: 9:30am - 11:30am
  • Block Heuristic Algorithms: 12:30pm - 2pm

If you haven't scheduled a meeting with your advisor yet, please do so ASAP. The meeting with your advisor is mandatory. If you do not have this meeting with your advisor, we will lower your grade by one level.

 

Presentation Guideline

Your talk must be 23-25 minutes in length. The technical deep dive afterwards, where you discuss an important proof or go over some code, must take 7-10 minutes. Overall, your presentation will take 30-35 minutes. Afterwards, we will have 5 minutes for questions and discussion with the audience (Q&A). You may (and should) prepare backup slides of anything that you were not able to cover in your talk because of a lack of time but which might come up during the Q&A. Please include references to related work(s) and use the alphabetic style for references. They should look like this: [Sel+89; OL90; Van98; VM96; MN06] where Sel+89 is Selinger et al.'s work from 1989 and OL90 is Ono & Lohman's work from 1990. Have the bibliography appear after your final / concluding slide. Our seminar room 3.06 (where we held our peer group meetings) is very bright and we do not have shutters on the windows to the north. Slides with black / dark background don't work well in this room, please avoid them and prefer high contrast with black / dark text on white background. Also make sure to prepare slides for the beamer's 4:3 aspect ratio.

Please contact me immediately if something is unclear.

 

Looking forward to great talks!

Kind regards,

Immanuel

Dear all,

please fill in this poll to schedule the final talks. I plan to have 3 presentations of 25+10 minutes each in a 2h block. We will then distribute four 2h blocks over the week. Optimally, we would need two days with one block before and one block after lunch. Let's see how the poll goes.

Regards,

Immanuel

Dear all,

here is the assignment of students to supervisors:

• Joris Nix: 5, 7, 8
• Marcel Maltry: 1, 9, 10
• Immanuel Haffner: 2, 3, 6, 11, 12

Please get in contact with your advisor soon to schedule a meeting. You can reach us by mail via the Team page.

The meeting with your advisor should happen this month, so that you have time to incorporate your supervisor's feedback into your presentation. Make sure to come prepared! Prepare your slides, have a clear agenda for your presentation, and prepare your 10 minutes "deep dive" (e.g. code or proof).

I will send around a poll to schedule the final presentations shortly.

Regards,

Immanuel

Dear all,

our second peer group meeting will be held on Thursday, June 29, at 3:15 pm in E1.1 room 3.06.

For the two students who are unable to attend: if you can't make it to the meeting, I expect you to get in contact with your peers on your own -- by video call, for example -- and catch up.

Sorry for sending you this information so late.

Regards,

Immanuel

Dear all,

your peer summaries are now available in the CMS in the Materials section. Make sure to read your peers' summaries carefully before our second peer group meeting.

I am sending you these lines from my flight back from SIGMOD in Seattle while watching the sunrise from the air plane. I can say that the internet up here is much better than in any DB train :D

Kind regards,

Immanuel

Dear all,

I have postponed the submission deadline for your peer paper summaries to June 18th, 23:59. Please make sure to not miss this deadline! You can submit your paper summaries via CMS on your personal status page. Please file one separate submission per paper. (Do not submit a single document summarizing both peer papers.)

After the submission deadline, your paper summaries will be made accessible on the CMS within this course so your peers can access your summaries. Your summary should be 1-2 pages. If you can manage to summarize the paper in one page, that is perfectly fine. Please also add remarks where you feel the paper is lacking detail, experimental results are unexpected, claims are not properly supported by proofs or experiments, or anything else that you feel needs to be discussed. Also, if you have a hard time understanding a particular section of a paper, please write that down and let your peer know. There is no shame in not understanding (parts of) a paper -- its often the authors' fault ;) Your opinion will greatly aid your peers in preparing an excellent presentation and better manage where to invest more time.

Overall, I suggest that you put in the effort to writing those summaries that you expect from your peers ;)

Regarding Peer Group D: You must write a summary on your peer's paper as well as on your own paper. This means you will be writing two peer summaries, like everyone else.

All the best,

Immanuel

Dear all,

Our first peer group meeting will be held on Thursday, June 1st, at 3:15 pm. Make sure to come prepared: you must have read your assigned paper and are expected to give your peers a brief, roughly 5 minutes, overview of the paper. Afterwards, you will discuss how your papers are related, how they overlap in content, and how you will be able to build upon each other's presentations.

We meet in seminar room 3.06 in E1.1 (as usual).

See you on Thursday.

Regards, Immanuel 

Dear all,

please fill in this poll so we can find a date for our first peer group meeting. You can find the peer groups on the Paper Assignment page.

For the first peer group meeting, you must have read your own paper and give a brief (~5 minutes) overview of the paper to your peers. After each peer group member introduced their paper, you spend ~15 minutes on identifying overlapping content and how your assigned papers are related. Think about how you will be able to build on each others presentations to avoid repeating material.

Looking forward to seeing you next week ;)

Regards, Immanuel

Dear students,

the paper assignment is finished and can be found at Information → Paper Assignment. I can happily say that everyone was assigned their first or second preference; no third preference had to be assigned.

I only received 11 paper preferences. Currently, paper #4 by Cluet & Moerkotte is not assigned.

Regards,

Immanuel

Dear all,

please be aware that the deadline for the paper preferences submission is TODAY. To submit your preferences follow the instructions in the calendar entry. I will do my best to have your papers assigned to you by tomorrow afternoon.

(If you sent me a mail to my CMS mail address and the mail didn't bounce, you can assume that I received it.)

Best,

Immanuel

Dear students,

I am very pleased to welcome you to our seminar on query optimization.  We have to quickly find a date for our kick-off meeting. Please use the following link to our poll with available dates for a kick-off meeting. Please select all the dates you have time for.

Link to poll: https://nuudel.digitalcourage.de/XDAyjjIGgL1eLx5t

Please fill in the poll as soon as you can.  This poll is for the kick-off meeting only.  For future meetings, we will do another poll.

Thanks & kind regards,

Immanuel