Data modelling and storage
level of course unit
2nd Study cycle, Master
Learning outcomes of course unit
The following learning outcomes are developed in the course:
- Students know the central concepts of data modelling.
- Students can independently develop data models for a given scenario.
- Students know different solutions for data storage.
- Students can compare different storage solutions with regard to their suitability for a given scenario.
prerequisites and co-requisites
none
course contents
The following content is discussed in the course:
- Data modelling for relational data structures
- Database interaction in SQL (DDL, DML, DQL)
- Non-relational data storage concepts (NoSQL databases)
- Implementing data structures
- Integrating data structures into applications
recommended or required reading
PRIMARY LITERATURE: - Kleppmann, M. (2017): Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scala-ble, and Maintainable Systems (Ed. 1), O'Reilly Media, Farnham (ISBN: 978-1449373320)
SECONDARY LITERATURE: - Celko, J. (2013): Joe Celko's Complete Guide to NoSQL: What Every SQL Professional Needs to Know about Non-Relational Databases (Ed. 1), Morgan Kaufmann, Waltham (ISBN: 978-0124071926)
assessment methods and criteria
Written exam
language of instruction
German
number of ECTS credits allocated
6
eLearning quota in percent
17
course-hours-per-week (chw)
3
planned learning activities and teaching methods
English version available soon
semester/trimester when the course unit is delivered
1
name of lecturer(s)
Prof. (FH) Dr. Michael Kohlegger, Prof. (FH) PD Dr. Mario Döller
year of study
1
recommended optional program components
none
course unit code
DTS.1
type of course unit
integrated lecture
mode of delivery
Compulsory