|
|
 |
|
Database Systems
Content
The lecture is to introduce
the structure and the architecture of database systems
that use modularization and layers with abstraction.
The emphasis therefore is on technological aspects of database systems.
The storage of data on non-volatile storage
serves as a starting point
for a sequence of abstractions
which are defined on top of each other.
The first abstraction is the file.
Then records are introduced
and organized in blocks in different ways
(sequentially, with direct access, index-sequentially).
As a second major abstraction,
data models are introduced,
especially the relational data model.
That includes structures
as well as query languages like SQL.
The secondd part
deals with the implementation
of the services a database systems offers,
using the previously discussed records
and access paths ("top down").
This includes query processing and optimization,
but also mechanisms to log actions
and to recover data after failures.
A layered architecture
for database management systems
finally comprises all the tasks.
The goal of the lecture thus is
to create a fundamental understanding
of the structure and functionality
of a particular software system,
namely a database system.
Literature
| Heue03a |
HEUER, Andreas ;
SAAKE, Gunter ;
SATTLER, Kai-Uwe:
Datenbanken kompakt.
2. Aufl.
Bonn : mitp, 2003. - ISBN 3-8266-0987-5
|
| Kemp09a |
KEMPER, Alfons ;
EICKLER, André:
Datenbanksysteme : Eine Einführung.
7., aktual. u. erw. Aufl.
München ; Wien : Oldenbourg, 2009. - ISBN 978-3-486-57690-9
|
| Kemp06b |
KEMPER, Alfons ;
WIMMER, Martin:
Übungsbuch Datenbanksysteme.
München ; Wien : Oldenbourg, 2006. - ISBN 3-486-59018-0
|
| Heue07a |
HEUER, Andreas ;
SAAKE, Gunter:
Datenbanken : Konzepte und Sprachen.
3., aktual. u. erw. Aufl.
Bonn : mitp, 2007. - ISBN 3-8266-1664-2
|
| Haer99a |
HÄRDER, Theo ;
RAHM, Erhard:
Datenbanksysteme :
Konzepte und Techniken der Implementierung.
Berlin : Springer, 1999 - ISBN 3-540-65040-7
This book and the associated lecture
have been the prime source for SoS2.
Thanks to Prof. Härder
for the extensive suppport!
|
| Saak05a |
SAAKE, Gunter ;
HEUER, Andreas:
Datenbanken : Implementierungstechniken.
2., aktual. u. erw. Aufl.
Bonn : mitp, 2005. - ISBN 3-8266-1438-0
|
Target audience
Students of
- Computer Science (Bachelor),
- Business Computing,
- Computational Engineering (Bachelor),
- Computational Linguistics,
- and other curriculae
Further information
- Time:
winter semester (WS)
- Language:
German
- Hours per week (SWS):
2+2
- Credit points (ECTS):
5
- Examination:
written
- Contact:
Prof. Dr. Klaus Meyer-Wegener
|
|
|
|
