{"id":3347,"date":"2022-04-19T01:47:24","date_gmt":"2022-04-19T09:47:24","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=3347"},"modified":"2022-06-09T20:46:47","modified_gmt":"2022-06-10T04:46:47","slug":"whats-sql-lineage-101","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/jp\/whats-sql-lineage-101\/","title":{"rendered":"SQL \u30ea\u30cd\u30fc\u30b8\u30e5\u3068\u306f| | SQL\u7cfb\u7d71101"},"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;\"><h1>SQL \u30ea\u30cd\u30fc\u30b8\u30e5\u3068\u306f| | SQL\u7cfb\u7d71101<\/h1>\n<p>\u30c7\u30fc\u30bf \u30b5\u30a4\u30a8\u30f3\u30b9\u306e\u4e3b\u8981\u306a\u6210\u679c\u306e 1 \u3064\u306f\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30e2\u30c7\u30eb\u306e\u51fa\u73fe\u3067\u3059\u3002\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u69cb\u6210\u898f\u5247\u306b\u3088\u308a\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8a2d\u8a08\u3001\u69cb\u7bc9\u3001\u304a\u3088\u3073\u7ba1\u7406\u3001\u304a\u3088\u3073\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u95a2\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068\u30ec\u30dd\u30fc\u30c8\u306e\u69cb\u7bc9\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u305f\u3060\u3057\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u306f\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3001\u64cd\u4f5c\u3001\u304a\u3088\u3073\u62bd\u51fa\u3059\u308b\u305f\u3081\u306e\u6a19\u6e96\u5316\u3055\u308c\u305f\u30c4\u30fc\u30eb\u304c\u307e\u3060\u3042\u308a\u307e\u305b\u3093\u3002\u7d50\u679c\u3068\u3057\u3066\u3001 <strong><a href=\"https:\/\/en.wikipedia.org\/wiki\/SQL\">\u69cb\u9020\u5316\u7167\u4f1a\u8a00\u8a9e (SQL)<\/a><\/strong> \u304c\u958b\u767a\u3055\u308c\u307e\u3057\u305f\u3002\u56fd\u969b\u6a19\u6e96\u306e\u30b3\u30f3\u30d4\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u8a00\u8a9e\u3067\u3042\u308a\u3001\u30c6\u30fc\u30d6\u30eb\u3068\u5217\u306e\u5b9a\u7fa9\u304b\u3089\u62bd\u51fa - \u5909\u63db - \u30ed\u30fc\u30c9 (ETL) \u30d7\u30ed\u30bb\u30b9\u306e\u5b9f\u88c5\u3001\u3055\u307e\u3056\u307e\u306a\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u6709\u7528\u306a\u60c5\u5831\u306b\u7d50\u5408\u3059\u308b\u8907\u96d1\u306a\u30c6\u30fc\u30d6\u30eb\u7d50\u5408\u306e\u5b9f\u884c\u307e\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u306e\u3059\u3079\u3066\u306e\u5074\u9762\u3092\u5927\u5e45\u306b\u7c21\u7d20\u5316\u3057\u307e\u3059\u3002 SQL \u306f\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30eb\u30fc\u30eb\u306b\u53b3\u5bc6\u306b\u5f93\u3046\u305f\u3081\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u6574\u5408\u6027\u3092\u7dad\u6301\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n<p>\u56fd\u969b\u6a19\u6e96\u3068\u3057\u3066\u306e\u5730\u4f4d\u3068\u3001Oracle \u304b\u3089 MySQL\u3001Microsoft SQL Server \u306b\u81f3\u308b\u307e\u3067\u3001\u591a\u304f\u306e\u7a2e\u985e\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30b7\u30b9\u30c6\u30e0\u3067\u5e83\u304f\u4f7f\u7528\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001SQL \u306f\u5225\u306e\u6709\u7528\u306a\u7528\u9014\u3082\u63d0\u4f9b\u3057\u307e\u3059\u3002 <a href=\"https:\/\/www.gudusoft.com\/jp\/%e7%99%ba%e8%a6%8b-sql-server-data-lineage-in-3-minutes\/\"><strong>SQL\u7cfb\u7d71<\/strong><\/a> \u30c4\u30fc\u30eb\u3002<\/p>\n<h2><strong>\u3067\u306f\u3001SQL\u7cfb\u7d71\u3068\u306f\u4f55\u3067\u3059\u304b?<\/strong><\/h2>\n<p>\u3064\u307e\u308a\u3001SQL \u304b\u3089\u6d3e\u751f\u3057\u305f\u30c7\u30fc\u30bf\u7cfb\u7d71\u3067\u3059\u3002\u3064\u307e\u308a\u3001\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30c6\u30fc\u30d6\u30eb\u3001\u304a\u3088\u3073\u305d\u308c\u3089\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u5229\u7528\u3059\u308b\u30ec\u30dd\u30fc\u30c8\u306e\u69cb\u7bc9\u3001\u7dad\u6301\u3001\u304a\u3088\u3073\u7ba1\u7406\u306b\u4f7f\u7528\u3055\u308c\u308b SQL \u30b3\u30fc\u30c9\u306b\u7126\u70b9\u3092\u5f53\u3066\u305f\u30c7\u30fc\u30bf\u7cfb\u7d71\u3067\u3059\u3002\u591a\u304f\u306e\u72b6\u6cc1\u3067\u306f\u3001\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30b7\u30b9\u30c6\u30e0 (\u307e\u305f\u306f\u30b7\u30b9\u30c6\u30e0)\u3001\u30bf\u30fc\u30b2\u30c3\u30c8 \u30ec\u30dd\u30fc\u30c8\u3078\u306e\u30c7\u30fc\u30bf\u306e\u79fb\u52d5\u306b\u3064\u3044\u3066\u77e5\u3063\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308b\u3059\u3079\u3066\u306e\u60c5\u5831\u3092 SQL \u30b3\u30fc\u30c9\u304b\u3089\u53ce\u96c6\u3067\u304d\u307e\u3059\u3002 <span class=\"Y2IQFc\" lang=\"en\">\u3082\u3061\u308d\u3093\u3001\u3053\u308c\u306f SQL \u3092\u542b\u3080\u3059\u3079\u3066\u306e\u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3068\u305d\u306e\u4ed6\u306e\u6210\u679c\u7269\u3092\u958b\u3044\u3066\u691c\u67fb\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u624b\u52d5\u3067\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u3053\u306e\u65b9\u6cd5\u306b\u306f\u3001SQL \u306e\u6df1\u3044\u7406\u89e3\u3001\u8a73\u7d30\u3078\u306e\u57f7\u7740\u3001\u304a\u3088\u3073\u591a\u304f\u306e\u81ea\u7531\u6642\u9593\u304c\u5fc5\u8981\u3067\u3059\u3002\u00a0<\/span><\/p>\n<p><span class=\"Y2IQFc\" lang=\"en\">\u3082\u3061\u308d\u3093\u3001\u81ea\u52d5\u5316\u3055\u308c\u305f\u30c7\u30fc\u30bf\u7cfb\u7d71\u30c4\u30fc\u30eb\u3092\u4f7f\u7528\u3057\u3066 SQL \u3092\u81ea\u52d5\u7684\u306b\u691c\u7d22\u304a\u3088\u3073\u89e3\u6790\u3057\u3001\u30c7\u30fc\u30bf\u7cfb\u7d71\u95a2\u4fc2\u3092\u69cb\u7bc9\u3059\u308b\u3068\u3044\u3046\u3001\u3088\u308a\u512a\u308c\u305f\u30a2\u30d7\u30ed\u30fc\u30c1\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u65b9\u6cd5\u3067\u306f\u3001\u4eba\u9593\u306e\u4ecb\u5165\u306f\u5fc5\u8981\u3042\u308a\u307e\u305b\u3093\u3002\u307e\u305f\u3001SQL \u306b\u306f\u6a19\u6e96\u7684\u306a\u69cb\u6587\u304c\u3042\u308a\u3001\u591a\u304f\u306e\u7570\u306a\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30b7\u30b9\u30c6\u30e0\u3067\u4f7f\u7528\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001SQL \u30ea\u30cd\u30fc\u30b8\u30e5 \u30c4\u30fc\u30eb\u306f\u30b7\u30b9\u30c6\u30e0\u306b\u4f9d\u5b58\u3057\u306a\u3044\u3053\u3068\u3092\u6307\u6458\u3059\u308b\u3053\u3068\u3082\u91cd\u8981\u3067\u3059\u3002<\/span><span class=\"Y2IQFc\" lang=\"en\">\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u5834\u5408\u306b\u3088\u3063\u3066\u306f\u975e\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u4e00\u822c\u7684\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068 SQL \u306f\u4f9d\u7136\u3068\u3057\u3066\u5927\u90e8\u5206\u306e\u30a8\u30f3\u30bf\u30fc\u30d7\u30e9\u30a4\u30ba \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30b7\u30b9\u30c6\u30e0\u306e\u57fa\u76e4\u3067\u3042\u308a\u3001\u305d\u3046\u3067\u3042\u308b\u9650\u308a\u3001SQL \u30ea\u30cd\u30fc\u30b8\u306f\u81ea\u52d5\u5316\u3055\u308c\u305f\u30c7\u30fc\u30bf \u30ea\u30cd\u30fc\u30b8 \u30c4\u30fc\u30eb\u306e\u91cd\u8981\u306a\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3068\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n<h2>\u7d50\u8ad6<\/h2>\n<p>\u3053\u306e\u8a18\u4e8b\u3092\u304a\u8aad\u307f\u3044\u305f\u3060\u304d\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002 <strong>\u306a\u306b<\/strong> <strong>SQL\u7cfb\u7d71<\/strong>.\u8a73\u3057\u304f\u77e5\u308a\u305f\u3044\u65b9\u306f <strong>SQL\u7cfb\u7d71\u3001 <\/strong>\u8a2a\u554f\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059 <strong><a href=\"https:\/\/www.gudusoft.com\/jp\/\">Gudu SQLFlow<\/a><\/strong> \u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\uff01\u518d\u5ea6\u3001\u611f\u8b1d\u3057\u307e\u3059\uff01 <strong>(2022 \u5e74 4 \u6708 19 \u65e5\u306b Ryan \u306b\u3088\u308a\u516c\u958b)<\/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":3378,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[31,178],"tags":[53,50,51,54,52],"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/posts\/3347"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/comments?post=3347"}],"version-history":[{"count":12,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/posts\/3347\/revisions"}],"predecessor-version":[{"id":3434,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/posts\/3347\/revisions\/3434"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/media\/3378"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/media?parent=3347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/categories?post=3347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/tags?post=3347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}