back to table of content


MEDI  Database Programming Course INF
Lecturers : Prof. Dr. Susanne Busse    eMail
Term 4
Course Classification : Medizininformatik, Wahlpflicht Katalog B-MED-INF CH 4
Language : Deutsch Type VÜ 
Type of examination : PL  Credits
Method of evaluation : written examination 120 min 
Requirements :
Cross References :  
Previous knowledges : Databases I 
Aids and special features : Mode of assessment
Pass at course examination
Graded: yes
Continuous Evaluation for assignments.
Overall grade is the course examination grade.  
Teaching aims : Knowledge and understanding of transaction concept and DBMS recovery functionality
Knowledge and understanding of database programming variations and the standardisation developed in SQL 200x
Ability to use selected methods of database application programming in exercises using own relational database
Knowledge and understanding of important performance aspects, the functions of optimizer components in RMBMS and tuning database applications 
Contents :

Advanced transaction concept and recovery
Overview of database programming variants
Embedded SQL
SQL/CLI
SQL/PSM using Sybase TSQL
SQL/PSM level of standardisation
TSQL batches
TSQL stored proceduresv TSQL triggerv TSQL transactionsv RDB access pathsv Überblick zur Arbeit der Optimiererkomponente eines RDBMS
Tuning von DB-Applikationen 

Literature : Kifer M., Bernstein A., Lewis P.M.: Database Systems, 2nd ed., Addison Wesley, 2006.
Saake G., Heuer A., Sattler K.-U.: Datenbanken: Implementierungstechniken, 2. Aufl., MITP-Verlag 2005.
Kline K., Gould L., Zanevsky A.: Transact-SQL Programming, O Reilly Media, 1999.
Saake G., Sattler K.-U.: Datenbanken & Java, 2. Aufl., dpunkt Verlag, 2003.  


back to table of content