20-00-0015-iv Information Management

Course offering details

Instructors: Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych

Event type: Integrated Course

Org-unit: Dept. 20 - Computer Science

Displayed in timetable as: Information Management

Subject:

Crediting for:

Hours per week: 3

Language of instruction: German

Min. | Max. participants: - | -

Digital Teaching:
Due to the current COVID-19-situation, we will NOT cancel any of our courses (Information Management, Advanced Data Management Systems, Data Management – Lab / Extended Lab). Instead all teaching activities for summer term 2020 will be completely online: courses will be either given as webinars (live via zoom with recordings) or as video lectures (offline recordings). The detailed setup for each course regarding the organization will be announced on the Moodle website of each course. Please follow the links to Moodle from our web site: https://www.informatik.tu-darmstadt.de/datamanagement/datamanagement/dm_teaching/

Course Contents:
In this lecture, we discuss the foundations of information management. In the first part of the course, we focus on relational databases. In the second part, we provide an introduction to automatic language- and knowledge processing with a particular focus on text analytics.

Key topics:


  • Foundations of information management

    • Characteristics of information systems
    • Information storage and retrieval
    • Declarative and navigational access

  • Database systems and architectures

    • Data redundancy and data integration
    • Data independence
    • Database architecture models

  • Conceptual data modeling

    • Foundations of knowledge representation
    • Entity relationship model
    • UML structure diagrams

  • Logical data modeling

    • Relational model
    • Relational algebra
    • Relational calculus

  • Relational database design

    • Database anomalies
    • Normalization

  • Query languages

    • SQL
    • Query-by-example
    • SQL and programming languages

  • Transactions and multi-user environment

    • Serialization
    • Locks, 2PL
    • ACID criteria, isolation levels

  • Index structures and performance
  • Recent database concepts

    • In-memory databases
    • NoSQL

  • Foundations of language and knowledge processing
  • Text as a knowledge resource

    • Text formats and databases
    • XML
    • Pattern search

  • Linguistic preprocessing
  • Text corpora
  • Lexical resources and ontologies
  • Information retrieval

    • Vector space models

  • Information extraction

    • Named entity recognition

  • Fundamentals of machine learning


 

Literature:
To be announced in the lecture. Recommendations include:


  • Gunter Saake, Kai-Uwe Sattler, Andreas Heuer: Datenbanken: Konzepte und Sprachen. 4. Auflage, Heidelberg: mitp, 2010. ISBN: 978-38266-9057-0. [in german]
  • Ramez Elmasri, Shamkant B. Navathe: Fundamentals of Database Systems. 6th edition. Boston et al.: Addison-Wesley, 2011. ISBN: 978-0-136-08620-8.
  • Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: Database Systems: The Complete Book. 2nd edition. Upper Saddle River, NJ: Pearson Prentice Hall, 2009. ISBN: 978-0-131-87325-4.
  • Gottfried Vossen: Datenmodelle, Datenbanksprachen und Datenbankmanagementsysteme. 5. Auflage. München: Oldenbourg, 2008. ISBN 978-3-486-27574-2. [in german]
  • Daniel Jurafsky, James H. Martin: Speech and Language Processing. An Introduction to Natural Language Processing, Computational Linguistics, and Speech Recognition. Second Edition. Upper Saddle River: Prentice Hall, 2009. ISBN: 978-0-13-187321-6.
  • Gerhard Heyer, Uwe Quasthoff, Thomas Wittig: Text Mining: Wissensrohstoff Text. Konzepte, Algorithmen, Ergebnisse. Herdecke/Bochum: W3L, 2006. ISBN: 3-937137-30-0. [in german]
  • Steven Bird, Ewan Klein, Edward Loper: Natural Language Processing with Python, O’Reilly, 2009. ISBN: 978-0-596-51649-9.
  • Kai-Uwe Carstensen, Christian Ebert, Cornelia Endriss, Susanne Jekat, Ralf Klabunde: Computerlinguistik und Sprachtechnologie. Eine Einführung. 3. Auflage. Heidelberg: Spektrum, 2009. ISBN: 978-3-8274-20123-7. [in german]

Preconditions:
Recommended:
Participation of lecture „Funktionale und Objektorientierte Programmierkonzepte“ and „Algorithmen und Datenstrukturen“, respective according knowledge.

Further Grading Information:
After attending this course, students are in a position to


  • name and explain the foundational concepts of information management and language and knowledge processing,
  • explain, implement, and maintain information systems,
  • interpret and construct formal data models,
  • design and use relational databases,
  • name and compare different language-related data sources,
  • extract and retrieve basic information from natural language text.

Small group(s)
This course is divided into the following small groups:
  • Information Management - Übung

    Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych

    Fri, 24. Apr. 2020 [08:00]-Fri, 17. Jul. 2020 [09:40]

Literature
Appointments
Date From To Room Instructors
1 Tue, 21. Apr. 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
2 Tue, 28. Apr. 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
3 Tue, 5. May 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
4 Tue, 12. May 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
5 Tue, 19. May 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
6 Tue, 26. May 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
7 Tue, 2. Jun. 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
8 Tue, 9. Jun. 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
9 Tue, 23. Jun. 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
10 Tue, 30. Jun. 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
11 Tue, 7. Jul. 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
12 Tue, 14. Jul. 2020 09:50 11:30 >Digitaler Veranstaltungstermin Prof. Dr. rer. nat. Carsten Binnig; Prof. Dr. phil. Iryna Gurevych
Class session overview
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
Instructors
Prof. Dr. phil. Iryna Gurevych
Prof. Dr. rer. nat. Carsten Binnig