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

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