Lecture: Databases

Course Number 10909-01
Lecturers Heiko Schuldt
Assistants Lukas Probst
Tutors Sein Coray
Christian Patrick Gerd Frei
Eddie Joseph
Time and Location Thu 14:15 - 16:00; Seminarraum 05.001, Spiegelgasse 5
Fri 16:15 - 18:00; Seminarraum 00.003, Spiegelgasse 1
Start 23-02-2017
Exercises Thu 08:15 - 10:00; Seminarraum 00.003, Spiegelgasse 1
Prerequisites You sucessfully completed the following courses or have at your command the corresponding skills: Web Data Management, Grundlagen der Programmierung, Programmierprojekt
Objectives Students understand the internal structure and organization of database systems, in particular the internal processes and data structures for query processing, optimization, and transaction management. They possess both the theoretical knowledge and the practical skills to integrate several heterogeneous data sources and to apply analytical (data warehouse) queries on them.
Contents The course extends the introduction to databases given in Web Data Management and provides in-depth knowledge in the following areas:
- Data models, data and information integration
- Query processing in databases, index structures, query optimization, data warehousing
- Transaction management
Literature Will be announced in the course.
Assessment Lehrveranst.-begleitend

Please note: Oral examination, duration: 30 minutes. Dates: 15 & 16 June 2017 [UPDATED !], Spiegelgasse 1, office 06.005.
Admission to the oral examination: requires at least 50% of the points from the exercises and from the data integration / data warehousing project. Dates for the project presentations will also be announced in February 2017.

Credit Points 6
Grades 1-6 0,5
Modules Modul Wahlbereich Informatik (BSF - Informatik (Studienbeginn vor 01.08.2016))
Modul Praxis aktueller Informatikmethoden (MSF - Informatik (Studienbeginn vor 01.08.2016))
Vertiefungsmodul Verteilte Systeme (Bachelor Informatik 10)
Vertiefungsmodul Betriebliche Informationssysteme (Bachelor Informatik 10)
Modul Distributed Systems (Bachelor Computer Science 16)
Modul Applications and Related Topics (BSF - Computer Science)
Registration Services (Requires login)