Advanced Database and Information Systems
Lecturer
Course Contents
The course introduces advanced topics of Databases and Information systems, covering system-oriented as well as theoretical aspects:
Systems:
- JSON and XML standards, language families and processing using SQL
- NoSQL and columnar datastores
- SQL on top of cumputing clusters: Hadoop, MapReduce, PigLatin, Hive and Spark
Theory:
- SQL
- Datalog
- Nonfirst Normalform Languages
Material
Slides, exercise sheets and other material can be found in ILIAS.
Necessary Prerequisites
The key course (Kursvorlesung) 'Databases and Information Systems' or an equivalent Database course.
Time, Location and Organization:
Lecture: Thu 8-10 HS 036, Geb. 101. Zoom Meeting ID: 638 6588 5228 Passcode: j75DxsqiS
Exercises: Thu 14-16 Online. Zoom Meeting ID: 678 5201 3795 Passcode: 27PQPZGdq
(Note that the first week the exercise class is canceled)
Language: English
ECTS: 6 Points
Program of Study: Bachelor CS, Master CS/ESE, Lehramt Informatik
Schedule:
| Date | Topic | Notes |
|---|---|---|
| April 28, 2022 8-10 | Introduction, XML, XPath | |
| May 5, 2022 8-10 | Xrel, XQuery | |
| May 5, 2022 14-16 | MongoDB | |
| May 12, 2022 8-10 | MapReduce, Hadoop | |
| May 12, 2022 14-16 | Exercise 1, 2 | |
| May 19, 2022 8-10 | Spark | |
| May 19, 2022 14-16 | Exercise 3, Intro to Project1 | |
| June 2, 2022 8-10 | GraphDB | |
| June 2, 2022 14-16 | In Memory DB, Intro to Project 2 |
Exam:
Two projects plus final exam