Final exam: Thursday May 2. In-person in our usual room
(Life Science Building 412) from 1:00 to 3:00. Online, you will have 2
hours during the window 1:00-6:00.
Monday
Postgres internal tables: pld.cs.luc.edu/database/sql3.html#pg_cat
Recursive CTEs: pld.cs.luc.edu/database/sql3.html#recursive
conndemo:
MAXPART=50, so there's lots of contention
conndemo1.py: update the quantity in the part table on
each transaction. Lots of contention for part records
conndemo3.py: put the quantity updates into partupdate.
There is zero contention.
NUMTHREADS = 4 versus 1. MAXPART = 50 versus 500
Wednesday
500 vs 50 parts
Conndemo1 vs Conndemo3
Stronger isolation levels
Friday
NoSQL
CAP