MSE Master of Science in Engineering

The Swiss engineering master's degree

Each module contains 3 ECTS. You choose a total of 10 modules/30 ECTS in the following module categories: 

  • 12-15 ECTS in technical scientific modules (TSM)
    TSM modules teach profile-specific specialist skills and supplement the decentralised specialisation modules.
  • 9-12 ECTS in fundamental theoretical principles modules (FTP)
    FTP modules deal with theoretical fundamentals such as higher mathematics, physics, information theory, chemistry, etc. They will teach more detailed, abstract scientific knowledge and help you to bridge the gap between abstraction and application that is so important for innovation.
  • 6-9 ECTS in context modules (CM)
    CM modules will impart additional skills in areas such as technology management, business administration, communication, project management, patent law, contract law, etc.

In the module description (download pdf) you find the entire language information per module divided into the following categories:

  • instruction
  • documentation
  • examination 
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

Prerequisites

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

Learning Objectives

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.

Contents of Module

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


 

Teaching and Learning Methods

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

Literature

Lecture slides, references to internet resources and books

Download full module description

Back