Why the transactions schedule below is violating two- phase policy? Database Concurrency Control Two-Phase Locking Techn

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Why the transactions schedule below is violating two- phase policy? Database Concurrency Control Two-Phase Locking Techn

Post by answerhappygod »

Why The Transactions Schedule Below Is Violating Two Phase Policy Database Concurrency Control Two Phase Locking Techn 1
Why The Transactions Schedule Below Is Violating Two Phase Policy Database Concurrency Control Two Phase Locking Techn 1 (22.77 KiB) Viewed 56 times
Why the transactions schedule below is violating two- phase policy? Database Concurrency Control Two-Phase Locking Techniques: The algorithm T1 T2 Result read lock (Y): X=50; Y=50 read item (Y); Nonserializable because it. unlock (Y); violated two-phase policy read_lock (X); read item (X); Time unlock (X): write_lock (Y); read item (9) Y:=X+Y; write_item (Y); unlock (Y): write_lock (x): read item (X): X=X+Y: write_item (X); unlock (x);
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply