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 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.

Eintrittskompetenzen

 

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

 

Lernziele

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

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

Modulkategorie

Databases architectures (30%)

  • Distributed architectures
  • Replication and scalability
  • Parallel architectures
  • Consistency models

Beyond the relational model (30%)

  • Document-oriented databases
  • Graph systems
  • Key value systems
  • Spatio-temporal databases

Database-oriented software architectures (40%)

  • Database first and code first
  • Embedded databases
  • Testing and evolution
  • Query plans, indexation, integrity constraints and data validation
  • Database administration

 

Lehr- und Lernmethoden

This

course involves theoretical presentations and practical exercises, laboratories

or group projects.

Bibliografie

Lecture slides, references to internet resources and

books.

Vollständige Modulbeschreibung herunterladen

Zurück