Saarland University Saarland University | Department of Computer Science

Big Data Analytics Group

Advanced Information Systems LAB: OctopusDB, SoSe 11

Database systems are the backbone of today's data-ubiquitous and data-intensive economy. However, much of the data processing architectures and the core technology in current databases was designed in 70s or 80s. In this course the students will look into a new kind of database architecture, namely one-size-fits-all database architecture, and apply advanced data management concepts and technology to process modern day data-oriented tasks using this architecture.

This course is project-oriented. It aims to solve one or multiple tasks by letting students develop small software projects. Students will be grouped into teams of 2-3 people.

Topics will include:

This year we will build several components in a PostgreSQL prototype of OctopusDB system, which was briefly discussed in the NOSQL lecture. OctopusDB is a new type of database system making life of users and DBAs far easier. Detailed information will be given in the lecture. Part of the LAB consists of lecture-style presentations. The lecture material covers:
  • introduction to the research problem
  • some initial directions to solve it
  • pointers to related work and baseline comparisons
For the project students will be grouped into teams. The project consist of three milestones:
  1. Milestone 1 is is the research phase. In this phase students will study related work and develop initial solution to the research problem.
  2. Milestone 2 is the practical phase. In this phase students will prototype their solution in C/Java. Each team will be responsible for at least one component of the overall system.
  3. Milestone 3 is the validation phase. Students will test and benchmark their approach and compare it with existing solutions.

Administrative issues:

  • Students are expected to have successfully passed the information systes base lecture as well as the database systems core lecture or equivalent lectures. Additional DB-related courses are considered a plus.
  • This course counts 9 graded ECTS.
  • Regular meetings are on Thursdays, 14.15 to 16:00, Place: room 222.2, Building E1.1
  • The kickoff meeting will on April 14, 2011 at 14:15.
  • The number of participants is limited to 15 people.
  • Requirements for passing this course:
    • Regular attendance of classes (you may miss at most one class)
    • Active participation in research, practical, and validation phase
    • Successful accomplishment of milestones (at least 50% for each milestone)
    • Successful presentation of your programming project
    • Final grade: Each milestone counts 20% of your overall grade. The final solution of your project counts 40% of your overall grade. Your team will influence your overall grade, however, each student will be graded individually.
    • We will also offer a weekly office hour to help you with technical issues, write-up, presentations etc. Partiticpation in the office hour is voluntary, however highly recommended. In case we have any doubt on the quality of your milestones or project, we may ask you to attend office hours regularly.

Lecture Notes

Project Material