Seminar aus Datenbanken
SE 181.201 (2.0) Sommersemester 2012
Reinhard Pichler
in cooperation with Gerald Aufmuth (IBM Austria, Certified DB2 Specialist)
and Helmut Riegler (IBM Austria, Certified IT Specialist, Datawarehouse Specialist)
|
Please register until 1 March, 2012 |
General information
- Language. This course will possibly be held in English since it is part of the European Master's Program in Computational Logic (EMCL) curriculum.
- Place. Classes will be held in the von Neumann Seminarraum (Favoritenstraße 9-11, ground floor). Only the first class (5 March) will be in the Gödel Seminarraum.
- Time.
Classes will take place on the following days.
- Monday 5 March, 11:00 sharp - 13:00: first class (Gödel Seminarraum).
- Monday 16 April, 09:00 - 11:00: students' presentations, reserve (if needed).
- Monday 16 April, 11:00 - 13:00: students' presentations, part 1.
- Monday 23 April, 09:00 - 11:00: students' presentations, reserve (if needed).
- Monday 23 April, 11:00 - 13:00: students' presentations, part 2.
- Monday 30 April, 11:00 - 13:00: case study database (basics of DB2), part 1.
- Monday 7 May, 11:00 - 13:00: case study database (basics of DB2), part 2.
- Monday 14 May, 11:00 - 13:00: case study database (basics of DB2), part 3.
- Monday 21 May, 11:00 - 13:00: case study database (basics of DB2), part 4.
Prerequisites
Basic knowledge in database systems to the extent of the undergraduate lectures "Datenmodellierung" and "Datenbanksysteme" is an indispensable prerequisite for this seminar. Knowledge in XML and related technologies as taught in the lecture "Semistrukturierte Daten" is very helpful but not absolutely necessary.Registration
Registration in TISS is required for this seminar!!
(Attention: registration != subscription)
Contents and Course Structure
Several topics in the area of Database Administration are studied in this course with emphasis on:- Database Security
- Storage Management
- Performance Management/Optimization
- Data Concurrency and Consistency
In the first part of the seminar, students are requested to collect material on some aspect of the above topics and prepare a written report and an oral presentation. The focus is on generally applicable concepts - independent of concrete products.
In the second part of the seminar, we will discuss these concepts on a concrete database system, namely DB2. Students will then be requested to extend their written reports from the first part by a brief reflection where the general concepts are juxtaposed with the concrete realization.
The knowledge acquired in this seminar enables the students to pass the certification as IBM Certified Database Associate. IBM Austria invites every participant of this seminar to do the certification exam free of charge. For details, see below. Please note that the certification exam is optional and independent of the course assessment.
Course Material
First class on 5 March: General information, DB2 specific information
Course Assessment
Presence in the classes is compulsory. Assessment for the "Seminar aus Datenbanken" will be based on:- written report (8-10 pages)
- oral presentation (ca. 20 min, depending on number of participants)
- reflection (1-2 pages)
Moreover, active participation in the discussions is expected. The details will be fixed in the first class.
DB2 Certification
IBM Austria invites every participant of this seminar to do the certification exam free of charge. This exam corresponds to the certification as IBM Certified Database Associate.
The certification exam will take place at IBM (Obere Donaustraße 95, 1020 Wien) towards the end of the semester. Details will be provided in the first class of the seminar. For further information, see also DB2 on Campus Initiative.
| Last modified 21 February, 2012 |