ARBEITSGRUPPE

DATENBANKEN UND

SOFTWARE ENGINEERING

Organization

Exam requirements

• Registration for an exercise via LSF platform.
• Passing the programming assignment. 

News

• You need to register for the exercise via LSF platform until the 28.04.2019.
• The exam review will take place on the 01st of April at 09:00 in room G29-130.
• The first exercise will take place on 10. April 2019 (Introduction - all students should attempt).
• The exercise on the 29.05.2019 is canceled due to the teaching day.

Content

• Most recent technological developments in data management.
• Current scientific research being on the verge to wide usage in current applications
• Topics of the lecture will frequently change in accordance with current research directions in the database community:
• Indexing and storage techniques for new applications and data types,
• Self-management capabilities of database management systems
• Column-oriented DBMS
• GPU-accelerated Datamanagement
• Query Compilation
• etc.

Lecture

• The lecture slides will be published after each lecture.
  • Overview
  • Main Memory Database Systems 
  • Parallel Join Ordering
  • Hardware-Sensitive Database Operations I
  • Hardware-Sensitive Database Operations II
  • Index Structures for Main Memory Databases (complete)
  • A Gentle Introduction to Document Stores and Querying with the SQL/JSON Path Language
  • AI Techniques for Database Management I
  • AI Techniques for Database Management II

Exercise

• Exercise sheets will be published one week in advance.
• Exercise tasks need to be prepared before the exercise and will be discussed within the exercise.
  • Main Memory Database Systems I
  • Main Memory Database Systems II
  • Parallel Join Ordering I
  • Parallel Join Ordering II 
  • Hardware-Sensitive Database Operations I  
  • Hardware-Sensitive Database Operations II
  • Index Structures for Main Memory Databases
  • Document Stores I  (open)
  • Document Stores II  (open)
  • Document Stores III  (open)
  • Machine Learning (open)

Programming Project

• You need to pass two of the following programming assignments:
  • Extending Main-Memory Index Structures with Special Selection Capabilities (Task, Supervisor: David Broneske, code updated on 13.05.2019) (full)
  • Task Sheet: Optimizing Memory Pooling for In-Memory Database Systems (GitHub Code Repo, Supervisor: Marcus Pinnecke)
  • SQL Evaluation using Volcano Processing Model (Task, Supervisor: Balasubramanian Gurumurthy) (full)
  • Range search with neural networks (Task, Supervisor: Gabriel Campero )
• You need to register your group for the assignments via mail to Andreas Meister
• There is a limit of 9 groups per programming assignment (Provision according to registration date)
• There is no registration deadline
• Submission deadline for the programming assignments is the 30. June.
• For general questions regarding the programming project, please contact Andreas Meister
• For questions regarding a specific programming assignment, please contact the corresponding supervisor.

Literature

• Additional references are included in each lecture slide