department of informatics

Databases for Bachelor Studies - Course HS-2012 (German)

Contacts
About
Dates: 
1. September 2012 - 15. December 2012
Description: 

The lecture introduces the area of databases: database draft, entity-relationship model, relational algebra, structured query language (SQL), architecture of database systems, concurrency control and transactions concept.

  • Data management: Components of a database system and advantages of the database deployment; Organisation, data architecture, data organization and techniques.
  • Entity-Relationship Model: Entities, associations, relations; Aggregation, generalisation; Transformation rules for entity and relation sets.
  • Relational model: Normal forms; Functional, transitive and multivalued dependencies; Extension of the relational model.
  • Relational algebra: Set and relation oriented operators, different join operators, completeness, predicate calculus.
  • Structured Query Language (SQL): Introduction to SQL, data definition and manipulation, views concept, authorization, integrity conditions.
  • Architecture of database systems: Layers architecture, translation, query optimization, tree and space organised memory structures.
  • Multiuser operating: Transactions, serialisability, pessimistc and optimistic methods, two phase locking protocol.
  • Work with a database system: Data protection and security, archive after the generation principle, error treatment, tuning and optimization.
  • Post-relational databases: Object relational and object oriented databases, databases for online analytical processing (OLAP), fuzzy databases

Key Words: Database Management System, Entity Relationship Model, Query Language, Transaction Management, Data Protection and Security


Important Remarks:

  • Lectures will be given in German and the exercise sessions will be in English
  • The latest information and documents are available on Moodle. The password will be provided during the first lecture.

Details
Lectures: 
  • Day: tuesday
  • Time: from 8h15 to 10h00
  • Starting date: sept 20th
  • Room: G120

Exercise Session:

  • Day: wednesday (every two weeks)
  • Time: from 13h15 to 15h00
  • Starting date: sept 26th
  • Room: F230  
Term: 
Autumn
Language: 
English
Language: 
German
Curriculum: 
  • Bachelor Studies in Economics and Computer Science
Examination: 
  • Written examination at the end of the semester. All subjects treated in the lecture, in the exercises and in the given chapters of the textbook are relevant for the exam.
Literature