Lecture "Distributed Database Systems" WS 2011 / 2012
Lecture "Distributed Database Systems"
Dr. Katja Hose,
PD Dr.-Ing. Ralf Schenkel,
Content
In today's data management, we face the problem that data is often naturally distributed among multiple sites. The distributed architecture requires sophisticated techniques to answer queries efficiently.
Beginning with the basics of data management in classical distributed database systems, this lecture gives an overview of the state of the art. More specifically, the lecture covers topics such as data fragmentation, replication, schema integration, query processing algorithms in general as well as for specialized architectures, e.g., standard distributed database systems, peer-to-peer systems, and grid systems.
Organization
- Lecture: Thursday, 14:15 - 15:45, HS-002, building E1.3 (CS building) !!! Room changed !!!
- First lecture: Thursday, October 20
- No lecture on December 22
- Last lecture: Thursday, February 9, room 0.01, building E1.7 (MMCI building)
- Exercises:
- Group 1: Tuesday, 10 - 12, room 3.23, building E1.7 (MMCI building, third floor)
- Group 2: Wednesday, 14:15 - 15:45, room 0.01, building E1.7 (MMCI building)
- First excercise group meeting: November 2
- Additional short tutorial on Wednesday, January 11, 14:15, room 0.01, building E1.7, to discuss the last exercise of Assignment 6
- Exams:
- Dates: February 20-24
- The schedule for the exams is available here
- If you have to cancel, please inform us well in advance!
- Location:
- February 10: building E1.7 (MMCI) room 3.01
- February 20: building E1.7 (MMCI) room 3.01
- February 22: building E1.7 (MMCI) room 0.02
- February 23: building E1.7 (MMCI) room 3.01
- February 24: building E1.7 (MMCI) room 3.01
- Please be there 10 minutes in advance and bring your student ID!
- In case you have to cancel, let us know as soon as possible and well in advance.
- Certificates (Scheine):
- Certificates (Scheine) can be picked up in building E1 4 room 402
- Re-Exams:
- Date: Tuesday, April 3
- The schedule is available here
- Oral exam
- Certificates (Scheine) can be picked up in building E1 4 room 402
Prerequisites
Students planning to attend the course should have basic knowledge of standard database technologies (successful participation in the basic course on Database Systems or Information Systems is fine), even though we will introduce all necessary concepts and techniques in the lecture.
Requirements for the certificate
- You must successfully participate in an exam at the end of the semester
- You should actively participate in the exercise group
Slides
Assignments
- Assignment 1 Handout: October 20,
Due: October 26 (before lecture)
- Assignment 2 Handout: October 26, Due: November 3 (before lecture time, only assignments 2.1 and 2.2) / November 10 (before lecture time, assignments 2.3-2.6)
- Assignment 3 Handout: November 10, Due: November 17 (before lecture)
- Assignment 4 Handout: November 17, Due: November 24 (before lecture)
- Assignment 5 Handout: November 24, Due: December 1 (before lecture)
- Assignment 6 Handout: December 1, Due: December 8 (before lecture)
- Since we are behind schedule in the excercise groups, the next assignment will be available December 15 (due January 12). Groups on December 20 and 21 meet if needed to catch up (Luis will announce this in the meetings on December 13 and 14). There are no group meetings in the first two weeks of January.
- Assignment 7 Handout: December 15, Due: January 12 (before lecture)
- Assignment 8 Handout: January 12, Due: January 19 (before lecture)
- Assignment 9 Handout: January 19, Due: January 26 (before lecture)
- Assignment 10 Handout: January 26, Due: February 2 (before lecture)
