263-3845-00L  Data Management Systems

SemesterHerbstsemester 2020
DozierendeG. Alonso
Periodizitätjährlich wiederkehrende Veranstaltung


263-3845-00 VData Management Systems
3 Std.
Mi10:15-12:00CAB G 11 »
Fr08:15-09:00CAB G 11 »
G. Alonso
263-3845-00 UData Management Systems1 Std.
Fr09:15-10:00HG E 1.2 »
G. Alonso
263-3845-00 AData Management Systems3 Std.G. Alonso


KurzbeschreibungThe course will cover the implementation aspects of data management systems using relational database engines as a starting point to cover the basic concepts of efficient data processing and then expanding those concepts to modern implementations in data centers and the cloud.
LernzielThe goal of the course is to convey the fundamental aspects of efficient data management from a systems implementation perspective: storage, access, organization, indexing, consistency, concurrency, transactions, distribution, query compilation vs interpretation, data representations, etc. Using conventional relational engines as a starting point, the course will aim at providing an in depth coverage of the latest technologies used in data centers and the cloud to implement large scale data processing in various forms.
InhaltThe course will first cover fundamental concepts in data management: storage, locality, query optimization, declarative interfaces, concurrency control and recovery, buffer managers, management of the memory hierarchy, presenting them in a system independent manner. The course will place an special emphasis on understating these basic principles as they are key to understanding what problems existing systems try to address. It will then proceed to explore their implementation in modern relational engines supporting SQL to then expand the range of systems used in the cloud: key value stores, geo-replication, query as a service, serverless, large scale analytics engines, etc.
LiteraturThe main source of information for the course will be articles and research papers describing the architecture of the systems discussed. The list of papers will be provided at the beginning of the course.


Information zur Leistungskontrolle (gültig bis die Lerneinheit neu gelesen wird)
Leistungskontrolle als Semesterkurs
ECTS Kreditpunkte8 KP
PrüfendeG. Alonso
RepetitionDie Leistungskontrolle wird in jeder Session angeboten. Die Repetition ist ohne erneute Belegung der Lerneinheit möglich.
Prüfungsmodusschriftlich 180 Minuten
Zusatzinformation zum PrüfungsmodusThe examination could take place electronically.
Hilfsmittel schriftlichNo supporting materials will be allowed.
Diese Angaben können noch zu Semesterbeginn aktualisiert werden; verbindlich sind die Angaben auf dem Prüfungsplan.


Es werden nur die öffentlichen Lernmaterialien aufgeführt.


Keine Informationen zu Gruppen vorhanden.


Keine zusätzlichen Belegungseinschränkungen vorhanden.

Angeboten in

Cyber Security MasterKernfächerWInformation
Cyber Security MasterKernfächerWInformation
Data Science MasterDatenmanagement und DatenverarbeitungWInformation
Informatik MasterKernfächer der Vertiefung General StudiesWInformation
Informatik MasterKernfächerWInformation
Informatik MasterKernfächer der Vertiefung in Distributed SystemsWInformation
Informatik MasterErgänzung in Data ManagementWInformation
Informatik MasterErgänzung in Systems SoftwareWInformation