DBMS Notes

Conflicting and Non-Conflicting Operation

Two operations (Read and Write)  are consider as conflicting operations, if they hold the following conditions.

  • Both the operations are on the same data.
  • Both the operations (Read and Write) belong to different transactions.
  • At least one of the two operations is a write operation.

Two operations (Read and Write)  are consider as Non-Conflicting Operations,  if they hold the following conditions.

  • Both the operations are on different data item.
  • Both the operations belong to different transactions.

Note: Both READ operation of same or different data is also a non-conflict pair

Look at Descriptive diagram as following,

Help Other’s By Sharing…

Contact Us

Burewala, Vehari, Punjab, Pakistan

cstaleem1@gmail.com

Website: CStaleem.com

Pin It on Pinterest