{"id":2080,"date":"2025-01-02T15:30:00","date_gmt":"2025-01-02T07:30:00","guid":{"rendered":"https:\/\/aws-oncloudai.com\/?p=2080"},"modified":"2025-01-02T15:30:00","modified_gmt":"2025-01-02T07:30:00","slug":"srljaxdsjckdqdgj","status":"publish","type":"post","link":"https:\/\/aws-oncloudai.com\/ko\/srljaxdsjckdqdgj\/","title":{"rendered":"Amazon Redshift \uc2ec\uce35 \ubd84\uc11d: \ud604\ub300\uc801 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc9d5\uc744 \uc704\ud55c \uac15\ub825\ud55c \ub3c4\uad6c"},"content":{"rendered":"

Amazon Redshift\ub294 AWS\uc758 \uc644\uc804 \uad00\ub9ac\ud615, \ud655\uc7a5 \uac00\ub2a5\ud55c \ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc11c\ube44\uc2a4\ub85c, \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ubd84\uc11d\ud558\uace0 \ube60\ub978 \ucffc\ub9ac \uc131\ub2a5\uc744 \uc81c\uacf5\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. Redshift\ub294 \uae30\uc5c5\uc6a9 \ubcf4\uace0\uc11c \uc0dd\uc131\ubd80\ud130 \uace0\uae09 \ub370\uc774\ud130 \ubd84\uc11d \ubc0f \uba38\uc2e0 \ub7ec\ub2dd \ubaa8\ub378 \uc9c0\uc6d0\uae4c\uc9c0 \ud604\ub300\uc758 \ub370\uc774\ud130 \uc911\uc2ec \ud658\uacbd\uc5d0\uc11c \uae30\uc5c5\uc758 \ub2e4\uc591\ud55c \uc694\uad6c \uc0ac\ud56d\uc744 \ucda9\uc871\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

\ud575\uc2ec \uae30\ub2a5<\/h3>\n
    \n
  1. \uace0\uc131\ub2a5 \ucffc\ub9ac<\/strong> Amazon Redshift\ub294 \uc5f4 \uae30\ubc18 \uc2a4\ud1a0\ub9ac\uc9c0\uc640 \ub300\uaddc\ubaa8 \ubcd1\ub82c \ucc98\ub9ac(MPP) \uc544\ud0a4\ud14d\ucc98\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc0ac\uc6a9\uc790\uc5d0\uac8c \ube60\ub978 \ucffc\ub9ac \uc131\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc9c0\ub2a5\ud615 \ucffc\ub9ac \ucd5c\uc801\ud654 \ud504\ub85c\uadf8\ub7a8\uacfc \uc790\ub3d9\ud654\ub41c \uc6cc\ud06c\ub85c\ub4dc \uad00\ub9ac\ub97c \ud1b5\ud574 \ubcf5\uc7a1\ud55c \ucffc\ub9ac \uc2dc\ub098\ub9ac\uc624\uc5d0\uc11c\ub3c4 \ub192\uc740 \ud6a8\uc728\uc131\uc744 \ubcf4\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n
  2. \ud655\uc7a5\uc131 \ubc0f \uc720\uc5f0\uc131<\/strong> \uc0ac\uc6a9\uc790\ub294 \ud544\uc694\uc5d0 \ub530\ub77c \uc18c\uaddc\ubaa8 \ubc30\ud3ec\ubd80\ud130 PB \uc218\uc900\uc758 \ub370\uc774\ud130 \uc800\uc7a5\uc18c\uae4c\uc9c0 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \ud06c\uae30\ub97c \uc6d0\ud65c\ud558\uac8c \ud655\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Redshift Serverless \uc635\uc158\uc740 \ub9ac\uc18c\uc2a4 \uad00\ub9ac\ub97c \ub354\uc6b1 \uac04\uc18c\ud654\ud558\uc5ec \uc0ac\uc6a9\uc790\uac00 \uae30\ubcf8 \uc778\ud504\ub77c\uc5d0 \ub300\ud574 \uac71\uc815\ud558\uc9c0 \uc54a\uace0 \ub370\uc774\ud130\uc640 \ubd84\uc11d\uc5d0 \uc9d1\uc911\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/li>\n
  3. \ube44\uc6a9 \ud6a8\uc728\uc131<\/strong> Redshift\ub294 \uc8fc\ubb38\ud615 \uac00\uaca9\uc744 \uc81c\uacf5\ud558\uace0 \ub370\uc774\ud130 \uc555\ucd95 \ubc0f \uc790\ub3d9 \uc2a4\ub0c5\uc0f7 \uae30\ub2a5\uc744 \ud1b5\ud574 \uc800\uc7a5 \ube44\uc6a9\uc744 \uc808\uac10\ud569\ub2c8\ub2e4. \ub610\ud55c, \uc0ac\uc6a9\uc790\ub294 Redshift Spectrum\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\uc9c0 \uc54a\uace0\ub3c4 Amazon S3\uc5d0 \uc788\ub294 \ub370\uc774\ud130\ub97c \ubd84\uc11d\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc2dc\uac04\uacfc \ube44\uc6a9\uc744 \uc808\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
  4. \ub370\uc774\ud130 \ud1b5\ud569 \uae30\ub2a5<\/strong> Redshift\ub294 AWS \uc11c\ube44\uc2a4(\uc608: S3, RDS, DynamoDB) \ubc0f \ud0c0\uc0ac \ub370\uc774\ud130 \ub3c4\uad6c\ub97c \ud3ec\ud568\ud55c \ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc18c\uc2a4\uc640\uc758 \ud1b5\ud569\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ub0b4\uc7a5\ub41c ETL \uae30\ub2a5\uacfc \ud45c\uc900 SQL \uc9c0\uc6d0\uc744 \ud1b5\ud574 \uc0ac\uc6a9\uc790\ub294 \ub370\uc774\ud130 \ud1b5\ud569 \ubc0f \ubcc0\ud658\uc744 \uc27d\uac8c \uad6c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n

     <\/p>\n

    \uc77c\ubc18\uc801\uc778 \uc0ac\uc6a9 \uc2dc\ub098\ub9ac\uc624<\/h3>\n
      \n
    1. \ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4 \ubc0f \ubcf4\uace0<\/strong> \uae30\uc5c5\uc5d0\uc11c\ub294 Redshift\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc911\uc559 \uc9d1\uc911\uc2dd \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \ub9cc\ub4e4\uace0, \ub2e4\uc591\ud55c \uc2dc\uc2a4\ud15c\uc758 \ub370\uc774\ud130\ub97c \ud1b5\ud569\ud558\uace0, \uc2e4\uc2dc\uac04 \ub610\ub294 \uc8fc\uae30\uc801 \ube44\uc988\ub2c8\uc2a4 \ubcf4\uace0\uc11c\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc18c\ub9e4\uc5c5\uccb4\ub294 \ud310\ub9e4 \ucd94\uc138\ub97c \ubd84\uc11d\ud558\uace0 \uc7ac\uace0 \uad00\ub9ac\ub97c \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
    2. \uace0\uae09 \ub370\uc774\ud130 \ubd84\uc11d<\/strong> \ub370\uc774\ud130 \uacfc\ud559\uc790\uc640 \ubd84\uc11d\uac00\ub294 Redshift\uc5d0\uc11c \ubcf5\uc7a1\ud55c \ucffc\ub9ac\uc640 \ud1b5\uacc4 \ubaa8\ub378\uc744 \uc2e4\ud589\ud558\uc5ec \uc0ac\uc6a9\uc790 \ud589\ub3d9 \ubd84\uc11d, \uc608\uce21 \ubd84\uc11d, \uc2dc\uc7a5 \uc138\ubd84\ud654\ub97c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
    3. \ub370\uc774\ud130 \ub808\uc774\ud06c \ubd84\uc11d<\/strong> Redshift Spectrum\uc744 \uc0ac\uc6a9\ud558\uba74 \uc0ac\uc6a9\uc790\ub294 \ub370\uc774\ud130\ub97c \ucc3d\uace0\ub85c \uc62e\uae30\uc9c0 \uc54a\uace0\ub3c4 \ub370\uc774\ud130 \ub808\uc774\ud06c(Amazon S3)\uc5d0\uc11c \uc9c1\uc811 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\uc5b4 \uc720\uc5f0\uc131\uc774 \ub354\uc6b1 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<\/li>\n
    4. \uc2e4\uc2dc\uac04 \ubd84\uc11d \ubc0f \uba38\uc2e0 \ub7ec\ub2dd<\/strong> Amazon Kinesis\uc640 SageMaker\ub97c \ud1b5\ud569\ud568\uc73c\ub85c\uc368 Redshift\ub294 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ubd84\uc11d\uacfc \uba38\uc2e0 \ub7ec\ub2dd \ubaa8\ub378 \uad50\uc721\uc744 \uc9c0\uc6d0\ud558\uc5ec \uae30\uc5c5\uc774 \uc2dc\uc7a5 \ubcc0\ud654\uc5d0 \uc2e0\uc18d\ud558\uac8c \ub300\uc751\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n

       <\/p>\n

      \uc774\uc810 \ubc0f \ubaa8\ubc94 \uc0ac\ub840<\/h3>\n
        \n
      1. \ubcf4\uc548 \ubc0f \uaddc\uc815 \uc900\uc218<\/strong> Redshift\ub294 \uc800\uc7a5 \uc911 \ubc0f \uc804\uc1a1 \uc911 \uc554\ud638\ud654\ub97c \ud3ec\ud568\ud558\uc5ec \ud3ec\uad04\uc801\uc778 \ub370\uc774\ud130 \uc554\ud638\ud654 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc5ec\ub7ec \uaddc\uc815 \uc900\uc218 \ud45c\uc900(HIPAA, SOC 2 \ub4f1)\uacfc \ud638\ud658\ub418\uba70 \ub2e4\uc591\ud55c \uc0b0\uc5c5\uc758 \ubbfc\uac10\ud55c \ub370\uc774\ud130 \ucc98\ub9ac \uc694\uad6c \uc0ac\ud56d\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.<\/li>\n
      2. \uc131\ub2a5 \ucd5c\uc801\ud654<\/strong>\n
          \n
        • \ucffc\ub9ac \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud558\ub824\uba74 \ud30c\ud2f0\uc158 \ud0a4\uc640 \uc815\ub82c \ud0a4\ub97c \uc0ac\uc6a9\ud558\uc138\uc694.<\/li>\n
        • \uc815\uae30\uc801\uc73c\ub85c ANALYZE \ubc0f VACUUM \uba85\ub839\uc744 \uc2e4\ud589\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc815\ub9ac\ud558\uace0 \ud1b5\uacc4\ub97c \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n
        • \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \uad00\ub9ac<\/strong> Amazon CloudWatch\uc640 \ub0b4\uc7a5\ub41c \uc131\ub2a5 \ub370\uc774\ud130 \ub300\uc2dc\ubcf4\ub4dc\ub97c \ud1b5\ud574 \uc0ac\uc6a9\uc790\ub294 Redshift \ud074\ub7ec\uc2a4\ud130\uc758 \uc6b4\uc601 \uc0c1\ud0dc\ub97c \uc2e4\uc2dc\uac04\uc73c\ub85c \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0 \ub9ac\uc18c\uc2a4\ub97c \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n

          \"\"<\/p>\n

           <\/p>\n

          \uc694\uc57d\ud558\ub2e4<\/h3>\n

          Amazon Redshift\ub294 \uae30\uc5c5\uc5d0 \ub370\uc774\ud130 \uc800\uc7a5, \ucffc\ub9ac\ubd80\ud130 \ubd84\uc11d\uae4c\uc9c0 \uc6d0\uc2a4\ud1b1 \ud50c\ub7ab\ud3fc\uc744 \uc81c\uacf5\ud558\ub294 \uac15\ub825\ud55c \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc194\ub8e8\uc158\uc785\ub2c8\ub2e4. \ub6f0\uc5b4\ub09c \uc131\ub2a5, \uc720\uc5f0\uc131, \ud1b5\ud569 \uae30\ub2a5 \ub355\ubd84\uc5d0 \ucd5c\uc2e0 \ub370\uc774\ud130 \ubd84\uc11d\uc5d0 \uc774\uc0c1\uc801\uc785\ub2c8\ub2e4. \ud569\ub9ac\uc801\uc778 \uad6c\uc131\uacfc \ubaa8\ubc94 \uc0ac\ub840\ub97c \ud1b5\ud574 \uae30\uc5c5\uc740 \ub370\uc774\ud130\uc758 \uac00\uce58\ub97c \ucd5c\ub300\ud55c \ud65c\uc6a9\ud558\uace0 \ub514\uc9c0\ud138 \uc804\ud658 \ud504\ub85c\uc138\uc2a4\ub97c \uac00\uc18d\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>","protected":false},"excerpt":{"rendered":"

          Amazon Redshift\ub294 AWS\uc758 \uc644\uc804 \uad00\ub9ac\ud615, \ud655\uc7a5 \uac00\ub2a5\ud55c \ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc11c\ube44\uc2a4\ub85c, \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ubd84\uc11d\ud558\uace0 \ube60\ub978 \ucffc\ub9ac \uc131\ub2a5\uc744 \uc81c\uacf5\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. Redshift\ub294 \uae30\uc5c5\uc6a9 \ubcf4\uace0\uc11c \uc0dd\uc131\ubd80\ud130 \uace0\uae09 \ub370\uc774\ud130 \ubd84\uc11d \ubc0f \uba38\uc2e0 \ub7ec\ub2dd \ubaa8\ub378 \uc9c0\uc6d0\uae4c\uc9c0 \ud604\ub300\uc758 \ub370\uc774\ud130 \uc911\uc2ec \ud658\uacbd\uc5d0\uc11c \uae30\uc5c5\uc758 \ub2e4\uc591\ud55c \uc694\uad6c \uc0ac\ud56d\uc744 \ucda9\uc871\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>","protected":false},"author":1,"featured_media":2081,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-2080","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\/2080","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=2080"}],"version-history":[{"count":0,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts\/2080\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/media\/2081"}],"wp:attachment":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/media?parent=2080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/categories?post=2080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/tags?post=2080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}