Teaching:

Winter term 2006/2007: Database Systems (practical course)


Summer term 2006:
Knowledge Discovery in Databases (practical course)

Winter term 2005/2006: Database Systems (practical course)
Content of the practical course: The practical course 'Database Systems' is a main class for students of Computer Science at the University of Munich (LMU). On the basis of database systems theory, this course mainly focuses on practical aspects of database systems. In particular, the course covers the following topics: relational data model, DDL and DML in SQL, procedures in SQL and the cursor concept, embedded SQL (with C as host language), SQLJ and JDBC (with Java as host language), database tuning, database systems and the World Wide Web, distributed database systems and client-server architectures. The students develop several minor projects in small teams and the practical course is concluded with a major project. All projects are developed on a commercial database system.


Summer term 2005:
Knowledge Discovery in Databases (practical course)
This practical course deals with tools and methods for Knowledge Discovery in Databases (KDD). KDD is a process that aims at discovery of statistically valid, interesting, and potentially new knowledge in large datasets, whereas Data Mining (DM) is application of efficient algorithms for data analysis that is part of KDD process. Nowadays several data mining algorithms and techniques exist that can be used to discover various types of models and patterns in databases. The KDD practical course is focused on single steps of KDD process, like pre-processing, and application of data mining algorithms in databases.

Winter term 2004/2005: Database Systems (practical course)
Content of the practical course: The practical course 'Database Systems' is a main class for students of Computer Science at the University of Munich (LMU). On the basis of database systems theory, this course mainly focuses on practical aspects of database systems. In particular, the course covers the following topics: relational data model, DDL and DML in SQL, procedures in SQL and the cursor concept, embedded SQL (with C as host language), SQLJ and JDBC (with Java as host language), database tuning, database systems and the World Wide Web, distributed database systems and client-server architectures. The students develop several minor projects in small teams and the practical course is concluded with a major project. All projects are developed on a commercial database system.


Summer term 2004: Efficient algorithms
Content of the class: The class 'Efficient Algorithms' is a fourth class for students of Computer Science at the University of Munich (LMU). The topics are: Search techniques (Exhaustive search, Greedy algorithms, Backtracking, Branch-and-Bound techniques, Divide-and-Conquer methods and Dynamic Programming methods), Sort algorithms (Simple Sort methods, Divide-and-Conquer methods, Tree-based methods with performance considerations), Graphs and Graph algorithms (Graph models, Graph navigation, Shortest-Path problems), and general algorithmic methods.

Content of the tutorial: The main purpose of the accompanying tutorial is to deepen the theoretical knowledge and to gain practical experience in designing and implementing problem solving algorithms. For the latter reason many exercises use Java.


Winter term 2003/2004: Database Systems (practical course)
Content of the practical course: The practical course 'Database Systems' is a main class for students of Computer Science at the University of Munich (LMU). On the basis of database systems theory, this course mainly focuses on practical aspects of database systems. In particular, the course covers the following topics: relational data model, DDL and DML in SQL, procedures in SQL and the cursor concept, embedded SQL (with C as host language), SQLJ and JDBC (with Java as host language), database tuning, database systems and the World Wide Web, distributed database systems and client-server architectures. The students develop several minor projects in small teams and the practical course is concluded with a major project. All projects are developed on a commercial database system.