Advanced Database and Information Systems

Lecturer

Dr. Fang Wei-Kleiner

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:

The lectures and the exercise will be given online. Details of the online accessing information follows. The first lecture takes place on Tuesday 12 May at 10am.

Lecture: Tuesday 10-12 Location: SR 03-026

Exercises: Thursday 10-12 Location: SR 00-034, Geb. 051

(Note that the first week there will be two lectures and no exercise)

Language: English

ECTS: 6 Points

Program of Study: Bachelor CS, Master CS/ESE, Lehramt Informatik

Exam:

Oral Exam

Literature and Additional Material