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 centered on the Data Engineering domain.

This course covers modern methods and technologies that are needed to manage and process potentially large, heterogeneous and distributed data collections. It  includes diverse technologies frequently used in industrial contexts such as data warehouses,  multi-model databases and NoSQL stores. A focus of the class is also given on Information Retrieval including techniques to efficiently retrieve data that are typically in unstructured form. 


Compétences préalables

  • Basic data structures and algorithms
  • Working level on basic relational databases
  • Relational Models, Relational Algebra,
  • Normalization
  • RDBMS architectures
  • Transactions
  • SQL:92
  • Query optimization, Indexes
  • Security in RDBMS

Objectifs d'apprentissage

Learning objectives and acquired competencies:

The learning objectives are directed towards Data Engineering:

  • Students understand the modern ecosystems currently used in industries for data storage and data processing; including their respective adequations to application needs.
  • Students understand the use of modern database and processing technologies for managing large, distributed and potentially heterogeneous data collections.
  • Students are able to organize complex data structures, reaching beyond RDBMS and meeting the requirements of data availability and type, e.g. polyglot persistence and multi-model databases.
  • Students are able to use selected advanced data technology stacks such as data warehouses, NoSQL stores and cloud data stores.
  • Students are able to implement methods and tools to integrate, cleanse and synthesize data, such as the ones used to compose data pipelines.
  • Students are able to integrate efficient Information Retrieval techniques typically used for unstructured and textual data, such as the ones used for search engines.
  • Students can also apply the acquired knowledge in their own working environment.

 

Catégorie de module

The module covers the following contents:

1. Database Management (DM): overview of modern ecosystems currently used in industries for data management; new data structures and alternatives to RDBMS; non-relational aspects including NoSQL and cloud data stores; new ways to query data such as JSON paths, SQL extensions, graph query language, etc.

2. Data Integration (DI): Data Warehousing for data aggregation and data preparation for analytics (e.g. business intelligence components); other methods and tools for data integration, data cleansing and data synthesizing.

3. Information Retrieval (IR): Efficient methods for finding information, typically in the context of unstructured and textual data, such as the ones used for search engines; ways to query data in IR systems, such as Query DSL.

Méthodes d'enseignement et d'apprentissage

Head-on teaching, exercises, case studies.

Bibliographie

Optional literature suggestion (books):

  • DB: Lena Wiese: Advanced Data Management for SQL, NoSQL, Cloud and Distributed Databases. De Gruyter Textbook. 2015. ISBN 978-3-11-044140-6.
  • IR: Introduction to Information Retrieval. C.D. Manning, P. Raghavan, H. Schütze. Cambridge UP, 2008. Classical and web information retrieval systems: algorithms, mathematical foundations and practical issues.
  • IR: Information Retrieval in Practice. B. Croft, D. Metzler, T. Strohman. Pearson Education, 2009.

Télécharger le descriptif complet

Retour