Skip to content

Commit a90b32d

Browse files
committed
ADD Transaction.md
1 parent 7df9e3f commit a90b32d

5 files changed

Lines changed: 58 additions & 4 deletions

File tree

โ€Ž_data/pageMap.ymlโ€Ž

Lines changed: 11 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -125,7 +125,7 @@ DBMS:
125125
parent: index
126126
url: /wiki/DBMS
127127
updated: '2018-12-06 18:54:36 +0900'
128-
children: [Hbase, MS-SQL]
128+
children: [Hbase, MS-SQL, Transaction]
129129
DevOps:
130130
type: wiki
131131
title: DevOps
@@ -212,7 +212,7 @@ index:
212212
summary: 'anyjava wiki index'
213213
parent: null
214214
url: /wiki/index
215-
updated: '2020-09-07 10:46:08 +0900'
215+
updated: '2020-10-06 02:03:47 +0900'
216216
children: []
217217
Infra:
218218
type: wiki
@@ -356,7 +356,7 @@ MSA:
356356
summary: 'Microservice Architecture'
357357
parent: index
358358
url: /wiki/MSA
359-
updated: '2019-10-29 18:40:41 +0900'
359+
updated: '2020-09-15 03:04:13 +0900'
360360
children: []
361361
NoSQL:
362362
type: wiki
@@ -494,6 +494,14 @@ Test_Framework:
494494
url: /wiki/Test_Framework
495495
updated: '2018-11-28 08:25:51 +0900'
496496
children: [spock]
497+
Transaction:
498+
type: wiki
499+
title: ํŠธ๋žœ์žญ์…˜
500+
summary: ํŠธ๋žœ์žญ์…˜
501+
parent: DBMS
502+
url: /wiki/Transaction
503+
updated: '2020-10-06 02:07:35 +0900'
504+
children: []
497505
Web:
498506
type: wiki
499507
title: Web

โ€Ž_data/tagList.ymlโ€Ž

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -81,6 +81,7 @@
8181
- thread
8282
- tip
8383
- tools
84+
- transaction
8485
- validation
8586
- webflux
8687
- xss

โ€Ž_data/tagMap.ymlโ€Ž

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -121,6 +121,7 @@ logstash:
121121
- {fileName: logstash}
122122
'db,':
123123
- {fileName: MS-SQL}
124+
- {fileName: Transaction}
124125
'ms-sql,':
125126
- {fileName: MS-SQL}
126127
dbms:
@@ -182,6 +183,8 @@ synology:
182183
- {fileName: Test_Framework}
183184
junit:
184185
- {fileName: Test_Framework}
186+
transaction:
187+
- {fileName: Transaction}
185188
webflux:
186189
- {fileName: WebFlux}
187190
'secure,':

โ€Ž_wiki/Transaction.mdโ€Ž

