July 2023 0 27 Report
Selesaikan masalah dibawah ini dengan metode Locking pada concurrency control untuk permasalahan Inconsistent Analysis (Analisa yang tidak konsisten) Diketahui T1, T2: Transaksi 1, Transaksi 2 t a b с : waktu : 250 (nilai awal a) : 100 (nilai awal b) :50 (nilai awal c) sum : sum awal = 0 Transaksi yang terjadi: [Bobot: 25] tl 12 Tl begin transaction T1 sum 0 13T1 write lock(a) 14T1 read(a) t5 → T2 Begin transaction, Tl a=a+15 t6T2 read lock(a), T1 write(a) 17T1 write lock(b) t8T1 read(b) 19TI b-b+10 110 T1 write(b) t11 T1 sum-sum + b t12 TI unlock(a,b) t13 →T2 read(a), t14 →T2 a=a+15 t15 T2 write(a) t16T2 sum-sum+a t17T2 Write_lock(c) t18 T2 read (c) t19 →T2 c-c+50 t20 ➜T2 write(c) 121 122 t23 T1 write lock (c) ,T2 sum-sum+c T2 unlok(a.c) T1 read (c), T2 commit 124T1 c = c +100 125T1write (c) T26T1 unlock (c) t27T1 commit​

Life Enjoy

" Life is not a problem to be solved but a reality to be experienced! "

Get in touch

Social

© Copyright 2013 - 2024 KUDO.TIPS - All rights reserved.