Skip to content
Technische Universität Berlin Deutsch
Course catalog and module transfer system

The 800-pound Gorilla in the corner: Data IntegrationModule description #40791 / Version 3

← Module page Deutsche Fassung
This module description is not valid in the current semester (Winter semester 2026/27).
Module / Version#40791 / #3
ValiditySS 2017 – WS 2017/18
Available language(s)English
Credit points6
Person responsible for the moduleAbedjan, Ziawasch
GradingGraded
Exam formatOral exam
Language(s) of instructionEnglish

Affiliation

FacultyFakultät IV
InstituteInstitut für Softwaretechnik und Theoretische Informatik
Academic chair34352300 FG Big Data Management (Juniorprof.)

Contact

OfficeEN 7
Contact personAbedjan, Ziawasch
E-mail addresssekr@bigdama.tu-berlin.de
Websitehttp://www.bigdama.tu-berlin.de/menue/big_data_management_group/

Learning outcomes

“Data integration is the 800-pound gorilla in the corner, and everyone’s got it in spades,” according to Mike Stonebraker, MIT professor and Turing Award Laureate. The most challenging and time-consuming task of data scientists in the era of Big Data is to consolidate data from different sources, overcoming dirty data, heterogeneity in data representations, and incompleteness of data. In this course, we will surface the entire pipeline of an information integration workflow, by learning about existing integration architectures, algorithms in data cleansing, schema matching, and data fusion. Furthermore, we will discuss state-of-the-art systems and prominent use cases of information integration techniques.

Content

The course has the following main topics:
- Distribution and autonomy
- Foundations of data integration
- String Matching
- Schema matching/mapping
- Global-as-View and Lokal-as-View modelling
- Data cleansing
- Duplicate detection
- Data quality

Module components

Compulsory area

The following courses are mandatory for this module:

CoursesTypeNumberFrequencyLanguageHours per weekCourse catalog
Data IntegrationIntegrated course4523 L 08957 Winter and summer semester–4 ISIS

Workload and credit points

Data Integration (Integrated course)

Workload descriptionMultiplierHoursTotal
Präsentation der Übung152 h30 h
Präsenz154 h60 h
Übungsaufgaben/Praxisteil (Fallbeispiel)152 h30 h
Vor- und Nachbearbeitung (inkl. Lesen der Primärliteratur und eigenem Vortrag)154 h60 h
180 h

The workload of the module adds up to 180 hours. The module therefore comprises 6 credit points.

Description of teaching and learning methods

Vorlesung und Übung

Requirements for participation and examination

Desirable prerequisites for participation in the courses:

Die Voraussetzungen sind das abgeschlossene Bachelorstudium und Grundkenntnisse im Bereich des Datenbankmanagements und Grundkenntnisse in mindestens einer modernen Programmier- oder Skriptsprache.

Mandatory requirements for the module examination registration:

The examination requirements could not be retrieved.

Completion of the module

GradingGraded
Exam formatOral exam
LanguageEnglish
Duration/Extent20 Minuten

Duration of the module

The following number of semesters is estimated for taking and completing the module: 1 semester(s).

This module can be started in the following semesters: Winter and summer semester.

Maximum number of participants

The maximum capacity of participants is 45.

Registration procedures

Alle Teilnehmer/innen müssen sich vor dem ersten Lehrveranstaltungstermin mit dem Anmeldetool auf den BigDaMa-Webseiten (http://www.bigdama.tu-berlin.de/) für dieses Modul bei BigDaMa anmelden. Beachten Sie bitte unbedingt alle Regelungen Ihres Studienganges! Die Anmeldung zur Prüfung erfolgt über ein elektronisches Prüfungsanmeldesystem.

Recommended reading, lecture notes

Lecture notes

unavailable

Electronic lecture notes

unavailable

Recommended literature

  • Principles of Data Integration. Anhai Doan, Alon Halevy, Zachary Ives. Morgan Kaufmann, 1st edition (2012), 520 pages Ulf Leser and Felix Naumann: Informationsintegration, dpunkt Verlag, 2006.

Assigned programs

This module is not used in any program.

Miscellaneous

Not specified