{"id":1099,"date":"2025-01-01T20:57:28","date_gmt":"2025-01-01T11:57:28","guid":{"rendered":"https:\/\/scrutineer.co.kr\/wordpress\/?p=1099"},"modified":"2025-01-07T23:14:07","modified_gmt":"2025-01-07T14:14:07","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%84%b1%eb%8a%a5-%ea%b3%a0%eb%8f%84%ed%99%94-%ec%9b%90%eb%a6%ac%ed%99%94-%ed%95%b4%eb%b2%95-ch-1-6","status":"publish","type":"post","link":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/2025\/01\/01\/%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%84%b1%eb%8a%a5-%ea%b3%a0%eb%8f%84%ed%99%94-%ec%9b%90%eb%a6%ac%ed%99%94-%ed%95%b4%eb%b2%95-ch-1-6\/","title":{"rendered":"\uc624\ub77c\ud074 \uc131\ub2a5 \uace0\ub3c4\ud654 \uc6d0\ub9ac\ud654 \ud574\ubc95 (Ch.1 6 ~ 8)"},"content":{"rendered":"\n<h2 class=\"wp-block-heading has-large-font-size\">06 \ubb38\uc7a5\uc218\uc900 \uc77d\uae30 \uc77c\uad00\uc131<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"font-size:27px\">\uc77d\uae30 \uc77c\uad00\uc131\uc740 \uc911\uc694\ud558\ub2e4..<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8\uc77c SQL\ubb38\uc774 \uc218\ud589\ub418\ub294\ub370 \uc788\uc5b4\uc11c, \uc77d\uae30 \uc77c\uad00\uc131\uc740 \ub2f9\uc5f0\ud788 \ub9e4\uc6b0 \uc911\uc694\ud558\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub798\uc11c \ubcf4\ud1b5\uc740, \uc77d\uae30\ub97c \uc9c4\ud589\ud560 \ub54c\uc5d0\ub3c4 row lock\uc744 \uac70\ub294 DBMS\ub3c4 \uc885\uc885 \uc874\uc7ac\ud558\uae34 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub7f0\ub370, \ub2e8\uc77c row\ub97c \uc77d\ub294 \uacbd\uc6b0\ub77c\uba74 \ubaa8\ub97c\uae4c, \uc0ac\uc2e4 row lock\ub9cc\uc73c\ub85c\ub294 \ubd80\uc871\ud558\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<table>\n    <thead>\n        <tr>\n            <th>\uacc4\uc88c\ubc88\ud638<\/th>\n            <th>\uc794\uace0<\/th>\n        <\/tr>\n    <\/thead>\n    <tbody>\n        <tr>\n            <td>1<\/td>\n            <td>1000<\/td>\n        <\/tr>\n        <tr>\n            <td>2<\/td>\n            <td>1000<\/td>\n        <\/tr>\n        <tr>\n            <td>3<\/td>\n            <td>1000<\/td>\n        <\/tr>\n        <tr>\n            <td>4<\/td>\n            <td>1000<\/td>\n        <\/tr>\n        <tr>\n            <td>5<\/td>\n            <td>1000<\/td>\n        <\/tr>\n        <tr>\n            <td>6<\/td>\n            <td>1000<\/td>\n        <\/tr>\n        <tr>\n            <td>7<\/td>\n            <td>1000<\/td>\n        <\/tr>\n        <tr>\n            <td>8<\/td>\n            <td>1000<\/td>\n        <\/tr>\n        <tr>\n            <td>9<\/td>\n            <td>1000<\/td>\n        <\/tr>\n        <tr>\n            <td>10<\/td>\n            <td>1000<\/td>\n        <\/tr>\n    <\/tbody>\n<\/table>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ud14c\uc774\ube14 \uad6c\uc870\uc5d0\uc11c,<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ucf00\uc774\uc2a4 1<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b8\ub79c\uc7ad\uc158 1\uc774 \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\ub97c \uc218\ud589\ud558\uace0<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SUM(\uc794\uace0) FROM \uacc4\uc88c<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uace0 \uc0ac\uc774 \ud2b8\ub79c\uc7ad\uc158 2\uac00 \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\ub97c \uc218\ud589\ud558\uba74..<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\bINSERT INTO  \uacc4\uc88c(\uacc4\uc88c\ubc88\ud638, \uc794\uace0) VALUES (11,1000);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b8\ub79c\uc7ad\uc158 1\uc5d0\uc11c \uacc4\uc88c\ubc88\ud638 1~10\ub97c \ub2e4 row lock\uc744 \uac74\ub2e4 \ud55c\ub4e4, \uc77d\uae30 \uc77c\uad00\uc131\uc774 \ubcf4\uc7a5\ub418\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uac00 \uc0dd\uaca8\ubc84\ub9ac\ub124&#8230;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud2b8\ub79c\uc7ad\uc158 1\uc774 \ub808\ucf54\ub4dc\ub97c \ub2e4 \uc77d\uae30 \uc804\uc5d0 \ud2b8\ub79c\uc7ad\uc158 2\uac00 \ucee4\ubc0b \ucc0d\ud788\uba74 &#8211;> \uacc4\uc88c\ubc88\ud638 11\uc758 \uac12\uae4c\uc9c0 \uc77d\uc740\ucc44\ub85c \uc218\ud589\ub428<\/li>\n\n\n\n<li>\ud2b8\ub79c\uc7ad\uc158 1\uc774 \ub808\ucf54\ub4dc\ub97c \ub2e4 \uc77d\uc740 \ud6c4\uc5d0 \ud2b8\ub79c\uc7ad\uc158 2\uac00 \ucee4\ubc0b \ucc0d\ud788\uba74 &#8211;> \uacc4\uc88c\ubc88\ud638 10\uc758 \uac12\uae4c\uc9c0 \uc77d\uc740\ucc44\ub85c \uc218\ud589\ub428<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ucf00\uc774\uc2a4 2<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b8\ub79c\uc7ad\uc158 2\uac00 \uac11\uc790\uae30 \ud2b8\ub79c\uc7ad\uc1581\uc774 \uc77d\uace0 \uc9c0\ub098\uac04 \ub808\ucf54\ub4dc\uc5d0\uc11c \uc794\uace0\ub97c \ucc28\uac10\ud558\uac70\ub098 \ub354\ud558\uba74&#8230; \ucd1d \ud569\uacc4\uac00 \ub354\ud558\uac70\ub098 \ubeb4\uc838\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">p.s: \ucc45\uc5d0\uc11c\ub294 \ub2e4\ub978 DBMS\ub97c \uc608\ub97c \ub4e4\uc5b4\uc11c &#8216;\ub2e4\ub978 DBMS\ub294 \uc774 \uc77d\uae30 \uc77c\uad00\uc131\uc774 \ubcf4\uc7a5\uc774 \ub418\uc9c0 \uc54a\ub294\ub2e4&#8217; \ub77c\uace0 \ud558\ub294\ub370&#8230; \uc774\uac74 \ud328\uc2a4\ud558\uae30\ub85c \ud568..<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"font-size:27px\">\uace0\ub7ec\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud558\ub098??<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uac00\uc7a5 \uc2ec\ud50c\ud55c \ud574\uacb0\ubc95 : \ud2b8\ub79c\uc7ad\uc158 \uace0\ub9bd(Isolation) \uc218\uc900\uc744 \ub192\uc774\uac70\ub098, \ud14c\uc774\ube14 lock\uc744 \uac78\uba74 \ub41c\ub2e4..<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub7f0\ub370, \uc774\ub7ec\uba74 \uc131\ub2a5\uc774 \ub2f9\uc5f0\ud788 \ub098\uc624\uc9c0 \uc54a\uc74c.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub7fc \uc624\ub77c\ud074\uc740 \uc5b4\ub5bb\uac8c \uc774 \uc77d\uae30 \uc77c\uad00\uc131\uc744 \ubcf4\uc7a5\ud558\ub294\uac00?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>UNDO\uc138\uadf8\uba3c\ud2b8\ub97c \uc774\uc6a9\ud574 \uc77d\uae30 \uc77c\uad00\uc131\uc744 \ubcf4\uc7a5\ud55c\ub2e4.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\ud788, SCN\uc774\ub77c\uace0 \ud558\ub294 \uc2dc\uac04\uc815\ubcf4\ub97c \uc774\uc6a9\ud574 \uc77c\uad00\uc131 \ubcf4\uc7a5\uc744 \ud558\ub294\ub370, \uadf8\ub0e5 &#8216;\ucee4\ubc0b\ubc88\ud638&#8217; \ub77c\uace0 \uc774\ud574\ud558\uba74 \ub41c\ub2e4.. (\uc560\ucd08\uc5d0 System Commit Number \uc784.) \ucee4\ubc0b\uc744 \ucc0d\uc744\ub54c\ub9c8\ub2e4 \uc774 \uac12\uc740 \uc99d\uac00\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \ub298\uc5b4\ub098\uace0, \uac01 \ube14\ub85d\ub4e4\uc740 \uc774 SCN\uc744 \uac16\uace0 \uc788\ub2e4\uace0 \uc0dd\uac01\ud558\uba74 \ub428.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250101_203532-1024x577.jpg\" alt=\"\" class=\"wp-image-1101\" srcset=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250101_203532-1024x577.jpg 1024w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250101_203532-300x169.jpg 300w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250101_203532-768x432.jpg 768w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250101_203532-1536x865.jpg 1536w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250101_203532-2048x1153.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">(pdf \uc5b4\ub514 \uc5c6\ub098&#8230;.\uc81c\ubcf8\uc744 \ub728\ub358\uac00 \uc6d0..)<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc6d0\ub9ac\ub294 \uac04\ub2e8\ud558\ub2e4. <strong>&#8216;\uc77d\ub294 \ucffc\ub9ac\ub97c \ub0a0\ub9b0 \uc2dc\uc810\uc758 SCN\ubcf4\ub2e4 \uc791\uac70\ub098 \uac19\uc740\uac83\ub4e4 \uc911, \uac00\uc7a5 \ud070&#8217;<\/strong> SCN\ube14\ub85d\uc758 \uac12\uc744 \uc77d\uc5b4\ub4e4\uc778\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ucffc\ub9ac\ub97c \ub0a0\ub9ac\ub294 \uc2dc\uc810\uc758 SCN\uc774 123 \uc77c\ub54c<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SCN\uc774 123\ubcf4\ub2e4 \ud070 \ube14\ub85d\uc740 &#8216;\ub0b4\uac00 \uc77d\uae30-SELECT\ucffc\ub9ac-\ub97c \uc2dc\uc791\ud55c \uc774\ud6c4 \uc2dc\uc810\uc5d0 \uc801\uc6a9\ub41c \ube14\ub85d&#8217; \uc774\ub2e4. \ub530\ub77c\uc11c \uc77d\uc9c0 \uc54a\ub294\ub2e4.<\/li>\n\n\n\n<li>SCN\uc774 123\ubcf4\ub2e4 \uc791\uc740 \ube14\ub85d\uc740 &#8216;\ub0b4\uac00 \uc77d\uae30\ub97c \uc2dc\uc791\ud55c \uc2dc\uc810\uc5d0 \uc774\ubbf8 \uae30 \uc801\uc6a9\ub418\uc5b4\uc788\ub294 \ube14\ub85d&#8217;\uc774\ub2e4. \ub530\ub77c\uc11c \uc77d\uc5b4\uc57c \ud55c\ub2e4.\n<ul class=\"wp-block-list\">\n<li>\ud5c8\ub098, <strong>\uadf8 \uc791\uc740 \ube14\ub85d\ub4e4 \uc911 \uc544\ubb34\uac70\ub098 \uc77d\uc73c\uba74 \uc548\ub418\uace0, \uadf8 \uc911\uc5d0\uc11c \uac00\uc7a5 \ub9c8\uc9c0\ub9c9\uc5d0 \uc801\uc6a9\ub41c \ube14\ub85d\uc758 \uac12\uc744 \uc77d\uc5b4\uc57c \ud55c\ub2e4.<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ucc45\uc5d0\uc120 \uc5c4\uccad \ub9ce\uc740 \ubcf5\uc7a1\ud55c \uc0c1\ud669\uc744 \ub300\uc785\ud558\uba70 \uc124\uba85\uc744 \ub108\uc904\ub108\uc904 \ud558\uc9c0\ub9cc, \uc0ac\uc2e4 \ud575\uc2ec\uc740 \uc774\uac70 \ud558\ub098\uc784&#8230;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uadf8\ub7fc \ub0b4\uac00 \uc77d\uc73c\ub824\ub294 \ube14\ub85d\uc774 UNDO\uc138\uadf8\uba3c\ud2b8\uc5d0\uc11c \uc0ac\ub77c\uc9c0\uba74?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2f9\uc5f0\ud788 \uc77d\uc9c0 \ubabb\ud55c\ub2e4. \uadf8\ub54c \ubc1c\uc0dd\ud558\ub294 ORA\uc624\ub958\uac00 \uc788\ub2e4. &#8216;Snapshot too old&#8217;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ub0b4\uac00 \ub0a0\ub9b0 \ucffc\ub9ac\uac00 \uc77c\ub2e8 \uc5c4\uccad \ud5e4\ube44\ud55c \ucffc\ub9ac\uc774\ub2e4.<\/li>\n\n\n\n<li>\ud558\ud544 \ud2b8\ub798\ud53d\uc774 \ub9ce\uc740 \uc2dc\uac04\ub300\uc774\uace0 \ucee4\ubc0b\uc774 \uc7a6\uc740 \uc0c1\ud669\uc774\ub77c\uc11c, DB\uac00 \uacc4\uc18d \uc0c8\ub85c\uc6b4 SCN\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8 \ub418\uba70 UNDO\uc5d0 \ub0b4\uac00 \uc77d\uc73c\ub824\ub294 \ub370\uc774\ud130\uac00 \ubc00\ub9b0\ub2e4.<\/li>\n\n\n\n<li>\ucffc\ub9ac\uac00 \ub2e4 \ud480\ub824 \uc774\uc81c \ube14\ub85d\uc744 \uc77d\uc73c\ub824 \ud558\ub294\ub370, UNDO\uc138\uadf8\uba3c\ud2b8\uc5d0\uc11c \uc774\ubbf8 \uc6a9\ub7c9\ubd80\uc871\uc73c\ub85c \uc778\ud574 \ub0a0\uc544\uac00\ubc84\ub9b0 \ube14\ub85d\uc774 \uc788\uc73c\uba74 \uc5d0\ub7ec \ubc1c\uc0dd<\/li>\n\n\n\n<li><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">07 Consistent vs  Current \ubaa8\ub4dc \uc77d\uae30<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">07 \ub300\uc81c\ubaa9\uc5d0 \ub098\uc640\uc788\ub4ef, \ube14\ub85d \uc77d\uae30 \ubaa8\ub4dc\uc5d0\ub3c4 \uc5ec\ub7ec\uac00\uc9c0 \ubaa8\ub4dc\uac00 \uc788\uc74c.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Consistent mode\n<ul class=\"wp-block-list\">\n<li>&#8216;\ucffc\ub9ac\ub97c \ub584\ub9b0 \uadf8 \uc2dc\uc810\uc758 SCN\uac12\uc744 \uae30\uc900\uc73c\ub85c \uac12\uc744 \uc77d\uc74c&#8217;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Current mode\n<ul class=\"wp-block-list\">\n<li>&#8216;\ucffc\ub9ac\ub97c \ub584\ub9ac\uace0 \ub098\uc11c, \ub370\uc774\ud130\ub97c \ucc3e\uc544\uac04 \ubc14\ub85c \uadf8 \uc2dc\uc810\uc758 \ucd5c\uc885 \uac12\uc744 \uc77d\uc74c&#8217;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uadfc\ub370&#8230; \uc55e\uc120 SCN\uc774 \uc5b4\uca4c\uace0\uc800\uca4c\uace0 \ud558\ub294\uac78 \ubcf4\uba74&#8230; \ub2e8\uc21c\uc774 SELECT\ud558\ub294 \ucffc\ub9ac\ubb38\uc740 Consistent\ubaa8\ub4dc\ub85c \uc77d\uc9c0 \uc54a\ub098?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub807\uc9c0 \uc54a\uc74c&#8230; DML\uc744 \ud560 \ub54c\uc5d0\ub3c4 &#8220;UPDATE SET A = A+1&#8221; \uacfc \uac19\uc774 \uc774\uc804 \uac12\uc744 \uc77d\uc5b4\uc57c \ud560 \uc2dc\uc810\uc774 \uc788\uc744\uac70\uace0, SELECT FOR UPDATE\ubb38\uacfc \uac19\uc774 UPDATE \uc9c1\uc804\uc5d0 \ub370\uc774\ud130\ub97c \uc77d\ub294 \uacbd\uc6b0\ub3c4 \uc788\uc74c. \uc774\ub54c \ubc14\ub85c \uc624\ub77c\ud074\uc740 Current mode\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ub97c \uc77d\ub294\ub2e4\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ubaa8\ub974\uaca0\uace0&#8230; \uadf8\uc800 &#8216;\uc77c\ubc18\uc801\uc778 \ub2e8\uc21c SELECT\ub294 Consistent mode\ub85c \ub370\uc774\ud130\ub97c \uc77d\uc9c0\ub9cc, \ub2e4\uc74c\uacfc \uac19\uc740 \uc608\uc678 \ucf00\uc774\uc2a4\uc5d0 Current mode\ub85c \ub370\uc774\ud130\ub97c \uc77d\ub294 \uacbd\uc6b0\ub3c4 \uc788\ub2e4&#8217; \uc815\ub3c4\ub97c \uc678\uc6cc\ub450\uc790.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>DML<\/li>\n\n\n\n<li>SELECT FOR UPDATE<\/li>\n\n\n\n<li>\ub514\uc2a4\ud06c \uc18c\ud2b8\uac00 \ud544\uc694\ud560 \uc815\ub3c4\ub85c, \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc815\ub82c\ud560 \ub54c<\/li>\n\n\n\n<li>\ub4f1\ub4f1\ub4f1\ub4f1&#8230;.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ucc45\uc5d0\uc11c \uac11\uc790\uae30 \ubcc4\ub85c \ud544\uc694\ud560 \uac83 \uac19\uc9c0\ub3c4 \uc54a\uc740 Current mode\uc5d0 \ub300\ud574\uc11c \ub108\uc904\ub108\uc904 \uc124\uba85\uc744 \ud558\uae30 \uc2dc\uc791\ud55c\ub2e4..\ud558\uc9c0\ub9cc Current mode\uac00 \ud544\uc694\ud55c \uacbd\uc6b0\uac00 \ubd84\uba85 \uc874\uc7ac\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">08 \ube14\ub85d \ud074\ub9b0\uc544\uc6c3<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>06 \ubb38\uc7a5\uc218\uc900 \uc77d\uae30 \uc77c\uad00\uc131 \uc77d\uae30 \uc77c\uad00\uc131\uc740 \uc911\uc694\ud558\ub2e4.. \ub2e8\uc77c SQL\ubb38\uc774 \uc218\ud589\ub418\ub294\ub370 \uc788\uc5b4\uc11c, \uc77d\uae30 \uc77c\uad00\uc131\uc740 \ub2f9\uc5f0\ud788 \ub9e4\uc6b0 \uc911\uc694\ud558\ub2e4. \uadf8\ub798\uc11c \ubcf4\ud1b5\uc740, \uc77d\uae30\ub97c \uc9c4\ud589\ud560 \ub54c\uc5d0\ub3c4 row lock\uc744 \uac70\ub294 DBMS\ub3c4 \uc885\uc885 \uc874\uc7ac\ud558\uae34 \ud55c\ub2e4. \uadf8\ub7f0\ub370, \ub2e8\uc77c row\ub97c \uc77d\ub294 \uacbd\uc6b0\ub77c\uba74 \ubaa8\ub97c\uae4c, \uc0ac\uc2e4 row lock\ub9cc\uc73c\ub85c\ub294 \ubd80\uc871\ud558\ub2e4. \uacc4\uc88c\ubc88\ud638 \uc794\uace0 1 1000 2 1000 3 1000 4 1000 5 1000 6 1000 7 1000 8 &#8230; <a title=\"\uc624\ub77c\ud074 \uc131\ub2a5 \uace0\ub3c4\ud654 \uc6d0\ub9ac\ud654 \ud574\ubc95 (Ch.1 6 ~ 8)\" class=\"read-more\" href=\"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/2025\/01\/01\/%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%84%b1%eb%8a%a5-%ea%b3%a0%eb%8f%84%ed%99%94-%ec%9b%90%eb%a6%ac%ed%99%94-%ed%95%b4%eb%b2%95-ch-1-6\/\" aria-label=\"Read more about \uc624\ub77c\ud074 \uc131\ub2a5 \uace0\ub3c4\ud654 \uc6d0\ub9ac\ud654 \ud574\ubc95 (Ch.1 6 ~ 8)\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1099","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=1099"}],"version-history":[{"count":4,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1099\/revisions"}],"predecessor-version":[{"id":1110,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1099\/revisions\/1110"}],"wp:attachment":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=1099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=1099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=1099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}