{"id":476664,"date":"2023-08-09T07:31:20","date_gmt":"2023-08-09T07:31:20","guid":{"rendered":""},"modified":"2023-09-05T11:13:11","modified_gmt":"2023-09-05T11:13:11","slug":"data-manipulation-language","status":"publish","type":"wiki","link":"https:\/\/oneproxy.pro\/kr\/wiki\/data-manipulation-language\/","title":{"rendered":"\ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4"},"content":{"rendered":"<p>DML(\ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4)\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac80\uc0c9, \uc0bd\uc785, \uc218\uc815 \ubc0f \uc0ad\uc81c\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 SQL(\uad6c\uc870\uc801 \ucffc\ub9ac \uc5b8\uc5b4)\uc758 \ud558\uc704 \uc9d1\ud569\uc785\ub2c8\ub2e4. DML\uc758 \uc8fc\uc694 \ubaa9\uc801\uc740 \uad6c\uc870\ud654\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud658\uacbd \ub0b4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc870\uc791\ud560 \uc218 \uc788\ub294 \uc720\uc5f0\ud558\uace0 \ud6a8\uc728\uc801\uc778 \ubc29\ubc95\uc744 \uc81c\uacf5\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<h2>\ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4\uc758 \uc5ed\uc0ac\uc640 \uc9c4\ud654<\/h2>\n<p>\ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4\ub294 1970\ub144\ub300 SQL \uac1c\ubc1c\uc5d0\uc11c \uc720\ub798\ub418\uc5c8\uc2b5\ub2c8\ub2e4. SQL\uc740 IBM\uc758 Raymond F. Boyce\uc640 Donald D. Chamberlin\uc774 \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. \uadf8\ub4e4\uc740 1974\ub144 &quot;SEQUEL: A Structured English Query Language&quot;\ub77c\ub294 \ub17c\ubb38\uc5d0\uc11c SQL \uc5b8\uc5b4\uc758 \uc77c\ubd80\ub85c DML\uc744 \ucc98\uc74c \uc18c\uac1c\ud588\uc2b5\ub2c8\ub2e4. \uc2dc\uac04\uc774 \uc9c0\ub0a8\uc5d0 \ub530\ub77c DML\uc740 \ubc1c\uc804\ud558\uc5ec \ub2e4\uc591\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(DBMS)\uc5d0 \ub110\ub9ac \ucc44\ud0dd\ub418\uc5b4 ANSI \ubc0f ISO SQL \ud45c\uc900\uc758 \ud45c\uc900 \ubd80\ubd84\uc774 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<h2>\ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4\uc5d0 \ub300\ud55c \uc2ec\uce35 \ubd84\uc11d<\/h2>\n<p>DML \uba85\ub839\uc740 SQL\uc758 \ud575\uc2ec\uc774\uba70 \uc774\ub97c \ud1b5\ud574 \uc0ac\uc6a9\uc790\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \uc870\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. DML \ub0b4\uc758 \ub124 \uac00\uc9c0 \uae30\ubcf8 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li><strong>\uc120\ud0dd\ud558\ub2e4<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc788\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\uace0 \uac80\uc0c9\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\ub07c\uc6cc \ub123\ub2e4<\/strong>: \ud14c\uc774\ube14\uc5d0 \uc0c8 \ub808\ucf54\ub4dc\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uc5c5\ub370\uc774\ud2b8<\/strong>: \ud14c\uc774\ube14\uc758 \uae30\uc874 \ub808\ucf54\ub4dc\ub97c \uc218\uc815\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uc0ad\uc81c<\/strong>: \ud14c\uc774\ube14\uc5d0\uc11c \ub808\ucf54\ub4dc\ub97c \uc81c\uac70\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\uc774\ub7ec\ud55c \uba85\ub839, \ud2b9\ud788 UPDATE \ubc0f DELETE\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc758 \ub370\uc774\ud130\ub97c \ud06c\uac8c \ubcc0\uacbd\ud560 \uc218 \uc788\ub2e4\ub294 \uc810\uc744 \uc774\ud574\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc774\ub7ec\ud55c \uba85\ub839\uc744 \uc8fc\uc758\ud574\uc11c \uc2e4\ud589\ud558\ub294 \uac83\uc774 \uac00\uc7a5 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n<h2>\ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4\uc758 \ub0b4\ubd80 \uc791\ub3d9<\/h2>\n<p>\uae30\ubcf8\uc801\uc73c\ub85c DML\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc5d0 \uba85\ub839\uc744 \ubcf4\ub0b4\ub294 \ubc29\uc2dd\uc73c\ub85c \uc791\ub3d9\ud569\ub2c8\ub2e4. DBMS\ub294 \uc774\ub7ec\ud55c \uba85\ub839\uc744 \ud574\uc11d\ud558\uace0, \ub370\uc774\ud130\uc5d0 \ub300\ud574 \uc694\uccad\ub41c \uc791\uc5c5\uc744 \uc218\ud589\ud558\uace0, \uc694\uccad\ub41c \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\uc790\uc5d0\uac8c \ubc18\ud658\ud569\ub2c8\ub2e4. DBMS\ub294 \ub370\uc774\ud130 \uc561\uc138\uc2a4 \ubc0f \uc800\uc7a5\uc758 \ubaa8\ub4e0 \ubcf5\uc7a1\uc131\uc744 \ucc98\ub9ac\ud558\ubbc0\ub85c \uc0ac\uc6a9\uc790\ub294 \ube44\uad50\uc801 \uac04\ub2e8\ud55c \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\uc640 \uc0c1\ud638 \uc791\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc2e4\ud589 \uce21\uba74\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc740 DML \uba85\ub839\uc744 \ub450 \ub2e8\uacc4\ub85c \ucc98\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n<ol>\n<li><strong>\ucef4\ud30c\uc77c \uc2dc\uac04<\/strong>: SQL \ubb38\uc758 \uad6c\ubb38\uc744 \ud655\uc778\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ub7f0\ud0c0\uc784<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc740 SQL \ubb38\uc744 \uc2e4\ud589\ud558\uace0 \ub370\uc774\ud130 \uc870\uc791\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<h2>\ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4\uc758 \uc8fc\uc694 \ud2b9\uc9d5<\/h2>\n<p>DML\uc758 \uc911\uc694\ud55c \uae30\ub2a5 \uc911 \uc77c\ubd80\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li><strong>\uac04\ub2e8<\/strong>: DML \uba85\ub839\uc740 \uac04\ub2e8\ud558\uace0 \uc774\ud574\ud558\uae30 \uc27d\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\uc720\uc5f0\uc131<\/strong>: DML\uc740 \ub808\ucf54\ub4dc \ubc0f \uc138\ud2b8 \uc218\uc900 \ubaa8\ub450\uc5d0\uc11c \ub370\uc774\ud130 \uc870\uc791\uc744 \ud5c8\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uac15\ub825\ud55c \ub370\uc774\ud130 \ucc98\ub9ac<\/strong>: DML\uc740 \ub300\uc6a9\ub7c9 \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ub370\uc774\ud130 \uc77c\uad00\uc131<\/strong>: DML\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc5d0\uc11c \ub370\uc774\ud130\uc758 \ubb34\uacb0\uc131\uacfc \uc77c\uad00\uc131\uc744 \ubcf4\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h2>\ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4\uc758 \uc720\ud615<\/h2>\n<p>DML\uc5d0\ub294 \ub450 \uac00\uc9c0 \uc720\ud615\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li><strong>\uc808\ucc28\uc801 DML<\/strong>: \uc0ac\uc6a9\uc790\ub294 \ud544\uc694\ud55c \ub370\uc774\ud130\uc640 \uc774\ub97c \uc5bb\ub294 \ubc29\ubc95\uc744 \uc9c0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ube44\uc808\ucc28\uc801 DML<\/strong>: \uc0ac\uc6a9\uc790\ub294 \ub370\uc774\ud130\ub97c \uc5bb\ub294 \ubc29\ubc95\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uace0 \ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \uc9c0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\ub2e4\uc74c \ud45c\uc5d0\uc11c\ub294 \ub450 \uac00\uc9c0 \uc720\ud615\uc744 \ube44\uad50\ud569\ub2c8\ub2e4.<\/p>\n<table>\n<thead>\n<tr>\n<th>\ud2b9\uc9d5<\/th>\n<th>\uc808\ucc28\uc801 DML<\/th>\n<th>\ube44\uc808\ucc28\uc801 DML<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\uc0ac\uc6a9\uc758 \uc6a9\uc774\uc131<\/td>\n<td>\ub370\uc774\ud130\uac00 \uc800\uc7a5\ub418\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \uc9c0\uc2dd\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/td>\n<td>\uc0ac\uc6a9\uc790\uc5d0\uac8c \ub354 \uc26c\uc6c0, \ud544\uc694\ud55c \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc9c0\uc2dd\ub9cc \uc788\uc73c\uba74 \ub428<\/td>\n<\/tr>\n<tr>\n<td>\ub2a5\ub960<\/td>\n<td>\uc0ac\uc6a9\uc790\uac00 \uc2dc\uc2a4\ud15c\uc744 \ubcf4\ub2e4 \uad6c\uccb4\uc801\uc73c\ub85c \uc9c0\uc2dc\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \ub354\uc6b1 \ud6a8\uc728\uc801\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td>\n<td>\uc2dc\uc2a4\ud15c\uc774 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\ub294 \ucd5c\uc120\uc758 \ubc29\ubc95\uc744 \uacb0\uc815\ud574\uc57c \ud558\ubbc0\ub85c \ud6a8\uc728\uc131\uc774 \ub5a8\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td>\n<\/tr>\n<tr>\n<td>\uc608<\/td>\n<td>JOIN, WHERE \ubc0f \uae30\ud0c0 \uc720\uc0ac\ud55c \uba85\ub839\uacfc \ud568\uaed8 \uc0ac\uc6a9\ub418\ub294 SQL<\/td>\n<td>\uae30\ubcf8 SELECT \ubb38\uacfc \ud568\uaed8 \uc0ac\uc6a9\ub418\ub294 SQL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4\uc758 \uc0ac\uc6a9\ubc95, \ubb38\uc81c \ubc0f \uc194\ub8e8\uc158<\/h2>\n<p>DML\uc740 \ubcf4\uace0\uc11c\ub97c \uc704\ud55c \uac04\ub2e8\ud55c \ub370\uc774\ud130 \uac80\uc0c9\ubd80\ud130 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub0b4\uc758 \ubcf5\uc7a1\ud55c \ub370\uc774\ud130 \uc870\uc791\uc5d0 \uc774\ub974\uae30\uae4c\uc9c0 \ub2e4\uc591\ud55c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \ub110\ub9ac \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uadf8\ub7ec\ub098 DML\uc744 \ubd80\uc801\uc808\ud558\uac8c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130 \uc190\uc0c1, \ub370\uc774\ud130 \uc190\uc2e4 \ubc0f \uc131\ub2a5 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7ec\ud55c \ubb38\uc81c\ub97c \uc644\ud654\ud558\uae30 \uc704\ud55c \uba87 \uac00\uc9c0 \ubaa8\ubc94 \uc0ac\ub840\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\ud2b8\ub79c\uc7ad\uc158\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n<li>\uc6b0\ubc1c\uc801\uc778 \ub370\uc774\ud130 \uc190\uc2e4\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud574 DELETE \ubc0f UPDATE \uba85\ub839\uc758 \uc0ac\uc6a9\uc744 \uc81c\ud55c\ud569\ub2c8\ub2e4.<\/li>\n<li>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc815\uae30\uc801\uc73c\ub85c \ubc31\uc5c5\ud569\ub2c8\ub2e4.<\/li>\n<li>DML \uba85\ub839\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\ub294 \uc0ac\ub78c\uc744 \uc81c\ud55c\ud558\uae30 \uc704\ud574 \uc801\uc808\ud55c \uc0ac\uc6a9\uc790 \uad8c\ud55c\uc744 \uc801\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h2>\uc720\uc0ac\ud55c \uc5b8\uc5b4\uc640\uc758 \ube44\uad50<\/h2>\n<p>SQL\uacfc DML\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc758 \ud45c\uc900 \ub3c4\uad6c\uac00 \ub418\uc5c8\uc9c0\ub9cc \ub2e4\ub978 \uc5b8\uc5b4\ub3c4 \ub370\uc774\ud130 \uc870\uc791 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc8fc\ubaa9\ud560\ub9cc\ud55c \ub450 \uac00\uc9c0 \uc608\ub294 XML \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc6a9 XQuery\uc640 RDF \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc6a9 SPARQL\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7ec\ud55c \uc5b8\uc5b4\ub294 SQL \ubc0f DML\uacfc\ub294 \ub2e4\ub978 \ucd08\uc810\uc744 \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. XQuery\ub294 \ubb38\uc11c\uc640 \uac19\uc740 \ub370\uc774\ud130 \uad6c\uc870\uc5d0 \uc911\uc810\uc744 \ub450\uace0 SPARQL\uc740 \uc758\ubbf8 \uc6f9 \ub370\uc774\ud130\uc5d0 \uc911\uc810\uc744 \ub461\ub2c8\ub2e4. \uadf8\ub7ec\ub098 DML\uc5d0 \uc788\ub294 SELECT, INSERT, UPDATE \ubc0f DELETE \uba85\ub839\uacfc \uc720\uc0ac\ud55c \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<h2>\ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4\uc758 \ubbf8\ub798 \uc804\ub9dd<\/h2>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uacc4\uc18d\ud574\uc11c \uc815\ubcf4 \uae30\uc220\uc758 \ucd08\uc11d\uc774 \ub428\uc5d0 \ub530\ub77c DML\uc758 \uc911\uc694\uc131\uc740 \uc5ec\uc804\ud788 \uc911\uc694\ud560 \uac83\uc785\ub2c8\ub2e4. NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc0f \ube45 \ub370\uc774\ud130 \ud50c\ub7ab\ud3fc\uacfc \uac19\uc740 \uac1c\ubc1c\uc740 \uc0c8\ub85c\uc6b4 \uacfc\uc81c\uc640 \uae30\ud68c\ub97c \ucc3d\ucd9c\ud588\uc2b5\ub2c8\ub2e4. DML\uc758 \uc9c4\ud654, \ub610\ub294 \uc774\ub7ec\ud55c \ubb38\uc81c\ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4\uc758 \uac1c\ubc1c\uc740 \uc9c0\ucf1c\ubcfc \ub9cc\ud55c \ud765\ubbf8\ub85c\uc6b4 \uacf5\uac04\uc774 \ub420 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<h2>\ud504\ub85d\uc2dc \uc11c\ubc84\uc640 \ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4\uc758 \uad50\ucc28\uc810<\/h2>\n<p>\ud504\ub85d\uc2dc \uc11c\ubc84\ub294 \ub2e4\ub978 \uc11c\ubc84\uc5d0\uc11c \ub9ac\uc18c\uc2a4\ub97c \ucc3e\ub294 \ud074\ub77c\uc774\uc5b8\ud2b8 \uac04\uc758 \uc911\uac1c\uc790 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \ud504\ub85d\uc2dc \uc11c\ubc84\ub294 \ubcf8\uc9c8\uc801\uc73c\ub85c DML\uacfc \uc0c1\ud638 \uc791\uc6a9\ud558\uc9c0 \uc54a\uc9c0\ub9cc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc694\uccad\uc744 \uad00\ub9ac\ud558\uace0 \ubcf4\uc548 \ubc0f \uc775\uba85\uc131\uc744 \uc720\uc9c0\ud558\ub294 \uc5ed\ud560\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc608\ub97c \ub4e4\uc5b4, \uc5ec\ub7ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uac78\uccd0 DML \uc694\uccad \ub85c\ub4dc\uc758 \uade0\ud615\uc744 \uc720\uc9c0\ud558\uc5ec \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub3c4\ub85d \ud504\ub85d\uc2dc \uc11c\ubc84\ub97c \uad6c\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \ud504\ub85d\uc2dc \uc11c\ubc84\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc694\uccad\uc744 \ub77c\uc6b0\ud305\ud568\uc73c\ub85c\uc368 \ub370\uc774\ud130 \uc870\uc791 \ud504\ub85c\uc138\uc2a4\uc5d0 \ucd94\uac00 \uc775\uba85\uc131 \ubc0f \ubcf4\uc548 \uacc4\uce35\uc774 \ucd94\uac00\ub418\uc5b4 \uc545\uc758\uc801\uc778 \ub370\uc774\ud130 \uc870\uc791\uc758 \uc704\ud5d8\uc774 \uc904\uc5b4\ub4ed\ub2c8\ub2e4.<\/p>\n<h2>\uad00\ub828\ub41c \ub9c1\ud06c\ub4e4<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/default.asp\" target=\"_new\" rel=\"noopener nofollow\">W3Schools\uc758 SQL \ud29c\ud1a0\ub9ac\uc5bc<\/a><\/li>\n<li><a href=\"https:\/\/www.dataversity.net\/sql-foundation-data-manipulation\/\" target=\"_new\" rel=\"noopener nofollow\">SQL: \ub370\uc774\ud130 \uc870\uc791\uc758 \uae30\ucd08<\/a><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/server.102\/b14200\/statements_10002.htm\" target=\"_new\" rel=\"noopener nofollow\">Oracle\uc758 \ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4<\/a><\/li>\n<\/ul>\n<p>DML\uc744 \uc774\ud574\ud558\uace0 \uc801\uc808\ud558\uac8c \ud65c\uc6a9\ud568\uc73c\ub85c\uc368 \uad6c\uc870\ud654\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud658\uacbd \ub0b4\uc5d0\uc11c \ub370\uc774\ud130\uc640 \ud6a8\uacfc\uc801\uc73c\ub85c \uc0c1\ud638 \uc791\uc6a9\ud558\uace0 \ub370\uc774\ud130\ub97c \uc870\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 \uc810\uc810 \ub354 \ub370\uc774\ud130 \uc911\uc2ec\uc774 \ub418\ub294 \uc138\uc0c1\uc5d0\uc11c \uc911\uc694\ud55c \uae30\uc220\uc785\ub2c8\ub2e4.<\/p>","protected":false},"featured_media":476665,"menu_order":0,"template":"","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"class_list":["post-476664","wiki","type-wiki","status-publish","has-post-thumbnail","hentry"],"acf":{"faq_title":"Frequently Asked Questions about <mark>Data Manipulation Language: A Comprehensive Guide<\/mark>","faq_items":[{"question":"What is Data Manipulation Language?","answer":"<p>Data Manipulation Language (DML) is a subset of SQL (Structured Query Language) used to retrieve, insert, modify, and delete data in a database. It is primarily designed to facilitate efficient and flexible manipulation of data within a structured database environment.<\/p>"},{"question":"What is the history of Data Manipulation Language?","answer":"<p>DML originated from the development of SQL in the 1970s by Raymond F. Boyce and Donald D. Chamberlin at IBM. They first introduced DML as part of the SQL language in a 1974 paper called \"SEQUEL: A Structured English Query Language\". Since then, DML has evolved and has been widely adopted in various database management systems (DBMS), becoming a standard part of ANSI and ISO SQL standards.<\/p>"},{"question":"What are the key features of Data Manipulation Language?","answer":"<p>Key features of DML include simplicity, flexibility, powerful data handling, and data consistency. DML commands are simple and easy to understand, allow data manipulation at both record and set levels, can efficiently handle a large volume of data, and ensure the integrity and consistency of the data within the database.<\/p>"},{"question":"What are the types of Data Manipulation Language?","answer":"<p>There are two types of DML: Procedural and Non-Procedural. Procedural DML requires a user to specify what data is needed and how to get it. In contrast, Non-Procedural DML requires a user to specify what data is needed without dictating how to get it.<\/p>"},{"question":"What problems can arise from using Data Manipulation Language, and how can they be solved?","answer":"<p>Improper use of DML can result in data corruption, data loss, and performance issues. These problems can be mitigated by using transactions to ensure data integrity, limiting the use of the DELETE and UPDATE commands to prevent accidental data loss, regularly backing up the database, and applying appropriate user permissions to limit who can execute DML commands.<\/p>"},{"question":"How are proxy servers associated with Data Manipulation Language?","answer":"<p>While proxy servers don't inherently interact with DML, they can be configured to manage database requests, thereby maintaining security and anonymity. For instance, a proxy server can balance the load of DML requests across multiple databases, improving performance. Additionally, by routing database requests through a proxy server, an extra layer of security and anonymity is added to the data manipulation process.<\/p>"},{"question":"What are the future prospects for Data Manipulation Language?","answer":"<p>As databases continue to be central to information technology, DML's relevance is expected to remain significant. With the advent of NoSQL databases and Big Data platforms, there are new challenges and opportunities for DML. The evolution of DML to handle these challenges, or the development of new data manipulation languages, is an area to watch in the future.<\/p>"}]},"_links":{"self":[{"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/wiki\/476664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/wiki"}],"about":[{"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/types\/wiki"}],"version-history":[{"count":0,"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/wiki\/476664\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/media\/476665"}],"wp:attachment":[{"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/media?parent=476664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}