Module Handbook

  • Dynamischer Default-Fachbereich geändert auf INF

Module INF-00-12-M-2

Information Systems (M, 8.0 LP)

Module Identification

Module Number Module Name CP (Effort)
INF-00-12-M-2 Information Systems 8.0 CP (240 h)

Basedata

CP, Effort 8.0 CP = 240 h
Position of the semester 1 Sem. in SuSe
Level [2] Bachelor (Fundamentals)
Language [DE] German
Module Manager
Lecturers
Area of study [INF-PFL] Mandatory Modules
Reference course of study [INF-82.79-SG] B.Sc. Computer Science
Livecycle-State [NORM] Active

Courses

Type/SWS Course Number Title Choice in
Module-Part
Presence-Time /
Self-Study
SL SL is
required for exa.
PL CP Sem.
4V+2U INF-00-12-K-2
Information Systems
P 84 h 156 h
U-Schein
ja PL1 8.0 SuSe
  • About [INF-00-12-K-2]: Title: "Information Systems"; Presence-Time: 84 h; Self-Study: 156 h
  • About [INF-00-12-K-2]: The study achievement "[U-Schein] proof of successful participation in the exercise classes (ungraded)" must be obtained.
    • It is a prerequisite for the examination for PL1.

Examination achievement PL1

  • Form of examination: written exam (Klausur) (120-150 Min.)
  • Examination Frequency: each summer semester
  • Examination number: 60012 ("Information Systems")

Evaluation of grades

The grade of the module examination is also the module grade.


Contents

  • Introduction and Basics
  • Introduction to Information Retrieval (Vector Space Model, TF*IDF)
  • Models for Result Quality (Precision and Recall)
  • Latent-Topic-Models (Singular Value Decomposition, LSI)
  • Computation of Document Similarities (Shingling)
  • Link Analysis and Markov Chains (PageRank)
  • Data-Mining: Frequent-Itemset-Mining and Clustering (k-Means)
  • Entity Relationship Modeling
  • The Relational Model
  • Relational Design Theory (Normal Forms)
  • Rule-based Conjunctive Queries and Relational Calculus
  • The SQL language (incl. recursion and window queries)
  • Relational Algebra and Extensions (Aggregation, Duplicate Elimination, Bag Semantics)
  • Views, Data Integrity, and Access Control
  • Programming Principles of SQL-based Applications (JDBC)
  • Database Triggers and User-Defined Functions
  • DBS Architecture and Buffer Replacement Strategies
  • Efficient Data Access through Indices (B/B+ Trees, Hashing, Bulkloading)
  • Equivalence Rules of Relational Algebra (Logical Query Optimization and Selectivity Estimation)
  • Transactions (ACID) and Serializability
  • Selected topics of managing Big Data (NoSQL, CAP Theorem, Eventual Consistency)

Competencies / intended learning achievements

Information systems are highly database-based applications, often with many users (thousands and more). They are transaction-processing systems, i.e. they perform their services in many small steps for the users accessing simultaneously. In doing so, they have to guarantee the integrity of the data and provide high throughput and short response times. Information systems typically run on a high-performance server and present themselves to the user with a graphical user interface as client/server systems, increasingly also via the Internet. Students acquire a detailed understanding of the tasks and solution methods involved in the development of operational application and information systems. This includes in particular skills and abilities in
  • use of information and data models to model mini-worlds,
  • assessment and improvement of the quality of modelling results,
  • construction, maintenance and query of databases using declarative, standardised query languages and
  • securing the processes in databases through the transaction concept.

Besides these classical topics, which are deepened in the lecture Database Systems this lecture will also address elementary aspects of information search and data mining, which are indispensable for understanding the omnipresent processes of modern everyday life.

In particular students achieve a

  • basic understanding of principles behind search engines like Google, as well as
  • Insights into knowledge gained through analysis of data (e.g. shopping basket analysis for product recommendation).

Literature

  • Alfons Kemper und André Eickler. Datenbanksysteme: Eine Einführung. Oldenbourg.
  • Elmasri, R., Navathe, S.: Grundlagen von Datenbanksystemen: Bachelorausgabe, 3. überarbeitete Auflage, Pearson Studium, 2009.
  • Raghu Ramakrishnan und Johannes Gehrke. Database Management Systems. Mcgraw-Hill Publ.Comp., 2002.
  • Christopher D. Manning, Prabhakar Raghavan und Hinrich Schütze. Introduction to Information Retrieval. Cambridge University Press, 2008. http://informationretrieval.org.
  • copies of lecture slides.
  • additional literature will be announced during the course.

Requirements for attendance of the module (informal)

None

Requirements for attendance of the module (formal)

None

References to Module / Module Number [INF-00-12-M-2]

Course of Study Section Choice/Obligation
[INF-82.79-SG] B.Sc. Computer Science [Compulsory Modules] Computer Science Systems [P] Compulsory
[MAT-82.105-SG] B.Sc. Mathematics [Subsidiary Topic] Subsidiary Subject (Minor) [WP] Compulsory Elective
[WIW-82.176-SG#2009] B.Sc. Business Administration and Engineering specialising in Computer Science (2009) [2009] [Fundamentals] Field of study: Computer Science [P] Compulsory
[WIW-82.789-SG#2009] B.Sc. Business Studies with Technical Qualifications (2009) [2009] [Fundamentals] Field of study: Computer Science [P] Compulsory
[MAT-88.118-SG] M.Sc. Industrial Mathematics [Core Modules (non specialised)] Computer Science and Computational Methods [WP] Compulsory Elective
[MAT-88.276-SG] M.Sc. Business Mathematics [Core Modules (non specialised)] Computer Science and Computational Methods [WP] Compulsory Elective
[WIW-82.?-SG#2021] B.Sc. Business Studies with Technical Qualifications (2021) [2021] [Core Modules (non specialised)] Technical Profile Area [P] Compulsory
[WIW-82.?-SG#2021] B.Sc. Business Administration and Engineering specialising in Computer Science (2021) [2021] [Specialisation] Field of Study: Computer Science [P] Compulsory
Module-Pool Name
[MV-MB-INF-2022-MPOOL-6] Wahlpflichtmodule M.Sc. Maschinenbau mit angewandter Informatik 2022
[MV-MBINFO-MPOOL-6] Wahlpflichtmodule Maschinenbau mit angewandter Informatik