Search result: Catalogue data in Autumn Semester 2017

Computer Science (General Courses) Information
Computer Science for Non-Computer Scientists
NumberTitleTypeECTSHoursLecturers
252-0834-00LInformation Systems for Engineers Information Z4 credits2V + 1UG. Fourny
AbstractThis course provides the basics of information systems from the perspective of the user. The main focus is on relational databases, including tabular data, the relational algebra, the SQL query language, schema design, normal forms, physical architecture, indices. The course also covers support for data cubes on top of relational databases.
ObjectiveAfter visiting this course, students should be capable to:

1. Explain, in the big picture, how a relational database works and what it can do in their own words.
2. Explain the relational data model (tables, rows, attributes, primary keys, foreign keys), formally and informally, including the relational algebra operators (select, project, rename, all kinds of joins, division, cartesian product, union, intersection, etc).
3. Perform non-trivial reading SQL queries on existing relational databases, as well as insert new data, update and delete existing data.
4. Design a new relational schema to store data in accordance to the real world's constraints, such as relationship cardinality.
5. Adapt and improve an existing schema to make it more robust against anomalies, thanks to a very good theoretical knowledge of normal forms.
6. Understand how indices work (hash indices, B-trees), how they are implemented, and how to use them to make queries faster.
7. Access an existing relational database from a host language such as Java, using bridges such as JDBC.
8. Explain data independence.
9. Explain how a relational database is physically implemented.
10. Know and deal with the natural syntax for relational data, CSV.
11. Explain the data cube model including slicing and dicing.
12. Store data cubes in a relational database.
13. Map cube queries to SQL.
14. Slice and dice cubes in a UI.
ContentUsing a relational database
=================
1. Introduction (historical overview, data independence, data shapes)
2. The relational model (data models, tables, relational algebra, CSV syntax)
3. The query language SQL (DML 1 of 2, SQL shell, counterpart of selection, projection, grouping, ordering, renaming)
4. Schema definitions (DDL, data types, SQL)
5. Updates (DML 2 of 2, insertion, deletion, updates, SQL)

Taking a relational database to the next level
=================
6. Best practices and normal forms (update/insert/delete anomalies, first, second, third, BC, fourth)
7. Physical architecture of a relational database (storage levels, tuple storage)
8. Indices and optimization (ISAM, B-tree, B+-tree, hash)
9. Communicating with a SQL database from a host language (Java, JDBC)

Analytics on top of a relational database
=================
10. Analytics, data warehousing, OLAP vs. OLTP, the data cube model (dimensions, algebra)
11. Storing and querying data cubes in a relational database (star schema, snowflake schema)
12. Data cube optimization (indices, bitmaps)

Outlook
=================
13. Limits of tables and cubes (decision points for when and when not to use them vs. trees, graphs)
14. Limits of scaling up a single machine and transition to Big Data (introduction to data denormalization on simple cases, "hacking" a relational database onto several machines and issues)
Literature- Lecture material (slides).

- Book: "Database Systems: The Complete Book", H. Garcia-Molina, J.D. Ullman, J. Widom
(It is not required to buy the book, as the library has it)
Prerequisites / NoticeFor non-CS/DS students only, BSc and MSc
Elementary knowledge of set theory and logics
Knowledge as well as basic experience with a programming language such as Pascal, C, C++, Java, Haskell, Python
252-0835-00LComputer Science I Information Z4 credits2V + 2UF. Friedrich Wicker
AbstractThe course covers the fundamental concepts of computer programming with a focus on systematic algorithmic problem solving. Teached language is C++. No programming experience is required.
ObjectivePrimary educational objective is to learn programming with C++. When successfully attended the course, students have a good command of the mechanisms to construct a program. They know the fundamental control and data structures and understand how an algorithmic problem is mapped to a computer program. They have an idea of what happens "behind the secenes" when a program is translated and executed.
Secondary goals are an algorithmic computational thinking, undestanding the possibilities and limits of programming and to impart the way of thinking of a computer scientist.
ContentThe course covers fundamental data types, expressions and statements, (Limits of) computer arithmetic, control statements, functions, arrays, structural types and pointers. The part on object orientiation deals with classes, inheritance and polymorphy, simple dynamic data types are introduced as examples.
In general, the concepts provided in the course are motivated and illustrated with algorithms and applications.
Lecture notesA script written in English will be provided during the semeter. The script and slides will be made available for download on the course web page.
LiteratureBjarne Stroustrup: Einführung in die Programmierung mit C++, Pearson Studium, 2010
Stephen Prata, C++ Primer Plus, Sixth Edition, Addison Wesley, 2012
Andrew Koenig and Barbara E. Moo: Accelerated C++, Addison-Wesley, 2000.
Prerequisites / NoticeFrom AS 2013, an admission to the exam does not any more formally require an attending of the recitation sessions. Handing in solutions to the weekly exercise sheets is thus not mandatory, but we strongly recommend it.

