{"id":20480,"date":"2018-04-04T19:15:00","date_gmt":"2018-04-04T10:15:00","guid":{"rendered":"http:\/\/w3devlabs.net\/wp\/?p=20480"},"modified":"2018-03-22T20:15:43","modified_gmt":"2018-03-22T11:15:43","slug":"13-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-13-1-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"http:\/\/w3devlabs.net\/wp\/?p=20480","title":{"rendered":"13. \ub370\uc774\ud130\ubca0\uc774\uc2a4 13.1 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uce58"},"content":{"rendered":"

C\uae09 \uac1c\ubc1c\uc790\uc640 \ud568\uaed8\ud558\ub294 \ud30c\uc774\uc36c<\/h1>\n

13. \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/font><\/font><\/span><\/h1>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc704\ud0a4\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc774 \uc815\uc758\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\u201c\ub370\uc774\ud130\ubca0\uc774\uc2a4(\uc601\uc5b4: database, DB)\ub294 \uccb4\uacc4\ud654\ub41c \ub370\uc774\ud130\uc758 \ubaa8\uc784\uc774\ub2e4.[1] \uc989, \uc791\uc131\ub41c \ubaa9\ub85d\uc73c\ub85c\uc368 \uc5ec\ub7ec \uc751\uc6a9 \uc2dc\uc2a4\ud15c\ub4e4\uc758 \ud1b5\ud569\ub41c \uc815\ubcf4\ub4e4\uc744 \uc800\uc7a5\ud558\uc5ec \uc6b4\uc601\ud560 \uc218 \uc788\ub294 \uacf5\uc6a9 \ub370\uc774\ud130\ub4e4\uc758 \ubb36\uc74c\uc774\ub2e4\u201d<\/font><\/span><\/p>\n


<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub780 \uc6b0\ub9ac\uac00 \ud504\ub85c\uadf8\ub7a8\uc73c\ub85c \uc791\uc5c5\uc744 \ud560\ub54c \uba54\ubaa8\ub9ac\uc5d0 \uc788\ub294 \uc815\ubcf4\ub97c \uc800\uc7a5\ud574\uc11c \uc774\ud6c4\uc5d0\ub3c4 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\uac8c\ub054 \ud558\ub294\uac83\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\uc774\ub7ec\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c\ub294 ORACLE, MSSQL, MySQL\ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 RDBMS\ub77c\uace0 \ud574\uc11c \uad00\uacc4\ud615 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc785\ub2c8\ub2e4. \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub77c\uace0 \ud558\uba74 \uc77c\ubc18\uc801\uc73c\ub85c RDBMS\ub97c \uac00\ub9ac\ud0a4\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774\ub7ec\ud55c RDBMS\ub9d0\uace0\ub3c4 NoSQL\ud615\ud0dc\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub3c4 \uc694\uc998\uc5d0 \ub9ce\uc774\ub4e4 \uc0ac\uc6a9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. NoSQL\uc740 \ub300\uc6a9\ub7c9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc704\ud574 \uc124\uacc4\ub418\uc5c8\ub294\ub370 Hadoop, MongoDB, Cassandra\ub4f1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\uc774\ubc88 \uc7a5\uc5d0\uc11c\ub294 \ubb34\ub8cc\ub85c \ubc30\ud3ec\ub418\uace0 \uc788\uc73c\uba70 \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 MySQL\uc744 \uc811\uc18d\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uac00\uc838\uc624\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc77c\ubc18\uc801\uc73c\ub85c Query\ub97c \ud1b5\ud574\uc11c \ub370\uc774\ud130\ub97c \uc800\uc7a5 \ubc0f \uac00\uc838\uc624\ub294\ub370 \uc774\ubd80\ubd84\uc5d0 \ub300\ud574\uc11c\ub294 \ud504\ub85c\uadf8\ub798\ubc0d\uc744 \ud558\uba74\uc11c \uc544\uc8fc \uac04\ub7b5\ud558\uac8c \uc124\uba85\ud558\uace0 \ub118\uc5b4\uac00\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

13.1 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uce58<\/font><\/font><\/span><\/h2>\n

\uc5ec\uae30\uc5d0\uc11c\ub294 MySQL\uc744 \uc124\uce58\ud574\uc11c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\uc544\ub798\ub0b4\uc6a9\uc740 \uc708\ub3c4\uc6b0\uc5d0\uc11c \uc124\uce58\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uace0 \uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n

<\/span><\/p>\n

https:\/\/dev.mysql.com\/downloads\/windows\/<\/font><\/span><\/a><\/p>\n

\uc704 \ud654\uba74\uc758 \ub9c1\ud06c\ub85c \ub4e4\uc5b4\uac00\uc11c MySQL Installer\ub97c \ud074\ub9ad\ud558\uba74 \uc544\ub798\uc640 \uac19\uc740 \ud398\uc774\uc9c0\uac00 \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n

\uc704\uc758 \ud654\uba74\uc5d0\uc11c MySQL Server\ub97c \ud074\ub9ad\ud558\uc5ec \uc544\ub798\ud654\uba74\uc5d0\uc11c \ud574\ub2f9\ud558\ub294 \ud30c\uc77c\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n

<\/span><\/p>\n


<\/p>\n

32, 64\ube44\ud2b8 \uc120\ud0dd\ud574\uc11c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc73c\uc2dc\uba74 \ub429\ub2c8\ub2e4. \uc694\uc998\uc740 \ub300\ubd80\ubd84 64\ube44\ud2b8\uc774\uc9c0\ub9cc \uc708\ub3c4\uc5d0\uc11c \uc544\ub798\ud654\uba74\uc744 \ud1b5\ud574\uc11c 64\ube44\ud2b8\uc778\uc9c0 32\ube44\ud2b8\uc778\uc9c0 \ud655\uc778\ud6c4\uc5d0 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc73c\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/font><\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

\ub2e4\uc6b4\ub85c\ub4dc \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \uc704\uc640 \uac19\uc774 \ub85c\uadf8\uc778\uc744 \ud558\ub77c\uace0 \ub098\uc635\ub2c8\ub2e4. \ub85c\uadf8\uc778 \uacc4\uc815\uc774 \uc788\uc73c\uc2e0\ubd84\uc740 \ub85c\uadf8\uc778\ud558\uc2dc\uace0 \uc5c6\uc73c\uc2dc\ubd84\uc740 \ubd89\uc740\uc0c9 \uc6d0\uc548\uc5d0 \uc788\ub294 No thanks, just start my download\ub97c \ud074\ub9ad\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n","protected":false},"excerpt":{"rendered":"

C\uae09 \uac1c\ubc1c\uc790\uc640 \ud568\uaed8\ud558\ub294 \ud30c\uc774\uc36c 13. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc704\ud0a4\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc774 \uc815\uc758\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \u201c\ub370\uc774\ud130\ubca0\uc774\uc2a4(\uc601\uc5b4: database, DB)\ub294 \uccb4\uacc4\ud654\ub41c \ub370\uc774\ud130\uc758 \ubaa8\uc784\uc774\ub2e4.[1] \uc989, \uc791\uc131\ub41c \ubaa9\ub85d\uc73c\ub85c\uc368 \uc5ec\ub7ec \uc751\uc6a9 \uc2dc\uc2a4\ud15c\ub4e4\uc758 \ud1b5\ud569\ub41c \uc815\ubcf4\ub4e4\uc744 \uc800\uc7a5\ud558\uc5ec \uc6b4\uc601\ud560 \uc218 \uc788\ub294 \uacf5\uc6a9 \ub370\uc774\ud130\ub4e4\uc758 \ubb36\uc74c\uc774\ub2e4\u201d \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub780 \uc6b0\ub9ac\uac00 \ud504\ub85c\uadf8\ub7a8\uc73c\ub85c \uc791\uc5c5\uc744 \ud560\ub54c \uba54\ubaa8\ub9ac\uc5d0 \uc788\ub294 \uc815\ubcf4\ub97c \uc800\uc7a5\ud574\uc11c \uc774\ud6c4\uc5d0\ub3c4 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\uac8c\ub054 \ud558\ub294\uac83\uc785\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c\ub294 ORACLE, MSSQL, MySQL\ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 RDBMS\ub77c\uace0 … <\/p>\n

\ub354 \ubcf4\uae30 “13. \ub370\uc774\ud130\ubca0\uc774\uc2a4 13.1 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uce58”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[5836],"tags":[16211,5291,24393,5625],"class_list":["post-20480","post","type-post","status-publish","format-standard","hentry","category-5836","tag-python","tag-5291","tag-24393","tag-5625","entry"],"_links":{"self":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20480"}],"version-history":[{"count":1,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20480\/revisions"}],"predecessor-version":[{"id":20481,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20480\/revisions\/20481"}],"wp:attachment":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20480"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}