Lines changed: 41 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,41 @@
1+
---
2+
layout : wiki
3+
title : ํŠธ๋žœ์žญ์…˜
4+
summary : ํŠธ๋žœ์žญ์…˜
5+
date : 2020-10-06 02:04:00 +0900
6+
updated : 2020-10-06 02:22:36 +0900
7+
tags : db, transaction
8+
toc : true
9+
public : true
10+
parent : DBMS
11+
latex : false
12+
adsense : true
13+
---
14+
* TOC
15+
{:toc}
16+
17+
## ์ฃผ์š”๊ฐœ๋…
18+
19+
20+
> ์•„๋ž˜ ๋‚ด์šฉ๋“ค์€ '๋ฐ์ดํ„ฐ ์ค‘์‹ฌ ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ์„ค๊ณ„ 07์žฅ ํŠธ๋žœ์žญ์…˜'์„ ์ฐธ๊ณ ํ•˜์˜€์Šต๋‹ˆ๋‹ค.
21+
22+
23+
* [Dirty Reads](https://en.wikipedia.org/wiki/Isolation_(database_systems)#Dirty_reads)
24+
* ํ•œ ํด๋ผ์ด์–ธํŠธ๊ฐ€ ๋‹ค๋ฅธ ํด๋ผ์ด์–ธํŠธ๊ฐ€ ์ผ์ง€๋งŒ ์•„์ง ์ปค๋ฐ‹๋˜์ง€ ์•Š์€ ๋ฐ์ดํ„ฐ๋ฅผ ์ฝ๋Š”๋‹ค. ์ปค๋ฐ‹ ํ›„ ์ฝ๊ธฐ ๋˜๋Š” ๊ทธ๋ณด๋‹ค ๊ฐ•ํ•œ ๊ฒฉ๋ฆฌ ์ˆ˜์ค€์€ ๋”ํ‹ฐ ์ฝ๊ธฐ๋ฅผ ๋ฐฉ์ง€ํ•œ๋‹ค.
25+
26+
* [Dirty Write](https://en.wikipedia.org/wiki/Write%E2%80%93read_conflict)
27+
* ํ•œ ํด๋ผ์ด์–ธํŠธ๊ฐ€ ๋‹ค๋ฅธ ํด๋ผ์ด์–ธํŠธ๊ฐ€ ์ป์ง€๋งŒ ์•„์ง ์ปค๋ฐ‹๋˜์ง€ ์•Š์€ ๋ฐ์ดํ„ฐ๋ฅผ ๋ฎ์–ด์“ด๋‹ค. ๊ฑฐ์˜ ๋ชจ๋“  ํŠธ๋žœ์žญ์…˜ ๊ตฌํ˜„์€ ๋”ํ‹ฐ ์“ฐ๊ธฐ๋ฅผ ๋ฐฉ์ง€ํ•œ๋‹ค.
28+
29+
* ์ฝ๊ธฐ ์Šคํ (๋น„๋ฐ˜๋ณต ์ฝ๊ธฐ)
30+
* ํด๋ผ์ด์–ธํŠธ๋Š” ๋‹ค๋ฅธ ์‹œ์ ์— ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์˜ ๋‹ค๋ฅธ ๋ถ€๋ถ„์„ ๋ณธ๋‹ค. ์ด ๋ฌธ์ œ๋ฅผ ๋ง‰๊ธฐ ์œ„ํ•œ ํ•ด๊ฒฐ์ฑ…์œผ๋กœ ํŠธ๋žœ์žญ์…˜์ด ์–ด๋А ์‹œ์ ์˜ ์ผ๊ด€๋œ ์Šค๋ƒ…์ˆ์œผ๋กœ๋ถ€ํ„ฐ ์ฝ๋Š” ์Šค๋ƒ…์ˆ ๊ฒฉ๋ฆฌ๋ฅผ ๊ฐ€์žฅ ํ”ํžˆ ์‚ฌ์šฉํ•œ๋‹ค. (REPEATABLE READ) ์Šค๋ƒ…์ˆ ๊ฒฉ๋ฆฌ๋Š” ๋ณดํ†ต ๋‹ค์ค‘ ๋ฒ„์ „ ๋™์‹œ์„ฑ ์ œ์–ด(MVCC) ๋ฅผ ์จ์„œ ๊ตฌํ˜„ ํ•œ๋‹ค.
31+
32+
* ๊ฐฑ์‹  ์†์‹ค
33+
* ๋‘ ํด๋ผ์ด์–ธํŠธ๊ฐ€ ๋™์‹œ์— read-modify-write ์ฃผ๊ธฐ๋ฅผ ์‹คํ–‰ํ•œ๋‹ค. ์„œ๋กœ ๋‹ค๋ฅธ ํŠธ๋žœ์žญ์…˜์ด ์ˆ˜์ •๋‚ด์šฉ์„ ํ›„ํ–‰ํ•˜๋Š” ๋ฒ„์ ผ์ด ๋ฎ์œผ์“ฐ๋Š” ๊ฒฝ์šฐ. ์Šค๋ƒ…์ˆ ๊ฒฉ๋ฆฌ ๊ตฌํ˜„ ์ค‘ ์–ด๋–ค ๊ฒƒ์€ ์ด๋Ÿฐ ์ด์ƒ ํ˜„์ƒ์„ ์ž๋™์œผ๋กœ ๋ง‰์•„์ฃผ์ง€๋งŒ ๊ทธ๋ ‡์ง€ ์•Š์€ ๊ฒƒ์€ ์ˆ˜๋™ ์ž ๊ธˆ(SELECT FOR UPDATE)์ด ํ•„์š”ํ•˜๋‹ค.
34+
35+
* ์“ฐ๊ธฐ ์Šคํ
36+
* ํŠธ๋žœ์žญ์…˜์ด ๋ฌด์—‡์ธ๊ฐ€๋ฅผ ์ฝ๊ณ  ์ฝ์€ ๊ฐ’์„ ๊ธฐ๋ฐ˜์œผ๋กœ ์–ด๋–ค ๊ฒฐ์ •์„ ํ•˜๊ณ  ๊ทธ ๊ฒฐ์ •์„ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์“ด๋‹ค. ๊ทธ๋Ÿฌ๋‚˜ ์“ฐ๊ธฐ๋ฅผ ์‹คํ–‰ํ•˜๋Š” ์‹œ์ ์—๋Š” ๊ฒฐ์˜ ์ „์ œ๊ฐ€ ๋” ์ด์ƒ ์ฐธ์ด ์•„๋‹ˆ๋‹ค. ์ง๋ ฌ์„ฑ ๊ฒฉ๋ฆฌ๋งŒ ์ด๋Ÿฐ ์ด์ƒ ํ˜„์ƒ์„ ๋ง‰์„ ์ˆ˜ ์žˆ๋‹ค.
37+
* ๋ณดํ†ต INSERT ํ• ๋•Œ ๋ฐœ์ƒํ•˜๋Š”๋ฐ, Table ์˜ UNIQUE INDEX ์„ ํ•ด๊ฒฐํ•˜๊ฑฐ๋‚˜ id ๊ธฐ๋ฐ˜์˜ ์ง๋ ฌ์„ฑ ๊ฒฉ๋ฆฌ, ํ˜น์˜ ๋ฒ”์œ„๊ธฐ๋ฐ˜์˜ ์„œ์ˆ  ์ž ๊ธˆ(predicate lock)์ด ํ•„์š”ํ•จ.
38+
39+
40+
* [ํŒฌํ…€ ์ฝ๊ธฐ(Phantom Reads)](https://en.wikipedia.org/wiki/Isolation_(database_systems)#Phantom_reads)
41+
* ํŠธ๋žœ์žญ์…˜์ด ์–ด๋–ค ๊ฒ€์ƒ‰ ์กฐ๊ฑด์— ๋ถ€ํ•ฉํ•˜๋Š” ๊ฐ์ฒด๋ฅผ ์ฝ๋Š”๋‹ค. ๋‹ค๋ฅธ ํด๋ผ์ด์–ธํŠธ๊ฐ€ ๊ทธ ๊ฒ€์ƒ‰ ๊ฒฐ๊ณผ์— ์˜ํ–ฅ์„ ์ฃผ๋А ใ„ด์“ฐ๊ธฐ๋ฅผ ์‹คํ–‰ํ•œ๋‹ค. ์Šค๋ƒ…์‡ผ ใ……๊ฒฉ๋ฆฌ๋Š” ๊ฐ„๋‹จํ•œ ํŒฌํ…€์ฝ๊ธฐ๋Š” ๋ง‰์•„์ฃผ์ง€๋งŒ ์“ฐ๊ธฐ ์Šคํ ๋งฅ๋ฝ์—์„œ ๋ฐœ์ƒํ•˜๋Š” ํŒฌํ…€์€ ์ƒ‰์ธ ๋ฒ”์œ„ ์ž ๊ธˆ์ฒ˜๋Ÿผ ํŠน๋ณ„ํ•œ ์ฒ˜๋ฆฌ๊ฐ€ ํ•„์š”ํ•˜๋‹ค.

โ€Ž_wiki/index.mdโ€Ž

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@ layout : wiki
33
title : index
44
summary : anyjava wiki index
55
date : 2018-08-15 19:41:36 +0900
6-
updated : 2020-09-07 10:46:08 +0900
6+
updated : 2020-10-06 02:03:47 +0900
77
tags :
88
toc : true
99
public : true
@@ -43,6 +43,7 @@ latex : false
4343
* [[spock]]
4444
* [[JUnit5]]
4545
* [[DBMS]]
46+
* [[Transaction]]
4647
* [[MS-SQL]]
4748
* [[NoSQL]]
4849
* [[Hbase]]

0 commit comments

Comments
ย (0)