Databases II (Database Implementation Techniques)

Organization

Lecturer:	Sandro Schulze
SWS:	2 Lecture, 2 Exercise;
Participants:	Computer science students of Wadi University
Time/Place:	Tuesday, 3-5 p.m., G29-335
	The exam takes place on Monday, Feb 8th from 9 a.m. until 11 a.m. in room 22A/020 !!!!
Practice:	Monday 9-11 a.m., G22A-004 (starts on 26.10.2009)

Objectives & acquired competences:

• Knowledge about functioning of database management systems
• Capability for physical design of database management systems
• Capaility for administration and tuning of database systems
• Capability for developing components of data management solutions

Contents

• Functionality and principles of database systems
• Architecture of database systems
• Management of storage device(s)
• File organisation and data structures
• Data structures for specific applications
• Basic algorithms for database operations

Requirements

Fundamental knowledge of databases or data management( e.g., SQL, relational algebra) is required.

Slides

1. Introduction/Requirements and principles of DBS [pdf]
2. Architecture of database systems [pdf]
3. Storage management [pdf]
4. File organisation & access structures [pdf - part I] [pdf - part II] [pdf - part III]
5. Specific access structures [pdf]
6. Basic algorithms [pdf]
7. Optimization [pdf - part I] [pdf - part II]

Practice

1. Repetition of SQL and relational algebra (02.11.2009)
2. Optimization 1 & DB architecture (09.11.2009)
3. RAID & PAges & Buffer Management (16.11.2009)
4. File Organisation (23.11.2009)
5. Access Structures I (30.11.2009)
6. Access Structures II (07.12.2009)
7. Access Structures III(14.12.2009)
8. Optimization 2 - part I(11.01.2010)
9. Optimization 2 - part II(18.01.2010)

Literature

The lecture is based on the following book:

G. Saake, A. Heuer, Kai-Uwe Sattler:
"Datenbanken: Implementierungstechniken"
MITP-Verlag, Bonn, 2003, ISBN 3-8266-1438-0 www

Further literature recommendations are given in the lecture (see introduction slides).