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

Most of the following books are available at SLUB Dresden.
  • 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