{"id":3347,"date":"2022-04-19T01:47:24","date_gmt":"2022-04-19T09:47:24","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=3347"},"modified":"2026-07-11T22:56:12","modified_gmt":"2026-07-12T06:56:12","slug":"whats-sql-lineage-101","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/ko\/%ec%99%93%ec%b8%a0-sql-%ea%b3%84%eb%b3%b4-101\/","title":{"rendered":"SQL Lineage\ub780 \ubb34\uc5c7\uc778\uac00? | SQL Lineage 101"},"content":{"rendered":"<h1>SQL Lineage\ub780 \ubb34\uc5c7\uc778\uac00? | SQL Lineage 101<\/h1>\n<p>\ub370\uc774\ud130 \uacfc\ud559\uc758 \uc8fc\uc694 \uc131\uacfc \uc911 \ud558\ub098\ub294 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub378\uc758 \ub4f1\uc7a5\uc785\ub2c8\ub2e4. \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad6c\uc131 \uaddc\uce59 \ub355\ubd84\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc124\uacc4, \uad6c\ucd95 \ubc0f \uad00\ub9ac\ud558\ub294 \uac83\uc774 \ub354 \uc26c\uc6cc\uc84c\uace0, \uc774\ub97c \uae30\ubc18\uc73c\ub85c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uacfc \ubcf4\uace0\uc11c\ub97c \uac1c\ubc1c\ud558\ub294 \uac83\ub3c4 \uac00\ub2a5\ud574\uc84c\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud558\uc9c0\ub9cc \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc5ec\uc804\ud788 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc0dd\uc131, \uc870\uc791 \ubc0f \ucd94\ucd9c\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud45c\uc900\ud654\ub41c \ub3c4\uad6c\uac00 \ubd80\uc871\ud569\ub2c8\ub2e4. \uadf8 \uacb0\uacfc, <strong><a href=\"https:\/\/en.wikipedia.org\/wiki\/SQL\">\uad6c\uc870\ud654 \uc9c8\uc758 \uc5b8\uc5b4(SQL)<\/a><\/strong> SQL\uc740 \ud14c\uc774\ube14\uacfc \uceec\ub7fc \uc815\uc758\ubd80\ud130 \ucd94\ucd9c-\ubcc0\ud658-\uc801\uc7ac(ETL) \ud504\ub85c\uc138\uc2a4 \uad6c\ud604, \uadf8\ub9ac\uace0 \uc5ec\ub7ec \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \uacb0\ud569\ud558\uc5ec \uc720\uc6a9\ud55c \uc815\ubcf4\ub97c \ub9cc\ub4dc\ub294 \ubcf5\uc7a1\ud55c \ud14c\uc774\ube14 \uc870\uc778\uc5d0 \uc774\ub974\uae30\uae4c\uc9c0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc758 \ubaa8\ub4e0 \uce21\uba74\uc744 \ud06c\uac8c \ub2e8\uc21c\ud654\ud558\ub294 \uad6d\uc81c \ud45c\uc900 \ucef4\ud4e8\ud305 \uc5b8\uc5b4\ub85c \uac1c\ubc1c\ub418\uc5c8\uc2b5\ub2c8\ub2e4. SQL\uc740 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uaddc\uce59\uc744 \uc5c4\uaca9\ud558\uac8c \uc900\uc218\ud558\uae30 \ub54c\ubb38\uc5d0 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p>\n<p>SQL\uc740 \uad6d\uc81c \ud45c\uc900\uc73c\ub85c\uc11c\uc758 \uc704\uc0c1\uacfc Oracle, MySQL, Microsoft SQL Server \ub4f1 \ub2e4\uc591\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \ub355\ubd84\uc5d0 \ub610 \ub2e4\ub978 \uc720\uc6a9\ud55c \uc6a9\ub3c4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \ubc14\ub85c SQL\uc744 \ud1b5\ud574 \ub2e4\uc591\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc744 \ud65c\uc6a9\ud560 \uc218 \uc788\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/3%eb%b6%84-%ec%95%88%ec%97%90-sql-server-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4%eb%a5%bc-%eb%b0%9c%ea%b2%ac%ed%95%98%ec%84%b8%ec%9a%94\/\"><strong>SQL \uacc4\ubcf4<\/strong><\/a> \ub3c4\uad6c.<\/p>\n<h2><strong>\uadf8\ub807\ub2e4\uba74 SQL \uacc4\ubcf4\ub780 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/strong><\/h2>\n<p>\uac04\ub2e8\ud788 \ub9d0\ud574, SQL\uc5d0\uc11c \ud30c\uc0dd\ub41c \ub370\uc774\ud130 \uacc4\ubcf4\uc785\ub2c8\ub2e4. \ub2e4\uc2dc \ub9d0\ud574, \ub370\uc774\ud130 \uc18c\uc2a4, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14, \uadf8\ub9ac\uace0 \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud558\ub294 \ubcf4\uace0\uc11c\ub97c \uad6c\ucd95, \uc720\uc9c0 \uad00\ub9ac \ubc0f \uad00\ub9ac\ud558\ub294 \ub370 \uc0ac\uc6a9\ub41c SQL \ucf54\ub4dc\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd98 \ub370\uc774\ud130 \uacc4\ubcf4\uc785\ub2c8\ub2e4. \ub9ce\uc740 \uacbd\uc6b0, \uc18c\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c(\ub610\ub294 \uc2dc\uc2a4\ud15c\ub4e4)\uc744 \uac70\uccd0 \ub300\uc0c1 \ubcf4\uace0\uc11c\ub85c \uc774\uc5b4\uc9c0\ub294 \ub370\uc774\ud130\uc758 \uc5ec\uc815\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \uc815\ubcf4\ub294 SQL \ucf54\ub4dc\uc5d0\uc11c \uc218\uc9d1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <span class=\"Y2IQFc\" lang=\"en\">\ubb3c\ub860, \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uc640 SQL\uc774 \ud3ec\ud568\ub41c \uae30\ud0c0 \uc544\ud2f0\ud329\ud2b8\ub97c \ubaa8\ub450 \uc5f4\uc5b4 \uac80\uc0ac\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \uc218\ub3d9\uc73c\ub85c \uc774 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774 \ubc29\ubc95\uc740 SQL\uc5d0 \ub300\ud55c \uae4a\uc740 \uc774\ud574, \uc138\ubd80 \uc0ac\ud56d\uc5d0 \ub300\ud55c \uc9d1\ucc29, \uadf8\ub9ac\uace0 \ub9ce\uc740 \uc5ec\uc720 \uc2dc\uac04\uc744 \ud544\uc694\ub85c \ud569\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p><span class=\"Y2IQFc\" lang=\"en\">\ubb3c\ub860, \ub354 \ub098\uc740 \uc811\uadfc \ubc29\uc2dd\uc740 \uc790\ub3d9\ud654\ub41c \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec SQL\uc744 \uc790\ub3d9\uc73c\ub85c \ucc3e\uace0 \uad6c\ubb38 \ubd84\uc11d\ud558\uc5ec \ub370\uc774\ud130 \uacc4\ubcf4 \uad00\uacc4\ub97c \uad6c\ucd95\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774 \ubc29\ubc95\uc740 \uc0ac\ub78c\uc758 \uac1c\uc785\uc774 \uc804\ud600 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub610\ud55c SQL\uc740 \ud45c\uc900 \uad6c\ubb38\uc744 \uac00\uc9c0\uace0 \uc788\uc73c\uba70 \ub2e4\uc591\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc0ac\uc6a9\ub418\ubbc0\ub85c SQL \uacc4\ubcf4 \ub3c4\uad6c\ub294 \uc2dc\uc2a4\ud15c\uc5d0 \ub3c5\ub9bd\uc801\uc774\ub77c\ub294 \uc810\ub3c4 \uc911\uc694\ud569\ub2c8\ub2e4.<\/span><span class=\"Y2IQFc\" lang=\"en\">\ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uad00\uacc4\ud615\uc740 \uc544\ub2c8\uc9c0\ub9cc, \ube44\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc77c\ubd80 \uacbd\uc6b0\uc5d0 \uc778\uae30\ub97c \uc5bb\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 SQL\uc740 \uc5ec\uc804\ud788 \ub300\ub2e4\uc218 \uae30\uc5c5 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc758 \uae30\ubc18\uc774\uba70, \uc774\ub7ec\ud55c \ucd94\uc138\uac00 \uc9c0\uc18d\ub418\ub294 \ud55c SQL \ub370\uc774\ud130 \uacc4\ubcf4\ub294 \ubaa8\ub4e0 \uc790\ub3d9\ud654\ub41c \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c\uc758 \ud575\uc2ec \uad6c\uc131 \uc694\uc18c\uac00 \ub420 \uac83\uc785\ub2c8\ub2e4.<\/span><\/p>\n<h2>\uacb0\ub860<\/h2>\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>\ubb50\uc57c<\/strong> <strong>SQL \uacc4\ubcf4<\/strong>. \ub354 \uc54c\uace0 \uc2f6\ub2e4\uba74 <strong>SQL \uacc4\ubcf4, <\/strong>\uc800\ud76c\ub294 \uc5ec\ub7ec\ubd84\uaed8 \ubc29\ubb38\uc744 \uad8c\uc7a5\ud574 \ub4dc\ub9ac\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/\">Gudu SQLFlow<\/a><\/strong> \ub354 \ub9ce\uc740 \uc815\ubcf4\ub97c \uc6d0\ud558\uc2dc\uba74! \ub2e4\uc2dc \ud55c\ubc88 \uac10\uc0ac\ud569\ub2c8\ub2e4! <strong>(\ub77c\uc774\uc5b8\uc774 2022\ub144 4\uc6d4 19\uc77c\uc5d0 \uac8c\uc2dc\ud568)<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>SQL \uacc4\ubcf4\ub780 \ubb34\uc5c7\uc77c\uae4c\uc694? | SQL \uacc4\ubcf4 \uae30\ucd08 \ub370\uc774\ud130 \uacfc\ud559\uc758 \uc8fc\uc694 \uc131\uacfc \uc911 \ud558\ub098\ub294 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub378\uc758 \ub4f1\uc7a5\uc785\ub2c8\ub2e4. \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad6c\uc131 \uaddc\uce59 \ub355\ubd84\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc124\uacc4, \uad6c\ucd95, \uad00\ub9ac\ud558\uace0 \uc774\ub97c \uae30\ubc18\uc73c\ub85c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uacfc \ubcf4\uace0\uc11c\ub97c \ub9cc\ub4dc\ub294 \uac83\uc774 \ud6e8\uc52c \uc26c\uc6cc\uc84c\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc5ec\uc804\ud788 \ub370\uc774\ud130 \uc0dd\uc131, \uc870\uc791, \ucd94\ucd9c\uc744 \uc704\ud55c \ud45c\uc900\ud654\ub41c \ub3c4\uad6c\uac00 \ubd80\uc871\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ubb38\uc81c\uc810\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc758 \ubaa8\ub4e0 \uce21\uba74, \uc989 \ud14c\uc774\ube14\uacfc \uc5f4 \uc815\uc758\ubd80\ud130 ETL(\ucd94\ucd9c-\ubcc0\ud658-\uc801\uc7ac) \ud504\ub85c\uc138\uc2a4 \uad6c\ud604, \ubcf5\uc7a1\ud55c \ud14c\uc774\ube14 \uc870\uc778 \uc218\ud589\uae4c\uc9c0 \ud06c\uac8c \uac04\uc18c\ud654\ud558\ub294 \uad6d\uc81c \ud45c\uc900 \ucef4\ud4e8\ud305 \uc5b8\uc5b4\uc778 SQL(\uad6c\uc870\ud654 \uc9c8\uc758 \uc5b8\uc5b4)\uc774 \uac1c\ubc1c\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>","protected":false},"author":27,"featured_media":3378,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[31,178],"tags":[53,50,51,54,52],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3347"}],"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=3347"}],"version-history":[{"count":13,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3347\/revisions"}],"predecessor-version":[{"id":6625,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3347\/revisions\/6625"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media\/3378"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=3347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/categories?post=3347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/tags?post=3347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}