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 14-16 SR 01-016/18 Geb. 101.
Exercises: Thu 16-18 SR 01-016/18 Geb. 101.
(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 20, 2023 14-16 | Introduction, XML, XPath |
Exam:
Two projects plus final exam