mailing list For webmasters
Welcome Guest
would Options
Tara2
Posted: Thursday, January 21, 2021 4:29:59 AM

Rank: Advanced Member

Joined: 11/8/2017
Posts: 3,446
Neurons: 12,601
Is the use of 'would' here strange for you?



both methods may result in transaction rollback. Prevention is commonly used if the probability that the system would enter a deadlock state is relatively high; otherwise, detection and recovery are more efficient.

Database System Concepts, Silberschatz
thar
Posted: Thursday, January 21, 2021 4:41:33 AM

Rank: Advanced Member

Joined: 7/8/2010
Posts: 23,708
Neurons: 96,171
The chance is high that the system will enter a deadlock state.

But you do something to prevent this happening.

The chance is high that the system would enter a deadlock state if you ran that process.

If that condition is true, that is when you use prevention, so it doesn't happen.

Tara2
Posted: Thursday, January 21, 2021 8:12:18 AM

Rank: Advanced Member

Joined: 11/8/2017
Posts: 3,446
Neurons: 12,601
thar wrote:
The chance is high that the system will enter a deadlock state.

But you do something to prevent this happening.

The chance is high that the system would enter a deadlock state if you ran that process.

If that condition is true, that is when you use prevention, so it doesn't happen.


Many thanks for the great explanation!!!
Tara2
Posted: Wednesday, January 27, 2021 6:25:48 AM

Rank: Advanced Member

Joined: 11/8/2017
Posts: 3,446
Neurons: 12,601
thar wrote:
The chance is high that the system will enter a deadlock state.

But you do something to prevent this happening.

The chance is high that the system would enter a deadlock state if you ran that process.

If that condition is true, that is when you use prevention, so it doesn't happen.


Sorry thar
I think here is exactly the same and the if clause isn't for 'would' . For 'would' should there be an implied if like 'if we didn't do something to prevent this', right, please?



If concurrency control is performed at the tuple granularity, this conflict would go undetected. As a result, the system could fail to prevent a nonserializable schedule.
Database System Concepts, Silberchatz
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.