Advanced Topics in Databases
Organization
| Lecturer: |
David Broneske |
| Lecture: | LSF-Entry |
| Exercise Instructor: | Andreas Meister |
| Exercise: | LSF-Entry |
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