VVZ API is not affiliated with ETH Zurich. Data might be outdated or incorrect. Please view the official ETHZ Vorlesungsverzeichnis for binding information.

263-3845-00L 8 Credits MSC , WBZ D-ITET , D-INFK , D-MATH , D-GESS
You're viewing possible stale or outdated data. Please check the latest semester for more up-to-date information.

Data Management Systems

Lecturers & Examiners: Prof. Dr. Gustavo Alonso
VVZ CR 1.93

Last Updated: 2026-02-05 15:48:26

Abstract

The 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.

Objective

The 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.

Content

The 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.

Resources

Literature

The 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.

Learning Materials (Links)

General Information

Language
English
Levels
MSC , WBZ
Frequency
Yearly recurring

Examination

Type
session examination
Mode
written 180 minutes
Aids
No supporting materials will be allowed.
Digital
The exam takes place on devices provided by ETH Zurich.

Course Components

Type Title Time & Place Hours
lecture Data Management Systems
  • Wed 10:15-12:00 (CAB G 61)
  • Fri 08:15-09:00 (HG G 3)
3 h weekly
exercise Data Management Systems
  • Fri 09:15-10:00 (HG D 5.1)
  • Fri 09:15-10:00 (HG E 21)
  • Fri 09:15-10:00 (HG G 26.1)
1 h weekly
independent project Data Management Systems No time listed 3 h weekly

Offered In