'2pl' presentation slideshows

Chapter 4: Concurrency Control Algorithms

533 views • 51 slides

Carnegie Mellon Univ. Dept. of Computer Science 15-415 - Database Applications

Carnegie Mellon Univ. Dept. of Computer Science 15-415 - Database Applications. C. Faloutsos Concurrency control - deadlocks. General Overview. Relational model - SQL Functional Dependencies & Normalization Physical Design &Indexing Query optimization Transaction processing

231 views • 23 slides

Inconsistent retrieval (is locking enough CC? NO!)

T1 (transfer). T2 (audit). = 1200. Inconsistent retrieval (is locking enough CC? NO!). @@@ ________ __/BANK) @ - - @ |ACCOUNTS| _____ < $> | @` - ' |--------| |AUDIT| >___' | ____ |CHECKING| |Ch__ | .|

147 views • 5 slides