{"id":1280,"date":"2024-11-25T13:55:09","date_gmt":"2024-11-25T05:55:09","guid":{"rendered":"https:\/\/aws-oncloudai.com\/?p=1280"},"modified":"2025-05-07T17:52:23","modified_gmt":"2025-05-07T09:52:23","slug":"understanding-aws-redshift-a-comprehensive-guide","status":"publish","type":"post","link":"https:\/\/aws-oncloudai.com\/ko\/aws-redshift-\uc774\ud574\ud558\uae30-\uc885\ud569-\uac00\uc774\ub4dc\/","title":{"rendered":"AWS Redshift \uc774\ud574: \uc885\ud569 \uac00\uc774\ub4dc"},"content":{"rendered":"<p class=\"\" data-start=\"92\" data-end=\"278\">\uc624\ub298\ub0a0 \uae09\uc18d\ud788 \ubc1c\uc804\ud558\ub294<strong data-start=\"100\" data-end=\"109\">\ube45\ub370\uc774\ud130 \ubd84\uc11d<\/strong>\uc774 \ubd84\uc57c\uc5d0\uc11c \uae30\uc5c5\uc5d0\ub294 \uac15\ub825\ud558\uace0 \uc720\uc5f0\ud55c \ub3c4\uad6c\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<strong data-start=\"125\" data-end=\"141\">\ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc800\uc7a5, \uad00\ub9ac \ubc0f \ubd84\uc11d\ud569\ub2c8\ub2e4.<\/strong>.<strong data-start=\"142\" data-end=\"161\">\uc544\ub9c8\uc874 \ub808\ub4dc\uc2dc\ud504\ud2b8<\/strong> \uc774\ub294 \uc131\ub2a5\uc774 \ub9e4\uc6b0 \ub6f0\uc5b4\ub09c \uc194\ub8e8\uc158\uc785\ub2c8\ub2e4. \uadf8\uac83\uc740<strong data-start=\"182\" data-end=\"205\">\uc644\uc804 \uad00\ub9ac\ud615 PB\uae09 \ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130 \uc2a4\ud1a0\ub9ac\uc9c0 \uc11c\ube44\uc2a4<\/strong>, \uadf8\uac83\uc744 \ud1b5\ud574<strong data-start=\"209\" data-end=\"256\">\ub300\uaddc\ubaa8 \ubcd1\ub82c \ucc98\ub9ac(MPP)<\/strong> \uc774 \uc544\ud0a4\ud14d\ucc98\ub294 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ub6f0\uc5b4\ub09c \ucffc\ub9ac \uc131\ub2a5\uacfc \ud655\uc7a5\uc131\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p class=\"\" data-start=\"280\" data-end=\"391\"><strong data-start=\"280\" data-end=\"294\">\uc628\ud074\ub77c\uc6b0\ub4dc AI<\/strong> Amazon Web Services(AWS)\uc758 \uacf5\uc2dd \uc5d0\uc774\uc804\ud2b8\ub85c\uc11c, \uc774 \uae00\uc744 \ud1b5\ud574 AWS Redshift\uc758 \ud575\uc2ec \uac1c\ub150, \uc544\ud0a4\ud14d\ucc98\uc801 \uc7a5\uc810, \uc8fc\uc694 \uae30\ub2a5\uc5d0 \ub300\ud55c \uc2ec\uce35\uc801\uc778 \uc774\ud574\ub97c \uc81c\uacf5\ud558\uace0, \uc774\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub2e4\uc591\ud55c \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ucc98\ub9ac\ud558\uace0 \ube44\uc988\ub2c8\uc2a4 \uc758\uc0ac \uacb0\uc815\uc744 \uac00\uc18d\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\ub824\ub4dc\ub9bd\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h4 id=\"heading-what-is-aws-redshift\" class=\"permalink-heading\"><strong>AWS Redshift\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/strong><\/h4>\n<p class=\"\" data-start=\"423\" data-end=\"539\"><strong data-start=\"423\" data-end=\"442\">\uc544\ub9c8\uc874 \ub808\ub4dc\uc2dc\ud504\ud2b8<\/strong> Amazon Web Services\uc5d0\uc11c \uc81c\uacf5<strong data-start=\"469\" data-end=\"481\">\ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc9d5 \ud50c\ub7ab\ud3fc<\/strong>\uc0ac\uc6a9\uc790\uac00 \ub2e4\uc591\ud55c \uac83\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\ub3c4\ub85d \ud5c8\uc6a9\ud569\ub2c8\ub2e4.<strong data-start=\"490\" data-end=\"498\">\ub370\uc774\ud130 \uc18c\uc2a4<\/strong>\uc815\ubcf4\ub97c \ud1b5\ud569\ud558\uc5ec \uc218\ud589<strong data-start=\"505\" data-end=\"516\">\ubcf5\uc7a1\ud55c SQL \ucffc\ub9ac<\/strong>\ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc9d5, \ubcf4\uace0\uc11c \ubd84\uc11d, \ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4\uc640 \uac19\uc740 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc2dc\ub098\ub9ac\uc624\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/p>\n<p class=\"\" data-start=\"541\" data-end=\"672\">Redshift\uc758 \uac00\uc7a5 \uc911\uc694\ud55c \uc7a5\uc810 \uc911 \ud558\ub098\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <strong data-start=\"564\" data-end=\"581\">\ub300\uaddc\ubaa8 \ubcd1\ub82c \ucc98\ub9ac(MPP)<\/strong> \uac74\ucd95\ud559. \uc774 \uc544\ud0a4\ud14d\ucc98\ub294 \ub370\uc774\ud130\uc640 \ucffc\ub9ac \uc791\uc5c5\uc744 \ubd84\uc0b0\ud569\ub2c8\ub2e4.<strong data-start=\"600\" data-end=\"625\">\uc5ec\ub7ec \uac1c\uc758 \ucef4\ud4e8\ud305 \ub178\ub4dc<\/strong>\uac01 \ub178\ub4dc\ub294 \ub3d9\uc2dc\uc5d0 \uc791\uc5c5\uc758 \uc77c\ubd80\ub97c \ucc98\ub9ac\ud558\ubbc0\ub85c \uc131\ub2a5\uc774 \ud06c\uac8c \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<strong data-start=\"645\" data-end=\"653\">\ucffc\ub9ac \ud6a8\uc728\uc131<\/strong>, \ucc98\ub9ac\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4<strong data-start=\"658\" data-end=\"669\">PB \uc218\uc900 \ub370\uc774\ud130 \ucc98\ub9ac<\/strong>\ud544\uc694.<\/p>\n<p class=\"\" data-start=\"674\" data-end=\"815\">\uae30\uc874\uc758 \ub85c\uceec \ubc30\ud3ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ube44\uad50\ud588\uc744 \ub54c Redshift\ub294 \ub192\uc740 \uc218\uc900\uc758<strong data-start=\"701\" data-end=\"711\">\ud0c4\ub825\uc801\uc778 \ud655\uc7a5\uc131<\/strong>, \uc0ac\uc5c5 \uaddc\ubaa8\uc758 \uc131\uc7a5\uc5d0 \uc720\uc5f0\ud558\uac8c \ub300\uc751\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c Amazon S3, Amazon RDS, AWS Glue, Data Pipeline \ub4f1 AWS \uc0dd\ud0dc\uacc4\uc758 \ub2e4\uc591\ud55c \uc11c\ube44\uc2a4\uc640 \ud1b5\ud569\ud558\uc5ec \ub370\uc774\ud130 \ub808\uc774\ud06c\uc640 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uac04\uc758 \uc5f0\uacc4 \ud1b5\ud569\uc744 \ub2ec\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h4><strong>AWS Redshift\uc758 \uc8fc\uc694 \uae30\ub2a5<\/strong><\/h4>\n<p><strong>1. \ud655\uc7a5\uc131<\/strong><br \/>\nRedshift\ub97c \uc0ac\uc6a9\ud558\uba74 \uc18c\uaddc\ubaa8\ub85c \uc2dc\uc791\ud574\uc11c \ub370\uc774\ud130\uac00 \uc99d\uac00\ud568\uc5d0 \ub530\ub77c \ud655\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Redshift Spectrum\uc744 \uc0ac\uc6a9\ud558\uba74 Redshift \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub85c \ub370\uc774\ud130\ub97c \uc62e\uae30\uc9c0 \uc54a\uace0\ub3c4 Amazon S3\uc5d0\uc11c \uc5d1\uc0ac\ubc14\uc774\ud2b8 \uaddc\ubaa8\uc758 \ub370\uc774\ud130\ub97c \uc9c1\uc811 \ucffc\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>2. \uacbd\uc81c\uc801\uc774\uace0 \ud6a8\uc728\uc801<\/strong><br \/>\nAWS Redshift\ub294 \uc800\ub834\ud55c \ube44\uc6a9\uc73c\ub85c \ub192\uc740 \uc131\ub2a5\uc744 \uc81c\uacf5\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\ud558\ub294 \ub9ac\uc18c\uc2a4\uc5d0 \ub300\ud574\uc11c\ub9cc \ube44\uc6a9\uc744 \uc9c0\ubd88\ud569\ub2c8\ub2e4.<strong>\uc608\uc57d\ub41c \uc778\uc2a4\ud134\uc2a4<\/strong>\uc640 \uac19\uc740 \uae30\ub2a5\uc740 \uc608\uce21 \uac00\ub2a5\ud55c \uc791\uc5c5 \ubd80\ud558\uc5d0 \ub300\ud55c \ube44\uc6a9\uc744 \ub354\uc6b1 \uc904\uc774\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>3. \ub300\uaddc\ubaa8 \ubcd1\ub82c \ucc98\ub9ac(MPP)<\/strong><br \/>\nRedshift\ub294 \ub370\uc774\ud130\uc640 \ucffc\ub9ac \ubd80\ud558\ub97c \uc5ec\ub7ec \ub178\ub4dc\uc5d0 \ubd84\uc0b0\uc2dc\ud0b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ubcd1\ub82c \ucc98\ub9ac \ub355\ubd84\uc5d0 \ubcf5\uc7a1\ud55c \ucffc\ub9ac\uc5d0\uc11c\ub3c4 \ube60\ub974\uac8c \uacb0\uacfc\uac00 \ubc18\ud658\ub418\ubbc0\ub85c \ub370\uc774\ud130 \uc9d1\uc57d\uc801\uc778 \uc791\uc5c5\uc5d0 \uc774\uc0c1\uc801\uc785\ub2c8\ub2e4.<\/p>\n<p><strong>4. \uc5f4 \ub370\uc774\ud130 \uc800\uc7a5<\/strong><br \/>\nRedshift\ub294 \uc5f4 \ud615\uc2dd\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ubbc0\ub85c \ucffc\ub9ac \uc2e4\ud589\uc5d0 \ud544\uc694\ud55c I\/O \uc591\uc774 \uc904\uc5b4\ub4e4\uace0 \ubd84\uc11d \ucffc\ub9ac\uc758 \ud6a8\uc728\uc131\uc774 \ub9e4\uc6b0 \ub192\uc544\uc9d1\ub2c8\ub2e4. \uc774 \uc5f4 \uc800\uc7a5 \ud615\uc2dd\uc740 \uc800\uc7a5 \ubc0f \ucffc\ub9ac \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud569\ub2c8\ub2e4.<\/p>\n<p><strong>5. \ub370\uc774\ud130 \ubcf4\uc548<\/strong><br \/>\nRedshift\ub294 \uc800\uc7a5 \uc911\uc778 \ub370\uc774\ud130\uc640 \uc804\uc1a1 \uc911\uc778 \ub370\uc774\ud130\uc758 \uc554\ud638\ud654, \uc5c5\uacc4 \ud45c\uc900 \uc900\uc218, \uc561\uc138\uc2a4 \uc81c\uc5b4\ub97c \uc704\ud55c AWS Identity and Access Management(IAM)\uc640\uc758 \ud1b5\ud569\uc744 \ud3ec\ud568\ud558\uc5ec \uc5ec\ub7ec \uacc4\uce35\uc758 \ubcf4\uc548\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p><strong>6. \uc801\uc0c9\ud3b8\uc774 \uc2a4\ud399\ud2b8\ub7fc<\/strong><br \/>\nRedshift Spectrum\uc744 \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\ub97c Redshift \ud074\ub7ec\uc2a4\ud130\ub85c \uc774\ub3d9\ud558\uc9c0 \uc54a\uace0\ub3c4 Amazon S3\uc5d0\uc11c \uc9c1\uc811 \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud560 \uc218 \uc788\uc5b4 \ub370\uc774\ud130 \ub808\uc774\ud06c \uc544\ud0a4\ud14d\ucc98\ub97c \uad6c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc720\uc5f0\uc131\uc740 \ube45\ub370\uc774\ud130 \ubd84\uc11d\uc5d0 \uc774\uc0c1\uc801\uc785\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h4 id=\"heading-architecture-of-aws-redshift\" class=\"permalink-heading\"><strong>AWS Redshift \uc544\ud0a4\ud14d\ucc98 \uc124\uba85<\/strong><\/h4>\n<p class=\"\" data-start=\"1577\" data-end=\"1620\">Amazon Redshift\uc758 \uae30\ubcf8 \uc544\ud0a4\ud14d\ucc98\ub294 MPP\ub97c \uc911\uc2ec\uc73c\ub85c \uad6c\ucd95\ub418\uc5c8\uc73c\uba70 \uc5ec\ub7ec \ud575\uc2ec \uad6c\uc131 \uc694\uc18c\uac00 \ud568\uaed8 \uc791\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n<h5 data-start=\"1622\" data-end=\"1643\">\ub9ac\ub354 \ub178\ub4dc<\/h5>\n<p class=\"\" data-start=\"1644\" data-end=\"1700\">\ud074\ub77c\uc774\uc5b8\ud2b8\ub85c\ubd80\ud130 SQL \ucffc\ub9ac\ub97c \ubc1b\uc2b5\ub2c8\ub2e4.<strong data-start=\"1658\" data-end=\"1668\">\ucef4\ud30c\uc77c \uc2e4\ud589 \uacc4\ud68d<\/strong>, \uac01 \ucef4\ud4e8\ud305 \ub178\ub4dc\uc5d0 \ud558\uc704 \uc791\uc5c5\uc744 \ud560\ub2f9\ud569\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ucffc\ub9ac \uacb0\uacfc\uac00 \uc9d1\uacc4\ub418\uc5b4 \ud074\ub77c\uc774\uc5b8\ud2b8\ub85c \ubc18\ud658\ub429\ub2c8\ub2e4.<\/p>\n<h5 data-start=\"1702\" data-end=\"1725\">\ucef4\ud4e8\ud305 \ub178\ub4dc<\/h5>\n<p class=\"\" data-start=\"1726\" data-end=\"1783\">\uac01 \ucef4\ud4e8\ud305 \ub178\ub4dc\ub294 \ub370\uc774\ud130\uc758 \ud558\uc704 \uc9d1\ud569\uc744 \ucc98\ub9ac\ud569\ub2c8\ub2e4.<strong data-start=\"1742\" data-end=\"1754\">\ubcd1\ub82c\ub85c \ucffc\ub9ac \uc791\uc5c5 \uc2e4\ud589<\/strong>. \ub178\ub4dc\ub294 \uace0\uc18d \ub124\ud2b8\uc6cc\ud06c\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ub97c \uad50\ud658\ud558\uc5ec \uac15\ub825\ud55c \ucc98\ub9ac \ud074\ub7ec\uc2a4\ud130\ub97c \ud615\uc131\ud569\ub2c8\ub2e4.<\/p>\n<h5 data-start=\"1785\" data-end=\"1806\">\ub178\ub4dc \uc2ac\ub77c\uc774\uc2a4<\/h5>\n<p class=\"\" data-start=\"1807\" data-end=\"1875\">\uac01 \ucef4\ud4e8\ud305 \ub178\ub4dc\ub294 \uc5ec\ub7ec \uac1c\uc758 \uc2ac\ub77c\uc774\uc2a4\ub85c \ub098\ub258\uba70, \uac01 \uc2ac\ub77c\uc774\uc2a4\ub294 \ub3c5\ub9bd\uc801\uc778 CPU, \uba54\ubaa8\ub9ac \ubc0f \uc800\uc7a5 \ub9ac\uc18c\uc2a4\ub97c \uac16\uc2b5\ub2c8\ub2e4.<strong data-start=\"1852\" data-end=\"1866\">\ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc870\uac01\uc744 \ub3d9\uc2dc\uc5d0 \ucc98\ub9ac\ud569\ub2c8\ub2e4<\/strong>, \ud6a8\uc728\uc131\uc774 \ub354\uc6b1 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<\/p>\n<h5 data-start=\"1877\" data-end=\"1887\">\uc5f4 \ub370\uc774\ud130 \uc800\uc7a5\uc18c<\/h5>\n<p class=\"\" data-start=\"1888\" data-end=\"1964\">\ub370\uc774\ud130\ub294 Redshift\uc758 \uc5f4\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc555\ucd95 \ubc0f I\/O \ucc98\ub9ac\ub97c \ucd5c\uc801\ud654\ud569\ub2c8\ub2e4. Redshift\uac00 \uc790\ub3d9\uc73c\ub85c \uc801\uc6a9\ub429\ub2c8\ub2e4<strong data-start=\"1946\" data-end=\"1956\">\ud6a8\uc728\uc801\uc778 \uc555\ucd95 \uc54c\uace0\ub9ac\uc998<\/strong>, \uc800\uc7a5 \ud6a8\uc728\uc131\uc744 \ud5a5\uc0c1\uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h4><strong>AWS Redshift \uc791\ub3d9 \ubc29\uc2dd<\/strong><\/h4>\n<p class=\"\" data-start=\"1990\" data-end=\"2030\">Redshift\ub294 \ud45c\uc900 SQL \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub41c \ucd5c\uc2e0 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc9d5 \ub3c4\uad6c\uc785\ub2c8\ub2e4. \ucffc\ub9ac \uc2e4\ud589 \ud504\ub85c\uc138\uc2a4\uc5d0\ub294 \ub2e4\uc74c\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n<ol data-start=\"2032\" data-end=\"2147\">\n<li class=\"\" data-start=\"2032\" data-end=\"2052\">\n<p class=\"\" data-start=\"2035\" data-end=\"2052\"><strong data-start=\"2035\" data-end=\"2046\">\ud074\ub77c\uc774\uc5b8\ud2b8\uac00 \ucffc\ub9ac\ub97c \uc81c\ucd9c\ud569\ub2c8\ub2e4<\/strong>\ub9ac\ub354 \ub178\ub4dc\ub85c;<\/p>\n<\/li>\n<li class=\"\" data-start=\"2053\" data-end=\"2082\">\n<p class=\"\" data-start=\"2056\" data-end=\"2082\">\ub9ac\ub354 \ub178\ub4dc\ub294 SQL \ucffc\ub9ac\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4.<strong data-start=\"2068\" data-end=\"2081\">\ubcd1\ub82c \uc2e4\ud589 \uacc4\ud68d\uc73c\ub85c \ubcc0\ud658<\/strong>;<\/p>\n<\/li>\n<li class=\"\" data-start=\"2083\" data-end=\"2104\">\n<p class=\"\" data-start=\"2086\" data-end=\"2104\">\ud558\uc704 \uc791\uc5c5\uc740 \uac01 \ucef4\ud4e8\ud305 \ub178\ub4dc\uc758 \ub2e4\ub978 \uc2ac\ub77c\uc774\uc2a4\ub85c \uc804\uc1a1\ub429\ub2c8\ub2e4.<\/p>\n<\/li>\n<li class=\"\" data-start=\"2105\" data-end=\"2132\">\n<p class=\"\" data-start=\"2108\" data-end=\"2132\"><strong data-start=\"2108\" data-end=\"2131\">\uac01 \ub178\ub4dc\ub294 \ub370\uc774\ud130 \uc2a4\uce90\ub2dd, \ud544\ud130\ub9c1, \uacc4\uc0b0 \ub4f1\uc758 \uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/strong>;<\/p>\n<\/li>\n<li class=\"\" data-start=\"2133\" data-end=\"2147\">\n<p class=\"\" data-start=\"2136\" data-end=\"2147\">\uacb0\uacfc\ub294 \uc694\uc57d\ub418\uc5b4 \uace0\uac1d\uc5d0\uac8c \ubc18\ud658\ub429\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ol>\n<p class=\"\" data-start=\"2149\" data-end=\"2204\">Redshift\ub294 MPP \uc544\ud0a4\ud14d\ucc98 \ub355\ubd84\uc5d0 TB \ub610\ub294 PB \uc218\uc900\uc758 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\uace0 \uba87 \ubd84 \ub0b4\uc5d0 \ucffc\ub9ac \uacb0\uacfc\ub97c \ubc18\ud658\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h4>\uc77c\ubc18\uc801\uc778 \uc0ac\uc6a9 \uc2dc\ub098\ub9ac\uc624<\/h4>\n<ul>\n<li><strong>\ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4 \ubd84\uc11d<\/strong><br \/>\nTableau, Power BI, Looker \ub4f1\uc758 BI \ub3c4\uad6c\uc640 \uc6d0\ud65c\ud558\uac8c \ud1b5\ud569\ud558\uc5ec \uc2dc\uac01\uc801 \ubcf4\uace0\uc11c\uc640 \ub300\uc2dc\ubcf4\ub4dc\ub97c \ube60\ub974\uac8c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ud1b5\ud569 \ub370\uc774\ud130 \uc800\uc7a5 \ud50c\ub7ab\ud3fc<\/strong><br \/>\nAmazon RDS, \ud0c0\uc0ac \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ubc0f S3 \ub370\uc774\ud130 \ub808\uc774\ud06c\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc9d1\uacc4\ud569\ub2c8\ub2e4.<strong>\ubd84\uc11d\uc744 \uc704\ud55c \uc911\uc559 \ud50c\ub7ab\ud3fc<\/strong>.<\/li>\n<li><strong>\ube45\ub370\uc774\ud130 \ucc98\ub9ac \ubc0f \ubaa8\ub378\ub9c1<\/strong><br \/>\n\ub9c8\ucf00\ud305 \ud589\ub3d9 \ubd84\uc11d, \uc0ac\uc6a9\uc790 \ud504\ub85c\ud30c\uc77c\ub9c1 \ub4f1 \ubcf5\uc7a1\ud55c \ubd84\uc11d \ub17c\ub9ac\ub098 \ubaa8\ub378 \ud559\uc2b5\uc744 \uc2e4\ud589\ud558\ub294 \ub370 \uc801\ud569\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>ETL \ubc0f \ub370\uc774\ud130 \uc804\ucc98\ub9ac<\/strong><br \/>\nAWS Glue, Glue DataBrew \ubc0f \uae30\ud0c0 \uc11c\ube44\uc2a4\uc640 \uacb0\ud569\ud558\uc5ec \ube4c\ub4dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<strong>\uc790\ub3d9\ud654\ub41c \ub370\uc774\ud130 \ucc98\ub9ac<\/strong>(ETL \ud30c\uc774\ud504\ub77c\uc778)\uc744 \ud1b5\ud574 \ub370\uc774\ud130 \ud1b5\ud569\uacfc \uc815\ub9ac \ud6a8\uc728\uc131\uc744 \uac1c\uc120\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4>Redshift \uc0ac\uc6a9\uc744 \uc704\ud55c \ubaa8\ubc94 \uc0ac\ub840<\/h4>\n<ul>\n<li><strong>\ubc30\ud3ec \ud0a4\uc640 \uc815\ub82c \ud0a4\uc758 \uc124\uacc4 \ucd5c\uc801\ud654<\/strong>, \ucffc\ub9ac \ud6a8\uc728\uc131\uc744 \uac1c\uc120\ud558\uace0 \ub178\ub4dc \uac04 \ub370\uc774\ud130 \uc804\uc1a1\uc744 \uc904\uc785\ub2c8\ub2e4.<\/li>\n<li><strong>\uc790\ub3d9 \uc555\ucd95 \ubc0f VACUUM \uc804\ub7b5 \ud65c\uc131\ud654<\/strong>\ub370\uc774\ud130 \ud14c\uc774\ube14\uc758 \ucd5c\uc801 \uad6c\uc870\ub97c \uc720\uc9c0\ud569\ub2c8\ub2e4.<\/li>\n<li>\uad6c\uc131<strong>\uc6cc\ud06c\ub85c\ub4dc \uad00\ub9ac(WLM)<\/strong>\ucffc\ub9ac \uc6b0\uc120\uc21c\uc704\ub97c \ud569\ub9ac\uc801\uc73c\ub85c \ud560\ub2f9\ud558\uace0 \ub9ac\uc18c\uc2a4 \uacbd\ud569\uc744 \ubc29\uc9c0\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ucffc\ub9ac \uc131\ub2a5 \uc9c0\ud45c \ubaa8\ub2c8\ud130\ub9c1<\/strong>I\/O \ubd80\ud558, \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9, \ub178\ub4dc \ud65c\uc6a9\ub3c4 \ub4f1\uc744 \ud30c\uc545\ud558\uc5ec \uc0ac\uc6a9 \uacb0\uacfc\ub97c \uc9c0\uc18d\uc801\uc73c\ub85c \ucd5c\uc801\ud654\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4>\uc694\uc57d\ud558\ub2e4<\/h4>\n<p>Amazon Redshift\ub294 \ud3ec\uad04\uc801\uc774\uace0 \uace0\uc131\ub2a5\uc758 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc9d5 \uc194\ub8e8\uc158\uc785\ub2c8\ub2e4. \uadf8\uac83\uc5d0 \uadfc\uac70\ud558\uc5ec<strong>\ub300\uaddc\ubaa8 \ubcd1\ub82c \ucc98\ub9ac \uc544\ud0a4\ud14d\ucc98<\/strong>\ud6a8\uc728\uc801\uc778 \uc2e4\ud589 \uc5d4\uc9c4, \ud0c4\ub825\uc801\uc778 \ud074\ub7ec\uc2a4\ud130 \ud655\uc7a5 \uae30\ub2a5, AWS \uc0dd\ud0dc\uacc4\uc640\uc758 \uae34\ubc00\ud55c \ud1b5\ud569\uc744 \uac16\ucd98 Redshift\ub294 \ube45\ub370\uc774\ud130 \ubd84\uc11d, \ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4, \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc9d5 \ubd84\uc57c\uc5d0\uc11c \ud604\ub300 \uae30\uc5c5\uc744 \uc704\ud55c \uc911\uc694\ud55c \ud50c\ub7ab\ud3fc\uc774 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uadc0\ud558\uc758 \uae30\uc5c5\uc774 \ubc29\ub300\ud55c \ub370\uc774\ud130 \uc138\ud2b8\uc5d0\uc11c \ub354 \ub9ce\uc740 \ud1b5\ucc30\ub825\uc744 \ucd94\ucd9c\ud558\uace0 \ud6a8\uc728\uc801\uc778 \ubd84\uc11d \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud558\ub824\ub294 \uacbd\uc6b0,<strong>AWS Redshift\ub294 \ud655\uc2e4\ud788 \uc120\ud0dd\ud560 \ud575\uc2ec \ub3c4\uad6c\uc785\ub2c8\ub2e4.<\/strong>.<\/p>\n<p><strong>\uc628\ud074\ub77c\uc6b0\ub4dc AI<\/strong> \uacf5\uc2dd AWS \ud30c\ud2b8\ub108\ub85c\uc11c, \uc800\ud76c\ub294 \uace0\uac1d\uc5d0\uac8c AWS \uacc4\uc815 \uacb0\uc81c, \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc11c\ube44\uc2a4, Redshift \ubc30\ud3ec, AWS Glue \ud1b5\ud569, \ub370\uc774\ud130 \ud30c\uc774\ud504\ub77c\uc778 \uad6c\ucd95 \ub4f1\uc744 \ud3ec\ud568\ud55c \uc6d0\uc2a4\ud1b1 \ud074\ub77c\uc6b0\ub4dc \uc194\ub8e8\uc158\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc800\ud76c\uc5d0\uac8c \uc5f0\ub77d\ud558\uc5ec \ub370\uc774\ud130 \uc911\uc2ec \uc5ec\uc815\uc744 \uc2dc\uc791\ud574 \ubcf4\uc138\uc694!<\/p>","protected":false},"excerpt":{"rendered":"<p>\uc624\ub298\ub0a0 \ube60\ub974\uac8c \ubc1c\uc804\ud558\ub294 \ube45\ub370\uc774\ud130 \ubd84\uc11d \ubd84\uc57c\uc5d0\uc11c \uae30\uc5c5\uc740 \ubc29\ub300\ud55c \uc591\uc758 \ub370\uc774\ud130\ub97c \uc800\uc7a5, \uad00\ub9ac, \ubd84\uc11d\ud560 \uc218 \uc788\ub294 \uac15\ub825\ud558\uace0 \uc720\uc5f0\ud55c \ub3c4\uad6c\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. Amazon Redshift\ub294 \uc815\ub9d0 \uace0\uc131\ub2a5 \uc194\ub8e8\uc158\uc774\uc5d0\uc694. MPP(Massively Parallel Processing) \uc544\ud0a4\ud14d\ucc98\ub97c \ud1b5\ud574 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ub6f0\uc5b4\ub09c \ucffc\ub9ac \uc131\ub2a5\uacfc \ud655\uc7a5\uc131\uc744 \uc81c\uacf5\ud558\ub294 \uc644\ubcbd\ud558\uac8c \uad00\ub9ac\ub418\ub294 PB \uc218\uc900\uc758 \ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc9d5 \uc11c\ube44\uc2a4\uc785\ub2c8\ub2e4.<\/p>","protected":false},"author":1,"featured_media":1281,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-1280","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technical-sharing"],"_links":{"self":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts\/1280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/comments?post=1280"}],"version-history":[{"count":0,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts\/1280\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/media\/1281"}],"wp:attachment":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/media?parent=1280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/categories?post=1280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/tags?post=1280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}