Queries and processing, optimizer, cost models, execution plans, rewriting rules, access methods, spatial indexing; transactions, ACID properties, concurrency control, serializability, two-phase locking, timestamping, logging,checkpointing, transaction abort and commit, crash recovery; distributed databases.

Prerequisites: Computer Science 130B.

4

Units

Letter

Grading

1, 2, 3

Passtime

None

Level Limit

Engineering

College
These majors only cmpsc
Jianwen Su
2.0
30 reviews
PHELP1445
T
09:00 AM - 09:50 AM
33 / 33 Full

ILP 3316
T
16:00 PM - 16:50 PM
30 / 30 Full

PHELP2514
T
11:00 AM - 11:50 AM
34 / 34 Full

Spring 2025 . Agrawal D
LSB 1001
M W
09:30 AM - 10:45 AM
See All
CMPSC 174B Su J Spring 2024 Total: 78
CMPSC 174B Su J Spring 2020 Total: 25
See All
30
2.0
CMPSC174A . 1 Year, 5 Months Ago

Pretty good class overall. There are only 5 homework assignments and you have at least a week to do each one. Textbook + lectures explain everything you need for assignments. Exams are as easy or easier than homework. Partner project at the end of the quarter, start early if you can because it does take time. Piazza will be your best friend

0 helpful 0 unhelpful
CMPSC174A . 1 Year, 5 Months Ago

I was worried about this class based on Prof. Su's rating here on RMP but I don't know why it's so low. His class isn't the most organized or clear but him and the TAs like Momin Haider were very responsive and accessible outside of class. The exams are straightforward and so were the assignments. Decent class overall.

0 helpful 0 unhelpful
CMPSC174A . 2 Years Ago

I was worried about taking this class, but I'm happy to say it's improved a lot since the last time it was taught. Homeworks were kind of difficult but they're only worth 2% each. Late days are generous. Exams were straightforward and a lot easier than the homework. Project was not too bad, but make sure to start early on it as it is a bit tedious.

0 helpful 0 unhelpful
CS174A . 5 Years Ago

DO NOT TAKE! 2/5 of the material is relevant, the rest is unnecessarily complicated and not important to understanding SQL databases. HWs are difficult and each only account for 2% of your grade. Exams are not graded fairly. Project is incredibly unclear, very time consuming, and graded VERY unfairly. Lectures are boring and unnecessary.

0 helpful 0 unhelpful
CS174A . 5 Years Ago

Literally no one goes to class because his lectures are so useless. The project was so vague and took weeks to complete and I ended up having 3000 lines of code that looked exactly the same. The project was due the last day of dead week so good luck studying for anything else since it takes forever. The TAs are the ones carrying this class.

0 helpful 0 unhelpful
CMPSC174A . 5 Years Ago

1. Lectures are useless, he goes off on random tangents about his research and you learn nothing. 2. HWs take 3/4 weeks to be graded, so there is no learning feedback at all 3. Midterm solutions and hw solutions are posted the day before the final?! Crazy. 4. HUGE, redudant, busy-work project with terrible instructions. 5. A lot of hw. 6. Terrible

0 helpful 0 unhelpful
See all 30 reviews
CMPSC 160
131 / 135 Enrolled
Translation of Programming Languages
Ben Hardekopf 4.7
T R
15:30 PM - 16:45 PM
52.5% A
CMPSC 165A
100 / 100 Full
Artificial Intelligence
Xifeng Yan 3.6
T R
12:30 PM - 13:45 PM
54.5% A
CMPSC 165B
66 / 100 Enrolled
Machine Learning
Wang Y F
T R
09:30 AM - 10:45 AM
59.7% A
CMPSC 170
101 / 100 Full
Operating Systems
Tao Yang 3.0
T R
12:30 PM - 13:45 PM
39.8% A
CMPSC 176C
40 / 100 Enrolled
Advanced Topics in Internet Computing
Arpit Gupta 2.4
M W
17:00 PM - 18:15 PM
61.3% A
CMPSC 177
100 / 100 Full
Computer Security
Chris Kruegel 4.7
M W
12:30 PM - 13:45 PM
43.2% A