{"id":4639,"date":"2022-06-24T23:29:41","date_gmt":"2022-06-25T07:29:41","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=4639"},"modified":"2022-06-27T18:36:48","modified_gmt":"2022-06-28T02:36:48","slug":"metadata-management-for-data-warehouses","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0%ec%9b%a8%ec%96%b4%ed%95%98%ec%9a%b0%ec%8a%a4%eb%a5%bc-%ec%9c%84%ed%95%9c-%eb%a9%94%ed%83%80%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b4%80%eb%a6%ac\/","title":{"rendered":"\ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uc704\ud55c \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac | \uad6c\ub450 SQL\ud50c\ub85c\uc6b0"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#e8eaf0;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1310.4px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-1\" style=\"line-height:26px;\"><h2>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uc704\ud55c \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac<\/h2>\n<p><strong><a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%a9%94%ed%83%80%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b4%80%eb%a6%ac%eb%9e%80-%eb%ac%b4%ec%97%87%ec%9d%b8%ea%b0%80\/\">\uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac<\/a><\/strong> \uae30\uc5c5\uc758 \uae30\ubc18\uc774\ub2e4 <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/category\/data-governance-101\/\">\ub370\uc774\ud130 \uac70\ubc84\ub10c\uc2a4<\/a><\/strong> \uadf8\ub9ac\uace0 \uac1c\uc120 <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0%ec%9b%a8%ec%96%b4%ed%95%98%ec%9a%b0%ec%8a%a4%eb%9e%80-%eb%ac%b4%ec%97%87%ec%9d%b8%ea%b0%80\/\">\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4<\/a><\/strong>\ub370\uc774\ud130 \uc791\uc5c5\uc744 \uc790\uc8fc \ud558\ub294 \uc0ac\ub78c\uc73c\ub85c\uc11c \uac00\uc7a5 \uba3c\uc800 \ud574\uc57c \ud560 \uc77c\uc740 \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\ub97c \uc774\ud574\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 \uba54\ud0c0\ub370\uc774\ud130\uc758 \uac1c\ub150\uc744 \uc815\ub9ac\ud558\uace0 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uc704\ud55c \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\ub97c \uc18c\uac1c\ud569\ub2c8\ub2e4.<\/p>\n<h3>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/h3>\n<p>\ub354 \ub098\uc544\uac00\uae30 \uc804\uc5d0 \uc54c\uc544\ubd05\uc2dc\ub2e4 <strong>\uba54\ud0c0\ub370\uc774\ud130\ub780 \ubb34\uc5c7\uc778\uac00<\/strong> \uadf8\ub9ac\uace0 <strong>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub780 \ubb34\uc5c7\uc778\uac00<\/strong>.<\/p>\n<p><strong>\uba54\ud0c0\ub370\uc774\ud130<\/strong>\uc911\uac04 \ub370\uc774\ud130 \ubc0f \ub9b4\ub808\uc774 \ub370\uc774\ud130\ub77c\uace0\ub3c4 \ud558\ub294 \uba54\ud0c0\ub370\uc774\ud130\ub294 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \ub370\uc774\ud130\uc785\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 \uba54\ud0c0\ub370\uc774\ud130\ub294 \ub098\ud0c0\ub0b4\ub294 \uc758\ubbf8\uc5d0 \ub530\ub77c \ube44\uc988\ub2c8\uc2a4 \uba54\ud0c0\ub370\uc774\ud130\uc640 \uae30\uc220 \uba54\ud0c0\ub370\uc774\ud130\ub85c \uad6c\ubd84\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc5d0\uc774 <strong>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4<\/strong> \ub354 \ub098\uc740 \uc758\uc0ac \uacb0\uc815\uc744 \uc704\ud574 \ubd84\uc11d\ud560 \uc218 \uc788\ub294 \uc815\ubcf4\uc758 \uc911\uc559 \uc800\uc7a5\uc18c\uc785\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \ub370\uc774\ud130\ub294 \ud2b8\ub79c\uc7ad\uc158 \uc2dc\uc2a4\ud15c, \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc0f \uae30\ud0c0 \uc18c\uc2a4\uc5d0\uc11c \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub85c \uc815\uae30\uc801\uc73c\ub85c \uc720\uc785\ub429\ub2c8\ub2e4. \ube44\uc988\ub2c8\uc2a4 \ubd84\uc11d\uac00\ub294 <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%97%94%ec%a7%80%eb%8b%88%ec%96%b4\/\">\ub370\uc774\ud130 \uc5d4\uc9c0\ub2c8\uc5b4<\/a><\/strong>, <a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%bc%ed%95%99%ec%9e%90\/\"><strong>\ub370\uc774\ud130 \uacfc\ud559\uc790<\/strong><\/a>\uc758\uc0ac\uacb0\uc815\uad8c\uc790\ub294 \ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4(BI) \ub3c4\uad6c, SQL \ud074\ub77c\uc774\uc5b8\ud2b8 \ubc0f \uae30\ud0c0 \ubd84\uc11d \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ud1b5\ud574 \ub370\uc774\ud130\uc5d0 \uc561\uc138\uc2a4\ud569\ub2c8\ub2e4.<\/p>\n<div id=\"attachment_4664\" style=\"width: 955px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-4664\" decoding=\"async\" class=\"size-full wp-image-4664\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Metadata_Management_for_Data_Warehouses-2.png\" alt=\"\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uc704\ud55c \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\" width=\"945\" height=\"532\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Metadata_Management_for_Data_Warehouses-2-200x113.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Metadata_Management_for_Data_Warehouses-2-300x169.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Metadata_Management_for_Data_Warehouses-2-400x225.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Metadata_Management_for_Data_Warehouses-2-600x338.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Metadata_Management_for_Data_Warehouses-2-768x432.png 768w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Metadata_Management_for_Data_Warehouses-2-800x450.png 800w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Metadata_Management_for_Data_Warehouses-2.png 945w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><p id=\"caption-attachment-4664\" class=\"wp-caption-text\">\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uc704\ud55c \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac<\/p><\/div>\n<p><strong>\uadf8\ub807\ub2e4\uba74 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\ub780 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/strong><\/p>\n<p>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \uba54\ud0c0\ub370\uc774\ud130\ub294 \uc8fc\ub85c \uac01 \ud14c\ub9c8\uc758 \uc815\uc758, \ub2e4\uc591\ud55c \ub808\ubca8 \uac04\uc758 \ub9e4\ud551 \uad00\uacc4, \ubaa8\ub2c8\ud130\ub9c1 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \ub370\uc774\ud130 \uc0c1\ud0dc, \uc791\uc5c5 \uc2e4\ud589 \uc0c1\ud0dc\ub97c \uae30\ub85d\ud569\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ec%b5%9c%ea%b3%a0%ec%9d%98-etl-%eb%8f%84%ea%b5%ac\/\"><strong>\uc804\uc790\uc0c1\uac70\ub798<\/strong><\/a>\uc77c\ubc18\uc801\uc73c\ub85c \uba54\ud0c0\ub370\uc774\ud130\ub294 \uba54\ud0c0\ub370\uc774\ud130 \uc800\uc7a5\uc18c\ub97c \ud1b5\ud574 \uc77c\uad00\ub418\uac8c \uc800\uc7a5\ub418\uace0 \uad00\ub9ac\ub418\uba70, \uadf8 \uc8fc\ub41c \ubaa9\uc801\uc740 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \uc124\uacc4, \ubc30\ud3ec, \uc6b4\uc601 \ubc0f \uad00\ub9ac\uc5d0 \uc788\uc5b4 \uc870\uc815\uacfc \uc77c\uad00\uc131\uc744 \ud655\ubcf4\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>\uba54\ud0c0\ub370\uc774\ud130\ub294 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc758 \uc911\uc694\ud55c \ubd80\ubd84\uc785\ub2c8\ub2e4. \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\ub294 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \ud575\uc2ec \uad6c\uc131 \uc694\uc18c\uc785\ub2c8\ub2e4. \uba54\ud0c0\ub370\uc774\ud130\ub294 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uad6c\ucd95 \uacfc\uc815 \uc804\ubc18\uc5d0 \uac78\uccd0 \uc801\uc6a9\ub418\uba70, \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \uad6c\ucd95, \uc0ac\uc6a9 \ubc0f \uc720\uc9c0 \uad00\ub9ac\uc5d0 \uc9c1\uc811\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4.<\/p>\n<h3>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0 \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\uac00 \ud544\uc694\ud55c \uc774\uc720\ub294 \ubb34\uc5c7\uc785\ub2c8\uae4c?<\/h3>\n<ol>\n<li><strong>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uad6c\ucd95\uc5d0 \ud544\uc218<\/strong>: \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub294 \uc678\ubd80 \ub370\uc774\ud130, \ube44\uc988\ub2c8\uc2a4 \ub370\uc774\ud130 \ubc0f \ubb38\uc11c\uc5d0\uc11c ETL \ub3c4\uad6c\ub97c \ud1b5\ud574 \uc218\uc9d1\ub429\ub2c8\ub2e4. \uba85\ud655\ud558\uace0 \uba85\ud655\ud55c \uaddc\uce59 \uc5c6\uc774\ub294 \uc774 \ud504\ub85c\uc138\uc2a4\ub97c \uc2e4\ud604\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc2dc\uc2a4\ud15c\uc744 \ube60\ub974\uac8c \uc774\ud574\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/strong>: \ud55c\ud3b8\uc73c\ub85c, \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub294 \ubcf8\uc9c8\uc801\uc73c\ub85c \ubd80\uc11c \ub610\ub294 \ud68c\uc0ac\uc758 \uc911\uc694\ud55c \ud504\ub85c\uc81d\ud2b8\uc774\uba70 \uac1c\ubc1c \uae30\uac04\uc774 \uae41\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc911\uac04\uc5d0 \uc5ec\ub7ec \uc0ac\ub78c\uc774 \uc624\uac00\ub294 \uac83\uc740 \ubd88\uac00\ud53c\ud569\ub2c8\ub2e4. \uba85\ud655\ud55c \uba54\ud0c0\ub370\uc774\ud130\uac00 \uc5c6\uc73c\uba74 \uc804\uccb4 \uc2dc\uc2a4\ud15c\uacfc \ud504\ub85c\uc81d\ud2b8\uc5d0 \ud070 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \ub2e4\ub978 \ud55c\ud3b8\uc73c\ub85c, \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub294 \ub370\uc774\ud130 \ub2f4\ub2f9\uc790\ubfd0\ub9cc \uc544\ub2c8\ub77c \ubd80\uc11c\uc640 \ud68c\uc0ac \uc804\uccb4\uc758 \ubd84\uc11d \ub370\uc774\ud130\ub97c \ub0b4\ubcf4\ub0b4\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. DM \uacc4\uce35\uc740 \ube44\uc988\ub2c8\uc2a4 \ub2f4\ub2f9\uc790\uc5d0\uac8c \ud544\uc218\uc801\uc774\uba70, DIM \uacc4\uce35\uc740 \ub2e4\ub978 \uac1c\ubc1c\uc790\uc5d0\uac8c \ud544\uc218\uc801\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc2dc\uc2a4\ud15c\uc744 \uc124\uba85\ud558\ub294 \uba85\ud655\ud55c \uba54\ud0c0\ub370\uc774\ud130\uac00 \uc788\ub2e4\uba74 \uc591\uce21 \uac04\uc758 \uc18c\ud1b5 \uc2dc\uac04\uc744 \ud06c\uac8c \uc808\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ud6a8\uc728\uc801\uc774\uace0 \uc815\ud655\ud55c \ucee4\ubba4\ub2c8\ucf00\uc774\uc158<\/strong>: \ud55c\ud3b8, \uba54\ud0c0\ub370\uc774\ud130\uc758 \uad00\ub9ac \uba54\ud0c0\ub370\uc774\ud130\ub294 \ub2e4\uc591\ud55c \uc0ac\uc6a9\uc790, \uc5ed\ud560 \ubc0f \ubd80\uc11c\uc758 \ub370\uc774\ud130 \uad8c\ud55c\uc744 \uae30\ub85d\ud569\ub2c8\ub2e4. \uc54c\ub9bc\uc774 \ud544\uc694\ud55c \ub370\uc774\ud130\uac00 \uc788\ub294 \uacbd\uc6b0, \uc2dc\uc2a4\ud15c\uc5d0 \ub300\ub7c9 \uc774\uba54\uc77c \ub4f1\uc744 \ud1b5\ud574 \uc2e0\uc18d\ud558\uac8c \uc5f0\ub77d\ud558\uc5ec \ub2f4\ub2f9\uc790 \ubd80\uc871 \ubc0f \uacfc\ub2e4\ud55c \uc18c\ud1b5 \uc0c1\ud669\uc744 \ubc29\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c, \uc81c\ud488 \ub610\ub294 R&amp;D \ubd80\uc11c\uc640\uc758 \uc18c\ud1b5 \uc2dc\uc5d0\ub294 \ube44\uc988\ub2c8\uc2a4 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uae30\ubc18\uc73c\ub85c \uc9c0\ud45c\uc758 \uc758\ubbf8\uc640 \uc0c1\ud638 \uc18c\ud1b5 \ucc28\uc6d0\uc744 \ud655\uc778\ud558\uc5ec \uc18c\ud1b5\uc758 \ubaa8\ud638\uc131\uc744 \uadfc\ubcf8\uc801\uc73c\ub85c \ubc29\uc9c0\ud558\uace0 \uc18c\ud1b5 \ud6a8\uc728\uc131\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ubcf4\uc7a5\ub428<\/strong> <a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ed%92%88%ec%a7%88%ec%9d%84-%ea%b0%9c%ec%84%a0%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95\/\"><strong>\ub370\uc774\ud130 \ud488\uc9c8<\/strong><\/a>: \uc774\uc0c1\uc801\uc778 \uba54\ud0c0\ub370\uc774\ud130\ub294 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \uad6c\uc870, \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \uc2a4\ud0a4\ub9c8, \ucc28\uc6d0, \uce21\uc815, \uacc4\uce35, \ubaa8\ub4e0 \uacf3\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc815\uc758, \uadf8\ub9ac\uace0 \uc704\uce58\uc640 \ub0b4\uc6a9\uc744 \uc124\uba85\ud569\ub2c8\ub2e4. <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%a7%88%ed%8a%b8-%eb%8d%b0%ec%9d%b4%ed%84%b0%ec%9b%a8%ec%96%b4%ed%95%98%ec%9a%b0%ec%8a%a4-%eb%9e%80-%eb%ac%b4%ec%97%87%ec%9d%b8%ea%b0%80\/\">\ub370\uc774\ud130\ub9c8\ud2b8<\/a><\/strong>\ub530\ub77c\uc11c \uc5b4\ub5a4 \ub370\uc774\ud130\uac00 \ud655\uc2e4\ud788 \uc815\ud655\ud55c\uc9c0, \uc5b4\ub5a4 \ub370\uc774\ud130\uac00 \uc624\ub958 \uac00\ub2a5\uc131\uc774 \uc788\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc5b4\ub5a4 \ub370\uc774\ud130\uac00 \ud655\uc2e4\ud788 \uc624\ub958\uc778\uc9c0 \ud655\uc2e4\ud558\uac8c \ud310\ub2e8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac04\ub2e8\ud788 \ub9d0\ud574, \uac01 \ud544\ub4dc\uc5d0\ub294 \uac12 \ubc94\uc704, \ube44\uc988\ub2c8\uc2a4 \uc815\uc758 \ubc0f \uae30\ud0c0 \uc815\ubcf4\uac00 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uba54\ud0c0\ub370\uc774\ud130\uac00 \uc815\uc758\ub418\uba74 \ub370\uc774\ud130 \ud488\uc9c8 \uac10\uc9c0 \ubc0f \ud3c9\uac00 \ub4f1\uc5d0 \uc801\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \ud488\uc9c8 \uad00\ub9ac \ud504\ub85c\uc138\uc2a4\ub97c \ud1b5\ud574 \uae30\uc5c5\uc758 \ub370\uc774\ud130 \ud488\uc9c8\uc744 \uc2e4\uc9c8\uc801\uc73c\ub85c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ub370\uc774\ud130 \uc2dc\uc2a4\ud15c \uad6c\ucd95 \ube44\uc6a9 \uc808\uac10<\/strong>: \uba54\ud0c0\ub370\uc774\ud130\uac00 \uc798 \uad6c\ucd95\ub418\uba74 \uc815\ubcf4\ub97c \ubcf4\ub2e4 \uc815\ud655\ud558\uace0 \ube60\ub974\uac8c \uc5bb\uc744 \uc218 \uc788\uc73c\ubbc0\ub85c \ub370\uc774\ud130 \uc2dc\uc2a4\ud15c \uad6c\ucd95\uc5d0 \uc7ac\uc791\uc5c5\uc774 \ud544\uc694 \uc5c6\uac70\ub098 \uc801\uac8c \uc18c\uc694\ub418\uace0, \ubd84\uc11d \uc5c5\ubb34\ub7c9\uc774 \uc904\uc5b4\ub4e4\uba70, \uac01 \ub2f9\uc0ac\uc790\uc758 \ud1b5\uc77c\ub41c \uc774\ud574\uc640 \uc18c\ud1b5 \ud6a8\uc728\uc131\uc774 \uac15\ud654\ub418\uace0, \uac1c\ubc1c \ube44\uc6a9\uc774 \ucd5c\uc18c\ud654\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\ubcc0\ud654\uc758 \uc601\ud5a5\uc744 \ube60\ub974\uac8c \ubd84\uc11d\ud558\uc138\uc694<\/strong>: \uba54\ud0c0\ub370\uc774\ud130\ub294 \ucc38\uc870 \uad00\uacc4\ub97c \ud1b5\ud574 \uc911\uc559\uc5d0\uc11c \uc720\uc9c0 \uad00\ub9ac\ub418\uace0 \uad00\ub9ac\ub418\ubbc0\ub85c \ubcc0\uacbd \uc0ac\ud56d\uc774 \ubc1c\uc0dd\ud558\uba74 \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc601\ud5a5\uc744 \ubc1b\ub294 \ube44\uc988\ub2c8\uc2a4 \uae30\ub2a5, \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc2dc\uc2a4\ud15c, \uad00\ub828 \uc778\ub825, \uac10\ub3c5 \uc5ec\ubd80 \ub4f1\uc744 \uc2e4\uc2dc\uac04\uc73c\ub85c \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ubbf8\ub798\ub97c \uc900\ube44\ud558\ub2e4<\/strong>: \ube45\ub370\uc774\ud130, \uc778\uacf5\uc9c0\ub2a5 \ub4f1 \uae30\uc5c5\uc758 \uc804\ub7b5\uc801 \uc751\uc6a9 \uc2dc\uc2a4\ud15c <a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%a0%88%ec%9d%b4%ed%81%ac%eb%9e%80-%eb%ac%b4%ec%97%87%ec%9d%b8%ea%b0%80\/\"><strong>\ub370\uc774\ud130 \ub808\uc774\ud06c<\/strong><\/a>\ub370\uc774\ud130 \uc13c\ud130\uc640 \ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4\ub294 \uc801\uc808\ud55c \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\ub97c \ud1b5\ud574 \uadf8 \ud6a8\uacfc\ub97c \ubc1c\ud718\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n<h3>\uba54\ud0c0\ub370\uc774\ud130 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc2dc\ub098\ub9ac\uc624<\/h3>\n<ol>\n<li><strong>\uc601\ud5a5 \ubd84\uc11d<\/strong>: \uac1c\ubc1c \uacfc\uc815\uc5d0\uc11c \uc885\uc885 \ub2e4\uc74c\uacfc \uac19\uc740 \ubb38\uc81c\uc5d0 \uc9c1\uba74\ud569\ub2c8\ub2e4. \ud14c\uc774\ube14\uc774\ub098 ETL\uc744 \ubcc0\uacbd\ud558\uba74 \uc5b4\ub5a4 \uc601\ud5a5\uc774 \uc788\uc744\uae4c\uc694? \uba54\ud0c0\ub370\uc774\ud130\uac00 \uc5c6\ub2e4\uba74 \uc6d0\ud558\ub294 \uacb0\uacfc\ub97c \uc5bb\uae30 \uc704\ud574 \ubaa8\ub4e0 \uc2a4\ud06c\ub9bd\ud2b8\uc640 \ub370\uc774\ud130\ub97c \ud0d0\uc0c9\ud574\uc57c \ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\uac00 \uc798 \ub418\uc5b4 \uc788\ub2e4\uba74 \uc6d0\ud558\ub294 \uacb0\uacfc\ub97c \ubc14\ub85c \uc5bb\uc744 \uc218 \uc788\uc5b4 \uc2dc\uac04\uc744 \ud06c\uac8c \uc808\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4%ec%9d%98-%ec%a4%91%ec%9a%94%ec%84%b1\/\"><strong>\ub370\uc774\ud130 \uacc4\ubcf4 \ubd84\uc11d<\/strong><\/a>: \ub370\uc774\ud130 \uacc4\ubcf4 \ubd84\uc11d\uc740 \ub370\uc774\ud130 \ucc98\ub9ac \ud504\ub85c\uc138\uc2a4\ub97c \ud3ec\uad04\uc801\uc73c\ub85c \ucd94\uc801\ud558\uc5ec \ud2b9\uc815 \ub370\uc774\ud130 \uac1d\uccb4\ub97c \uc2dc\uc791\uc73c\ub85c \ubaa8\ub4e0 \uad00\ub828 \uba54\ud0c0\ub370\uc774\ud130 \uac1d\uccb4\uc640 \uc774\ub4e4 \uac04\uc758 \uad00\uacc4\ub97c \ud30c\uc545\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \uae30\uc220\uc801 \uc218\ub2e8\uc785\ub2c8\ub2e4. \uba54\ud0c0\ub370\uc774\ud130 \uac1d\uccb4 \uac04\uc758 \uad00\uacc4\ub294 \uad6c\uccb4\uc801\uc73c\ub85c \uc774\ub7ec\ud55c \uba54\ud0c0\ub370\uc774\ud130 \uac1d\uccb4\ub97c \ub098\ud0c0\ub0b4\ub294 \ub370\uc774\ud130 \ud750\ub984\uc758 \uc785\ub825 \ubc0f \ucd9c\ub825 \uad00\uacc4\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc774 \uad6c\ucd95\ub41c \ud6c4, \uacc4\ubcf4 \uad00\uacc4 \ubd84\uc11d\uc744 \ud1b5\ud574 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \ub370\uc774\ud130 \uc0c1\ud0dc, \ub370\uc774\ud130 \ubd84\ud3ec, \uc9d1\uc911\ub3c4, \uadf8\ub9ac\uace0 \ub370\uc774\ud130 \uc5f4\ub7c9\uc744 \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>ETL \uc790\ub3d9\ud654 \uad00\ub9ac<\/strong>: \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0\uc11c ETL\uc758 \uc0c1\ub2f9 \ubd80\ubd84\uc740 \uc9c0\ub8e8\ud558\uace0 \ubc18\ubcf5\uc801\uc778 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc18c\uc2a4 \uc2dc\uc2a4\ud15c-ODS \uacc4\uce35\uc5d0\uc11c\ub294 \ud14c\uc774\ube14 \uc785\ub825 - \ud14c\uc774\ube14 \ucd9c\ub825 \uc21c\uc11c\ub85c \uc9c4\ud589\ub429\ub2c8\ub2e4. \ub610 \ub2e4\ub978 \uc608\ub85c ODS-DW\uc5d0\uc11c\ub294 SQL \uc785\ub825 - \ub370\uc774\ud130 \uc815\ub9ac - \ub370\uc774\ud130 \ucc98\ub9ac - \ud14c\uc774\ube14 \ucd9c\ub825 \uc21c\uc11c\ub85c \uc9c4\ud589\ub429\ub2c8\ub2e4. \uc704\uc758 \uaddc\uce59\uc740 \uc2e4\uc81c\ub85c \uba54\ud0c0\ub370\uc774\ud130\uc758 \uc77c\ubd80\uc785\ub2c8\ub2e4. \uc774\ub860\uc801\uc73c\ub85c\ub294 \uace0\uc815 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc791\uc131\ud55c \ud6c4 \ud504\ub7f0\ud2b8\uc5d4\ub4dc \ub610\ub294 API \uc778\ud130\ud398\uc774\uc2a4\ub97c \ud1b5\ud574 \ud574\ub2f9 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \ubc18\ubcf5\ub418\ub294 ETL\uc744 \uc790\ub3d9\uc73c\ub85c \uad00\ub9ac\ud558\uc5ec ETL \uac1c\ubc1c\uc5d0 \ub4dc\ub294 \uc2dc\uac04\uc744 \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ub370\uc774\ud130 \ud488\uc9c8 \uad00\ub9ac<\/strong>: \ub370\uc774\ud130 \uc815\ub9ac \ub17c\ub9ac\ub294 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc720\ud615\uacfc \uc9c0\uc815\ub41c \ud2b9\uc218 \ucc98\ub9ac \uc5f4\ub85c \uac04\ub2e8\ud788 \ub098\ub20c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc9c0\ub2a5\uc801\uc774\uace0 \ube60\ub978 \ub370\uc774\ud130 \uc815\ub9ac\ub97c \uc704\ud574\uc11c\ub294 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc720\ud615\uc5d0 \ub300\ud55c \uae30\ubcf8 \uc815\ub9ac \uaddc\uce59\uacfc \uc77c\ubd80 \ud2b9\uc218 \uc5f4\uc5d0 \ub300\ud55c \ud2b9\uc218 \ucc98\ub9ac \ub17c\ub9ac\ub9cc \uc9c0\uc815\ud558\uba74 \ub429\ub2c8\ub2e4. \ub370\uc774\ud130 \ud488\uc9c8 \uad00\ub9ac\ub294 \ub370\uc774\ud130 \uac70\ubc84\ub10c\uc2a4\uc640 \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\uc758 \uad50\ucc28\uc810\uc5d0 \uc704\uce58\ud558\uba70, \ub370\uc774\ud130 \uac70\ubc84\ub10c\uc2a4\uc5d0 \ub354 \uac00\uae5d\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ub370\uc774\ud130 \ubcf4\uc548 \uad00\ub9ac<\/strong>: Ali\uac00 \uc8fc\uc7a5\ud558\ub294 \ub370\uc774\ud130 \uc13c\ud130\uc5d0\uc11c\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130 \uc778\ud130\ud398\uc774\uc2a4 \uc9c0\ud45c\uac00 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0\uc11c \ub0b4\ubcf4\ub0b4\uc9d1\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc774\ub860\uc801\uc73c\ub85c\ub294 \uc774 \uba54\ud0c0\ub370\uc774\ud130\uc5d0\uc11c \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac \uad8c\ud55c\ub9cc \uad6c\uc131\ud558\uba74 \ud68c\uc0ac \uc804\uccb4\uc758 \ub370\uc774\ud130 \ubcf4\uc548 \uad00\ub9ac\ub97c \ub2ec\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n<h3>\uacb0\ub860<\/h3>\n<p>\uc800\ud76c \uae30\uc0ac\ub97c \uc77d\uc5b4\uc8fc\uc154\uc11c \uac10\uc0ac\ud569\ub2c8\ub2e4. \uc774 \uae30\uc0ac\uac00 \uc5ec\ub7ec\ubd84\uc774 \ub354 \uc798 \uc774\ud574\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4. <strong>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uc704\ud55c \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac<\/strong>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \ub2e4\uc74c\uc744 \ubc29\ubb38\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4. <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/\">Gudu SQLFlow<\/a><\/strong> \uc790\uc138\ud55c \ub0b4\uc6a9\uc740.<\/p>\n<p>\uadf8 \uc911 \ud558\ub098\ub85c\uc11c\u00a0<strong><a href=\"https:\/\/www.dpriver.com\/blog\/2022\/05\/11\/best-data-lineage-tools\/\" target=\"_blank\" rel=\"noopener noreferrer\">\ucd5c\uace0\uc758 \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c<\/a><\/strong> \ud604\uc7ac \uc2dc\uc911\uc5d0 \ud310\ub9e4\ub418\uace0 \uc788\ub294 Gudu SQLFlow\ub294 SQL \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c\uc744 \ubd84\uc11d\ud558\uace0, \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc5bb\uace0, \uc2dc\uac01\uc801\uc73c\ub85c \ud45c\uc2dc\ud560 \uc218 \uc788\uc744 \ubfd0\ub9cc \uc544\ub2c8\ub77c, \uc0ac\uc6a9\uc790\uac00 CSV \ud615\uc2dd\uc73c\ub85c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc81c\uacf5\ud558\uace0 \uc2dc\uac01\uc801\uc73c\ub85c \ud45c\uc2dc\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc90d\ub2c8\ub2e4.\u00a0<strong>(2022\ub144 6\uc6d4 25\uc77c Ryan \uac8c\uc2dc)<\/strong><\/p>\n<\/div><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-0{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-0 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-0{width:100% !important;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-0{width:100% !important;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-1{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":27,"featured_media":4663,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[178],"tags":[210,152,213,151,211,212],"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/4639"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=4639"}],"version-history":[{"count":28,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/4639\/revisions"}],"predecessor-version":[{"id":4669,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/4639\/revisions\/4669"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media\/4663"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=4639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/categories?post=4639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/tags?post=4639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}