Data Engineering
Niveau
1st semester: Master's course / 2nd semester: Master's course
Learning outcomes of the courses/module
The following skills are developed in the course:
- Students are familiar with various advanced data storage concepts (e.g. NoSQL databases, distributed databases, etc.).
- Students can compare and select data storage concepts with regard to their suitability for projects.
- Students understand the special requirements for data storage resulting from the use of very quantities amounts of data (Big Data).
- Students are familiar with various advanced data storage concepts (e.g. NoSQL databases, distributed databases, etc.).
- Students can compare and select data storage concepts with regard to their suitability for projects.
- Students understand the special requirements for data storage resulting from the use of very quantities amounts of data (Big Data).
Prerequisites for the course
1st semester: Students will have previous knowledge in the field of information technologies to the extent of 6 ECTS and therefore know the concept of the relational database and can read simple SQL queries. / 1st semester: Students will have previous knowledge in the field of information technologies to the extent of 6 ECTS and therefore know simple programming concepts (e.g. variables, branches, loops) as well as typical programming approaches (e.g. functional programming). / 2nd semester: SDDE.A1 module examination (Software Development 1)
Course content
The following content is discussed in the course:
- Properties of high-performance data systems (scalability, maintainability, reliability)
- Established concepts of data storage (Relational Model)
- Historical concepts of data storage (Hierarchical Model, Network Model)
- Modern concepts of data storage (Wide-Column Model, Graph Model, Key-Value Model, Document Model, Column-Oriented Model)
- Database systems, matching the models discussed
- Scaling of data systems (replication and partitioning)
- Writing and reading in data systems (index structures, write strategies)
- Properties of high-performance data systems (scalability, maintainability, reliability)
- Established concepts of data storage (Relational Model)
- Historical concepts of data storage (Hierarchical Model, Network Model)
- Modern concepts of data storage (Wide-Column Model, Graph Model, Key-Value Model, Document Model, Column-Oriented Model)
- Database systems, matching the models discussed
- Scaling of data systems (replication and partitioning)
- Writing and reading in data systems (index structures, write strategies)
Recommended specialist literature
PRIMARY LITERATURE:
- Kleppmann, M. (2017): Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintain-able 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
- Kleppmann, M. (2017): Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintain-able 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
English
Number of ECTS credits awarded
4
Share of e-learning in %
30
Semester hours per week
2.0
Planned teaching and learning method
The following methods are used:
- Lecture with discussion
- Processing of exercises
- Interactive workshop
- Lecture with discussion
- Processing of exercises
- Interactive workshop
Semester/trimester in which the course/module is offered
1
Name of lecturer
Prof. (FH) Dr. Michael Kohlegger
Academic year
1
Key figure of the course/module
SDDE.1
Type of course/module
integrated lecture
Type of course
Compulsory
Internship(s)
none