Home › GATE CSE › computerscience › Database Management Systems › Thomas's Write Rule, applied to the case TS(T) <…
Thomas's Write Rule, applied to the case TS(T) < W-timestamp(Q), says to
Aabort T immediately
Bconvert T's write into a read of Q
Cpromote T's timestamp to W-timestamp(Q)
Dignore (skip) T's write but allow T to continue
Answer & Solution
Correct answer: D. ignore (skip) T's write but allow T to continue
Thomas's Write Rule: when TS(T) is older than W-timestamp(Q), some newer write has already happened. T's write would just be immediately overwritten, so the rule lets you SKIP it without aborting T. The resulting schedule is view-serializable even if not conflict-serializable. The other options are invented.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment