TransactionalInformation Systems まとめ 第四章 (3)

    ②Lock mode compatibility

ロックの分類をテーブルで定義したもの。「現在のロック状態」と「実行するオペレーション」に応じて、どの種類のロックを取得するかを
   定めるもの。

    ・ベーシックなもの

 

 

Lock requested

rli (x)

wli (x)

Lock  held

rl j (x)

+

wl j (x)

 

 

    ・Selective use of ordered sharing in lock tables.

  order sharingで使用するlock tablesharingを許容する度合いに応じて対象を選択する。

 

LT1

Lock requested

rli (x)

wli (x)

Lock  held

rl j (x)

+

wl j (x)

 

 

LT2

Lock requested

rli (x)

wli (x)

Lock  held

rl j (x)

+

wl j (x)

LT3

Lock requested

rli (x)

wli (x)

Lock  held

rl j (x)

+

wl j (x)

LT4

Lock requested

rli (x)

wli (x)

Lock  held

rl j (x)

+

wl j (x)

 

LT5

Lock requested

rli (x)

wli (x)

Lock  held

rl j (x)

+

wl j (x)

LT6

Lock requested

rli (x)

wli (x)

Lock  held

rl j (x)

+

wl j (x)

LT7

Lock requested

rli (x)

wli (x)

Lock  held

rl j (x)

+

wl j (x)

 

LT8

Lock requested

rli (x)

wli (x)

Lock  held

rl j (x)

+

wl j (x)