Systems for data management and data science
CS-460
Media
- Lectures: Mondays from 14:15 to 16h
- Exercise sessions: Mondays from 16:15 to 18h
- Project office hours (upon prior request): Tuesdays from 11:15 to 12h GR A3 32
| Project | 40% |
|---|---|
| Exam | 60% |
- Yi Jiang (yi.jiang@epfl.ch)
- Hamish Nicholson (hamish.nicholson@epfl.ch)
- Akash Dhasade (akash.dhasade@epfl.ch)
- Diana Petrescu (diana.petrescu@epfl.ch)
- Rishi Sharma (rishi.sharma@epfl.ch)
- Mathis Randl (mathis.randl@epfl.ch)
- Milos Vujasinovic (milos.vujasinovic@epfl.ch)
- Jakob Gerhardt (jakob.gerhardt@epfl.ch)
- Alexander Procelewski (alexander.procelewski@epfl.ch)
- Elif Kurtay (elif.kurtay@epfl.ch)
- Martijn de Vos (martijn.devos@epfl.ch)
cs460-2025@groupes.epfl.ch
- Announcements (Forum)
- [DEADLINE March 3] Project registration (Questionnaire)
- ed discussion forum (URL)
17.02 (Week 1) Introduction, logistics and storage hierarchy
- Lecture (Text and media area)
- Week 1 - Lecture slides (File)
- Lecture video recording - Storage hierarchy 2023 (URL)
- Readings: Chapters from either texbook: R. Ramakri... (Text and media area)
- Exercises (Text and media area)
- Week 1 - Exercises (File)
- Week 1 - Exercise Solutions (File)
Project 1 - Query Processing and Optimization
- Important dates Register for a repo by 3.03 Detail... (Text and media area)
- Project presentation (File)
- Project 1 description (DEADLINE 17/04) (File)
24.02 (Week 2) Query execution
- Lecture (Text and media area)
- Week 2 - Lecture slides: Query Execution (File)
- Week 2 - Query Execution pdf (File)
- Week 2 - Video recording (URL)
- Readings: Chapters from either texbook: R. Ramakri... (Text and media area)
- Exercises (Text and media area)
- Week 2 - Exercises (File)
- Scala lightning tour (File)
- Week 2 solutions (File)
03.03 (Week 3) Query optimization
- Lecture (Text and media area)
- Week 3 - Query Optimization (File)
- Week 3 - Query Optimization pdf (File)
- Week 3 - Video recording (URL)
- Readings: Chapters from either texbook: R. Ramakri... (Text and media area)
- Exercises: (Text and media area)
- Week 3 - Exercises (File)
- Week 3 - Exercise Solutions (File)
10.03 (Week 4) Transactions
- Week 4 - Lecture slides: Concurrency control (File)
- Week 4 - Concurrency Control pdf (File)
- Lecture 4 – video recording (URL)
- Readings: Chapters from either texbook: R. Ramakri... (Text and media area)
- Exercises (Text and media area)
- Week 4 - Exercises (File)
- Week 4 - Exercise Solutions (File)
17.03 (Week 5) Intro to distributed execution and distributed transactions
- Week 5 - Lecture slides: Intro to distributed execution and distributed transactions (File)
- Week 5 - Lecture slides: Intro to distributed execution and distributed transactions pdf (File)
- Week 5 – Video recording (URL)
- Exercises (Text and media area)
- Week 5 - Exercises (File)
- Week 5 - Exercise solutions (File)
24.03 (Week 6) Distributed query execution, MapReduce, and dataflow
- Week 6 - Lecture slides (File)
- Lecture video recording (2023) (URL)
- Readings:MapReduce: Simplified Data Processing on ... (Text and media area)
- Exercises (copy) (copy) (copy) (Text and media area)
- Week 6 - Lecture slides (File)
- Week 6 - Lecture slides, pdf (File)
- Week 6 - Exercises (File)
- Week 6 - Exercise solutions (File)
- Week 6 - Exercise solutions slides (File)
31.03 (Week 7) Mid term
07.04 (Week 8) Gossip protocols
- Week 8 - Lecture slides: Gossip (File)
- Week 8 - Video recording (URL)
- Week 8 - Exercises (File)
- Week 8 - Exercise Solutions (File)
- Further readings:Peer-to-Peer Membership Managemen... (Text and media area)
14.04 (Week 9) DHT + Consistency models
- Week 8 - Lecture slides: DHT + Consistency models (File)
- Lecture 8 – video recording (URL)
- Further readings:Pastry: Scalable, distributed obj... (Text and media area)
- Week 9 - Exercises (File)
- Week 9 - Exercise Solutions (File)
21.04 Easter holiday: no lecture or exercises
28.04 (Week 10) Key-value stores, CAP theorem
- Week 10 - Lecture slides: KV stores, CAP theorem (File)
- Lecture 9 - video recording (URL)
- Week 10 - Exercises (File)
- Week 10 - Exercise Solutions (File)
Project 2 - Recommendation Serving
- Important dates Detailed project instructions and ... (Text and media area)
- Project 2 description (DEADLINE 30/05) (File)
- Project medium dataset (put files in src/main/resources) (File)
05.05 (Week 11) Scheduling
- Week 11 - Lecture slides: Scheduling (File)
- Week 11 - Exercises (File)
- Week 11 - Exercise Solutions (File)
- Week 11 – Video recording (URL)
12.05 (Week 12) Stream processing
- Lecture slides: Stream processing (File)
- Video recording (URL)
- Week 12 - Exercises (File)
- Week 12 - Exercise solutions (File)
- Week 12 - Exercise solutions slides (File)
19.05 (Week 13) Distributed learning systems
- Week 13 - Lecture slides - Part1: Distributed Learning (File)
- Week-13 - Lecture Slides - Part2: Decentralized Learning (File)
- Week 13 - Exercises (File)
- Week 13 – Video recording URL (URL)
- Week 13 - Exercise solutions (File)
26.05 (Week 14) Guest lecture (not part of the final exam)
17.06 Final exam
June 17, from 9:15 to 12:15 (for non-special arrangements).
Closed book exam. The questions will be related to the content of all topics covered, except for the final (guest) lecture by Oracle.
The final term will be on-site, on Moodle.
Personal Belongings: Please place all personal belongings (e.g., backpacks, jackets, and any internet-capable devices), at the designated area at the front of the room.
Bring your laptop, fully charged (and the charger, power cord, extension cord etc.). If you do not have a laptop or cannot use it, please let us know until Friday, 13.06.2025.
Bring your Camipro card and an official ID card: We will check the identities of the students taking the exam. Anyone not present in one of the designated rooms will be considered absent, even if they happen to submit the responses. In other words, you cannot take the exam from home or anywhere else than your designated room at EPFL.
Any sort of communication or using any device (e.g., smartphones, headphones/earphones, smart watches) other than your computer or a calculator is strictly prohibited. Please do not minimize the window. Opening any software other than a web browser (including the Spotlight search on MacOS) or a web page other than the final exam on EPFL Moodle (e.g., course slides, search engines, ChatGPT and other LLMs) is strictly prohibited. A physical calculator is permitted for the purpose of the exam. The usage of the calculator app on the laptop is not allowed. We obviously trust your integrity. Nevertheless, any form of cheating will be reported and can entail severe consequences.
One A4 page cheat sheet is allowed (no constraints: single- or double-sided, printed or handwritten). Two one-sided pages are NOT "One A4 page", therefore not allowed.
You will be given one A4 blank sheet to use as scrap paper (possibly more on demand). You are not allowed to use your own scrap paper.
Desk Arrangement: On your desk, you are allowed only the essentials: a pen/pencil, your laptop (along with a charger/extension cord, if necessary), your Camipro card and official ID, your cheatsheet, the provided scrap paper, and a bottle of water or another beverage.
The Moodle Quiz has ungraded explanation text boxes. Please use these boxes only to state assumptions that are not part of the question or any further explanation. Any answers in these boxes will not be considered. The content in these boxes will only be referred to in case of discrepancies. These are NOT mandatory.
There will be NO CLARIFICATIONS during the exam. The questions and their contexts should be sufficient to attempt them. If you think there is something missing or wrong, make "reasonable" assumptions and justify them in the explanation box.
You can attempt the quiz multiple times but only the last attempt of each student will be graded.
DO NOT copy/paste in text boxes. Moodle has issues with encoding, which may crash the quiz attempt. You should input/write in the designated box directly, only.
At the end of the quiz, you will have a grace period to submit your attempt.
It is mandatory to "Submit all and Finish" at the end. Submissions that are not submitted will NOT be graded.
Once you are done, before you leave, you need to wait for Teaching Assistants to record your departure in the presence sheet. Attempts after departure are prohibited.
You are not allowed to leave in the first and last 30 minutes of the exam.
Consequences for Non-Compliance: Adhering to these rules is crucial. These measures are in place to protect the integrity of our examination process and ensure fairness for all students.
Room assignment:
CE 1 1 - SCIPER < 329000.
CE 1 2 - SCIPER between 329000 and 370000, inclusive.
CE 1 515 - SCIPER > 370000.
BC 129 (special arrangements) In case you are assigned to this room, you will have received an e-mail.