{"id":422,"date":"2021-08-30T16:56:16","date_gmt":"2021-08-30T07:56:16","guid":{"rendered":"https:\/\/www.dkdk.info\/wpb\/?p=422"},"modified":"2021-08-30T17:02:37","modified_gmt":"2021-08-30T08:02:37","slug":"data-warehouse","status":"publish","type":"post","link":"https:\/\/www.dkdk.info\/wpb\/?p=422","title":{"rendered":"Data Warehouse"},"content":{"rendered":"

\uac1c\ub150<\/strong><\/span><\/h2>\n
\n

\uc0ac\uc6a9\uc790\uc758 \uc758\uc0ac \uacb0\uc815\uc5d0 \ub3c4\uc6c0\uc744 \uc8fc\uae30 \uc704\ud558\uc5ec\u00a0<\/span>\ubd84\uc11d \uac00\ub2a5\ud55c \ud615\ud0dc\ub85c \uc815\ubcf4\ub4e4\uc774 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \uc911\uc559 \uc800\uc7a5\uc18c<\/strong>\ub2e4. \uc815\ubcf4(data)\uc640 \ucc3d\uace0(warehouse)\uc758 \uc758\ubbf8\uac00 \ud569\uc131\ub418\uc5b4 \ub9cc\ub4e0 \uc5b4\ud718<\/span><\/span><\/p>\n

\ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4(DW)\ub294 1980\ub144\ub300 \uc911\ubc18 IBM\uc774 \uc790\uc0ac\uc758 \ud558\ub4dc\uc6e8\uc5b4\ub97c \ud310\ub9e4\ud558\uae30 \uc704\ud574 \ucc98\uc74c\uc73c\ub85c \ub3c4\uc785\ud588\ub358 \uac1c\ub150\uc73c\ub85c, IBM\uc740 \u2018<\/span>\uc815\ubcf4\ucc3d\uace0<\/strong>\u2019\uc758 \uc758\ubbf8\ub85c \uc778\ud3ec\uba54\uc774\uc158 \uc6e8\uc5b4\ud558\uc6b0\uc2a4(<\/span>Information Warehouse<\/strong>)\ub77c\ub294 \uc6a9\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc600\ub2e4.<\/span><\/span><\/p>\n

\uc774\ud6c4 \uc774 \uac1c\ub150\uc740 \ub9ce\uc740 \ud558\ub4dc\uc6e8\uc5b4, \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc0f \ud234(tool) \uacf5\uae09 \uc5c5\uccb4\ub4e4\uc5d0 \uc758\ud574 \uc774\ub860\uc801, \ud604\uc2e4\uc801\uc73c\ub85c \uc131\uc7a5\ud558\uc600\uc73c\uba70, 1980\ub144\ub300 \ud6c4\ubc18 W.H Inmon\uc5d0 \uc758\ud574 \ucd5c\ucd08\ub85c \ub370\uc774\ud130 \uc811\uadfc \uc804\ub7b5\uc73c\ub85c \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uac1c\ub150\uc744 \uc0ac\uc6a9\ud568\uc73c\ub85c\uc368 \ub9ce\uc740 \uad00\uc2ec\uacfc \uc9d1\uc911\uc744 \ubc1b\uac8c \ub418\uc5c8\ub2e4<\/span><\/span><\/p>\n

\ub370\uc774\ud130\ub294 \ud2b8\ub79c\uc7ad\uc158 \uc2dc\uc2a4\ud15c, \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4(RDMS) \ubc0f \uae30\ud0c0 \uc18c\uc2a4\ub85c\ubd80\ud130 \ubcf4\ud1b5 \uc815\uae30\uc801\uc73c\ub85c \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub85c \ub4e4\uc5b4\uac04\ub2e4. \ube44\uc988\ub2c8\uc2a4 \uc560\ub110\ub9ac\uc2a4\ud2b8, \ub370\uc774\ud130 \uc5d4\uc9c0\ub2c8\uc5b4, \ub370\uc774\ud130 \uc0ac\uc774\uc5b8\ud2f0\uc2a4\ud2b8\ub4e4\uc740 \ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4(BI) \ub3c4\uad6c, SQL \ud074\ub77c\uc774\uc5b8\ud2b8 \ubc0f \uae30\ud0c0 \ubd84\uc11d \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc744 \ud1b5\ud574 \ub370\uc774\ud130\uc5d0 \uc561\uc138\uc2a4\ud558\uac8c \ub41c\ub2e4.<\/span><\/span><\/p>\n

    \n
  • \uc8fc\uc81c \uc911\uc2ec\uc758 \uad6c\uc131<\/span>\n
      \n
    • \uc774\uc6a9\uc790\uac00 \uc774\ud574\ud558\uae30 \uc26c\uc6b4 \ud615\ud0dc\ub85c \uc8fc\uc81c \uc9c0\ud5a5\uc131\uc744 \uac00\uc9d0<\/span><\/li>\n<\/ul>\n<\/li>\n
    • \ud1b5\ud569\ub41c \uad6c\uc870<\/span>\n
        \n
      • \ub370\uc774\ud130 \uc18d\uc131\uc758 \uc774\ub984, \ucf54\ub4dc\uc758 \uad6c\uc870, \ub3c4\ub7c9\ud615 \ub2e8\uc704 \ub4f1\uc758\u00a0<\/span>\uc77c\uad00\uc131\uc744 \uc720\uc9c0\ud558\uba70 \uc804\uc0ac\uc801 \uad00\uc810\uc5d0\uc11c \ud558\ub098\ub85c\u00a0<\/span>\ud1b5\ud569\ud568<\/span><\/li>\n<\/ul>\n<\/li>\n
      • \uc2dc\uacc4\uc5f4<\/span>\n
          \n
        • \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4(DW)\ub294 \uc77c\uc815 \uae30\uac04 \uc218\uc9d1\ub41c \ub370\uc774\ud130\ub97c \uac31\uc2e0 \uc5c6\uc774 \ubcf4\uad00\ud558\uba70 \uc77c, \uc6d4, \ubd84\uae30, \ub144 \ub4f1\uacfc \uac19\uc740 \uae30\uac04 \uad00\ub828 \uc815\ubcf4\ub97c \ud568\uaed8 \uc800\uc7a5\ud568<\/span><\/li>\n<\/ul>\n<\/li>\n
        • \ube44\ud718\ubc1c\uc131<\/span>\n
            \n
          • \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4(DW) \ub0b4\uc758 \ub370\uc774\ud130\ub294 \uc77c\ub2e8 \uc801\uc7ac(loading)\uac00 \uc644\ub8cc\ub418\uba74 \uc77d\uae30 \uc804\uc6a9 \ud615\ud0dc\uc758 \uc2a4\ub0c5 \uc0f7 \ub370\uc774\ud130\ub85c \uc874\uc7ac\ud558\uba70, \ub354 \uc774\uc0c1 \uc5c5\ub370\uc774\ud2b8 \uc791\uc5c5\uc774 \uc77c\uc5b4\ub098\uc9c0 \uc54a\uc74c<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

            RDBMS \uc640 \ucc28\uc774<\/span><\/strong><\/span><\/h4>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
            <\/th>\nRDBMS<\/strong><\/span><\/th>\ndata warehouse<\/strong><\/span><\/th>\n<\/tr>\n
            \uc6a9\ub3c4<\/strong><\/span><\/td>\nOLTP(\uc628\ub77c\uc778 \ud2b8\ub79c\uc7ad\uc158) \uc6cc\ud06c\ub85c\ub4dc<\/span><\/td>\n\uc758\uc0ac\uacb0\uc815 \ubc0f \ubd84\uc11d<\/span><\/td>\n<\/tr>\n
            \ub370\uc774\ud130 \ud615\ud0dc<\/strong><\/span><\/td>\n\uae30\ub2a5\ubcc4 \uc0c1\uc138 \ub370\uc774\ud130<\/span><\/td>\n\uc8fc\uc81c\ubcc4 \uc694\uc57d \ub370\uc774\ud130<\/span><\/td>\n<\/tr>\n
            \ub370\uc774\ud130 \ucc98\ub9ac<\/strong><\/span><\/td>\nCRUD<\/span><\/td>\nread only<\/span><\/td>\n<\/tr>\n
            \ubaa9\uc801<\/strong><\/span><\/td>\n\ub2e8\uc77c \ud589 \ud2b8\ub79c\uc7ad\uc158 \ucc98\ub9ac<\/span><\/td>\n\ub300\uc6a9\ub7c9 \ub370\uc774\ud130 \uc14b\uc744 \ub300\uc0c1\uc73c\ub85c \ubcf5\ud569\uc801\uc778 \ubd84\uc11d \ucffc\ub9ac\ub97c \ube60\ub974\uac8c \uc2e4\ud589<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

            ETL (Extract, Transform, Load)<\/strong><\/span><\/h4>\n

            \uc6d0\uc2dc \ub370\uc774\ud130 \ud639\uc740 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud558\uc5ec \uc815\uc81c\ud55c \ud6c4\uc5d0 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0 \uc801\uc7ac\ud558\ub294 \ubaa8\ub4e0 \uacfc\uc815\uc744 \ub9d0\ud568<\/span><\/p>\n

            \uc77c\ubc18\uc801\uc73c\ub85c \ub370\uc774\ud130 \uc815\uc81c(\ubcc0\ud658)\uc5d0\ub294 \ud544\ud130\ub9c1, \uc815\ub82c, \uc9d1\uacc4, \ub370\uc774\ud130 \uc870\uc778, \ub370\uc774\ud130 \uc815\ub9ac, \uc911\ubcf5 \uc81c\uac70 \ubc0f \uc720\ud6a8\uc131 \uac80\uc0ac \ub4f1\uc758 \ub2e4\uc591\ud55c \uc791\uc5c5\uc774 \ud3ec\ud568\ub428<\/span><\/p>\n

              \n
            • Extract : \ud558\ub098 \ub610\ub294 \uc5ec\ub7ff \ub370\uc774\ud130 \uc18c\uc2a4\ub85c\ubd80\ud130 \ub370\uc774\ud130 \ucd94\ucd9c<\/span><\/li>\n
            • Transform : \ub370\uc774\ud130 \ud074\ub80c\uc9d5, \ud615\uc2dd \ubcc0\ud658 \ubc0f \ud45c\uc900\ud654, \ud1b5\ud569 \ub610\ub294 \ub2e4\uc218 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \ub0b4\uc7a5\ub41c \ube44\uc988\ub2c8\uc2a4\ub8f0 \uc801\uc6a9 \ub4f1<\/span><\/span><\/li>\n
            • Load : \uc815\uc81c \uc644\ub8cc\ub41c \ub370\uc774\ud130\ub97c \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc2dc\uc2a4\ud15c\uc5d0 \uc801\uc7ac<\/span><\/li>\n<\/ul>\n

              BI (Business Intelligence)<\/strong><\/span><\/h4>\n

              \ub370\uc774\ud130 \ucd94\ucd9c\/\ud1b5\ud569\/\ub9ac\ud3ec\ud305\uc744 \uc704\ud55c \uae30\ubcf8\ub3c4\uad6c \uc9d1\ud569. DW \uc5d0\uc11c \ubd84\uc11d\ub41c \ub370\uc774\ud130\ub97c \ud1b5\ud574 \uc228\uaca8\uc9c4 \ud328\ud134\uc744 \ucc3e\uc544\ub0c4<\/span><\/p>\n

              \uc544\ud0a4\ud14d\ucc98<\/strong><\/span><\/h2>\n
              \n

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

              DW (Data Warehouse) \uc758 \uc544\ud0a4\ud14d\ucc98\ub294 3\ub2e8\uacc4\uc758 \ud2f0\uc5b4\ub85c \uad6c\uc131\ub428<\/span><\/p>\n

                \n
              • Top Tier : \ud1b5\uacc4, \ubd84\uc11d, \ub370\uc774\ud130\ub9c8\uc774\ub2dd, AI \ub4f1\uc744 \ud1b5\ud574 \ubd84\uc11d\ud55c \uacb0\uacfc\ub97c \ub9ac\ud3ec\ud305\ud558\ub294 \ud504\ub860\ud2b8\uc5d4\ub4dc \ud2f0\uc5b4. \uac00\uc2dc\uc131(\uc2dc\uac01\ud654)\ub97c \uc81c\uacf5\ud558\ub294 \ud2f0\uc5b4. OLAP \ub3c4\uad6c\uc5d0 \ud574\ub2f9<\/span><\/li>\n
              • Middle Tier : \ub370\uc774\ud130\ub97c \uc561\uc138\uc2a4\ud558\uace0 \ubd84\uc11d\ud558\ub294\ub370 \uc0ac\uc6a9\ud558\ub294 \ubd84\uc11d \uc5d4\uc9c4\uc73c\ub85c \uad6c\uc131. OLAP \uc11c\ubc84\uc5d0 \ud574\ub2f9.<\/span><\/li>\n
              • Bottom Tier : \ub370\uc774\ud130\uac00 \ub85c\ub4dc\ub418\uace0 \uc800\uc7a5\ub418\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \ud2f0\uc5b4.<\/span><\/li>\n<\/ul>\n

                OLAP (On-Line Analytical Processing)<\/strong><\/span><\/h4>\n

                \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \ud65c\uc6a9 \uc218\ub2e8\uc758 \ud1b5\uce6d<\/span><\/p>\n

                BI (Business Intelligence) \uc758 \ud55c \ubd84\uc57c\ub85c \ucd5c\uc885 \uc0ac\uc6a9\uc790\uac00 \uc815\ubcf4\uc5d0 \uc9c1\uc811 \uc811\uadfc\ud574 \ub300\ud654\uc2dd\uc73c\ub85c \uc815\ubcf4\ub97c \ubd84\uc11d\ud558\uace0 \uc758\uc0ac\uacb0\uc815\uc5d0 \ud65c\uc6a9\ud558\ub294 \uacfc\uc815\uc744 \ub9d0\ud568<\/span><\/p>\n

                  \n
                • MOLAP (Multi-dimensional OLAP) : MDB(\ub2e4\ucc28\uc6d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4) \ub97c \ubca0\uc774\uc2a4\ub85c\ud568<\/span><\/li>\n
                • ROLAP (Relational OLAP) : RDB(\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4) \ub97c \ubca0\uc774\uc2a4\ub85c\ud568<\/span><\/li>\n<\/ul>\n

                  OLTP (On-Line Transaction Processing)<\/strong><\/span><\/h4>\n

                  \ud2b8\ub79c\uc7ad\uc158\uc744 \uc218\uc9d1\ud558\uace0 \ubd84\ub958, \uc800\uc7a5, \uc720\uc9c0\ubcf4\uc218, \uac31\uc2e0, \uac80\uc0c9\ud558\ub294 \uae30\ub2a5\uc744 \uc218\ud589\ud558\ub294 \uc2e4\uc2dc\uac04 \uac70\ub798 \ucc98\ub9ac \uc2dc\uc2a4\ud15c\uc73c\ub85c, \ud56d\uacf5\uc0ac\uc758 \uc608\uc57d\uc2dc\uc2a4\ud15c\uc774\ub098 \uc740\ud589\uc758 \ucc3d\uad6c\uc5c5\ubb34\uc2dc\uc2a4\ud15c \ub4f1\uc774 \ub300\ud45c\uc801\uc774\ub2e4.<\/span><\/p>\n

                  OLTP \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud558\uc5ec \uc815\uc81c\ud55c \uac83\uc774 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc774\uba70, \uc774\ub97c \ud65c\uc6a9\ud558\ub294 \uc218\ub2e8\uc774 OLAP \uc774\ub2e4.<\/span><\/p>\n

                  Data Mart<\/strong><\/span><\/h4>\n

                  \uae08\uc735, \ub9c8\ucf00\ud305 \ub610\ub294 \ud2b9\uc815\ud300, \uc0ac\uc5c5 \ub2e8\uc704\uc758 \uc694\uad6c\ub97c \ucda9\uc871\uc2dc\ud0a4\ub294 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4.<\/span><\/p>\n

                  \uaddc\ubaa8\uac00 \ub354 \uc791\uace0, \uc9d1\uc911\uc801\uc774\uba70 \uc0ac\uc6a9\uc790 \ucee4\ubba4\ub2c8\ud2f0\uc5d0 \uac00\uc7a5 \uc54c\ub9de\ub294 \ub370\uc774\ud130 \uc694\uc57d\uc744 \ud3ec\ud568\ud560 \uc218 \uc788\uc74c<\/span><\/p>\n

                  \ub300\uac1c \ub370\uc774\ud130 \ub9c8\ud2b8\ub294 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \uc77c\ubd80\ub85c \uad6c\uc131\ub428<\/span><\/p>\n

                  \uc8fc\uc694 Data Warehouse \uc11c\ube44\uc2a4<\/span><\/strong><\/span><\/h2>\n
                  \n

                  Amazon Redshift<\/strong><\/span><\/h4>\n

                  Amazon Redshift\ub294 AWS \uc5d0\uc11c \uc11c\ube44\uc2a4\ud558\ub294 \ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc774\ub2e4.<\/span><\/span><\/p>\n

                  \ub370\uc774\ud130 \uc791\uc5c5\uc744 \ube60\ub974\uace0 \uac04\ub2e8\ud558\uac8c \uc218\ud589\ud558\uace0, AWS \uc5d0\ucf54\uc2dc\uc2a4\ud15c\uc5d0 \uc190\uc27d\uac8c \uc5f0\uacb0\ud560 \uc218 \uc788\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/span><\/p>\n

                  \ub370\uc774\ud130 Load\/Unload<\/strong><\/span><\/p>\n

                    \n
                  • Load<\/span>\n
                      \n
                    • S3 : \ubcd1\ub82c \ub370\uc774\ud130 \ub85c\ub529(Multipart Upload) \uc744 \uc9c0\uc6d0<\/span><\/li>\n
                    • DynamoDB : Copy \uba85\ub839\uc5b4\ub97c \ud1b5\ud574 DynamoDB Table \ub85c \ub85c\ub529<\/span><\/li>\n
                    • EMR : Copy \uba85\ub839\uc5b4\ub97c \ud1b5\ud574 \ubcd1\ub82c \ub85c\ub529 \uc9c0\uc6d0<\/span><\/li>\n
                    • Remote \ud638\uc2a4\ud2b8(\uc628\ud504\ub808\ubbf8\uc2a4) : EC2 \ub4f1\uc758 \ud638\uc2a4\ud2b8\uc5d0\uc11c \ubcf5\uc218 \uc5f0\uacb0 \ud6c4\uc5d0, \ubcd1\ub82c \ub85c\ub529 \uc9c0\uc6d0<\/span><\/li>\n<\/ul>\n<\/li>\n
                    • Unload<\/span>\n
                        \n
                      • S3 \ub85c \uc99d\ubd84 \ubc31\uc5c5 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\uc74c<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                        \uceec\ub7fc \uc555\ucd95(Column Compression)<\/strong><\/span><\/p>\n

                          \n
                        • DW \uc2dc\uc2a4\ud15c\uc774 \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc77d\ub294 \ud06c\uae30\ub97c \uc904\uc5ec\u00a0<\/span>IO \ucd5c\uc18c\ud654 \uc2dc\ud0a4\uace0, \ucffc\ub9ac \uc131\ub2a5\uc744 \ud5a5\uc0c1<\/strong>\u00a0\uc2dc\ud0a4\ub294 \uc8fc\uc694 \uae30\ub2a5<\/span><\/span><\/li>\n
                        • COPY \uba85\ub839\uc744 \uc0ac\uc6a9\ud574\uc11c Amazon Redshift\ub85c \ub370\uc774\ud130\ub97c \ub85c\ub529\ud558\uba74 \ub370\uc774\ud130 \ubd84\uc11d\uc744 \ud1b5\ud574 \ucd5c\uc801\uc758 \uc555\ucd95 \uc218\ud589<\/span><\/li>\n
                        • \uc555\ucd95 \uae30\ub2a5\uc758 \uc790\ub3d9 \uc801\uc6a9\uc744 \uc704\ud574 COPY \uba85\ub839\uc5b4 \uc0ac\uc6a9\uc744 \uad8c\uc7a5<\/span><\/li>\n<\/ul>\n

                          \ub370\uc774\ud130 \ubd84\uc0b0(Data Distribution)<\/strong><\/span><\/p>\n

                          Redshift\ub294 \ubd84\uc0b0\ud615(MPP : Massively Parallel Computer<\/span>) \uad6c\uc870\uc758 \uc2dc\uc2a4\ud15c\uc774\ub2e4.<\/span><\/p>\n

                            \n
                          • \ud074\ub7ec\uc2a4\ud130\ub294 Leader node \uc640 Compute node \ucd5c\uc18c 2\uac1c\uc758 \ub178\ub4dc\ub85c \uad6c\uc131\ub428<\/span><\/li>\n
                          • Compute node\ub294 \ud558\ub098 \uc774\uc0c1\uc758 slices\ub85c \uad6c\uc131<\/span><\/li>\n
                          • \uac01 slices \ub294 \ub370\uc774\ud130\ub97c \ud3ec\ud568<\/span><\/li>\n<\/ul>\n

                            \ucffc\ub9ac\ub294 \ubaa8\ub4e0 slices \ub4e4\uc5d0\uc11c \ubcd1\ub82c \uc218\ud589\ud558\uc5ec \ub370\uc774\ud130\ub97c \uace0\ub974\uac8c \ubd84\uc0b0\ud568<\/span><\/p>\n

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

                              \n
                            • DISTKEY(Distribution key)<\/span>\n
                                \n
                              • \uba85\uc2dc\uc801\uc73c\ub85c \uc9c0\uc815\ud55c \uceec\ub7fc\uc744 \uae30\uc900\uc73c\ub85c \uac01 \ub808\ucf54\ub4dc\uc758 slice \ubc30\uce58\uac00 \uacb0\uc815\ub428<\/span><\/li>\n
                              • \uceec\ub7fc \uce74\ub514\ub110\ub9ac\ud2f0\uc5d0 \ub530\ub77c slice\uac04 \uc0c1\ub2f9\ud55c \ud3b8\ucc28\uac00 \ubc1c\uc0dd \uac00\ub2a5\ud568 (* \uceec\ub7fc \uce74\ub514\ub110\ub9ac\ud2f0 : \uc804\uccb4 \ud589\uc5d0 \ub300\ud55c \ud2b9\uc815 \uceec\ub7fc\uc758 \uc911\ubcf5 \uc218\uce58)<\/span><\/em><\/span><\/li>\n<\/ul>\n<\/li>\n
                              • ALL<\/span><\/span>\n
                                  \n
                                • \ubaa8\ub4e0 \ub808\ucf54\ub4dc\uac00 \uac01 \ucef4\ud4e8\ud305 \ub178\ub4dc\uc5d0 \ub3d9\uc77c\ud558\uac8c \ubcf5\uc81c\ud568<\/span><\/span><\/li>\n<\/ul>\n<\/li>\n
                                • EVEN<\/span><\/span>\n
                                    \n
                                  • \uac01 \ub808\ucf54\ub4dc\uac00 slice \uc5d0 \ub77c\uc6b4\ub4dc \ub85c\ube48 \ubc29\uc2dd\uc73c\ub85c \uade0\ub4f1\ud558\uac8c \uc800\uc7a5\ud568<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                                    Spectrum \uae30\ub2a5<\/strong><\/span><\/p>\n

                                    \ub370\uc774\ud130\ub97c Redshift \uc5d0 \uc801\uc7ac\ud558\uc9c0 \uc54a\uace0 S3 \ub0b4\uc5d0 \uc788\ub294 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \uc9c1\uc811 \ucffc\ub9ac\ud560 \uc218 \uc788\ub294 \uae30\ub2a5<\/span><\/p>\n

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

                                      \n
                                    • Athena \uc640 \uc720\uc0ac\ud558\uac8c \uc18c\uc2a4 \ub370\uc774\ud130\uc5d0 \ub300\ud574 \uc9c1\uc811 SQL \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\uc74c<\/span><\/li>\n
                                    • Athena\uc640 Redshift\ub294 \uacf5\ud1b5 \ub370\uc774\ud130 \uce74\ud0c8\ub85c\uadf8\uc640 \uacf5\ud1b5 \ub370\uc774\ud130 \ud615\uc2dd\uc744 \uacf5\uc720\ud558\ubbc0\ub85c \ub3d9\uc77c\ud55c \ub370\uc774\ud130 \uc790\uc0b0\uc5d0 \ub300\ud574 Athena \ubc0f Redshift Spectrum\uc744 \ubaa8\ub450 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc74c.<\/span><\/li>\n<\/ul>\n

                                      \ub370\uc774\ud130 \uc815\ub82c(Sorting Data) \uc640 Zone Maps<\/strong><\/span><\/p>\n

                                        \n
                                      • slices \ub0b4\uc5d0\uc11c \ub370\uc774\ud130\ub294 sort key \ub97c \uae30\ubc18\uc73c\ub85c \uc815\ub82c\ub428<\/span><\/li>\n
                                      • \ube48\ub3c4 \uc218\uac00 \ub192\uc740 \ucffc\ub9ac\uc5d0\uc11c sort key \ub85c \uc0ac\uc6a9\ud560 \uac83\uc744 \uc9c0\uc815<\/span><\/li>\n
                                      • sort key \ub97c \uc801\uc6a9\ud558\uba74 Redshift \uac00 \uc804\uccb4 \ube14\ub85d\uc744 \uc77d\ub294 \uac83\uc744 \ubc29\uc9c0\ud560 \uc218 \uc788\uc74c<\/span><\/li>\n<\/ul>\n

                                        \ubc31\uc5c5 \ubc0f \ubcf5\uad6c<\/strong><\/span><\/p>\n

                                        S3 \uc5d0 \uc790\ub3d9\uc73c\ub85c \uc99d\ubd84 \ubc31\uc5c5 \ub370\uc774\ud130\ub97c \uc800\uc7a5<\/span><\/p>\n

                                          \n
                                        • \uc2dc\uc2a4\ud15c \uc2a4\ub0c5\uc0f7 \uc720\uc9c0 \uae30\uac04\uc744 \uc124\uc815 \uac00\ub2a5 : 1~35\uc77c<\/span><\/li>\n
                                        • \uc0ac\uc6a9\uc790\uac00 \uc218\ub3d9\uc73c\ub85c \uc2a4\ub0c5\uc0f7 \uc0dd\uc131 \uac00\ub2a5<\/span><\/li>\n
                                        • Streaming restore \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud558\uc5ec, \ud074\ub7ec\uc2a4\ud130\uac00 \ub9cc\ub4e4\uc5b4\uc9c0\uba74 \uc989\uc2dc \ucffc\ub9ac \uc218\ud589 \uac00\ub2a5<\/span><\/li>\n<\/ul>\n

                                          \uc2a4\ub0c5\uc0f7\uc5d0\uc11c \uc804\uccb4 \ud074\ub7ec\uc2a4\ud130 \ub610\ub294 \ud2b9\uc815 Table \ubcf5\uc6d0 \uac00\ub2a5<\/span><\/p>\n

                                            \n
                                          • \ub178\ub4dc\uc758 \uc790\ub3d9 \ubcf5\uad6c \uae30\ub2a5 \uc81c\uacf5<\/span><\/li>\n
                                          • \uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130\ub97c \uc6b0\uc120\uc73c\ub85c \ubcf5\uad6c\ud568<\/span><\/li>\n<\/ul>\n

                                            \uc5c5\uadf8\ub808\uc774\ub4dc \ubc0f \ud655\uc7a5<\/strong><\/span><\/p>\n

                                              \n
                                            • \ud074\ub7ec\uc2a4\ud130 \uac00\ub3d9 \uc911\uc5d0 resizing \uc2e4\ud589 \uac00\ub2a5 (\uc77d\uae30 \uc804\uc6a9 \ubaa8\ub4dc\ub85c \uc804\ud658\ub428)<\/span><\/li>\n
                                            • \ubc31\uadf8\ub77c\uc6b4\ub4dc\uc5d0\uc11c \uc0c8\ub85c\uc6b4 \ud074\ub7ec\uc2a4\ud130\ub97c \ud504\ub85c\ube44\uc800\ub2dd\ud568<\/span><\/li>\n
                                            • \ub178\ub4dc \uac04\uc5d0 \ubcd1\ub82c\ub85c \ub370\uc774\ud130\ub97c \ubcf5\uc81c\ud568<\/span><\/li>\n
                                            • \uc18c\uc2a4 \ud074\ub7ec\uc2a4\ud130\uc5d0 \ub300\ud55c \ube44\uc6a9\ub9cc \ubc1c\uc0dd\ub428<\/span><\/li>\n<\/ul>\n

                                              \ud1b5\ud569 \ucffc\ub9ac<\/strong><\/span><\/p>\n

                                              Amazon RDS \uc5d0 \ub300\ud55c \ud1b5\ud569 \ucffc\ub9ac \uc9c0\uc6d0<\/span><\/p>\n

                                              \uc0ac\uc6a9\uc790 \uc815\uc758 \ud568\uc218 (UDF)<\/strong><\/span><\/p>\n

                                              SQL \ub610\ub294 Python \uc73c\ub85c UDF\ub97c \uc791\uc131\ud560 \uc218 \uc788\uc74c<\/span><\/p>\n

                                              Lambda UDF \uc9c0\uc6d0<\/span><\/p>\n

                                                \n
                                              • Lambda \ud568\uc218\ub97c UDF \ub85c \ub4f1\ub85d\ud558\uace0 Redshift SQL \ucffc\ub9ac\uc5d0\uc11c UDF \ub97c \ud638\ucd9c\ud560 \uc218 \uc788\uc74c<\/span><\/li>\n
                                              • \ud568\uc218 \ub0b4\uc5d0 \uac15\ub825\ud55c \uc791\uc5c5 \ub4f1\uc744 \ud3ec\ud568\ud558\uc5ec \uc678\ubd80 \uc11c\ube44\uc2a4\uc640 \ud1b5\ud569\ud560 \uc218 \uc788\uc74c<\/span><\/li>\n
                                              • Lambda \uac00 \uc9c0\uc6d0\ud558\ub294 \ubaa8\ub4e0 \uc5b8\uc5b4 \ubc0f SELECT, UPDATE, INSERT, DELETE \ub4f1\uc758 SQL \ubb38\uacfc \uc2a4\uce7c\ub77c \ud568\uc218\uac00 \ud5c8\uc6a9\ub418\ub294 SQL \ubb38\uc5d0\uc11c Lambda UDF\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc74c<\/span><\/li>\n<\/ul>\n

                                                \uce90\uc2f1<\/span><\/strong><\/span><\/p>\n

                                                \ucffc\ub9ac \ubc0f \uacb0\uacfc\ub97c \uce90\uc2f1\ud568<\/span><\/p>\n

                                                \uc2a4\ud2b8\ub9ac\ubc0d<\/span><\/strong><\/span><\/p>\n

                                                \uae30\ubcf8 \uc2a4\ud2b8\ub9ac\ubc0d \uae30\ub2a5\uc740 \uc5c6\uc73c\uba70, Kinesis Firehose \uc640 \uac19\uc740 AWS \uc11c\ube44\uc2a4\uc640 \ud1b5\ud569\uc774 \ud544\uc694\ud568<\/span><\/span><\/p>\n

                                                Google BigQuery<\/strong><\/span><\/h4>\n

                                                Google Cloud Platform \uc758 \uc790\uccb4 \ub370\uc774\ud130\uc6e8\uc5b4 \ud558\uc6b0\uc9d5 \uc11c\ube44\uc2a4\uc784<\/span><\/p>\n

                                                  \n
                                                • Google \uc5d0\uc11c \uac1c\ubc1c\ud55c Dremel \uc774\ub77c\ub294 \ucffc\ub9ac \uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud568<\/span><\/li>\n
                                                • Borg \ubc0f Colossus \uc640 \uac19\uc740 \ub2e4\ub978 Google Cloud \uc11c\ube44\uc2a4\ub97c \ud65c\uc6a9\ud560 \uc218 \uc788\uc74c<\/span><\/li>\n<\/ul>\n

                                                  \uc2a4\ud1a0\ub9ac\uc9c0 \ud615\uc2dd<\/strong><\/span><\/p>\n

                                                  \ub3c5\uc790\uc801\uc778 ColumnIO \ub97c \uc2a4\ud1a0\ub9ac\uc9c0 \ud615\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud558\uace0 Colossus \ud30c\uc77c \uc2dc\uc2a4\ud15c\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4. \ubd84\uc0b0 \ucef4\ud4e8\ud305\uacfc \uc2a4\ud1a0\ub9ac\uc9c0\ub97c \uc644\uc804\ud788 \ubd84\ub9ac\ud569\ub2c8\ub2e4.<\/span><\/p>\n

                                                    \n
                                                  • \uc555\ucd95 \ud615\uc2dd\ub3c4 ColumnIO \uc5f4 \ud615\uc2dd\uc73c\ub85c \ucc98\ub9ac\ub428<\/span><\/li>\n<\/ul>\n

                                                    \ub370\uc774\ud130 \uc811\uadfc \ubc0f \ud578\ub4e4\ub9c1<\/span><\/strong><\/span><\/p>\n

                                                    ODBC\/JDBC \uc678\uc5d0\ub3c4 GCP \ucf58\uc194 \ubc0f BigQuery API, CLI \ub97c \ud1b5\ud574 \uc811\uadfc \uac00\ub2a5\ud568 <\/span><\/p>\n

                                                    \ud1b5\ud569 \ucffc\ub9ac<\/span><\/strong><\/span><\/p>\n

                                                    Postgres \ubc0f MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc9c0\uc6d0\uc744 \ud3ec\ud568\ud558\ub294 CloudSQL \uc744 \ud1b5\ud574 \ud1b5\ud569 \ucffc\ub9ac\ub97c \uc9c0\uc6d0\ud568<\/span><\/p>\n

                                                    \uc0ac\uc6a9\uc790 \uc815\uc758 \ud568\uc218 (UDF)<\/strong><\/span><\/p>\n

                                                    SQL \ubc0f Java Script\ub85c \uc0ac\uc6a9\uc790 \uc815\uc758 \ud568\uc218 \uc791\uc131\uc744 \uc9c0\uc6d0<\/span><\/p>\n

                                                      \n
                                                    • \u00a0Google Cloud Storage\uc758 \uc678\ubd80 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \ud3ec\ud568\ud560 \uc218 \uc788\uc74c<\/span><\/li>\n<\/ul>\n

                                                      \uce90\uc2f1<\/span><\/strong><\/span><\/p>\n

                                                      \ucffc\ub9ac\ub97c \uce90\uc2dc\ud558\uace0 \uc778\uba54\ubaa8\ub9ac \uce90\uc2dc\ub97c \uc81c\uacf5\ud558\ub294 \uc911\uac04 \uce90\uc2dc\ub97c \uc81c\uacf5<\/span><\/p>\n

                                                      \ub370\uc774\ud130 \uc18c\uc2a4<\/span><\/strong><\/span><\/p>\n

                                                      \ud1b5\ud569 \ucffc\ub9ac\ub97c \ud1b5\ud574 Cloud Storage, Google Drive, Bigtable, Cloud SQL\ub4f1\uc744 \ube44\ub86f\ud55c \uc77c\ubd80 \uc678\ubd80 \ub370\uc774\ud130 \uc18c\uc2a4\uc5d0 \ub300\ud55c \uc5f0\uacb0\uc744 \uc124\uc815 \ud560 \uc218 \uc788\uc74c<\/span><\/p>\n

                                                      SnowFlake<\/strong><\/span><\/h4>\n

                                                      SaaS(Software-as-a-Service) \ubaa8\ub378\ub85c \uc81c\uacf5\ub418\ub294 \uad6c\uc870\ud654\ub41c \ub370\uc774\ud130\uc640 \ubc18 \uad6c\uc870\ud654\ub41c \ub370\uc774\ud130 \ubaa8\ub450\ub97c \uc9c0\uc6d0\ud558\ub294 \ub370\uc774\ud130\uc6e8\uc5b4 \ud558\uc6b0\uc2a4<\/span><\/p>\n

                                                        \n
                                                      • \uae30\uc874 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub610\ub294 \ube45 \ub370\uc774\ud130 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ud50c\ub7ab\ud3fc(e.g. Hadoop)\uc704\uc5d0 \uad6c\ucd95\ub418\uc9c0 \uc54a\uc74c<\/span><\/li>\n
                                                      • Snowflake\ub294 \ud074\ub77c\uc6b0\ub4dc \uc6a9\uc73c\ub85c \uc124\uacc4\ub41c \uace0\uc720\ud55c \uc544\ud0a4\ud14d\ucc98\uac00 \uc874\uc7ac\ud558\ub294 SQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uc744 \uc0ac\uc6a9<\/span><\/li>\n<\/ul>\n

                                                        Snowflake\ub294 \ube60\ub974\uace0 \uc0ac\uc6a9\uc790 \uce5c\ud654\uc801\uc774\uba70 \uae30\uc874 \ub370\uc774\ud130\uc6e8\uc5b4 \ud558\uc6b0\uc2a4\ubcf4\ub2e4 \ub354 \ub9ce\uc740 \uc720\uc5f0\uc131\uc744 \uc81c\uacf5\ud568<\/span><\/p>\n

                                                          \n
                                                        • Snowflake\ub294 Snowflake Elastic Data Warehouse\uc758 \ud615\ud0dc\ub85c \ud074\ub77c\uc6b0\ub4dc \uae30\ubc18 \ub370\uc774\ud130 \uc2a4\ud1a0\ub9ac\uc9c0 \ubc0f \ubd84\uc11d\uc744 \uc81c\uacf5\ud568<\/span><\/li>\n
                                                        • \ud2b9\uc815 \ud074\ub77c\uc6b0\ub4dc(\uc778\ud504\ub77c)\uc5d0 \uc885\uc18d\ub418\uc9c0 \uc54a\uace0, \uc5b4\ub290 \ud37c\ube14\ub9ad \ud074\ub77c\uc6b0\ub4dc\uc5d0\ub3c4 \ubc30\ud3ec\uac00 \uac00\ub2a5\ud568<\/span><\/li>\n
                                                        • Snowflake ETL\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 Hadoop\uacfc \uac19\uc740 \uae30\uc220\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0\ub3c4 \ud37c\ube14\ub9ad \ud074\ub77c\uc6b0\ub4dc \uc2dc\uc2a4\ud15c\uc744 \ud65c\uc6a9\ud560 \uc218 \uc788\uc74c<\/span><\/li>\n<\/ul>\n

                                                          \uc2a4\ud1a0\ub9ac\uc9c0 \ud615\uc2dd<\/span><\/strong><\/span><\/p>\n

                                                          \uac01 \uc2a4\ud1a0\ub9ac\uc9c0\uc758 \ub3c5\uc810\uc801\uc778 Row \ud615\uc2dd\uc73c\ub85c \uc81c\uacf5\ud558\uba70, \uba54\ud0c0 \ub370\uc774\ud130 \uce90\uc2f1\uc744 \uc0ac\uc6a9\ud558\uc5ec PAX(\ud558\uc774\ube0c\ub9ac\ub4dc \uceec\ub7fc \ud615\uc2dd)\ub85c \uc800\uc7a5<\/span><\/p>\n

                                                            \n
                                                          • \ubb3c\ub9ac \ub370\uc774\ud130\ub294 Amazon S3 \ub4f1\uc758 \ub2e4\ub978 \ud074\ub77c\uc6b0\ub4dc \uc2a4\ud1a0\ub9ac\uc9c0\ub97c \ud65c\uc6a9\ud560 \uc218 \uc788\uc74c<\/span><\/li>\n<\/ul>\n

                                                            \ucef4\ud4e8\ud305 \ud615\uc2dd<\/span><\/strong><\/span><\/p>\n

                                                            \ucef4\ud4e8\ud305 \uc5d4\uc9c4\uc740 \ud074\ub77c\uc6b0\ub4dc(AWS, GCP, Azure)\uc758 \uac00\uc0c1\uba38\uc2e0\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 Intelligent Predicate Pushdown + Smart Caching\uc774 \ud3ec\ud568\ub41c \ub3c5\uc810 \ud615\ud0dc\uc774\uba70, C-Store, MonetDB\uc5d0\uc11c \uc601\uac10\uc744 \uc5bb\uc740 \ud558\uc774\ube0c\ub9ac\ub4dc \uceec\ub7fc \uc2dc\uc2a4\ud15c<\/span><\/p>\n

                                                            \ub370\uc774\ud130 \uc811\uadfc \ubc0f \ud578\ub4e4\ub9c1<\/span><\/strong><\/span><\/p>\n

                                                            \uc194\ub8e8\uc158\uc758 \uc720\uc5f0\uc131\ub9cc\ud07c \ub2e4\uc591\ud55c \ub3c4\uad6c\uac00 \uc9c0\uc6d0\ub428<\/span><\/p>\n

                                                              \n
                                                            • ODBC\/JDBC<\/span><\/li>\n
                                                            • Spark \ud50c\ub7ec\uadf8\uc778 (spark-snowflake)<\/span><\/li>\n
                                                            • Kafka<\/span><\/li>\n
                                                            • Python\/Node.js\/Go\/.Net \ub4dc\ub77c\uc774\ubc84<\/span><\/li>\n
                                                            • SnowSQL<\/span><\/li>\n
                                                            • Snowsight<\/span><\/li>\n<\/ul>\n

                                                              \ud1b5\ud569 \ucffc\ub9ac<\/strong><\/span><\/p>\n

                                                              \ud604\uc7ac \ud1b5\ud569 \ucffc\ub9ac\ub97c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc74c<\/span><\/p>\n

                                                              \uce90\uc2f1<\/strong><\/span><\/p>\n

                                                              \ucf5c\ub4dc \ub370\uc774\ud130 \uc2a4\ud1a0\ub9ac\uc9c0\uc640 \ubd84\ub9ac\ub41c \uc911\uac04 \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0 Hot\/Warm \ucffc\ub9ac \uce90\uc2dc\ub97c \uc81c\uacf5<\/span><\/p>\n

                                                              \uc2a4\ud2b8\ub9ac\ubc0d<\/span><\/strong><\/span><\/p>\n

                                                              snowpipe\ub97c \ud1b5\ud574 Amazon S3, Google Cloud Storage, Azure Blob Storage\uc5d0\uc11c \ub9c8\uc774\ud06c\ub85c \ubc30\uce58\ub97c \ud560 \uc218 \uc788\uc9c0\ub9cc, \uae30\ubcf8 \uc2a4\ud2b8\ub9ac\ubc0d \uae30\ub2a5\uc740 \uc5c6\uc74c<\/span><\/p>\n

                                                              \ub370\uc774\ud130 \uc18c\uc2a4<\/strong><\/span><\/p>\n

                                                              \ucd5c\uc0c1\uc758 \uc131\ub2a5\uc744 \uc704\ud574\uc11c Snowflake \ub0b4\uc5d0 \ub370\uc774\ud130\uac00 \uc788\ub294 \uac83\uc774 \uc774\uc0c1\uc801\uc784<\/span><\/p>\n

                                                              \ud558\uc9c0\ub9cc Snowflake \ub0b4\ub85c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uac83\uc744 \uac15\uc694\ud558\uc9c0 \uc54a\uc73c\uba70, \uc8fc\uc694 \ud074\ub77c\uc6b0\ub4dc (Amazon S3, Google Cloud Storage, Azure Blog Storage)\uc758 \uac1d\uccb4 \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0 \uc5f0\uacb0\ud560 \uc218 \uc788\ub294 \uc678\ubd80 \ud14c\uc774\ube14 \uae30\ub2a5\uc744 \uc81c\uacf5\ud568<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

                                                              \uac1c\ub150 \uc0ac\uc6a9\uc790\uc758 \uc758\uc0ac \uacb0\uc815\uc5d0 \ub3c4\uc6c0\uc744 \uc8fc\uae30 \uc704\ud558\uc5ec\u00a0\ubd84\uc11d \uac00\ub2a5\ud55c \ud615\ud0dc\ub85c \uc815\ubcf4\ub4e4\uc774 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \uc911\uc559 \uc800\uc7a5\uc18c\ub2e4. \uc815\ubcf4(data)\uc640 \ucc3d\uace0(warehouse)\uc758 \uc758\ubbf8\uac00 \ud569\uc131\ub418\uc5b4 \ub9cc\ub4e0 \uc5b4\ud718 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4(DW)\ub294 1980\ub144\ub300 \uc911\ubc18 IBM\uc774 \uc790\uc0ac\uc758 \ud558\ub4dc\uc6e8\uc5b4\ub97c \ud310\ub9e4\ud558\uae30 \uc704\ud574 \ucc98\uc74c\uc73c\ub85c \ub3c4\uc785\ud588\ub358 \uac1c\ub150\uc73c\ub85c, IBM\uc740 \u2018\uc815\ubcf4\ucc3d\uace0\u2019\uc758 \uc758\ubbf8\ub85c \uc778\ud3ec\uba54\uc774\uc158 \uc6e8\uc5b4\ud558\uc6b0\uc2a4(Information Warehouse)\ub77c\ub294 \uc6a9\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc600\ub2e4. \uc774\ud6c4 \uc774 \uac1c\ub150\uc740 \ub9ce\uc740 \ud558\ub4dc\uc6e8\uc5b4, \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc0f \ud234(tool) \uacf5\uae09 \uc5c5\uccb4\ub4e4\uc5d0 \uc758\ud574 \uc774\ub860\uc801, \ud604\uc2e4\uc801\uc73c\ub85c \uc131\uc7a5\ud558\uc600\uc73c\uba70, 1980\ub144\ub300 […]<\/p>\n","protected":false},"author":1,"featured_media":426,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-422","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-it"],"_links":{"self":[{"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts\/422"}],"collection":[{"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=422"}],"version-history":[{"count":3,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts\/422\/revisions"}],"predecessor-version":[{"id":429,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts\/422\/revisions\/429"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/media\/426"}],"wp:attachment":[{"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}