Transaction ์ด๋ž€?
ยท
DataBase
1๏ธโƒฃTransaction ์ด๋ž€?Transaction์€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋‚ด์—์„œ ์ˆ˜ํ–‰๋˜๋Š” ์ž‘์—…์˜ ์ตœ์†Œ ๋‹จ์œ„๋กœ, ๋ฐ์ดํ„ฐ ๋ฒ ์ด์Šค์˜ ๋ฌด๊ฒฐ์„ฑ์„ ์œ ์ง€ํ•˜๋ฉฐ ๋ฐ์ดํ„ฐ ๋ฒ ์ด์Šค์˜ ์ƒํƒœ๋ฅผ ๋ณ€๊ฒฝํ•˜๋Š” ๊ธฐ๋Šฅ์„ ์ˆ˜ํ–‰ํ•ฉ๋‹ˆ๋‹ค.Transaction์€ ํ•˜๋‚˜ ์ด์ƒ์˜ query๋ฅผ ํฌํ•จํ•ด์•ผ ํ•˜๊ณ , ๋ฐ์ดํ„ฐ ์ •ํ•ฉ์„ฑ์„ ๋ณด์žฅํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” ACID ์›์น™์„ ๋งŒ์กฑํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ACID ์›์น™์ด๋ž€?์›์ž์„ฑ, ์ผ๊ด€์„ฑ, ๊ณ ๋ฆฝ์„ฑ, ์ง€์†์„ฑ 4๊ฐ€์ง€ ๊ทœ์น™1. ์›์ž์„ฑ (Atomicity)Transaction์— ํฌํ•จ๋œ ์ž‘์—…์€ ์ „๋ถ€ ์ˆ˜ํ–‰๋˜๊ฑฐ๋‚˜ ์ „๋ถ€ ์ˆ˜ํ–‰๋˜์ง€ ์•Š์•„์•ผ ํ•ฉ๋‹ˆ๋‹ค. (== All Or Nothing)2. ์ผ๊ด€์„ฑ (Consistency)Transaction์ด ์‹คํ–‰์„ ์„ฑ๊ณต์ ์œผ๋กœ ์™„๋ฃŒํ•˜๋ฉด ์‹คํ–‰ ์ „๊ณผ ํ›„์˜ ๋ฐ์ดํ„ฐ ๋ฌด๊ฒฐ์„ฑ์ด ์œ ์ง€๋˜์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.3. ๊ณ ๋ฆฝ์„ฑ (Isolation)์—ฌ๋Ÿฌ Tr..