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


Eintrittskompetenzen

  • 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

Lernziele

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.

 

Modulkategorie

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.

Lehr- und Lernmethoden

Head-on teaching, exercises, case studies.

Bibliografie

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.

Vollständige Modulbeschreibung herunterladen

Zurück