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
- Physical implementation of a DBMS (2 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 (1 lectures)
Query evaluation plan; optimization; sorting, implementation of the join operation
- Data layer implementation (JDBC, ADO.NET)
- Sample application (J2EE, ASP.NET)

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)
- Physical implementation of a DBMS (3 practices)
- SQL query evaluation and optimization of the query evaluation (2 practices)
- Tuning of an SQL query evaluation (1 practices)
- Data layer implementation