Chapter 17, Problem 5PE

Explanation of Solution

Conflict serializable schedule:

• A schedule is said to be serializable when it can be transformed to a serial schedule by swapping non-conflicting operations.
• Two operations are said to be conflicting if all they satisfies the conditions,
  • They belong to different transactions.
  • They operates on the same data item.

View Serializable schedule:

• The view serializability is the process of checking that the given schedule is view serializable or not.
• To check whether a given schedule is view serializable, we need to check whether the given schedule is View Equivalent to its serial schedule.
• The need of the view serializability is that non-serial schedule can leave the database in inconsistent state...