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 Databases (TSM_AdvDaBa)

 

The heterogeneity of the requirements of modern applications is not always well addressed by classical data management systems. The use of the appropriate data management system can address properly requirements such as replication, scalability, availability, data model flexibility, or query performance.

 

This course aims to provide a critical approach to polyglot data management systems by knowing their strengths and weaknesses, to help the data software architect to use the appropriate system in each context.

 

The course covers the following core topics:

 

 

  • Databases architectures,
  • Beyond the relational model,
  • Database-oriented software architectures.

Requisiti

 

  • Relational model, relational algebra and normalization
  • SQL: data modeling, query language, transactions and access rights
  • Query optimization, database indexes
  • Object-oriented programming languages

 

Obiettivi di apprendimento

At the end of this module, students will be able to:

 

  • Understand and use parallel and distributed databases,
  • Use strict and relaxed consistency models and understand their underlying tradeoffs,
  • Understand and use databases alternatives beyond the relational model,
  • Better choose an appropriate database system depending on the context and the kind of data available,
  • Understand the different implications of database-oriented software architectures,
  • Apply the acquired knowledge in their own working environment,
  • Iidentify the current research directions of these domains.

Categoria modulo

Foundations (30%)

  • Reliabilitym scalability, maintainability
  • Data models and query languages
  • Storage models
  • Backward and forward compatibility

Distributed data systems (50%)

  • Replication and partitioning
  • Transactions
  • Fault-tolerance
  • Consistency and consensus

Processing and integration (20%)

  • Batch, map-reduce and beyond
  • Streaming and events
  • Emerging technologies


Metodologie di insegnamento e apprendimento

This course involves theoretical presentations and practical exercises, laboratories or group projects.

Bibliografia

Lecture slides, references to internet resources and books.

Scarica il descrittivo completo del modulo

Indietro