Workload:
270 h
|
Module Number INFO-4141 |
Module Title Implementation of Relational Database Systems (DB2) |
Lecture Type(s) Lecture, Tutorial |
|---|---|---|
| ECTS | 9 | |
|
Work load - Contact time - Self study |
Workload:
270 h Class time:
90 h / 6 SWS Self study:
180 h |
|
| Duration | 1 Semester | |
| Frequency | Irregular | |
| Language of instruction | German and English | |
| Type of Exam | Written exam (oral exam with a small number of participants), exercise points |
|
| Content | Internals of PostgreSQL and MonetDB, secondary storage access and data layout, index structures (B+ trees, hashes), multidimensional index structures, sorting methods on secondary storage, query evaluation, plan generation and optimization for SQL, transactions (ACID principle). |
|
| Objectives | The role and relevance of the internals of a database system are clarified and analysed. Throughout the semester, we contrast PostgreSQL and MonetDB so that students can assess the suitability of disk-based and main memory-based database technology for concrete applications. Students know how to link this new knowledge with the concepts of the lecture "DB1". The students understand which basic parameters and algorithms enable efficient database operation and can optimise them for concrete applications. In doing so, the topic is treated in a depth that provides students with reading and learning skills as well as trains discipline and precision. |
|
| Allocation of credits / grading |
Type of Class
Status
SWS
Credits
Type of Exam
Exam duration
Evaluation
Calculation
of Module (%)
Tutorial
Ü
o
2
3.0
Lecture
V
o
4
6.0
wt
90
g
100
|
|
| Prerequisite for participation | There are no specific prerequisites. | |
| Lecturer / Other | Grust | |
| Literature | • Ramakrishnan / Gehrke: Database Management Systems |
|
| Last offered | Sommersemester 2022 | |
| Planned for | Sommersemester 2024 | |
| Assigned Study Areas | INFO-INFO, INFO-PRAK, MEDI-APPL, MEDI-INFO, ML-CS | |