department of informatics

Databases for Bachelor Studies 2015

Contacts
About
Dates: 
15. September 2015 - 18. December 2015
Objectives: 

The lecture introduces the area of databases including the topics of data management, entity-relationship model, relational algebra, structured query language (SQL), architecture of database systems, concurrency control and transactions concept, graph databases/cypher.

 

Description: 

 

  • Data management: Components of a database system and advantages of the database deployment, data architecture, data organisation 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, 2 phase lock protocol. 

  • Work with a database system: Data protection and security, archive after the generation principle, error treatment, tuning and optimization. 

  • Big Data: NoSQL databases, ACID versus BASE, Consistent Mashing,  Overview of NoSQL database systems.

Students have to register on Moodle to get acces to the latest information and materials. 

Details
Lectures: 

Lectures: Tuesday from 8h15 - 10h00 at PER21, Room C120

Exercises: Tuesday from 11h15 - 12h00 at PER21, Room B230

Term: 
Autumn
Language: 
English
Language: 
German
Curriculum: 

Bachelor Studies in Economis 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