CS145 Logo

CS 145

Fall 2025 • Intro to Big Data Systems

Fall 2025 Schedule

Weeks 1 to 10 • Tue and Thu • Nov 4 holiday • Test 1 on Thu Oct 30

SQL Systems nanoDB Transactions Distributed Systems

Attendance Requirements (for non-SCPD students)

  • Tests: Mandatory in-class attendance for Test 1 (Oct 30) and Test 2 (Final). No alternate exam schedules for those with exam conflicts. Please ensure you have no exam conflicts before enrolling in CS 145.
  • OAE accommodations: Tests will be on the same day with extended hours
  • Guest Speakers: Must attend at least 3 out of 4 guest lectures (marked with purple pills)
Week Dates Topics Deliverables
1 Sep 23
Sep 25		 SQL Section 1: SQL Basics
Kickoff. SQLite and BigQuery intro. Mission briefing: gear up with SQL. 		Setup: Canvas • Gradescope • Ed
Setup: BigQuery • Get Credits • Colab
2 Sep 30
Oct 2		 SQL Section 1: SQL Basics continued
CTEs, subqueries, window functions. Debugging Text to SQL. 		Oct 1 • PSET0
Oct 3 • PSET1 (Section 1)
3 Oct 7
Oct 9		 Systems Section 2: Systems Primer
nanoDB Section 3: nanoDb
BigSort. Hash partition. Foundations for nanoDB. 		Oct 8 • PSET2 (Section 1)
4 Oct 14
Oct 16		 nanoDB Section 3: nanoDB
Indexes. Joins. Query planning. 		Oct 12 • PSET3 (Section 2)
Oct 15 • Project 1
5 Oct 21
Oct 23		 nanoDb Section 5: Scaling Analytics
Part 1: Data designs, Parallelism. Distributed systems. 		Oct 21: Dr. Steven Whang
Data-centric AI and Database Design: Knowing Your Data
Oct 23: Guest speaker
Fast Analytics • Biswa Chattopadhyay (Google)
Oct 24 • PSET4 (Section 3)
6 Oct 28
Oct 30		 TestTest 1
In class on Thu Oct 30 		Oct 30 • Test 1
7 Nov 4 (No class)
Nov 6 (Thu only)		 Transactions Section 4: Transactions
ACID properties. Ticketing case study.
8 Nov 11
Nov 13		 Transactions Section 4: Transactions continued
Concurrency control, 2PL, LSM Trees. Recovery.
9 Nov 18
Nov 20		 Distributed Systems Section 5: Distributed Systems
Sharding. Replication. Global consistency. Guest Spanner talk. 		Nov 20: Guest speaker
Spanner • Sebastian Kanthak (Google)
Nov 21: Project 2 (Data Science)
Nov 21: Project 2 (Data Systems)
10 Nov 25 (No class)
Nov 27 (No class)		 - Nov 25: Thanksgiving no class
Nov 27: Thanksgiving no class
11 Dec 2
Dec 4		 Lessons from industry
Dec 1 • PSET5 (Section 4, 5)
Dropped Assignment: Dec 2• Project2a (for students taking 4 units)
Dec 2: Guest speaker
Data Security • Neil Daswani
Dec 4: Guest speaker
Finals Dec 8 TestTest 2 (Finals)
In class • 7-10 pm 		Dec 8 • Test 2 (Finals) • 7-10 pm