Examination is a one hour-long written test.
252-0839-00LInformatics Information Z2 credits2GL. E. Fässler, M. Dahinden
AbstractStudents learn to apply selected concepts and tools from computer science for working on interdisciplinary projects. The following topics are covered: modeling and simulations, visualizing multi-dimensional data, managing data with lists and tables and with relational databases, introduction to programming, universal methods for algorithm design.
ObjectiveThe students learn to

- choose and apply appropriate tools from computer science,
- process and analyze real-world data from their subject of study,
- handle the complexity of real-world data,
- know universal methods for algorithm design.
Content1. Modeling and simulations
2. Visualizing multidimensional data
3. Data management with lists and tables
4. Data management with a relational database
5. Introduction to macro programming
6. Introduction to programming with Python
Lecture notesAll materials for the lecture are available at Link
Prerequisites / NoticeThis course is based on application-oriented learning. The students spend most of their time working through projects with data from natural science and discussing their results with teaching assistants. To learn the computer science basics there are electronic tutorials available.
252-0845-00LComputer Science I Information Z5 credits2V + 2UH. Lehner, F. Friedrich Wicker
AbstractThe course covers the basic concepts of computer programming.
ObjectiveBasic understanding of programming concepts. Students will be able to write and read simple programs and to modify existing programs.
ContentVariablen, Typen, Kontrollanweisungen, Prozeduren und Funktionen, Scoping, Rekursion, dynamische Programmierung, vektorisierte Programmierung, Effizienz.
Als Lernsprachen werden Java und Matlab verwendet.
LiteratureSprechen Sie Java?
Hanspeter Mössenböck
dpunkt.verlag
252-0847-00LComputer Science Information Z5 credits2V + 2UB. Gärtner
AbstractThis lecture is an introduction to programming based on the language C++. We cover fundamental types, control statements, functions, arrays, and classes. The concepts will be motivated and illustrated through algorithms and applications.
ObjectiveThe goal of this lecture is an algorithmically oriented introduction to programming.
ContentThis lecture is an introduction to programming based on the language C++. We cover fundamental types, control statements, functions, arrays, and classes. The concepts will be motivated and illustrated through algorithms and applications.
Lecture notesLecture notes in English and Handouts in German will be distributed electronically along with the course.
LiteratureAndrew Koenig and Barbara E. Moo: Accelerated C++, Addison-Wesley, 2000.

Stanley B. Lippman: C++ Primer, 3. Auflage, Addison-Wesley, 1998.

Bjarne Stroustrup: The C++ Programming Language, 3. Auflage, Addison-Wesley, 1997.

Doina Logofatu: Algorithmen und Problemlösungen mit C++, Vieweg, 2006.

Walter Savitch: Problem Solving with C++, Eighth Edition, Pearson, 2012
252-0851-00LAlgorithms and ComplexityZ4 credits2V + 1UA. Steger
AbstractIntroduction: RAM machine, data structures; Algorithms: sorting, median, matrix multiplication, shortest paths, minimal spanning trees; Paradigms: divide & conquer, dynamic programming, greedy algorithms; Data Structures: search trees, dictionaries, priority queues; Complexity Theory: P and NP, NP-completeness, Cook's theorem, reductions.
ObjectiveAfter this course students know some basic algorithms as well as underlying paradigms. They will be familiar
with basic notions of complexity theory and can use them to classify problems.
ContentDie Vorlesung behandelt den Entwurf und die Analyse von Algorithmen und Datenstrukturen. Die zentralen Themengebiete sind: Sortieralgorithmen, Effiziente Datenstrukturen, Algorithmen für Graphen und Netzwerke, Paradigmen des Algorithmenentwurfs, Klassen P und NP, NP-Vollständigkeit, Approximationsalgorithmen.
Lecture notesJa. Wird zu Beginn des Semesters verteilt.
252-0852-00LFoundations of Computer Science Information Z4 credits2V + 2UL. E. Fässler, M. Dahinden, H. Lehner
AbstractStudents learn to apply selected concepts and tools from computer science for working on interdisciplinary projects.

