绗簲绔?/p>
鍒嗗竷寮忔暟鎹簱涓殑骞跺彂鎺у埗
姣旇緝鐨?/p>
DB2 ORACLE MSSQL SYBASE INFORMIX
骞跺彂鎺у埗鏈哄埗
鍦ㄥ叧绯绘暟鎹簱锛?/p>
DB2
锛?/p>
Oracle
锛?/p>
Sybase
锛?/p>
Informix
鍜?/p>
SQL
Server
锛夋渶灏忕殑鎭㈠鍜屼氦鏄撳崟
浣嶄负涓�涓簨鍔★紙
Transactions
锛?/p>
,
浜嬪姟鍏锋湁
ACID(
鍘熷瓙鎬э紝涓�鑷存�э紝闅旂鎬у拰姘镐箙鎬?/p>
)
鐗瑰緛銆?/p>
鍏崇郴鏁版嵁搴撲负浜嗙‘淇濆苟鍙戠敤鎴峰湪瀛樺彇鍚屼竴鏁版嵁搴撳璞℃椂鐨勬纭�?/p>
锛堝嵆鏃犱涪澶辨洿鏂般�?/p>
鍙噸澶嶈銆?/p>
涓嶈
"
鑴?/p>
"
鏁版嵁锛屾棤
"
骞诲儚
"
璇伙級锛屾暟鎹簱涓紩鍏ヤ簡骞跺彂锛堥攣锛夋満鍒躲�傚熀鏈殑閿佺被鍨嬫湁涓ょ锛氭帓
瀹冮攣锛?/p>
Exclusive locks
璁颁负
X
閿侊級鍜屽叡浜攣锛?/p>
Share locks
璁颁负
S
閿侊級銆?/p>
鎺掑畠閿侊細
鑻ヤ簨鍔?/p>
T
瀵规暟鎹?/p>
D
鍔?/p>
X
閿侊紝
鍒欏叾瀹冧换浣曚簨鍔￠兘涓嶈兘鍐嶅
D
鍔犱换浣曠被鍨嬬殑閿侊紝
鐩?/p>
鑷?/p>
T
閲婃斁
D
涓婄殑
X
閿侊紱
涓�鑸姹傚湪淇敼鏁版嵁鍓嶈鍚戣鏁版嵁鍔犳帓瀹冮攣锛?/p>
鎵�浠ユ帓瀹冮攣鍙堢О涓哄啓閿併�?/p>
鍏变韩閿侊細鑻ヤ簨鍔?/p>
T
瀵规暟鎹?/p>
D
鍔?/p>
S
閿侊紝
鍒欏叾瀹冧簨鍔″彧鑳藉
D
鍔?/p>
S
閿侊紝鑰屼笉鑳藉姞
X
閿侊紝鐩磋嚦
T
閲婃斁
D
涓婄殑
S
閿侊紱涓�鑸姹傚湪璇诲彇鏁版嵁鍓嶈鍚戣鏁版嵁鍔犲叡浜攣锛屾墍浠ュ叡浜攣鍙堢О涓鸿閿併�?/p>
DB2
鏁版嵁搴?/p>
IS
銆?/p>
IX
銆?/p>
SIX
鏂瑰紡鐢ㄤ簬琛ㄤ竴绾у苟闇�瑕佽閿侀厤鍚堬紝浠栦滑鍙互闃绘鍏朵粬搴旂敤绋嬪簭瀵硅琛ㄥ姞涓?/p>
鎺掑畠閿併�?/p>
濡傛灉涓�涓簲鐢ㄧ▼搴忚幏寰楁煇琛ㄧ殑
IS
閿侊紝璇ュ簲鐢ㄧ▼搴忓彲鑾峰緱鏌愪竴琛屼笂鐨?/p>
S
閿侊紝鐢ㄤ簬鍙鎿?/p>
浣滐紝鍚屾椂鍏朵粬搴旂敤绋嬪簭涔熷彲浠ヨ鍙栬琛岋紝鎴栨槸瀵硅〃涓殑鍏朵粬琛岃繘琛屾洿鏀广�?/p>
濡傛灉涓�涓簲鐢ㄧ▼搴忚幏寰楁煇琛ㄧ殑
IX
閿侊紝璇ュ簲鐢ㄧ▼搴忓彲鑾峰緱鏌愪竴琛屼笂鐨?/p>
X
閿侊紝鐢ㄤ簬鏇存敼鎿?/p>
浣滐紝鍚屾椂鍏朵粬搴旂敤绋嬪簭鍙互璇诲彇鎴栨洿鏀硅〃涓殑鍏朵粬琛屻�?/p>
濡傛灉涓�涓簲鐢ㄧ▼搴忚幏寰楁煇琛ㄧ殑
SIX
閿侊紝
璇ュ簲鐢ㄧ▼搴忓彲浠ヨ幏寰楁煇涓�琛屼笂鐨?/p>
X
閿侊紝
鐢ㄤ簬鏇存敼
鎿嶄綔锛屽悓鏃跺叾浠栧簲鐢ㄧ▼搴忓彧鑳藉琛ㄤ腑鍏朵粬琛岃繘琛屽彧璇绘搷浣溿�?/p>
S
銆?/p>
U
銆?/p>
X
鍜?/p>
Z
鏂瑰紡鐢ㄤ簬琛ㄤ竴绾э紝浣嗗苟涓嶉渶瑕佽閿侀厤鍚堬紝鏄瘮杈冧弗鏍肩殑琛ㄥ姞閿佺瓥鐣ャ�?/p>
濡傛灉涓�涓簲鐢ㄧ▼搴忓緱鍒版煇琛ㄧ殑
S
閿併�?/p>
璇ュ簲鐢ㄧ▼搴忓彲浠ヨ琛ㄤ腑鐨勪换浣曟暟鎹�?/p>
鍚屾椂瀹冨厑璁稿叾
浠栧簲鐢ㄧ▼搴忚幏寰楄琛ㄤ笂鐨勫彧璇昏姹傞攣銆傚鏋滄湁搴旂敤绋嬪簭闇�瑕佹洿鏀硅璇ヨ〃涓婄殑鏁版嵁锛屽繀椤荤瓑
S
閿佽閲婃斁銆?/p>
濡傛灉涓�涓簲鐢ㄧ▼搴忓緱鍒版煇琛ㄧ殑
U
閿侊紝
璇ュ簲鐢ㄧ▼搴忓彲浠ヨ琛ㄤ腑鐨勪换浣曟暟鎹紝
骞舵渶缁堝彲浠ラ�?/p>
杩囪幏寰楄〃涓婄殑
X
閿佹潵寰楀埌瀵硅〃涓换浣曟暟鎹殑淇敼鏉冦�傚叾浠栧簲鐢ㄧ▼搴忓彧鑳借鍙栬琛ㄤ腑鐨勬暟鎹�?/p>
U
閿佷笌
S
閿佺殑鍖哄埆涓昏鍦ㄤ簬鏇存敼鐨勬剰鍥句笂銆?/p>
U
閿佺殑璁捐涓昏鏄负浜嗛伩鍏嶄袱涓簲鐢ㄧ▼搴忓湪鎷ユ湁
S
閿佺殑鎯呭喌涓嬪悓鏃剁敵璇?/p>
X
閿佽�岄�犳垚姝婚攣鐨勩�?/p>
濡傛灉涓�涓簲鐢ㄧ▼搴忓緱鍒版煇琛ㄤ笂鐨?/p>
X
閿侊紝
璇ュ簲鐢ㄧ▼搴忓彲浠ヨ鎴栦慨鏀硅〃涓殑浠讳綍鏁版嵁銆?/p>
鍏朵粬
搴旂敤绋嬪簭涓嶈兘瀵硅琛ㄨ繘琛岃鎴栬�呮洿鏀规搷浣溿�?/p>
濡傛灉涓�涓簲鐢ㄧ▼搴忓緱鍒版煇琛ㄤ笂鐨?/p>
Z
閿侊紝
璇ュ簲鐢ㄧ▼搴忓彲浠ヨ鎴栦慨鏀硅〃涓殑浠讳綍鏁版嵁銆?/p>
鍏朵粬
搴旂敤绋嬪簭锛屽寘鎷湭鎻愪氦璇荤▼搴忛兘涓嶈兘瀵硅琛ㄨ繘琛岃鎴栬�呮洿鏀规搷浣溿�?/p>