|
Instructors: Dr. rer. nat. Thomas Otmar Arnold; 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:
- | -
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
- Information extraction
- 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.
|
