MSE Master of Science in Engineering

The Swiss engineering master's degree

Jedes Modul umfasst 3 ECTS. Sie wählen insgesamt 10 Module/30 ECTS in den folgenden Modulkategorien:

  • ​​​​12-15 ECTS in Technisch-wissenschaftlichen Modulen (TSM)
    TSM-Module vermitteln Ihnen profilspezifische Fachkompetenz und ergänzen die dezentralen Vertiefungsmodule.
  • 9-12 ECTS in Erweiterten theoretischen Grundlagen (FTP)
    FTP-Module behandeln theoretische Grundlagen wie die höhere Mathematik, Physik, Informationstheorie, Chemie usw. Sie erweitern Ihre abstrakte, wissenschaftliche Tiefe und tragen dazu bei, den für die Innovation wichtigen Bogen zwischen Abstraktion und Anwendung spannen zu können.
  • 6-9 ECTS in Kontextmodulen (CM)
    CM-Module vermitteln Ihnen Zusatzkompetenzen aus Bereichen wie Technologiemanagement, Betriebswirtschaft, Kommunikation, Projektmanagement, Patentrecht, Vertragsrecht usw.

In der Modulbeschreibung (siehe: Herunterladen der vollständigen Modulbeschreibung) finden Sie die kompletten Sprachangaben je Modul, unterteilt in die folgenden Kategorien:

  • Unterricht
  • Dokumentation
  • Prüfung
Advanced Data Management – Foundations of data-intensive systems (TSM_AdvDataMgmt)

The course covers the following core topics:

  • Distributed and parallel database systems architectures, internals and services such as transaction processing, concurrency control and query processing
  • No-SQL Systems
  • Data processing architectures

Eintrittskompetenzen

  • Database design
  • Relational Model
  • Normalization
  • SQL
  • Object relational database systems
  • Object-oriented programming languages

Lernziele

Students understand how to use database technologies to process and manage large data collections.

  • They know databases alternatives beyond Relational and Object Relational systems and are able to decide which database system is appropriate depending on the context, and depending on the kind of data available
  • They can design and implement Systems based on different architectures
  • They understand the functioning of internal components of a database system
  • They can reuse the material acquired in this course in their own working environment and apply them to solve their specific problems
  • They know the current research directions of these domains.

Modulinhalt

The Internet, new types of data and applications and new business requirements have driven the development of data management systems having data models and architectures beyond the traditional relational and object-relational systems and centralised architectures.

The module is organised around the following core subject areas:

  • Parallel query processing (20%)
  • Replication and partitioning (40%)
  • Consistency (25%)
  • DLT and Blockchain (15%)

Contents:

  • Introduction, data intensive architectures, relational vs document-based systems
  • Data processing architectures, parallel queries on a single node 
  • Serializability
  • Storage and retrieval, row-oriented vs column-oriented storage 
  • Partitioning
  • Consistent hashing
  • Replication 
  • Distributed consensus (2PC, 3PC, Paxos, Raft)
  • Zookeeper (CAP, ZAB, Leader election)
  • Batch processing: Distributed storage: block vs object storage
  • Stream processing 
  • Blockchain


 

Lehr- und Lernmethoden

  • Lectures with integrated exercises
  • Self study of literature
  • case studies

Bibliografie

Lecture slides, references to internet resources and books

Vollständige Modulbeschreibung herunterladen

Zurück