Realization of Database Systems SS 2011
News
Date | Announcement |
|---|---|
July, 11th, 2011 | Possible Schedules for Oral Examinations
Please ask our secretary for an appointment. |
July, 11th, 2011 | Update of Exercise Sheet 8 Please note, exercise 8.1 a) (E3) was updated. Thans Bo Zhang for the hint. |
July, 5th, 2011 | Change in Room Planning #3 Starting on July 6th until the rest of this semester, we will have our exercise in 36-336. |
May 27, 2011 | Update of Exercise Sheet 3 |
May 24, 2011 | Change in Room Planning #2 From this week on, the exercise will be in room 48-462. ds |
May 11, 2011 | Change in Room Planning Due to a conflict in the room planning,
the exercises will NOT be held in 48-462! Instead, they will take place in 36-336. ds |
May 9, 2011 | Update of Exercise Sheet 1 |
April 28, 2011 | Start of exercises |
March 29, | Start of lectures The lectures will start on Thursday, April 28, 2011. |
Contents
Chapter 0: Introduction
Chapter 1: Architecture of Database Systems
Chapter 2: I/O Architectures and Storage Hierarchies
Chapter 3: Files and Segments
Chapter 4: DB Buffer Management
Chapter 5: Storage Structures
Chapter 6: Tree-Based Access Paths
Chapter 7: Hash-Based Access Paths
Chapter 8: Secondary and Hierarchical Access Paths
Chapter 9: Multi-Dimensional Access Paths
Chapter 10: Record-Oriented Db Interface
Chapter 11: Table Operations - Implementation
Chapter 12: Set-Oriented DB Interface
Further reading
- Theo Härder: DBMS Architecture - The Layer Model and its Evolution
- Theo Härder: DBMS Architecture – New Challenges Ahead
- Guy Lohmann: DASFAA 2007 Keynote
- Goetz Graefe: Query evaluation techniques for large databases
- Goetz Graefe: Implementing sorting in database systems
- Goetz Graefe: New algorithms for join and grouping operations
Important links
Organizational matters
Course hours
Tuesday: 8:15 pm - 9:45 pm, 48-462
Thursday: 8:15 pm - 9:45 pm, 48-462
(Start: Thursday, April 28, 2011)
Exercise hours
Wednesday, 3:30 am - 5:00 am, 48-462
(Start Wednesday, May 11, 2011)
Office of the Teaching Area: Information Systems
Office hours: Mo. - Fr., 08:00 am - 11:00 am
36/332, 205-4031
References
Härder, T., Rahm, E.: Datenbanksysteme - Konzepte und Techniken der Implementierung
2. Auflage, Morgan Kaufmann, 2001
Gray, J., Reuter, A.: Transaction Processing: Concepts und Techniques
Morgan Kaufmann, San Mateo, Kalifornien, 1993
O’Neil, P.: Database—Principles, Programming, Performance
Morgan Kaufmann, 1994.
Mitschang, B.: Anfrageverarbeitung in Datenbanksystemen — Entwurfs- und Implementierungskonzepte
Reihe Datenbanksysteme, Vieweg, 1995.
Rahm, E.: Hochleistungs-Transaktionssysteme
Vieweg-Verlag, 1993
Saake, G., Heuer, A., Sattler, K.-U.: Datenbanken: Implementierungstechniken
MITP, 2005.
Stallings, W.: Betriebssysteme – Prinzipien und Umsetzung
4. Ed., Pearson Studium, 2003
Ramakrishnan, R., Gehrke, J.: Database Management Systems
McGraw-Hill, 2004