SoSe 16: Datenbanksysteme
Agnès Voisard
Additional information / Pre-requisites
Requirements
"Data Structures and Daten Abstraction" or "Informatik B"
Comments
Content
Database design with ER. Theoretical foundations of relational database
systems: relational algebra, functional dependencies, normal forms.
Relational database development: SQL data definitions, foreign keys and
other integrity constraints, SQL as applicable language: essential
language elements, embedding in programming language. Application
programming; object-relational mapping. Security and protection concepts.
Technical: Transaction subject, transactional guaranties,
synchronization of multi user operations, fault tolerance features.
Application and new developments: data warehouse systems, data mining,
information retrieval/search engines. The topics are deepened in an
implementation project for student groups.
Suggested reading
- Alfons Kemper, Andre Eickler: Datenbanksysteme - Eine Einführung, 5. Auflage, Oldenbourg 2004
- R. Elmasri, S. Navathe: Grundlagen von Datenbanksystemen, Pearson Studium, 2005
27 Class schedule
Additional appointments
Thu, 2016-06-30 14:00 - 16:00Regular appointments
Content
Database design with ER. Theoretical foundations of relational database systems: relational algebra, functional dependencies, normal forms. Relational database development: SQL data ... read more