{"id":4542,"date":"2022-06-21T19:08:11","date_gmt":"2022-06-22T03:08:11","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=4542"},"modified":"2022-06-21T19:19:42","modified_gmt":"2022-06-22T03:19:42","slug":"what-is-a-data-mart-data-warehouse","status":"publish","type":"post","link":"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\/","title":{"rendered":"\ub370\uc774\ud130\ub9c8\ud2b8\ub780 \ubb34\uc5c7\uc778\uac00? | \ub370\uc774\ud130\ub9c8\ud2b8 \ub300 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4"},"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><strong>\ub370\uc774\ud130\ub9c8\ud2b8\ub780?\u00a0<\/strong><\/h2>\n<p>\uc5d0\uc774 <strong><a href=\"https:\/\/www.dpriver.com\/blog\/2022\/06\/21\/what-is-a-data-mart\/\">\ub370\uc774\ud130\ub9c8\ud2b8<\/a><\/strong> \ud2b9\uc815 \uc804\ubb38\uac00 \uadf8\ub8f9\uc744 \ub300\uc0c1\uc73c\ub85c \ud558\ub294 \uc6b4\uc601 \ub370\uc774\ud130 \ubc0f \uae30\ud0c0 \ub370\uc774\ud130 \uc18c\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc218\uc9d1\ud558\ub294 \ucc3d\uace0\uc785\ub2c8\ub2e4. \ubc94\uc704 \uce21\uba74\uc5d0\uc11c \ub370\uc774\ud130\ub294 \uc804\uc0ac\uc801 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub610\ub294 \ubcf4\ub2e4 \uc804\ubb38\ud654\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ucd94\ucd9c\ub429\ub2c8\ub2e4. <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\/\"><strong>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4<\/strong><\/a>. \ub370\uc774\ud130 \uc13c\ud130\uc758 \uc694\uc810\uc740 \ubd84\uc11d, \ucf58\ud150\uce20, \uc131\ub2a5 \ubc0f \uc0ac\uc6a9 \ud3b8\uc758\uc131 \uce21\uba74\uc5d0\uc11c \uc804\ubb38 \uc0ac\uc6a9\uc790 \uadf8\ub8f9\uc758 \ud2b9\uc815 \uc694\uad6c \uc0ac\ud56d\uc744 \ucda9\uc871\ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \uc13c\ud130 \uc0ac\uc6a9\uc790\ub294 \ub370\uc774\ud130\uac00 \uc775\uc219\ud55c \uc6a9\uc5b4\ub85c \ud45c\ud604\ub418\uae30\ub97c \uae30\ub300\ud569\ub2c8\ub2e4.<\/p>\n<h3>\ub370\uc774\ud130\ub9c8\ud2b8 \ub300 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4:<\/h3>\n<p>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub294 DSS(\uc758\uc0ac\uacb0\uc815 \uc9c0\uc6d0 \uc2dc\uc2a4\ud15c) \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud558\ub3c4\ub85d \uc124\uacc4\ub41c \ud1b5\ud569\ub41c \uc8fc\uc81c \uc911\uc2ec\uc758 \ub370\uc774\ud130 \ubaa8\uc74c\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0\uc11c \uac01 \ub370\uc774\ud130 \ub2e8\uc704\ub294 \ud2b9\uc815 \uc2dc\uac04\uacfc \uc5f0\uad00\ub429\ub2c8\ub2e4. \uc6d0\uc790 \uc218\uc900 \ub370\uc774\ud130\uc640 \uac00\ubccd\uac8c \uc9d1\uacc4\ub41c \ub370\uc774\ud130\ub85c \uad6c\uc131\ub41c \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub294 \ube44\uc988\ub2c8\uc2a4 \uad00\ub9ac\uc5d0\uc11c \uc758\uc0ac \uacb0\uc815 \ud504\ub85c\uc138\uc2a4\ub97c \uc9c0\uc6d0\ud558\uae30 \uc704\ud55c \uc8fc\uc81c \uc911\uc2ec\uc758 \ud1b5\ud569\ub41c \uc5c5\ub370\uc774\ud2b8 \ubd88\uac00\ub2a5\ud55c(\uc548\uc815\uc801\uc778) \uc2dc\uac04 \uac00\ubcc0 \ub370\uc774\ud130 \ubaa8\uc74c\uc785\ub2c8\ub2e4.<\/p>\n<div id=\"attachment_4548\" style=\"width: 904px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-4548\" decoding=\"async\" class=\"size-full wp-image-4548\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Data_Mart_vs_Data_Warehouse.png\" alt=\"\ub370\uc774\ud130\ub9c8\ud2b8 \ub300 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\" width=\"894\" height=\"404\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Data_Mart_vs_Data_Warehouse-200x90.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Data_Mart_vs_Data_Warehouse-300x136.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Data_Mart_vs_Data_Warehouse-400x181.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Data_Mart_vs_Data_Warehouse-600x271.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Data_Mart_vs_Data_Warehouse-768x347.png 768w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Data_Mart_vs_Data_Warehouse-800x362.png 800w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/06\/Data_Mart_vs_Data_Warehouse.png 894w\" sizes=\"(max-width: 894px) 100vw, 894px\" \/><p id=\"caption-attachment-4548\" class=\"wp-caption-text\">\ub370\uc774\ud130\ub9c8\ud2b8 \ub300 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4<\/p><\/div>\n<p>\uadf8\ub7ec\uba74 \ub370\uc774\ud130 \ub9c8\ud2b8\ub294 \uc8fc\ub85c \ubd80\uc11c \uc218\uc900\uc758 \ube44\uc988\ub2c8\uc2a4\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd94\uace0 \ud2b9\uc815 \uc8fc\uc81c\uc5d0\ub9cc \ucd08\uc810\uc744 \ub9de\ucd98 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc218\uc900 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \ud558\uc704 \uc9d1\ud569\uc785\ub2c8\ub2e4. \uc720\uc5f0\uc131\uacfc \uc131\ub2a5 \uac04\uc758 \ubaa8\uc21c\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud574 \ub370\uc774\ud130 \ub9c8\ud2b8\ub294 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc544\ud0a4\ud14d\ucc98\uc5d0 \ucd94\uac00\ub41c \uc18c\uaddc\ubaa8 \ubd80\uc11c \ub610\ub294 \uc791\uc5c5 \uadf8\ub8f9 \uc218\uc900\uc758 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \ub9c8\ud2b8\ub294 \ud2b9\uc815 \uc0ac\uc6a9\uc790\uc758 \uc131\ub2a5 \uc694\uad6c \uc0ac\ud56d\uc744 \ucda9\uc871\ud558\uae30 \uc704\ud574 \ubbf8\ub9ac \uacc4\uc0b0\ub41c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0 \uc561\uc138\uc2a4\ud558\ub294 \ubcd1\ubaa9 \ud604\uc0c1\uc744 \uc5b4\ub290 \uc815\ub3c4 \uc644\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\ub370\uc774\ud130\ub9c8\ud2b8 \ud2b9\uc131:<\/h3>\n<ul>\n<li>\ud06c\uae30\uac00 \uc791\uc74c<\/li>\n<li>\ud2b9\uc815\ud55c \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ubd80\uc11c \uc911\uc2ec\uc758;<\/li>\n<li>\uc0ac\uc5c5\ubd80\uc5d0\uc11c \uc815\uc758, \uc124\uacc4 \ubc0f \uac1c\ubc1c\ub428<\/li>\n<li>\uc0ac\uc5c5\ubd80\uc5d0\uc11c \uad00\ub9ac \ubc0f \uc720\uc9c0 \uad00\ub9ac\ud568<\/li>\n<li>\ube60\ub974\uac8c \uad6c\ud604\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\uad6c\ub9e4 \ube44\uc6a9\uc774 \ub354 \uc800\ub834\ud558\ub2e4;<\/li>\n<li>\ube60\ub978 \ud22c\uc790 \ud68c\uc218<\/li>\n<li>\ud234\uc14b\uc758 \uae34\ubc00\ud55c \ud1b5\ud569<\/li>\n<li>\ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \ub354\uc6b1 \uc790\uc138\ud558\uace0 \uae30\uc874\uc758 \uc694\uc57d \ud558\uc704 \uc9d1\ud569\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/li>\n<li>\uc804\uccb4 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc \uac00\ub2a5<\/li>\n<\/ul>\n<h3>\ub370\uc774\ud130 \ub9c8\ud2b8\uc758 \ub370\uc774\ud130 \uad6c\uc870:<\/h3>\n<p>\ub370\uc774\ud130 \ub9c8\ud2b8\uc5d0\uc11c \ub370\uc774\ud130 \uad6c\uc870\ub294 \uc885\uc885 \ubcc4 \ub610\ub294 \ub208\uc1a1\uc774 \uad6c\uc870\ub85c \uc124\uba85\ub429\ub2c8\ub2e4. \ubcc4 \uad6c\uc870\ub294 \ud329\ud2b8 \ud14c\uc774\ube14\uacfc \ub2e4\uc591\ud55c \uc9c0\uc6d0 \ucc28\uc6d0 \ud14c\uc774\ube14\uc774\ub77c\ub294 \ub450 \uac00\uc9c0 \uae30\ubcf8 \ubd80\ubd84\uc73c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4.<\/p>\n<h4>1.\uc5d0\ud504<span class=\"Y2IQFc\" lang=\"en\">act \ud14c\uc774\ube14<\/span><\/h4>\n<p>\ud329\ud2b8 \ud14c\uc774\ube14\uc740 \ub370\uc774\ud130 \ub9c8\ud2b8\uc5d0\uc11c \uac00\uc7a5 \ubc00\ub3c4\uac00 \ub192\uc740 \ub370\uc774\ud130\ub97c \uc124\uba85\ud569\ub2c8\ub2e4. \uc804\ud654 \ud68c\uc0ac\uc5d0\uc11c\ub294 \ud1b5\ud654\uc5d0 \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130\uac00 \uc77c\ubc18\uc801\uc73c\ub85c \uac00\uc7a5 \ubc00\ub3c4\uac00 \ub192\uc2b5\ub2c8\ub2e4. \uc740\ud589\uc5d0\uc11c\ub294 \uc870\uc815 \ubc0f ATM(\uc790\ub3d9\ud654 \ud604\uae08 \uc778\ucd9c\uae30)\uacfc \uad00\ub828\ub41c \ub370\uc774\ud130\uac00 \uc77c\ubc18\uc801\uc73c\ub85c \uac00\uc7a5 \uc9d1\uc57d\uc801\uc785\ub2c8\ub2e4. \uc18c\ub9e4\uc758 \uacbd\uc6b0 \ud310\ub9e4 \ubc0f \uc7ac\uace0 \ub370\uc774\ud130\uac00 \uac00\uc7a5 \ubc00\ub3c4\uac00 \ub192\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud329\ud2b8 \ud14c\uc774\ube14\uc740 \uc8fc\ubb38, \ud310\ub9e4, \uc804\ud654 \ud1b5\ud654 \ub4f1\uacfc \uac19\uc774 \ud329\ud2b8 \ud14c\uc774\ube14\uc758 \ubaa9\uc801\uc744 \ubc18\uc601\ud558\ub294 \uc5d4\ud130\ud2f0\uc758 \uae30\ubcf8 \ud0a4, \uae30\ubcf8 \ud0a4 \uc815\ubcf4, \ud329\ud2b8 \ud14c\uc774\ube14\uc744 \ucc28\uc6d0 \ud14c\uc774\ube14\uc5d0 \uc5f0\uacb0\ud558\ub294 \uc678\ub798 \ud0a4, \uc678\ub798 \ud0a4\uc5d0 \uc758\ud574 \uc804\ub2ec\ub418\ub294 \ud0a4\uac00 \uc544\ub2cc \uc678\ubd80 \ub370\uc774\ud130\ub97c \ud3ec\ud568\ud558\uc5ec \ubbf8\ub9ac \uacb0\ud569\ub41c \uc5ec\ub7ec \uc720\ud615\uc758 \ub370\uc774\ud130\uc758 \uc870\ud569\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc774 \ube44\ud575\uc2ec \uc678\ubd80 \ub370\uc774\ud130\uac00 \uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 \uacbd\uc6b0 <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%b6%84%ec%84%9d%ea%b0%80-%ea%b8%b0%ec%88%a0\/\">\ub370\uc774\ud130 \ubd84\uc11d<\/a><\/strong> in the fact table, it is included in the scope of the fact table. Fact tables are highly indexed. It is very common to have 30 to 40 indexes on a fact table. Sometimes each column of the fact table is indexed, and the result is that the data in the fact table is very easy to read. However, the number of resources required to import the index must factor into the equation. Normally, fact table data cannot be changed, but data can be entered, and once a record is entered correctly, nothing can be changed for that record.<\/p>\n<h4>2. \ucc28\uc6d0\ud45c<\/h4>\n<p>\ucc28\uc6d0 \ud14c\uc774\ube14\uc740 \ud329\ud2b8 \ud14c\uc774\ube14\uc744 \uc911\uc2ec\uc73c\ub85c \uad6c\ucd95\ub429\ub2c8\ub2e4. \ucc28\uc6d0 \ud14c\uc774\ube14\uc5d0\ub294 \uc678\ub798 \ud0a4\ub97c \ud1b5\ud574 \ud329\ud2b8 \ud14c\uc774\ube14\uc5d0 \uc5f0\uacb0\ub41c \ube44\uc9d1\uc911\uc801 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 \ucc28\uc6d0 \ud14c\uc774\ube14\uc740 \uc81c\ud488 \uce74\ud0c8\ub85c\uadf8, \uace0\uac1d \ubaa9\ub85d, \uacf5\uae09\uc5c5\uccb4 \ubaa9\ub85d \ub4f1\uc744 \ud3ec\ud568\ud55c \ub370\uc774\ud130 \ub9c8\ud2b8\ub97c \uae30\ubc18\uc73c\ub85c \ud569\ub2c8\ub2e4.<\/p>\n<p>\ub370\uc774\ud130 \ub9c8\ud2b8\uc758 \ub370\uc774\ud130\ub294 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0\uc11c \ub098\uc635\ub2c8\ub2e4. \ud55c \uac00\uc9c0 \uc608\uc678\ub97c \uc81c\uc678\ud558\uace0 \ubaa8\ub4e0 \ub370\uc774\ud130\ub294 \ub370\uc774\ud130 \ub9c8\ud2b8\ub85c \uac00\uc838\uc624\uae30 \uc804\uc5d0 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uac70\uccd0\uc57c \ud569\ub2c8\ub2e4. \uc774\uc5d0 \ub300\ud55c \uc608\uc678\ub294 \ub370\uc774\ud130 \ub9c8\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \ud2b9\uc815 \ub370\uc774\ud130\ub85c, \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 \ub2e4\ub978 \uacf3\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc678\ubd80 \ub370\uc774\ud130\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc774 \ubc94\uc8fc\uc5d0 \uc18d\ud569\ub2c8\ub2e4. \uadf8\ub807\uc9c0 \uc54a\uace0 \ub370\uc774\ud130\uac00 \uc758\uc0ac \uacb0\uc815 \uc9c0\uc6d0 \uc2dc\uc2a4\ud15c\uc758 \ub2e4\ub978 \uacf3\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \uacbd\uc6b0, \ub370\uc774\ud130\ub294 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uac70\uccd0\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>\ub370\uc774\ud130\ub9c8\ud2b8\uc5d0\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ub450 \uac00\uc9c0 \uc720\ud615\uc758 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4. <strong>\uc790\uc138\ud55c \ub370\uc774\ud130<\/strong> \uadf8\ub9ac\uace0 <strong>\uc9d1\uacc4\ub41c \ub370\uc774\ud130<\/strong>.<\/p>\n<h4>1. \uc790\uc138\ud55c \ub370\uc774\ud130<\/h4>\n<p>\uc55e\uc11c \uc124\uba85\ud55c \ub300\ub85c, \ub370\uc774\ud130 \ub9c8\ud2b8\uc5d0 \uc788\ub294 \uc790\uc138\ud55c \ub370\uc774\ud130\ub294 \uc2a4\ud0c0 \uad6c\uc870\ub85c \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc2a4\ud0c0 \uc2a4\ud0a4\ub9c8\ub294 \ub370\uc774\ud130\uac00 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \ud1b5\uacfc\ud560 \ub54c \uc798 \uc9d1\uacc4\ub41c\ub2e4\ub294 \uc810\uc744 \uc5b8\uae09\ud560 \uac00\uce58\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub294 \ud544\uc694\ud55c \uae30\ubcf8 \ub370\uc774\ud130\ub97c \ud3ec\ud568\ud558\uace0 \ub370\uc774\ud130 \ub9c8\ud2b8\uc5d0\ub294 \ub354 \ub192\uc740 \uac04\uaca9 \ud06c\uae30\uc758 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub370\uc774\ud130 \ub9c8\ud2b8 \uc0ac\uc6a9\uc790\uc758 \ub9c8\uc74c\uc18d\uc5d0\uc11c \uc2a4\ud0c0 \uad6c\uc870 \ub370\uc774\ud130\ub294 \ud68d\ub4dd\ud588\uc744 \ub54c\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc790\uc138\ud569\ub2c8\ub2e4.<\/p>\n<h4>2. \uc9d1\uacc4\ub41c \ub370\uc774\ud130<\/h4>\n<p>\ub370\uc774\ud130 \ub9c8\ud2b8\uc5d0 \ud3ec\ud568\ub41c \ub450 \ubc88\uc9f8 \uc720\ud615\uc758 \ub370\uc774\ud130\ub294 \uc9d1\uacc4\ub41c \ub370\uc774\ud130\uc785\ub2c8\ub2e4. \ubd84\uc11d\uac00\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc2a4\ud0c0 \uc2a4\ud0a4\ub9c8\uc758 \ub370\uc774\ud130\uc5d0\uc11c \ub2e4\uc591\ud55c \uc9d1\uacc4\ub41c \ub370\uc774\ud130\ub97c \ub9cc\ub4ed\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 \ub864\uc5c5\uc740 \ud310\ub9e4 \uc9c0\uc5ed\uc758 \ucd1d \uc6d4\uac04 \ub9e4\ucd9c\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc9d1\uacc4\uc758 \uae30\ubc18\uc774 \ub04a\uc784\uc5c6\uc774 \uc9c4\ud654\ud558\uae30 \ub54c\ubb38\uc5d0 \uacfc\uac70 \ub370\uc774\ud130\ub294 \ub370\uc774\ud130 \ub9c8\ud2b8\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc774 \uacfc\uac70 \ub370\uc774\ud130\uc758 \uc7a5\uc810\uc740 \uc800\uc7a5\ud558\ub294 \uc77c\ubc18\ud654 \uc218\uc900\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. \uc2a4\ud0c0 \uc2a4\ud0a4\ub9c8\uc5d0 \ubcf4\uad00\ub418\ub294 \uacfc\uac70 \ub370\uc774\ud130\ub294 \ub9e4\uc6b0 \uc801\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub370\uc774\ud130 \ub9c8\ud2b8\ub294 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uae30\ubc18\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub429\ub2c8\ub2e4. \uc77c\uc8fc\uc77c\uc5d0 \ud55c \ubc88 \uc815\ub3c4 \uc5c5\ub370\uc774\ud2b8\ub418\ub294 \uac83\uc740 \ub4dc\ubb38 \uc77c\uc774 \uc544\ub2d9\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub370\uc774\ud130 \ub9c8\ud2b8\uc758 \uc5c5\ub370\uc774\ud2b8 \uc2dc\uac04\uc740 1\uc8fc\uc77c \ubbf8\ub9cc\uc774\uac70\ub098 1\uc8fc\uc77c \ucd08\uacfc\uc77c \uc218 \uc788\uc73c\uba70, \uc774\ub294 \uc8fc\ub85c \ub370\uc774\ud130 \ub9c8\ud2b8\uac00 \uc18d\ud55c \ubd80\uc11c\uc758 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c \uacb0\uc815\ub429\ub2c8\ub2e4.<\/p>\n<h3>\ub370\uc774\ud130\ub9c8\ud2b8 \uc720\ud615:<\/h3>\n<h4>1. \ub3c5\ub9bd\uc801<\/h4>\n<p>\ub3c5\ub9bd \ub370\uc774\ud130 \ub9c8\ud2b8\uc758 \ub370\uc774\ud130\ub294 \ud2b9\uc218 \uc0ac\uc6a9\uc790\uc758 \uc694\uad6c\ub97c \ucda9\uc871\ud558\uae30 \uc704\ud574 \uad6c\ucd95\ub41c \ubd84\uc11d \ud658\uacbd\uc778 \uc6b4\uc601 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub098\uc635\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc885\ub958\uc758 \ub370\uc774\ud130 \ub9c8\ud2b8\uc758 \uac1c\ubc1c \uc8fc\uae30\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc9e7\uace0 \uc720\uc5f0\ud558\uc9c0\ub9cc \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc640 \ubd84\ub9ac\ub418\uc5b4 \uc788\uae30 \ub54c\ubb38\uc5d0 \ub3c5\ub9bd \ub370\uc774\ud130 \ub9c8\ud2b8\ub294 \uc815\ubcf4 \uc12c\uc774 \uc874\uc7ac\ud558\uac8c \ub420 \uc218 \uc788\uc73c\uba70 \ub370\uc774\ud130\ub97c \uae00\ub85c\ubc8c \uad00\uc810\uc5d0\uc11c \ubd84\uc11d\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<h4>2. \uc885\uc18d\uc801<\/h4>\n<p>\uc885\uc18d \ub370\uc774\ud130\ub9c8\ud2b8\uc758 \ub370\uc774\ud130\ub294 \uae30\uc5c5\uc758 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0\uc11c \ub098\uc624\ubbc0\ub85c \uac1c\ubc1c\uc8fc\uae30\uac00 \uae38\uc5b4\uc9c0\uc9c0\ub9cc \uc885\uc18d \ub370\uc774\ud130\ub9c8\ud2b8\ub294 \ub3c5\ub9bd \ub370\uc774\ud130\ub9c8\ud2b8\ubcf4\ub2e4 \uc544\ud0a4\ud14d\ucc98\uac00 \uc548\uc815\uc801\uc774\uc5b4\uc11c \uac1c\ubc1c\uc8fc\uae30\ub97c \ub2e8\ucd95\uc2dc\ud0ac \uc218 \uc788\ub2e4. <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\/\">\ub370\uc774\ud130\uc758 \ud488\uc9c8<\/a><\/strong> \ubd84\uc11d\uc744 \ud1b5\ud574 \ub370\uc774\ud130 \uc77c\uad00\uc131\uc744 \ubcf4\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n<h3>\ub370\uc774\ud130\ub9c8\ud2b8\uc758 \uc7a5\uc810:<\/h3>\n<ul>\n<li>\uc774\ub294 \uc18c\ub7c9\uc758 \ub370\uc774\ud130\ub9cc \ucc98\ub9ac\ud558\uba74 \ub418\ub294 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0 \uac00\uc7a5 \ube44\uc6a9 \ud6a8\uc728\uc801\uc778 \ub300\uc548 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4.<\/li>\n<li>\ub370\uc774\ud130\ub97c \uc18c\uc2a4\uc5d0\uc11c \ubd84\ub9ac\ud558\uba74 \ud2b9\uc815 \uadf8\ub8f9\uc758 \uc0ac\ub78c\ub4e4\uc774 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \ubaa8\ub450 \uc0ac\uc6a9\ud558\ub294 \ub300\uc2e0 \ud2b9\uc815 \uc18c\uc2a4\uc758 \ub370\uc774\ud130\ub97c \ub2e4\ub8f0 \uc218 \uc788\uc73c\ubbc0\ub85c \ub370\uc774\ud130 \ub9c8\ud2b8\uc758 \ud6a8\uc728\uc131\uc774 \ub192\uc544\uc9d1\ub2c8\ub2e4.<\/li>\n<li>\uc5b4\ub5a4 \ud558\uc704 \uc9d1\ud569\uc5d0 \uc811\uadfc\ud574\uc57c \ud558\ub294\uc9c0 \uc54c\uace0 \uc788\ub2e4\uba74 \ub370\uc774\ud130 \ub9c8\ud2b8\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\uc5d0 \ub354 \ube60\ub974\uac8c \uc811\uadfc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\uc0ac\uc6a9\uc774 \ub354 \uc26c\uc6cc\uc11c \ucd5c\uc885 \uc0ac\uc6a9\uc790\uac00 \uc27d\uac8c \ucffc\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ub370\uc774\ud130\uac00 \uadf8\ub8f9\uc73c\ub85c \ubd84\ub9ac\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ubcf4\ub2e4 \uad6c\ud604 \uc2dc\uc810 \ub370\uc774\ud130\ub9c8\ud2b8\uc5d0 \uc785\ub825\ud558\ub294 \ub370 \uac78\ub9ac\ub294 \uc2dc\uac04\uc774 \uc9e7\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ud2b9\uc815 \uc8fc\uc81c\uc758 \uacfc\uac70 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc26c\uc6b4 \ucd94\uc138 \ubd84\uc11d\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h3>\ub370\uc774\ud130\ub9c8\ud2b8 \uad6c\ud604 \ub2e8\uacc4:<\/h3>\n<h4>1\ub2e8\uacc4. \ub514\uc790\uc778:<\/h4>\n<p>\uc774\ub294 \uad6c\ud604\uc758 \uccab \ubc88\uc9f8 \ub2e8\uacc4\uc774\uba70, \uae30\uc220 \ubc0f \ube44\uc988\ub2c8\uc2a4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\ub294 \ub370 \ud544\uc694\ud55c \ubaa8\ub4e0 \uc791\uc5c5\uacfc \uc18c\uc2a4\ub97c \uc2dd\ubcc4\ud569\ub2c8\ub2e4. \ub17c\ub9ac\uc801 \uacc4\ud68d\uc740 \ub098\uc911\uc5d0 \uad6c\ud604\ub418\uace0 \uac80\ud1a0 \ud6c4 \ubb3c\ub9ac\uc801 \uacc4\ud68d\uc73c\ub85c \ubcc0\ud658\ub429\ub2c8\ub2e4. \ub610\ud55c \uc5ec\uae30\uc11c \ub370\uc774\ud130\uc758 \ub17c\ub9ac\uc801 \ubc0f \ubb3c\ub9ac\uc801 \uad6c\uc870\uac00 \uacb0\uc815\ub429\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ub370\uc774\ud130\ub97c \ubd84\ud560\ud558\ub294 \ubc29\ubc95\uacfc \ub0a0\uc9dc \ub610\ub294 \ub2e4\ub978 \ud30c\uc77c\uacfc \uac19\uc740 \ud544\ub4dc\ub97c \ubd84\ud560\ud558\ub294 \ubc29\ubc95\uc774 \uacb0\uc815\ub429\ub2c8\ub2e4.<\/p>\n<h4>2\ub2e8\uacc4. \uac74\uc124:<\/h4>\n<p>\uc774\uac83\uc740 \uad6c\ud604\uc758 \ub450 \ubc88\uc9f8 \ub2e8\uacc4\uc774\uba70, RDBMS\uc758 \ub3c4\uc6c0\uc73c\ub85c \ubb3c\ub9ac\uc801 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\ub294 \uac83\uc740 \uc124\uacc4 \ud504\ub85c\uc138\uc2a4\uc640 \ub17c\ub9ac\uc801 \uad6c\uc870\uc758 \uc77c\ubd80\ub85c \uacb0\uc815\ub429\ub2c8\ub2e4. \uc2a4\ud0a4\ub9c8, \uc778\ub371\uc2a4, \ud14c\uc774\ube14, \ubdf0 \ub4f1\uacfc \uac19\uc740 \ubaa8\ub4e0 \uac1d\uccb4\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\n<h4><strong>3\ub2e8\uacc4. \ucc44\uc6b0\uae30:<\/strong><\/h4>\n<p>\uc774\uac83\uc740 \uc138 \ubc88\uc9f8 \ub2e8\uacc4\ub85c, \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uba74\uc11c \ub370\uc774\ud130\ub97c \ucc44\uc6c1\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \ucc44\uc6cc\uc9c0\uae30 \uc804\uc5d0 \ubaa8\ub4e0 \ud544\uc218 \ubcc0\ud658\uc774 \uad6c\ud604\ub429\ub2c8\ub2e4.<\/p>\n<h4><strong>4\ub2e8\uacc4. \uc811\uadfc:\u00a0<\/strong><\/h4>\n<p>\uc774\uac83\uc740 \uad6c\ud604\uc758 \ub2e4\uc74c \ub2e8\uacc4\uc774\uba70, \ucc44\uc6cc\uc9c4 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubcf4\uace0\uc11c\ub97c \ub9cc\ub4e4\uae30 \uc704\ud55c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4. \ucd5c\uc885 \uc0ac\uc6a9\uc790\ub294 \uc774 \ub2e8\uacc4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc774\ud574\ud569\ub2c8\ub2e4.<\/p>\n<h4>5\ub2e8\uacc4. \uad00\ub9ac:<\/h4>\n<p>\uc774\ub294 \ub370\uc774\ud130 \ub9c8\ud2b8 \uad6c\ud604\uc758 \ub9c8\uc9c0\ub9c9 \ub2e8\uacc4\ub85c, \uc561\uc138\uc2a4 \uad00\ub9ac, \uc2dc\uc2a4\ud15c \ucd5c\uc801\ud654 \ubc0f \ud29c\ub2dd, \ub370\uc774\ud130 \ub9c8\ud2b8\uc5d0 \uc0c8 \ub370\uc774\ud130 \uad00\ub9ac \ubc0f \ucd94\uac00, \ubaa8\ub4e0 \uc2e4\ud328 \uc2dc\ub098\ub9ac\uc624\ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \ubcf5\uad6c \uc2dc\ub098\ub9ac\uc624 \uacc4\ud68d \ub4f1\uc758 \uc791\uc5c5\uc774 \uc5ec\uae30\uc11c \ucc98\ub9ac\ub429\ub2c8\ub2e4.<\/p>\n<h3>\uacb0\ub860<\/h3>\n<p>\uc800\ud76c \uae30\uc0ac\ub97c \uc77d\uc5b4\uc8fc\uc154\uc11c \uac10\uc0ac\ud569\ub2c8\ub2e4. \uc7ac\ubbf8\uc788\uac8c \uc77d\uc73c\uc168\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4. \ub354 \uc790\uc138\ud788 \uc54c\uace0 \uc2f6\uc73c\uc2dc\ub2e4\uba74 <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/category\/data-governance-101\/\">\ub370\uc774\ud130 \uac70\ubc84\ub10c\uc2a4<\/a><\/strong>, \ubc29\ubb38\ud558\uc2dc\uae30\ub97c \uad8c\uc7a5\ub4dc\ub9bd\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>\u00a0\uc624\ub298\ub0a0 \uc2dc\uc7a5\uc5d0 \ucd9c\uc2dc\ub41c Gudu SQLFlow\ub294 SQL \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c\uc744 \ubd84\uc11d\ud558\uace0 \uc5bb\uc744 \uc218 \uc788\uc744 \ubfd0\ub9cc \uc544\ub2c8\ub77c <strong><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\/\">\ub370\uc774\ud130 \uacc4\ubcf4<\/a><\/strong>, \uc2dc\uac01\uc801 \ud45c\uc2dc\ub97c \uc218\ud589\ud560 \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 \ud45c\uc2dc\ub97c \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4.\u00a0<strong>(2022\ub144 6\uc6d4 22\uc77c Ryan\uc774 \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":4573,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[178],"tags":[193,187,191,188,190,189,157,192],"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/4542"}],"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=4542"}],"version-history":[{"count":29,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/4542\/revisions"}],"predecessor-version":[{"id":4574,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/4542\/revisions\/4574"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media\/4573"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=4542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/categories?post=4542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/tags?post=4542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}