Advanced Database System Techniques

11B0556

Bachelor

German

5.0

irregular

1 semester

In practice, data is primarily persisted in databases using relational databases or . Approaches such as cloud and noSQL databases are practical and open up possibilities that often cannot be offered by current relational database management systems. This module introduces students to current database concepts and enables them to select and use suitable databases. In addition to seminar-style lectures, the focus is on the practical application of what has been learned.

1. Overview of current database management systems
    1. areas of application and restrictions
    2. current scientific developments in data management
2. Advanced language concepts
    1. query optimization
    2. database tuning
3. Selection and operation of modern database management systems
4. Introduction to NOSQL databases, i.e.
    1. schema on read / schema on write
    2. document-oriented database management systems
    3. key-value stores
    4. (Multi-)Column Stores
    5. graph databases
5. Management of complex data, including, i.e.
   1. temporal data
   2. geographical data
   3. image data
   4. semi-structured data
6. Overview of scalable data management architectures
   1. Parallel databases
   2. Distributed databases
   3. Distributed ledgers (private and public)
   4. Data warehousing
   5. Pub/sub systems
   6. Mediator/wrapper architectures
   7. Data room concepts and initiatives
7. Advanced concepts
   1.  event processing
   2. data stream management
8. Current developments in data management
9. Application examples from practice

The total workload for the module is 150 hours (see also "ECTS credit points and grading").

• oral exam or
• Homework / Assignment

• Field work / Experimental work or
• Regular participation

The selection of graded and ungraded assessment types from the given options is at the discretion of the respective instructor. In doing so, they must adhere to the applicable study regulations.

Term paper - approx 15 pages, rpresentation approx. 10 minutes

oral exam - s. study regulations

Knowledge analogous to the introductory course on databases is recommended.

Students who want to refresh their knowledge are recommended to read the following literature:

* R. Elmasri, S. Navathe, Fundamentals of database systems (2016) 

Students will be familiar with current data storage paradigms and database management systems that follow these paradigms.

Students have in-depth knowledge of these systems (in terms of modeling, data persistence and data access).

Students are able to use current database management systems in practice. They know the relevant technical vocabulary and concepts and can apply them.

Given a specific task, students are able to select a suitable database management system/data representation, model the necessary data structures, and access these systems using a high-level programming language. This includes the transfer of knowledge to various specialized domains.

The students are able to explain the working methods of persistent data processing in various database management systems and to use the corresponding vocabulary in technical discussions.

• Tapken, Heiko

• Tapken, Heiko