{"id":1626,"date":"2026-02-17T11:53:52","date_gmt":"2026-02-17T11:53:52","guid":{"rendered":"https:\/\/wayhope.kro.kr\/?p=1626"},"modified":"2026-08-31T07:32:30","modified_gmt":"2026-08-31T07:32:30","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ed%95%b5%ec%8b%ac-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/wayhope.kro.kr\/?p=1626","title":{"rendered":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud575\uc2ec \uc815\ub9ac"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub2e4 \ubcf4\uba74 \uacb0\uad6d \uc800\uc7a5\ud574\uc57c \ud558\ub294 \ubb38\uc81c\uac00 \uc0dd\uae34\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uac8c\uc784\uc758 \ud50c\ub808\uc774\uc5b4 \uc815\ubcf4, \uc544\uc774\ud15c, \uc7ac\ud654, \uc124\uc815\uac12, \ub85c\uadf8 \uac19\uc740 \ub370\uc774\ud130\ub294 \ud504\ub85c\uadf8\ub7a8\uc774 \uc885\ub8cc\ub41c\ub2e4\uace0 \uc0ac\ub77c\uc9c0\uba74 \uc548 \ub41c\ub2e4. \uc11c\ubc84\uc5d0\uc11c\ub294 \ub3d9\uc2dc\uc5d0 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \uac19\uc740 \ub370\uc774\ud130\ub97c \uc77d\uace0 \uc218\uc815\ud558\uae30\ub3c4 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc774\ub7f0 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uc870\ud68c\ud558\uace0 \ubcc0\uacbd\ud558\uae30 \uc704\ud55c \uc2dc\uc2a4\ud15c\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8\uc21c\ud788 \ub370\uc774\ud130\ub97c \ud30c\uc77c\uc5d0 \uc800\uc7a5\ud558\ub294 \uac83\uacfc \ub2e4\ub978 \uc810\uc740 <strong>\ub9ce\uc740 \ub370\uc774\ud130\uc5d0 \ub300\ud574 \uc77c\uad00\ub41c \ubc29\uc2dd\uc73c\ub85c \uc811\uadfc\ud558\uace0, \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \uc791\uc5c5\ud558\ub354\ub77c\ub3c4 \ub370\uc774\ud130\uc758 \uc0c1\ud0dc\ub97c \uad00\ub9ac\ud560 \uc218 \uc788\ub2e4\ub294 \uac83<\/strong>\uc774\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 DBMS<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4(Database)\ub294 \ub370\uc774\ud130\ub97c \uad6c\uc870\uc801\uc73c\ub85c \uc800\uc7a5\ud55c \uacf5\uac04\uc774\ub77c\uace0 \ubcfc \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub9ac\uace0 \uadf8 \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\ub294 \uc18c\ud504\ud2b8\uc6e8\uc5b4\uac00 <strong>DBMS(Database Management System)<\/strong>\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Application -&gt; DBMS -&gt; Database -&gt; Storage\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uac1c\ubc1c\uc790\uac00 \uc9c1\uc811 \ub514\uc2a4\ud06c\uc758 \ud2b9\uc815 \uc704\uce58\uc5d0 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uac80\uc0c9\ud558\ub294 \ub300\uc2e0 DBMS\uc5d0 \uc694\uccad\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub300\ud45c\uc801\uc778 \uad00\uacc4\ud615 DBMS\ub85c\ub294 PostgreSQL, MySQL, MariaDB, SQL Server \ub4f1\uc774 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">MongoDB \uac19\uc740 NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub3c4 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc911\uc694\ud55c \uac83\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc885\ub958\ub97c \uba3c\uc800 \uc678\uc6b0\ub294 \uac83\uc774 \uc544\ub2c8\ub77c <strong>\uc5b4\ub5a4 \ub370\uc774\ud130\uc640 \uc811\uadfc \ud328\ud134\uc744 \uac00\uc9c0\uace0 \uc788\ub294\uac00<\/strong>\ub97c \ubcf4\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ub418\ub294 \ud615\ud0dc \uc911 \ud558\ub098\uac00 <strong>\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4(Relational Database)<\/strong>\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ub97c \ud14c\uc774\ube14 \ud615\ud0dc\ub85c \uc800\uc7a5\ud55c\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"250\" src=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-95.png\" alt=\"\" class=\"wp-image-1900\" style=\"width:317px;height:auto\" srcset=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-95.png 500w, https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-95-300x150.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uac01 \ud589\uc740 \ud558\ub098\uc758 \ub370\uc774\ud130\ub97c \ub098\ud0c0\ub0b4\uace0, \uac01 \uc5f4\uc740 \ub370\uc774\ud130\uc758 \uc18d\uc131\uc744 \ub098\ud0c0\ub0b8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5ec\ub7ec \ud14c\uc774\ube14 \uc0ac\uc774\uc758 \uad00\uacc4\ub3c4 \ud45c\ud604\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"520\" height=\"280\" src=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-96.png\" alt=\"\" class=\"wp-image-1901\" style=\"width:243px;height:auto\" srcset=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-96.png 520w, https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-96-300x162.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub370\uc774\ud130\ub97c \uad6c\uc870\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 SQL\uc744 \ud1b5\ud574 \uc6d0\ud558\ub294 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \uc218 \uc788\ub2e4\ub294 \uc7a5\uc810\uc774 \uc788\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\ub294 <strong>SQL(Structured Query Language)<\/strong>\uc744 \uc0ac\uc6a9\ud574 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uace0 \ubcc0\uacbd\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT id, name, level\nFROM Player\nWHERE level &gt;= 20;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ub97c \ucd94\uac00\ud560 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO Player (name, level)\nVALUES ('Alice', 20);\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc218\uc815\uacfc \uc0ad\uc81c\ub3c4 \uac00\ub2a5\ud558\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE Player\nSET level = 21\nWHERE id = 1;\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM Player\nWHERE id = 1;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">SQL\uc740 \ub2e8\uc21c\ud788 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uc5b8\uc5b4\uac00 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uace0, \uad8c\ud55c\uc744 \uad00\ub9ac\ud558\uace0, \ud2b8\ub79c\uc7ad\uc158\uc744 \uc81c\uc5b4\ud558\uace0, \uc5ec\ub7ec \ud14c\uc774\ube14\uc744 \uc870\ud569\ud558\ub294 \ub4f1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub2e4\uc591\ud55c \uae30\ub2a5\uc744 \ub2e4\ub8ec\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Primary Key<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ud14c\uc774\ube14\uc5d0\uc11c \uac01 \ud589\uc744 \uace0\uc720\ud558\uac8c \uc2dd\ubcc4\ud560 \uc218 \uc788\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub97c \uc704\ud574 <strong>Primary Key(PK)<\/strong>\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"531\" height=\"278\" src=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-110.png\" alt=\"\" class=\"wp-image-1917\" style=\"width:295px;height:auto\" srcset=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-110.png 531w, https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-110-300x157.png 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5ec\uae30\uc11c <code>id<\/code>\uac00 Primary Key\ub77c\uace0 \ud558\uba74 \uac01 \ud50c\ub808\uc774\uc5b4\ub97c \uace0\uc720\ud558\uac8c \uc2dd\ubcc4\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM Player\nWHERE id = 10;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Primary Key\ub294 \uc911\ubcf5\ub420 \uc218 \uc5c6\uace0 \uc77c\ubc18\uc801\uc73c\ub85c NULL\uc744 \ud5c8\uc6a9\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ub97c \uc2dd\ubcc4\ud558\ub294 \uae30\uc900\uc774\uae30 \ub54c\ubb38\uc5d0 \ud14c\uc774\ube14 \uc124\uacc4\uc5d0\uc11c \uc0c1\ub2f9\ud788 \uc911\uc694\ud55c \ubd80\ubd84\uc774\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Foreign Key<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ud14c\uc774\ube14\uacfc \ud14c\uc774\ube14 \uc0ac\uc774\uc758 \uad00\uacc4\ub97c \ud45c\ud604\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 <strong>Foreign Key(FK)<\/strong>\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"237\" height=\"174\" src=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-97.png\" alt=\"\" class=\"wp-image-1903\" style=\"width:151px;height:auto\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uc640<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"288\" height=\"232\" src=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-99.png\" alt=\"\" class=\"wp-image-1905\" style=\"width:162px;height:auto\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uac00 \uc788\ub2e4\uba74 <code>Item.player_id<\/code>\uac00 <code>Player.id<\/code>\ub97c \ucc38\uc870\ud558\ub3c4\ub85d \ub9cc\ub4e4 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"493\" src=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-98.png\" alt=\"\" class=\"wp-image-1904\" style=\"width:175px;height:auto\" srcset=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-98.png 355w, https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-98-216x300.png 216w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub807\uac8c \ud558\uba74 \ub370\uc774\ud130 \uc0ac\uc774\uc758 \uad00\uacc4\ub97c \uba85\ud655\ud558\uac8c \ud45c\ud604\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">JOIN<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc5ec\ub7ec \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \ud568\uaed8 \uc870\ud68c\ud560 \ub54c <strong>JOIN<\/strong>\uc744 \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Player.name, Item.item_name\nFROM Player\nJOIN Item\n    ON Player.id = Item.player_id;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uacb0\uacfc\ub294 \uac1c\ub150\uc801\uc73c\ub85c \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"315\" src=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-100.png\" alt=\"\" class=\"wp-image-1906\" style=\"width:342px;height:auto\" srcset=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-100.png 616w, https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-100-300x153.png 300w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\ud14c\uc774\ube14\uc744 \uc5ec\ub7ec \uac1c\ub85c \ub098\ub204\uc5b4 \uc800\uc7a5\ud558\ub354\ub77c\ub3c4 \ud544\uc694\ud560 \ub54c JOIN\uc744 \uc774\uc6a9\ud574 \ud558\ub098\uc758 \uacb0\uacfc\ub85c \uac00\uc838\uc62c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub300\ud45c\uc801\uc778 JOIN\uc5d0\ub294 \ub2e4\uc74c\uc774 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INNER JOIN\nLEFT JOIN\nRIGHT JOIN\nFULL OUTER JOIN\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2e4\ubb34\uc5d0\uc11c\ub294 \ud2b9\ud788 <code>INNER JOIN<\/code>\uacfc <code>LEFT JOIN<\/code>\uc744 \uc790\uc8fc \ub9cc\ub098\uac8c \ub41c\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\uc815\uaddc\ud654<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc124\uacc4\ud560 \ub54c \uac19\uc740 \ub370\uc774\ud130\ub97c \uc5ec\ub7ec \uacf3\uc5d0 \uc911\ubcf5\ud574\uc11c \uc800\uc7a5\ud558\uba74 \ubb38\uc81c\uac00 \uc0dd\uae38 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"293\" height=\"232\" src=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-101.png\" alt=\"\" class=\"wp-image-1907\" style=\"width:167px;height:auto\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0ac\uc6a9\uc790\uc758 \uc774\uba54\uc77c\uc774 \ubcc0\uacbd\ub418\uba74 \uc5ec\ub7ec \ud589\uc744 \uc218\uc815\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77c\ubd80\ub9cc \uc218\uc815\ub418\uba74 \ub370\uc774\ud130\uac00 \uc11c\ub85c \ub2e4\ub978 \uc0c1\ud0dc\uac00 \ub420 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub7f0 \ubb38\uc81c\ub97c \uc904\uc774\uae30 \uc704\ud574 \ub370\uc774\ud130\ub97c \uc801\uc808\ud55c \ud14c\uc774\ube14\ub85c \ubd84\ub9ac\ud558\ub294 \uac83\uc774 <strong>\uc815\uaddc\ud654(Normalization)<\/strong>\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"618\" height=\"239\" src=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-108.png\" alt=\"\" class=\"wp-image-1914\" style=\"width:348px;height:auto\" srcset=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-108.png 618w, https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-108-300x116.png 300w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub294 \ud55c \uacf3\uc5d0\uc11c \uad00\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc815\uaddc\ud654\uc758 \ubaa9\uc801\uc740 \ub2e8\uc21c\ud788 \ud14c\uc774\ube14\uc744 \ub9ce\uc774 \ub9cc\ub4dc\ub294 \uac83\uc774 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ub370\uc774\ud130\uc758 \uc911\ubcf5\uc744 \uc904\uc774\uace0 \ub370\uc774\ud130 \ubcc0\uacbd \uc2dc \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \uc774\uc0c1 \ud604\uc0c1\uc744 \uc904\uc774\ub294 \uac83<\/strong>\uc774\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ubc18\uc815\uaddc\ud654<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub807\ub2e4\uace0 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \ucd5c\ub300\ud55c \ubd84\ub9ac\ud558\ub294 \uac83\uc774 \ud56d\uc0c1 \uc88b\uc740 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud14c\uc774\ube14\uc744 \uc9c0\ub098\uce58\uac8c \ubd84\ub9ac\ud558\uba74 JOIN\uc774 \ub9ce\uc544\uc9c0\uace0 \uc870\ud68c \ube44\uc6a9\uc774 \uc99d\uac00\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub798\uc11c \uc870\ud68c \uc131\ub2a5\uc774\ub098 \uc2dc\uc2a4\ud15c \uad6c\uc870\uc5d0 \ub530\ub77c \uc77c\ubd80 \ub370\uc774\ud130\ub97c \uc758\ub3c4\uc801\uc73c\ub85c \uc911\ubcf5 \uc800\uc7a5\ud558\uae30\ub3c4 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uac83\uc744 <strong>\ubc18\uc815\uaddc\ud654(Denormalization)<\/strong>\ub77c\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\uc815\uaddc\ud654\n-&gt; \uc911\ubcf5 \uac10\uc18c\n-&gt; \ub370\uc774\ud130 \uc77c\uad00\uc131 \uad00\ub9ac \uc6a9\uc774\n\n\ubc18\uc815\uaddc\ud654\n-&gt; \uc911\ubcf5 \uc99d\uac00\n-&gt; \uc870\ud68c \uc131\ub2a5 \ub610\ub294 \uad6c\uc870 \ub2e8\uc21c\ud654\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uacb0\uad6d \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub3c4 \ud2b8\ub808\uc774\ub4dc\uc624\ud504\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubb34\uc870\uac74 \uc815\uaddc\ud654\ud558\uac70\ub098 \ubb34\uc870\uac74 \uc911\ubcf5\uc744 \uc81c\uac70\ud558\ub294 \uac83\uc774 \uc815\ub2f5\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Index<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\uac00 \ub9ce\uc544\uc9c0\uba74 \ub2e8\uc21c\ud788 \ud14c\uc774\ube14 \uc804\uccb4\ub97c \uac80\uc0c9\ud558\ub294 \ubc29\uc2dd\uc740 \ub290\ub824\uc9c8 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \ud50c\ub808\uc774\uc5b4\uac00 1\uc5b5 \uba85 \uc788\ub294\ub370 \ub2e4\uc74c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud55c\ub2e4\uace0 \ud558\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM Player\nWHERE email = 'alice@example.com';\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><code>email<\/code>\uc5d0 \uc778\ub371\uc2a4\uac00 \uc5c6\ub2e4\uba74 \ub9ce\uc740 \ub370\uc774\ud130\ub97c \uc9c1\uc811 \ud655\uc778\ud574\uc57c \ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5ec\uae30\uc5d0 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE INDEX idx_player_email\nON Player(email);\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \ud2b9\uc815 \uac12\uc744 \ucc3e\ub294 \uc791\uc5c5\uc744 \ud6e8\uc52c \ube60\ub974\uac8c \ub9cc\ub4e4 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub300\uc2e0 \uc778\ub371\uc2a4\uc5d0\ub3c4 \ube44\uc6a9\uc774 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ub97c \ucd94\uac00\ud558\uac70\ub098 \uc218\uc815\ud560 \ub54c \uc778\ub371\uc2a4\ub3c4 \ud568\uaed8 \uad00\ub9ac\ud574\uc57c \ud558\uace0 \ub514\uc2a4\ud06c \uacf5\uac04\ub3c4 \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub798\uc11c \ubaa8\ub4e0 \uceec\ub7fc\uc5d0 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4dc\ub294 \uac83\uc740 \uc88b\uc9c0 \uc54a\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uc790\uc8fc \uc870\ud68c\ub418\ub294 \uc870\uac74\uacfc \uc2e4\uc81c \ucffc\ub9ac \ud328\ud134\uc744 \ubcf4\uace0 \ud544\uc694\ud55c \uc778\ub371\uc2a4\ub97c \uc120\ud0dd\ud574\uc57c \ud55c\ub2e4.<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">B-Tree\uc640 \uc778\ub371\uc2a4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc778\ub371\uc2a4\ub294 \ub2e4\uc591\ud55c \uc790\ub8cc\uad6c\uc870\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc9c0\ub9cc B-Tree \uacc4\uc5f4 \uad6c\uc870\uac00 \uc77c\ubc18\uc801\uc73c\ub85c \ub9ce\uc774 \uc0ac\uc6a9\ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uac1c\ub150\uc801\uc73c\ub85c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uad6c\uc870\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"393\" height=\"217\" src=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-109.png\" alt=\"\" class=\"wp-image-1915\" style=\"width:249px;height:auto\" srcset=\"https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-109.png 393w, https:\/\/wayhope.kro.kr\/wp-content\/uploads\/2026\/08\/image-109-300x166.png 300w\" sizes=\"auto, (max-width: 393px) 100vw, 393px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc815\ub82c\ub41c \uad6c\uc870\ub97c \uc774\uc6a9\ud558\uae30 \ub54c\ubb38\uc5d0 \ud2b9\uc815 \uac12\uc744 \ucc3e\uac70\ub098 \ubc94\uc704 \uac80\uc0c9\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WHERE level &gt;= 50\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uac19\uc740 \ubc94\uc704 \uac80\uc0c9\uc5d0\uc11c\ub3c4 \uc778\ub371\uc2a4\uac00 \ud65c\uc6a9\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc \uc2e4\uc81c\ub85c \uc5b4\ub5a4 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud588\ub294\uc9c0\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc2e4\ud589 \uacc4\ud68d\uc744 \ud655\uc778\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4\uc5c8\ub2e4\uace0 \ud574\uc11c \ubaa8\ub4e0 \ucffc\ub9ac\uac00 \uc790\ub3d9\uc73c\ub85c \ube68\ub77c\uc9c0\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ubcf5\ud569 \uc778\ub371\uc2a4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5ec\ub7ec \uceec\ub7fc\uc744 \ubb36\uc5b4\uc11c \ud558\ub098\uc758 \uc778\ub371\uc2a4\ub85c \ub9cc\ub4e4 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE INDEX idx_player_server_level\nON Player(server_id, level);\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub7f0 \uc778\ub371\uc2a4\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\uc5d0\uc11c \ud65c\uc6a9\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM Player\nWHERE server_id = 1\n  AND level &gt;= 50;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ubcf5\ud569 \uc778\ub371\uc2a4\uc5d0\uc11c\ub294 \uceec\ub7fc\uc758 \uc21c\uc11c\uac00 \uc911\uc694\ud558\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8\uc21c\ud788 \ud544\uc694\ud55c \uceec\ub7fc\uc744 \ubaa8\ub450 \ub123\ub294\ub2e4\uace0 \uc88b\uc740 \uc778\ub371\uc2a4\uac00 \ub418\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2e4\uc81c \uc870\ud68c \uc870\uac74\uacfc \uc815\ub82c \uc870\uac74 \ub4f1\uc744 \uae30\uc900\uc73c\ub85c \uc778\ub371\uc2a4 \uad6c\uc870\ub97c \uacb0\uc815\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Transaction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc5ec\ub7ec \uc791\uc5c5\uc744 \ud558\ub098\uc758 \ub17c\ub9ac\uc801\uc778 \uc791\uc5c5\uc73c\ub85c \ucc98\ub9ac\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uac8c\uc784\uc5d0\uc11c \ud50c\ub808\uc774\uc5b4\uc758 \uc7ac\ud654\ub97c \ucc28\uac10\ud558\uace0 \uc544\uc774\ud15c\uc744 \uc9c0\uae09\ud55c\ub2e4\uace0 \ud558\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\uc7ac\ud654 -100\n\uc544\uc774\ud15c +1\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc7ac\ud654\ub9cc \ucc28\uac10\ub418\uace0 \uc544\uc774\ud15c \uc9c0\uae09\uc774 \uc2e4\ud328\ud558\uba74 \ub370\uc774\ud130\uac00 \uc774\uc0c1\ud574\uc9c4\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ub450 \uc791\uc5c5\uc740 \ud558\ub098\uc758 \uc791\uc5c5\uc73c\ub85c \ubb36\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Transaction\n\n\uc7ac\ud654 -100\n\uc544\uc774\ud15c +1 -&gt; \ub458 \ub2e4 \uc131\uacf5\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc911\uac04\uc5d0 \ubb38\uc81c\uac00 \uc0dd\uae30\uba74 \ubcc0\uacbd\uc0ac\ud56d\uc744 \ub418\ub3cc\ub9b0\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\uc7ac\ud654 -100\n\uc544\uc774\ud15c \uc9c0\uae09 \uc2e4\ud328 -&gt; Rollback -&gt; \uc6d0\ub798 \uc0c1\ud0dc\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uac83\uc774 Transaction\uc758 \uae30\ubcf8\uc801\uc778 \uac1c\ub150\uc774\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">ACID<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b8\ub79c\uc7ad\uc158\uc758 \ud2b9\uc131\uc744 \uc124\uba85\ud560 \ub54c <strong>ACID<\/strong>\ub77c\ub294 \uac1c\ub150\uc744 \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Atomicity<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b8\ub79c\uc7ad\uc158\uc758 \uc791\uc5c5\uc740 \ud558\ub098\uc758 \ub2e8\uc704\ub85c \ucc98\ub9ac\ub41c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\uc804\ubd80 \uc131\uacf5 \ub610\ub294 \uc804\ubd80 \uc2e4\ud328\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Consistency<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b8\ub79c\uc7ad\uc158 \uc804\ud6c4\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc815\uc758\ub41c \uaddc\uce59\uc744 \ub9cc\uc871\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Isolation<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5ec\ub7ec \ud2b8\ub79c\uc7ad\uc158\uc774 \ub3d9\uc2dc\uc5d0 \uc2e4\ud589\ub420 \ub54c \uc11c\ub85c\uc758 \uc791\uc5c5\uc774 \uc5b4\ub5bb\uac8c \ubcf4\uc774\ub294\uc9c0\ub97c \uc81c\uc5b4\ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Durability<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b8\ub79c\uc7ad\uc158\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \ucee4\ubc0b\ub418\uc5c8\ub2e4\uba74 \uc2dc\uc2a4\ud15c\uc5d0 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud574\ub3c4 \uacb0\uacfc\uac00 \uc720\uc9c0\ub418\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ub124 \uac00\uc9c0\ub97c \uac01\uac01 \uc774\ud574\ud558\ub294 \uac83\ubcf4\ub2e4 \uc2e4\uc81c \ub3d9\uc2dc\uc131 \ubb38\uc81c\uc640 \ud568\uaed8 \ubcf4\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ub3d9\uc2dc\uc131 \ubb38\uc81c<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \uc811\uadfc\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uc7ac\ud654\uac00 100\uc778\ub370 \ub450 \uc694\uccad\uc774 \ub3d9\uc2dc\uc5d0 100\uc744 \ucc28\uac10\ud558\ub824\uace0 \ud55c\ub2e4\uace0 \ud558\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Player Gold = 100\n\nRequest A -&gt; 100 \ud655\uc778\nRequest B -&gt; 100 \ud655\uc778\n\nA -&gt; 0 \uc800\uc7a5\nB -&gt; 0 \uc800\uc7a5\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub450 \uc694\uccad \ubaa8\ub450 100\uc744 \ud655\uc778\ud588\uae30 \ub54c\ubb38\uc5d0 \uc2e4\uc81c\ub85c\ub294 \ub450 \ubc88 \ucc28\uac10\ub418\uc5b4\uc57c \ud558\ub294 \uc0c1\ud669\uc5d0\uc11c\ub3c4 \ub370\uc774\ud130\uac00 \ud55c \ubc88\ub9cc \ubcc0\uacbd\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub7f0 \ubb38\uc81c\ub97c <strong>Race Condition<\/strong> \uad00\uc810\uc5d0\uc11c \ubcfc \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ud2b8\ub79c\uc7ad\uc158\uacfc \ub3d9\uc2dc\uc131 \uc81c\uc5b4\ub97c \ud1b5\ud574 \uc774\ub7f0 \ubb38\uc81c\ub97c \ucc98\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Isolation Level<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b8\ub79c\uc7ad\uc158 \uac04\uc758 \uaca9\ub9ac \uc218\uc900\uc744 \uc870\uc808\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub300\ud45c\uc801\uc73c\ub85c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>READ UNCOMMITTED\nREAD COMMITTED\nREPEATABLE READ\nSERIALIZABLE\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub4f1\uc774 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uaca9\ub9ac \uc218\uc900\uc774 \ub192\uc544\uc9c8\uc218\ub85d \ub2e4\ub978 \ud2b8\ub79c\uc7ad\uc158\uc758 \uc601\ud5a5\uc744 \ub354 \uac15\ud558\uac8c \uc81c\ud55c\ud560 \uc218 \uc788\uc9c0\ub9cc \uc77c\ubc18\uc801\uc73c\ub85c \ub3d9\uc2dc \ucc98\ub9ac \uc131\ub2a5\uacfc\uc758 \ud2b8\ub808\uc774\ub4dc\uc624\ud504\uac00 \uc0dd\uae34\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5b4\ub5a4 \uc218\uc900\uc774 \ubb34\uc870\uac74 \uac00\uc7a5 \uc88b\uc740 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc11c\ube44\uc2a4\uc5d0\uc11c \uc694\uad6c\ud558\ub294 \ub370\uc774\ud130 \uc77c\uad00\uc131\uacfc \uc131\ub2a5\uc744 \uae30\uc900\uc73c\ub85c \uc120\ud0dd\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Lock<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub3d9\uc2dc\uc5d0 \uac19\uc740 \ub370\uc774\ud130\ub97c \uc218\uc815\ud558\ub294 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 <strong>Lock<\/strong>\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Transaction A -&gt; Row Lock -&gt; \ub370\uc774\ud130 \uc218\uc815 -&gt; Commit -&gt; Lock \ud574\uc81c\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub978 \ud2b8\ub79c\uc7ad\uc158\uc740 \ud574\ub2f9 \ub370\uc774\ud130\uc758 \uc0c1\ud0dc\uc5d0 \ub530\ub77c \uae30\ub2e4\ub9ac\uac8c \ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc Lock\uc744 \uacfc\ub3c4\ud558\uac8c \uc0ac\uc6a9\ud558\uba74 \ub300\uae30 \uc2dc\uac04\uc774 \uc99d\uac00\ud558\uace0, \uc798\ubabb \uc124\uacc4\ud558\uba74 Deadlock\uc774 \ubc1c\uc0dd\ud560 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ubb38\uc81c\ub97c \ubcfc \ub54c \ub2e8\uc21c\ud788 &#8220;\ucffc\ub9ac\uac00 \ub290\ub9ac\ub2e4&#8221;\ub9cc \ubcf4\ub294 \uac83\uc774 \uc544\ub2c8\ub77c <strong>Lock\uc744 \uae30\ub2e4\ub9ac\uace0 \uc788\ub294\uc9c0<\/strong>\ub3c4 \ud655\uc778\ud560 \ud544\uc694\uac00 \uc788\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Deadlock<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub450 \ud2b8\ub79c\uc7ad\uc158\uc774 \uc11c\ub85c\uac00 \uac00\uc9c4 Lock\uc744 \uae30\ub2e4\ub9ac\uba74 Deadlock\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Transaction A\nLock A \ud68d\ub4dd -&gt;Lock B \ub300\uae30\n\nTransaction B  \nLock B \ud68d\ub4dd -&gt; Lock A \ub300\uae30\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub458 \ub2e4 \uc0c1\ub300\ubc29\uc774 Lock\uc744 \ud574\uc81c\ud558\uae30\ub97c \uae30\ub2e4\ub9b0\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 Deadlock\uc744 \uac10\uc9c0\ud558\uace0 \ud55c\ucabd \ud2b8\ub79c\uc7ad\uc158\uc744 \uc2e4\ud328\uc2dc\ud0a4\ub294 \ubc29\uc2dd \ub4f1\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c\ub3c4 \uc774\ub7f0 \uc2e4\ud328\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc744 \uace0\ub824\ud558\uace0 \uc801\uc808\ud55c \uc7ac\uc2dc\ub3c4 \uc815\ucc45 \ub4f1\uc744 \uc124\uacc4\ud560 \ud544\uc694\uac00 \uc788\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">NoSQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub9cc \uc788\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">NoSQL\uc740 \uad00\uacc4\ud615 \ubaa8\ub378\uacfc \ub2e4\ub978 \ubc29\uc2dd\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud1b5\uce6d\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub300\ud45c\uc801\uc778 \ud615\ud0dc\ub85c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Document\nKey-Value\nColumn Family\nGraph\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub4f1\uc774 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 Document DB\uc5d0\uc11c\ub294 JSON\uacfc \ube44\uc2b7\ud55c \ud615\ud0dc\ub85c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n  \"id\": 1,\n  \"name\": \"Alice\",\n  \"level\": 20,\n  \"items\": &#91;\n    \"sword\",\n    \"shield\"\n  ]\n}\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2a4\ud0a4\ub9c8\uac00 \uc720\uc5f0\ud558\uace0 \ud2b9\uc815 \uc870\ud68c \ud328\ud134\uc5d0 \ub9de\ucdb0 \ub370\uc774\ud130\ub97c \uad6c\uc131\ud558\uae30 \ud3b8\ud55c \uacbd\uc6b0\uac00 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubc18\uba74 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc81c\uacf5\ud558\ub294 \uac15\ud55c \uad00\uacc4 \ubaa8\ub378\uacfc \ud2b8\ub79c\uc7ad\uc158 \ud2b9\uc131\uc774 \ud544\uc694\ud55c \uc2dc\uc2a4\ud15c\uc774\ub77c\uba74 RDB\uac00 \ub354 \uc801\ud569\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">NoSQL\uc774 RDB\ubcf4\ub2e4 \ubb34\uc870\uac74 \ube60\ub974\uac70\ub098 \uc88b\uc740 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud560 \ub54c\ub294 \uc720\ud589\ubcf4\ub2e4 \ub370\uc774\ud130\uc758 \ud2b9\uc131\uc744 \uba3c\uc800 \ubcf4\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\ub370\uc774\ud130 \uad6c\uc870\ub294?\n\uad00\uacc4\uac00 \ubcf5\uc7a1\ud55c\uac00?\n\ud2b8\ub79c\uc7ad\uc158\uc774 \uc911\uc694\ud55c\uac00?\n\uc870\ud68c \ud328\ud134\uc740?\n\uc4f0\uae30\uc640 \uc77d\uae30 \ube44\uc728\uc740?\n\ub370\uc774\ud130 \uaddc\ubaa8\ub294?\n\uc218\ud3c9 \ud655\uc7a5\uc774 \ud544\uc694\ud55c\uac00?\n\uc77c\uad00\uc131\uc774 \uc5bc\ub9c8\ub098 \uc911\uc694\ud55c\uac00?\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uacb0\uc81c\ub098 \uacc4\uc815 \ub370\uc774\ud130\ucc98\ub7fc \uac15\ud55c \uc77c\uad00\uc131\uc774 \ud544\uc694\ud55c \uc601\uc5ed\uacfc \ub300\uaddc\ubaa8 \ub85c\uadf8\ucc98\ub7fc \ub2e8\uc21c\ud558\uac8c \uc313\uc774\ub294 \ub370\uc774\ud130\ub294 \uc694\uad6c\uc0ac\ud56d\uc774 \ub2e4\ub974\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ubaa8\ub4e0 \ubb38\uc81c\ub97c \ud574\uacb0\ud574\uc57c \ud55c\ub2e4\ub294 \ubc95\ub3c4 \uc5c6\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc11c\ube44\uc2a4\uc5d0 \ub530\ub77c \uc5ec\ub7ec \uc800\uc7a5\uc18c\ub97c \ud568\uaed8 \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Cache<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub9e4\ubc88 \uc9c1\uc811 \uc870\ud68c\ud558\ub294 \uac83\uc774 \ube44\ud6a8\uc728\uc801\uc778 \uacbd\uc6b0\uc5d0\ub294 \uce90\uc2dc\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub300\ud45c\uc801\uc73c\ub85c Redis \uac19\uc740 \uc778\uba54\ubaa8\ub9ac \uc800\uc7a5\uc18c\uac00 \uc0ac\uc6a9\ub41c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Application -&gt; Cache -&gt; Database\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130\ub97c \uba54\ubaa8\ub9ac\uc5d0 \uc800\uc7a5\ud574\ub450\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uae4c\uc9c0 \uc811\uadfc\ud558\ub294 \ud69f\uc218\ub97c \uc904\uc77c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uac8c\uc784\uc5d0\uc11c \uc790\uc8fc \uc870\ud68c\ub418\ub294 \ud50c\ub808\uc774\uc5b4\uc758 \uc138\uc158 \uc815\ubcf4\ub098 \ub7ad\ud0b9 \ub370\uc774\ud130\ub97c \uce90\uc2dc\uc5d0 \uc800\uc7a5\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc \uce90\uc2dc\uac00 \ucd94\uac00\ub418\uba74 \ub370\uc774\ud130\uac00 \uc5ec\ub7ec \uacf3\uc5d0 \uc874\uc7ac\ud558\uac8c \ub41c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Cache + Database\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub7ec\uba74 \ub370\uc774\ud130\uac00 \uc11c\ub85c \ub2e4\ub978 \uc0c1\ud0dc\uac00 \ub418\ub294 <strong>Cache Invalidation<\/strong> \ubb38\uc81c\uac00 \uc0dd\uae34\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uce90\uc2dc\ub294 \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \uac15\ub825\ud55c \ubc29\ubc95\uc774\uc9c0\ub9cc \uadf8\ub9cc\ud07c \uc2dc\uc2a4\ud15c\uc758 \ubcf5\uc7a1\ub3c4\ub3c4 \uc99d\uac00\ud55c\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ubcfc \ub54c<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ucffc\ub9ac\uac00 \ub290\ub9ac\ub2e4\uace0 \ud574\uc11c \ubb34\uc870\uac74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc758 \uc131\ub2a5\uc774 \ubd80\uc871\ud55c \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uba3c\uc800 \uc2e4\uc81c \ucffc\ub9ac\uac00 \uc5b4\ub5bb\uac8c \uc2e4\ud589\ub418\ub294\uc9c0\ub97c \ubd10\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub300\ud45c\uc801\uc73c\ub85c \uc2e4\ud589 \uacc4\ud68d\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>EXPLAIN\nSELECT *\nFROM Player\nWHERE email = 'alice@example.com';\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2e4\ud589 \uacc4\ud68d\uc744 \ud1b5\ud574 \uc5b4\ub5a4 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294\uc9c0, \ud14c\uc774\ube14\uc744 \uc5b4\ub5bb\uac8c \uc77d\ub294\uc9c0, JOIN\uc744 \uc5b4\ub5bb\uac8c \uc218\ud589\ud558\ub294\uc9c0 \ub4f1\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc131\ub2a5 \uac1c\uc120\uc740 \ubcf4\ud1b5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\ub290\ub9b0 \ucffc\ub9ac \ubc1c\uacac -&gt; \uc2e4\ud589 \uacc4\ud68d \ud655\uc778 -&gt; \ubcd1\ubaa9 \uc6d0\uc778 \ud655\uc778 -&gt; \uc778\ub371\uc2a4 \/ \ucffc\ub9ac \/ \uad6c\uc870 \uac1c\uc120 -&gt; \ub2e4\uc2dc \uce21\uc815\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc21c\uc11c\ub85c \uc9c4\ud589\ud558\ub294 \ud3b8\uc774 \uc88b\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uac10\uc73c\ub85c \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud558\ub294 \uac83\ubcf4\ub2e4 \uc2e4\uc81c \ucffc\ub9ac\uc640 \uce21\uc815 \uacb0\uacfc\ub97c \uae30\ubc18\uc73c\ub85c \uc218\uc815\ud558\ub294 \uac83\uc774 \ub0ab\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc124\uacc4\ud560 \ub54c<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub294 \ud14c\uc774\ube14\ubd80\ud130 \ub9cc\ub4dc\ub294 \uc791\uc5c5\uc774 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uba3c\uc800 \uc5b4\ub5a4 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uc5b4\ub5bb\uac8c \uc811\uadfc\ud560 \uac83\uc778\uc9c0\ubd80\ud130 \uc0dd\uac01\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\uc694\uad6c\uc0ac\ud56d -&gt; \ub370\uc774\ud130 \ubaa8\ub378 -&gt; \ud14c\uc774\ube14 \/ \uad00\uacc4 \uc124\uacc4 -&gt; \uc81c\uc57d\uc870\uac74 -&gt; \uc778\ub371\uc2a4 -&gt; \ucffc\ub9ac -&gt; \uc131\ub2a5 \uce21\uc815\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\ud788 \uc2e4\uc81c \uc11c\ube44\uc2a4\uc5d0\uc11c\ub294 <strong>\uc4f0\uae30\ubcf4\ub2e4 \uc77d\uae30\uac00 \ub9ce\uc740\uc9c0, \ud2b9\uc815 \ub370\uc774\ud130\ub97c \uc5b4\ub5bb\uac8c \uc870\ud68c\ud558\ub294\uc9c0<\/strong>\uac00 \uc778\ub371\uc2a4\uc640 \ud14c\uc774\ube14 \uad6c\uc870\uc5d0 \ud070 \uc601\ud5a5\uc744 \uc900\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130 \ubaa8\ub378\uacfc \ucffc\ub9ac\ub294 \uc11c\ub85c \ubd84\ub9ac\ud574\uc11c \uc0dd\uac01\ud558\uae30 \uc5b4\ub835\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uacb0\uad6d \ubcf4\ub294 \uac83<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uacf5\ubd80\ud558\uba74\uc11c \uacb0\uad6d \ubc18\ubcf5\ud574\uc11c \ub9cc\ub098\uac8c \ub418\ub294 \uac1c\ub150\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\ub370\uc774\ud130 \ubaa8\ub378\ub9c1 -&gt; \uc5b4\ub5a4 \uad6c\uc870\ub85c \uc800\uc7a5\ud560 \uac83\uc778\uac00\n\nSQL -&gt; \uc5b4\ub5bb\uac8c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uace0 \ubcc0\uacbd\ud560 \uac83\uc778\uac00\n\nIndex -&gt; \uc5b4\ub5bb\uac8c \ube60\ub974\uac8c \ucc3e\uc744 \uac83\uc778\uac00\n\nTransaction -&gt; \uc5ec\ub7ec \ubcc0\uacbd\uc744 \uc5b4\ub5bb\uac8c \ud558\ub098\uc758 \uc791\uc5c5\uc73c\ub85c \ubb36\uc744 \uac83\uc778\uac00\n\nConcurrency -&gt; \ub3d9\uc2dc\uc5d0 \uc811\uadfc\ud560 \ub54c \uc5b4\ub5bb\uac8c \uc77c\uad00\uc131\uc744 \uc720\uc9c0\ud560 \uac83\uc778\uac00\n\nReplication -&gt; \ub370\uc774\ud130\ub97c \uc5ec\ub7ec \uc11c\ubc84\uc5d0 \uc5b4\ub5bb\uac8c \ubcf5\uc81c\ud560 \uac83\uc778\uac00\n\nPartitioning -&gt; \ub9ce\uc740 \ub370\uc774\ud130\ub97c \uc5b4\ub5bb\uac8c \ub098\ub220\uc11c \uad00\ub9ac\ud560 \uac83\uc778\uac00\n\nCache -&gt; \ubc18\ubcf5\uc801\uc778 \uc870\ud68c\ub97c \uc5b4\ub5bb\uac8c \uc904\uc77c \uac83\uc778\uac00\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub2e8\uc21c\ud55c \uc800\uc7a5 \uacf5\uac04\uc774 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774 \ub370\uc774\ud130\ub97c \uc5b4\ub5bb\uac8c \uc77d\uace0 \uc4f0\ub294\uc9c0, \uc5ec\ub7ec \uc694\uccad\uc774 \ub3d9\uc2dc\uc5d0 \ub4e4\uc5b4\uc654\uc744 \ub54c \uc5b4\ub5a4 \uc0c1\ud0dc\ub97c \uc720\uc9c0\ud574\uc57c \ud558\ub294\uc9c0, \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c \ub370\uc774\ud130\ub97c \uc5b4\ub5bb\uac8c \ubcf4\uc874\ud560\uc9c0\uae4c\uc9c0 \uc5f0\uacb0\ub418\uc5b4 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uac1c\ubc1c\ud560 \ub54c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub2e8\uc21c\ud788 SELECT\uc640 INSERT\ub97c \uc0ac\uc6a9\ud558\ub294 \uc800\uc7a5\uc18c\ub85c \uc0dd\uac01\ud558\uba74 \uaddc\ubaa8\uac00 \ucee4\uc9c8\uc218\ub85d \ubb38\uc81c\uac00 \uc0dd\uae34\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ub370\uc774\ud130\uc758 \uad6c\uc870, \uc811\uadfc \ud328\ud134, \uc77c\uad00\uc131, \ub3d9\uc2dc\uc131, \uc131\ub2a5\uc744 \ud568\uaed8 \uc124\uacc4\ud558\ub294 \uac83<\/strong>\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc81c\ub300\ub85c \uc0ac\uc6a9\ud558\ub294 \ud575\uc2ec\uc774\ub77c\uace0 \ubcf4\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub2e4 \ubcf4\uba74 \uacb0\uad6d \uc800\uc7a5\ud574\uc57c \ud558\ub294 \ubb38\uc81c\uac00 \uc0dd\uae34\ub2e4. \uac8c\uc784\uc758 \ud50c\ub808\uc774\uc5b4 \uc815\ubcf4, \uc544\uc774\ud15c, \uc7ac\ud654, \uc124\uc815\uac12, \ub85c\uadf8 \uac19\uc740 \ub370\uc774\ud130\ub294 \ud504\ub85c\uadf8\ub7a8\uc774 \uc885\ub8cc\ub41c\ub2e4\uace0 \uc0ac\ub77c\uc9c0\uba74 \uc548 \ub41c\ub2e4. \uc11c\ubc84\uc5d0\uc11c\ub294 \ub3d9\uc2dc\uc5d0 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \uac19\uc740 \ub370\uc774\ud130\ub97c \uc77d\uace0 \uc218\uc815\ud558\uae30\ub3c4 \ud55c\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc774\ub7f0 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uc870\ud68c\ud558\uace0 \ubcc0\uacbd\ud558\uae30 \uc704\ud55c \uc2dc\uc2a4\ud15c\uc774\ub2e4. \ub2e8\uc21c\ud788 \ub370\uc774\ud130\ub97c \ud30c\uc77c\uc5d0 \uc800\uc7a5\ud558\ub294 \uac83\uacfc \ub2e4\ub978 \uc810\uc740 \ub9ce\uc740 \ub370\uc774\ud130\uc5d0 \ub300\ud574 \uc77c\uad00\ub41c \ubc29\uc2dd\uc73c\ub85c \uc811\uadfc\ud558\uace0, \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-1626","post","type-post","status-publish","format-standard","hentry","category-computer-science"],"_links":{"self":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/1626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1626"}],"version-history":[{"count":5,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/1626\/revisions"}],"predecessor-version":[{"id":1919,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/1626\/revisions\/1919"}],"wp:attachment":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}