Time: |
Monday, 4. DS (13:00 bis 14:30),
|
Location: |
APB/E010 |
Quantity: |
2V/2Ü/0P SWS |
Language: |
English |
Modules: |
DSE-14-M3 |
Post-exam review
- You can have a look at your exam again in case you wonder what went wrong. (Your participation is neither expected nor requested. It is merely an offer in case you cannot figure out what went wrong, so you can prepare better for future exams.)
- April 1, 2019
- Starting 13:00
- Room APB 3043
Summary
Database systems play a central role in building large and distributed transactionally working information systems. Within this lecture, we discuss techniques which are required to setup a robust distributed information system. After repeating the core concepts of ER modeling and the relational database model including SQL, we focus on specific features of a large scale database system.
Lecture notes
Chapter |
Content |
Slides |
Number of pages |
0 |
Introduction |
pdf |
12 |
1 |
Hands on SQL |
pdf |
39 |
2 |
Database Programming |
pdf |
50 |
3 |
Database Design |
pdf |
38 |
4 |
Relational Theory |
pdf |
46 |
5 |
DBMS Architecture I – From Disks To Pages |
pdf |
57 |
6 |
DBMS Architecture II – From Pages To Database Objects |
pdf |
62 |
7 |
DBMS Architecture III – From Database Objects To Query Results |
pdf |
40 |
8 |
Transactions |
pdf |
41 |
Literature
- Elasmri, R.; Navathe, S: “Fundamentals of Database Systems” (5th Edition)
- Ramakrishnan, R.; Gehrke, J.: “Database Management Systems” McGraw-Hill, 2000
- Weikum, G.; Vossen, G.: “Transactional Information Systems“ Morgan Kaufmann, 2001
- J. Hoffer:, M. Prescott, H. Topi: “Modern Database Management” (9th Edition)
- Garcia-Molina, H.; Ullman, J.; Widom, J.: “Database Systems: The Complete Book” (2nd Edition)
- Garcia-Molina, H.; Ullman, J.; Widom, J.: “Database System Implementation”, 2000