Revision as of 07:20, 28 December 2023 edit Jarfuls of Tweed (talk \| contribs) Extended confirmed users 798 edits Added categories Tag: 2017 wikitext editor ← Previous edit		Revision as of 12:55, 2 January 2024 edit undo Dkmoon2 (talk \| contribs) 1 edit m Fixed an incorrect schedule reference in the table. (Table named J while the text called it G) Next edit →
Line 457: These schedules are recoverable. The schedule F is recoverable because T1 commits before T2, that makes the value read by T2 correct. Then T2 can commit itself. In the F2 schedule, if T1 aborted, T2 has to abort because the value of A it read is incorrect. In both cases, the database is left in a consistent state. Transaction GJ is unrecoverable because T2 committed before T1 despite previously reading the value written by T1. Because T1 aborted after T2 committed, the value read by T2 is wrong. Because a transaction cannot be rolled-back after it commits, the schedule is unrecoverable. ====Cascadeless====

Database transaction schedule: Difference between revisions