Database and Information Systems

Syllabus of lectures:
- Transactions (1 lecture)
Introduction, architecture of a DBMS, paralelization on various layers of a DBMS (pages, records, relations, ...)
- Concurrency control (3 lectures)
ACID; serializability; locking, deadlock, locking efficiency; lockless concurrency control; recovery manager (log, recovery, undo and redo phases)
- Transaction support in SQL and host language environments (3 lectures)
Transactions in SQL and PL/SQL, the transaction support in host language environments like ODBC, JDBC, and ADO.NET
- Distributed databases (1 lecture)
- Physical implementation of a DBMS (3 lectures)
Introduction, persistent data structures, pages, clustering; B-tree, hashing, R-tree; a paralelization of data structures
- SQL query evaluation and optimization of the query evaluation (2 lectures)
Query evaluation plan; optimization; sorting, implementation of the join operation
- Tuning of the query evaluation (2 lectures)
Creation and parametrization of indices in DBMS (like DB2, Oracle, SQL Server), special types of indices, an analysis of the query evaluation efficiency

Syllabus of computer exercises:
- Introductions
- Transactions in SQL and PL/SQL (3 practices)
- Transaction support in host language environments like ODBC, JDBC, and ADO.NET (2 practices)
- Locking implementations (2 practices)
- Physical implementation of a DBMS (3 practices)
- SQL query evaluation and optimization of the query evaluation (3 practices)
- Tuning of an SQL query evaluation (2 practices)