The following topics are covered: modeling and simulations, introduction to programming, visualizing multi-dimensional data, introduction matrices, managing data with lists and tables and with relational databases, universal methods for algorithm design.
ObjectiveThe students learn to

- understand the role of computer science in science,
- to control computer and automate processes of problem solving by programming,
- choose and apply appropriate tools from computer science,
- process and analyze real-world data from their subject of study,
- handle the complexity of real-world data,
- know universal methods for algorithm design.
Content1. The role of computer science in science
2. Introduction to Programming with Python
3. Modeling and simulations
4. Introduction to Matrices with Matlab
5. Visualizing multidimensional data
6. Data management with lists and tables
7. Data management with a relational database
8. Universal methods for algorithm design
Lecture notesAll materials for the lecture are available at Link
LiteratureL. Fässler, M. Dahinden, D. Komm, and D. Sichau: Einführung in die Programmierung mit Python und Matlab. Begleitunterlagen zum Onlinekurs und zur Vorlesung, 2016. ISBN: 978-3741250842.
L. Fässler, M. Dahinden, and D. Sichau: Verwaltung und Analyse digitaler Daten in der Wissenschaft. Begleitunterlagen zum Onlinekurs und zur Vorlesung, 2017.
Prerequisites / NoticeThis course is based on application-oriented learning. The students spend most of their time working through projects with data from natural science and discussing their results with teaching assistants. To learn the computer science basics there are electronic tutorials available.
252-0855-00LComputer Science in Secondary School Mathematics Information Restricted registration - show details Z4 credits3GJ. Hromkovic, G. Serafini
AbstractThe unit "Computer Science in Secondary School Mathematics" addresses key contributions of computer science to general education, the tight relations between the algorithmic and the mathematical way of thinking, and the thoughtful choice of computer science topics for high school mathematics classes.
ObjectiveThe general goal of the course consists in presenting ways to teach fundamentals of computer science, which are closely related to contents and methods of mathematics. After attending the course unit, a mathematics teacher is able to teach selected fundamentals of computer science in mathematics classes.

The students understand the fundamental concepts of computer science in the context of a broad and deep knowledge. Through this understanding, they manage to prepare teaching materials for a successful knowledge transfer and to pass their passion for the subject on to their pupils.

The students know various teaching methods as well as their advantages and disadvantages. They can handle inhomogeneous prior knowledge of the learners inside a class. Besides holding classes, the students do care about the individual pupil support.

They encourage the autonomy of the learners, manage to work with diverse target groups and to establish a positive learning environment.

The students are able to express themselves using a comprehensible and refined professional language, both in a spoken and a written way, and they master the basic terminology of computer science. Besides the English terms, they are familiar with the corresponding German expressions. The students are able to produce detailed, matured, linguistically correct and design-wise appealing teaching materials.
ContentThe main topics of the course unit "Computer Science in Secondary School Mathematics" represent a scientific and didactic added value for mathematics classes.

The course covers the didactics of logic, of cryptology, of finite state automata, of computability and of the introduction to programming. The students develop the understanding of fundamental scientific concepts such as algorithm, program, complexity, determinism, computation, automata, verification, testing, security of a cryptosystem and secure communication. They reflect on ways to embed them into a scientifically sound and didactically sustainable mathematics course.

In a semester exercise, the students develop and document an adaptive teaching unit for computer science. They learn to employ the didactics methods and techniques that are introduced at the beginning of the semester.
Lecture notesLiteratur wird angegeben. Zusätzliche Unterlagen und Folien werden zur Verfügung gestellt.
LiteratureJ. Hromkovic: Sieben Wunder der Informatik: Eine Reise an die Grenze des Machbaren, mit Aufgaben und Lösungen. Vieweg+Teubner; Auflage: 2 (2008).

K. Freiermuth, J. Hromkovic, L. Keller und B. Steffen: Einfuehrung in die Kryptologie: Lehrbuch für Unterricht und Selbststudium. Springer Vieweg; Auflage: 2 (2014).

J. Hromkovic: Berechenbarkeit: Logik, Argumentation, Rechner und Assembler, Unendlichkeit, Grenzen der Automatisierbarkeit. Vieweg+Teubner; Auflage: 1 (2011).

H.-J. Böckenhauer, J. Hromkovic: Formale Sprachen: Endliche Automaten, Grammatiken, lexikalische und syntaktische Analyse. Springer Vieweg; Auflage: 1 (Januar 2013).

J. Hromkovic: Einführung in die Programmierung mit LOGO: Lehrbuch für Unterricht und Selbststudium. Springer Vieweg; Auflage: 3 (2014)
  •  Page  1  of  1