Database transaction schedule: Difference between revisions

Revision as of 09:41, 29 November 2023

Revision as of 09:58, 29 November 2023

Line 319:

====View-serializable====

A schedule is said to be '''view-serializable''' if it is view-equivalent to some serial schedule. Note that by definition, all conflict-serializable schedules are view-serializable.

{| class="wikitable"

|+G

Line 419:

====Unrecoverable====

A schedule becomes '''unrecoverable''' if a transaction <math>T_i</math> reads changes from another transaction <math>T_j</math>, and then <math>T_i</math> commits and <math>T_j</math> aborts.

If a transaction T1 aborts, and a transaction T2 commits, but T2 relied on T1, we have an unrecoverable schedule.

{| class="wikitable"