F2023 #15 - Concurrency Control Theory (CMU Intro to Database Systems)

[@potapow8684]

Timestamps: 1:44 - Transaction Management 11:03 - Definitions 13:15 - Transactions in SQL 15:33 - ACID 21:16 - Atomicity 28:25 - Consistency 34:32 - Isolation of transactions 58:42 - Transaction Durability

[@_4_632]

Also at 50:00, why is T2-W(B) and R(B) a conflict? write-read conflict is txn reading data written by another txn that has *not committed* yet. but T1 reads B after T2 writes and then *commit*

[@WeiLi-s6i]

that's a good course

[@_4_632]

So at 47:54, since the definition of a lost update is when a transaction overwrites *uncommitted* data, does that mean T2 - W(B) and T1 - W(B) aren't a lost update because T1 - W(B) happens after T2 - W(B) is committed? Only T1 - W(A) and T2 - W(A) would be considered a lost update, right? Can someone confirm if I understood this correctly?

[@yodo-y3i]

Is this course any different from the one from 2018?

[@abdelaziz2788]

I think its the overall the same