Information Systems Group
Hasso-Plattner-Institut
Hasso-Plattner-Institut
Prof. Dr. Felix Naumann
 

schließen

Our group includes PostDocs, PhD students, and student assistants, and is headed by Prof. Felix Naumann. If you are interested in joining our team, please contact Felix Naumann.

schließen

For bachelor students we offer German lectures on database systems in addition to paper- or project-oriented seminars. Within a one-year bachelor project, students finalize their studies in cooperation with external partners. For master students we offer courses on information integration, data profiling, and information retrieval enhanced by specialized seminars, master projects and we advise master theses.

schließen

Most of our research is conducted in the context of larger research projects, in collaboration across students, across groups, and across universities. We strive to make available most of our datasets and source code.

schließen

Please do not hesitate to reach out directly to us, if you cannot find a paper, slides, or other research artifacts.

schließen

schließen
  1. HOME
  2.  > Teaching
  3.  > Teaching
  4.  > Information Integration

Information Integration

Information integration is the merging of heterogeneous information from various data sources to a homogenous, clean dataset. This lecture introduces this ever-important topic. It will cover the basic technologies, such as distributed database architectures, techniques for virtual and materialized integration, and data cleansing technologies.

Further Information:

  • Lectures can be given in English, on demand.
  • Slides will be made available on the HPI-internal materials-folder.
  • The lectures will be recorded by tele-task.
  • The exercises are led by Tim Repke.

Schedule

The course will take place Mondays in F-E.06 and Thursdays in H-2.57 at 09:15 AM. Some lectures will have the form of exercises.

To download lecture slides, please click links below.

DateTopic
MO 14.10.No lecture - HPI Plenary Meeting
TH 17.10.Exercise: Organization and Task Introduction
MO 21.10.Introduction
TH 24.10.Distribution, Autonomy, and Heterogeneity
MO 28.10. in F-E.06Exercise: Extracted Datasets
Reformation Day--
MO 04.11.Distribution, Autonomy, and Heterogeneity
TH 07.11.Materialized and Virtual Integration
MO 11.11.Exercise: Project Task Definition (analytics question)
TH 14.11. in F-E.06Web Table Research (Hazar Harmouch)
Architectures (Felix Naumann)
MO 18.11.no lecture
TH 21.11.no lecture
MO 25.11.Architectures & SchemaSQL
TH 28.11.SchemaSQL
MO 02.12.Schema Matching
TH 05.12.Exercise: Data Integration (schema matching, transformation, normalization)
MO 09.12.Schema Mapping
TH 12.12.Global-as-View
MO 16.12.Local-as-View
TH 19.12.Local-as-View
Christmas break--
MO 06.01.Bucket Algorithm (Dr. Armin Roth, Universität Tübingen)
TH 09.01.Exercise: Data Cleansing (duplicate detection, linkage, data fusion)
MO 13.01.Duplicate Detection
TH 16.01.Duplicate Detection
MO 20.01.Duplicate Detection
TH 23.01.Information Quality
MO 27.01.no lecture
TH 30.01.Scalable Data Cleansing (Dr. Jorge Quiane-Ruiz, TU Berlin)
MO 03.02.Exercise: Analytics (visualizations, etc to answer the initial question)
TH 06.02.Exam Preparation
Feb. 11 and 12Oral exams

Office Hours

If you have any questions relating the lecture or exercise, feel free to contact Tim Repke or come by during the office hours:

Every Monday, 14:00 - 15:00
Room F-2.07

Exceptions:

  • 09.11. (any other day this week per request)
  • 23.12. - 05.01.

Literature & Exam

  • Ulf Leser and Felix Naumann: Informationsintegration, dpunkt Verlag, 2006 (free pdf).
    This book is available at the UP library and also, e.g., from Amazon.de.
  • Doan, Halevy, and Ives: Principles of data integration, Morgan Kaufmann, 2012.
  • Özsu and Valduriez: Principles of distributed database systems, Springer, 2011.
  • Stefan Conrad: Föderierte Datenbanksysteme, Springer,  1997.

Throughout the lecture, I will refer to various scientific papers, that serve as in-depth references.

Oral exams (30min) will take place on February 11th and 12th 2020, please contact Diana Stephan and check the doodle regarding the schedule.