MSE Master of Science in Engineering

The Swiss engineering master's degree


Ogni modulo equivale a 3 crediti ECTS. È possibile scegliere un totale di 10 moduli/30 ECTS nelle seguenti categorie: 

  • 12-15 crediti ECTS in moduli tecnico-scientifici (TSM)
    I moduli TSM trasmettono competenze tecniche specifiche del profilo e si integrano ai moduli di approfondimento decentralizzati.
  • 9-12 crediti ECTS in basi teoriche ampliate (FTP)
    I moduli FTP trattano principalmente basi teoriche come la matematica, la fisica, la teoria dell’informazione, la chimica ecc. I moduli ampliano la competenza scientifica dello studente e contribuiscono a creare un importante sinergia tra i concetti astratti e l’applicazione fondamentale per l’innovazione 
  • 6-9 crediti ECTS in moduli di contesto (CM)
    I moduli CM trasmettono competenze supplementari in settori quali gestione delle tecnologie, economia aziendale, comunicazione, gestione dei progetti, diritto dei brevetti, diritto contrattuale ecc.

La descrizione del modulo (scarica il pdf) riporta le informazioni linguistiche per ogni modulo, suddivise nelle seguenti categorie:

  • Insegnamento
  • Documentazione
  • Esame
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

Requisiti

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

Obiettivi di apprendimento

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.

Contenuti del modulo

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


 

Metodologie di insegnamento e apprendimento

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

Bibliografia

Lecture slides, references to internet resources and books

Scarica il descrittivo completo del modulo

Indietro