Question: Below are two examples of concurrent transactions. Select the type of conflict, if any, executed by each transaction.Example 1 read all accounts compute sum of
Below are two examples of concurrent transactions. Select the type of conflict, if any, executed by each transaction.Example
read all accounts
compute sum of all accounts
read account A
increase account A
by $
write account A
commit
read each account
reduce each account by
of the sum
write each account
commit
Example
read account E
add $ to account E
write account E
commit
write account D
read account E
write account A
increase account E by
write account E
write account C
commit
Pick: Dirty read, No Conflict, Non repeatable read, phantom read
EX : T
T
EX : T
T
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
