Time: |
Monday, 4. DS (13:00 bis 14:30),
|
Location: |
APB/E010 |
Quantity: |
2V/2Ü/0P SWS |
Language: |
English |
Modules: |
DSE-14-M3, MCL-FE |
News
Due to various circumstances, the videos for the course could not be made available for some time. For that reason, the new schedule looks as follows:
- 08.01. Videos for Chapter 4 and 5
- 14.01.(updated) Videos for Chapter 6
- 15.01.(updated) Videos for Chapter 7 (updated)
- 20.01. Videos for Chapter 8
- 27.01. Videos for Chapter 9
- 01.02. Test Exam at 1pm for 30min (Online Test)
- 10.02. Final Exam 90min (Online Test)
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.
Organizational Matters
- The course will be only offered online using pre-recorded presentations.
- Please register at OPAL for the course as well as for the exercises. Moreover, there is a forum which will be actively used for communication.
Lecture notes
Chapter |
Content |
Slides |
Video |
Number of pages |
0 |
Introduction |
pdf |
Video |
14 |
1 |
Hands on SQL |
pdf |
|
44 |
2 |
Database Design |
pdf |
01,
02,
03 |
38 |
3 |
Relational Theory (Recap) |
pdf |
01,
02 (is coming) |
48 |
4 |
Introduction to Transactions |
pdf |
01,
02
| 37 |
5 |
DBMS Architecture I – From Disks To Pages |
pdf |
01,
02,03
| 52 |
6 |
DBMS Architecture II – From Pages To Database Objects |
pdf
| 01,
B-Tree on Youtube |
62 |
7 |
DBMS Architecture III – From Database Objects To Query Results |
pdf |
43 |
8 |
Transactions |
pdf |
47 |
9 |
Distributed Transactions |
pdf |
39 |
–>
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