MSE Master of Science in Engineering

The Swiss engineering master's degree

Chaque module vaut 3 ECTS. Vous sélectionnez 10 modules/30 ECTS parmi les catégories suivantes:

  • 12-15 crédits ECTS en Modules technico-scientifiques (TSM)
    Les modules TSM vous transmettent une compétence technique spécifique à votre orientation et complètent les modules de spécialisation décentralisés.
  • 9-12 crédits ECTS en Bases théoriques élargies (FTP)
    Les modules FTP traitent de bases théoriques telles que les mathématiques élevées, la physique, la théorie de l’information, la chimie, etc., vous permettant d’étendre votre profondeur scientifique abstraite et de contribuer à créer le lien important entre l’abstraction et l’application dans le domaine de l’innovation.
  • 6-9 crédits ECTS en Modules contextuels (CM)
    Les modules CM vous transmettent des compétences supplémentaires dans des domaines tels que la gestion des technologies, la gestion d’entreprise, la communication, la gestion de projets, le droit des brevets et des contrats, etc.

Le descriptif de module (download pdf) contient le détail des langues pour chaque module selon les catégories suivantes:

  • leçons
  • documentation
  • examen 
Data Management (TSM_DataMgmt)

This course is about Data Engineering and Information Retrieval. It covers methods and technologies for managing, processing and analyzing potentially large and distributed data collections for transactional or analytical use, including multi-model databases and NoSQL stores. And it covers also mastering data in unstructured form (full text search). The course consists of four parts: 1. Database Management; 2. Data Warehousing and Data Analytics (Business Intelligence); 3. Data Integration including Data Synthesis; and 4. Information Retrieval.

Compétences préalables

  • UML Class Diagrams
  • Relational Models, Relational Algebra
  • Relational Database Management System (RDBMS) Architectures
  • SQL:92 (i.e. queries with SELECT-FROM-WHERE-GROUP BY)
  • Normalization, Query Optimization, Indexes
  • Transaction Processing, Concurrency Control
  • Security in Relational Database Systems

Objectifs d'apprentissage

This module covers following important aspects of Data Engineering:

  • Students understand the use of modern database technologies for processing and managing potentially large and distributed data collections for transactional or analytical use.
  • Students will be proficient in modern query languages such as the post-relational SQL (SQL:2023 and newer).
  • Reaching beyond RDBMS, students learn about data structures (data types) and know which of these to use depending on the requirements and type of data available (polyglot persistence, multi-model databases).
  • Students know NoSQL stores and selected cloud data stores.
  • Students know methods and tools to integrate, to cleanse and to synthesize data.
  • Students know how to deal with full text information using databases and search engines (information retrieval; prompt engineering).
  • Students can also apply the acquired knowledge in their own working environment.

Contenu des modules

The course is divided into four parts:

 

  1. Database Management (DB): New data structures (types) and alternatives to RDBMS. Storing data with post- and non-relational aspects, including NoSQL technologies (especially graph databases), and a selection of advanced topics such as cloud or vector databases.
  2. Data Warehousing and Data Analytics (DW): Methods and tools for data aggregation and data analytics such as the ones involved in business intelligence.
  3. Data Integration (DI): Methods and tools for data integration, data cleansing and data synthesizing (e.g. for training and testing) are explained.
  4. Information Retrieval (IR): Methods and tools for finding information in full text using databases and (enterprise) search engines, including crawling.

 

Weighting between the parts will be confirmed at the beginning of semester. Tentative weighting:  

 

  1. DB: ~4-6 weeks
  2. DW: ~2-4 weeks
  3. DI: ~1-3 weeks
  4. IR: ~3-5 weeks

 

 

Méthodes d'enseignement et d'apprentissage

Frontal teaching, case studies, exercises, discussions, (group) work assignments (i.e. laboratory work or mini-project).

Bibliographie

Optional literature suggestions (books):

  • DB: Advanced Data Management for SQL, NoSQL, Cloud and Distributed Databases. R. Wiese. De Gruyter Textbook. 2015. ISBN 978-3-11-044140-6.
  • DB: SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis. R. Teate. Wiley. 2021. ISBN 978-1-119-66936-4.
  • IR: Introduction to Information Retrieval. C.D. Manning, P. Raghavan, H. Schütze. Cambridge UP, 2008.
  • IR: Information Retrieval in Practice. B. Croft, D. Metzler, T. Strohman. Pearson Education, 2009.

Télécharger le descriptif complet

Retour