ãããããã«ïŒ
ããŒã¿ã¯äŒæ¥ã«ãšã£ãŠæã貎éãªè³ç£ã§ããããžã¿ã«ã«æ³šåããŠããã»ãŒãã¹ãŠã®äŒæ¥ãããã宣èšããŠããŸããããã«ç°è«ãå±ããã®ã¯å°é£ã§ããããŒã¿ã®ç®¡çãä¿åãåŠçã®ã¢ãããŒããè°è«ããã«éå¬ãããäž»èŠãª IT ã«ã³ãã¡ã¬ã³ã¹ã¯äžã€ããããŸããã
ããŒã¿ã¯å€éšããããããããŸããã瀟å ã§ãçæãããŸããéä¿¡äŒç€Ÿããã®ããŒã¿ã«ã€ããŠèšãã°ã瀟å ã®åŸæ¥å¡ã«ãšã£ãŠãããã¯ã¯ã©ã€ã¢ã³ãããã®èå³ãç¿æ £ãå Žæã«é¢ããæ å ±ã®ä¿ç®¡åº«ã§ããé©åãªãããã¡ã€ãªã³ã°ãšã»ã°ã¡ã³ããŒã·ã§ã³ãããã°ãåºåãªãã¡ãŒã¯æãå¹æçã«ãªããŸãããã ããå®éã«ã¯ããã¹ãŠãããã»ã©ãã©è²ã§ããããã§ã¯ãããŸãããäŒæ¥ãä¿åããŠããããŒã¿ã¯ã絶æçã«å€ããåé·ãå埩çã§ãããããŸãã¯ãã®ååšãäžéšã®ãŠãŒã¶ãŒä»¥å€ã«ã¯ç¥ãããŠããªãå¯èœæ§ããããŸãã ï¿£_(ã)_/ï¿£
äžèšã§èšãã°ãããŒã¿ã¯å¹æçã«ç®¡çãããªããã°ãªããŸãããããããŠåããŠãããŒã¿ã¯ããžãã¹ã«çã®ã¡ãªãããšå©çãããããè³ç£ãšãªãã®ã§ããæ®å¿µãªãããããŒã¿ç®¡çã®åé¡ã解決ããã«ã¯ãéåžžã«å€ãã®è€éããå
æããå¿
èŠããããŸãããããã¯äž»ã«ãã·ã¹ãã ã®ãåç©åãã®åœ¢ã§ã®æŽå²çéºç£ãšããã®ç®¡çã«å¯Ÿããçµ±äžãããããã»ã¹ãšã¢ãããŒãã®æ¬ åŠã®äž¡æ¹ãåå ã§ãããããããããŒã¿ããªãã³ããšã¯äœãæå³ããã®ã§ãããã?
ããã¯ãŸãã«ãã®ã«ããã®äžã§ã話ãããå
容ã§ããããªãŒãã³ãœãŒã¹ ã¹ã¿ãã¯ãã©ã®ããã«ç§ãã¡ãå©ããŠããããã«ã€ããŠãåæ§ã§ãã
æŠç¥çããŒã¿ç®¡çããŒã¿ ã¬ããã³ã¹ (DG) ã®æŠå¿µã¯ãã·ã¢åžå Žã§ã¯ãã§ã«ããç¥ãããŠããããã®å°å
¥ã®çµæãšããŠããžãã¹ãéæããç®æšã¯æ確ãã€æ確ã«å®£èšãããŠããŸããåœç€ŸãäŸå€ã§ã¯ãªããããŒã¿ç®¡çã®æŠå¿µãå°å
¥ãããšãã課é¡ãèªãã«èª²ããŸããã
ã§ã¯ãã©ãããå§ããã®ã§ãããã?ãŸãæåã«ãç§ãã¡ã¯èªåèªèº«ã®äž»èŠãªç®æšãèšå®ããŸããã
- ããŒã¿ã«ã¢ã¯ã»ã¹ã§ããç¶æ ãä¿ã¡ãŸãã
- ããŒã¿ã®ã©ã€ããµã€ã¯ã«ã®éææ§ã確ä¿ããŸãã
- äŒæ¥ãŠãŒã¶ãŒã«äžè²«æ§ã®ããããŒã¿ãæäŸããŸãã
- äŒæ¥ãŠãŒã¶ãŒã«æ€èšŒæžã¿ã®ããŒã¿ãæäŸããŸãã
çŸåšããœãããŠã§ã¢åžå Žã«ã¯å€æ°ã®ããŒã¿ ã¬ããã³ã¹ ã¯ã©ã¹ã®ããŒã«ãååšããŸãã
ãããããœãªã¥ãŒã·ã§ã³ã詳现ã«åæããŠæ€èšããçµæãç§ãã¡ã¯èªåèªèº«ã«å¯ŸããŠå€ãã®æ¹å€çãªã³ã¡ã³ããèšé²ããŸããã
- ã»ãšãã©ã®ã¡ãŒã«ãŒã¯å æ¬çãªãœãªã¥ãŒã·ã§ã³ã®ã»ãããæäŸããŠããŸãããç§ãã¡ã«ãšã£ãŠãããã¯åé·ã§ãããæ¢åã®æ©èœãšéè€ããŸããããã«ãçŸåšã® IT ç°å¢ãžã®çµ±åã«ã¯ãªãœãŒã¹ã®é¢ã§ãé«äŸ¡ã§ãã
- æ©èœãšã€ã³ã¿ãŒãã§ã€ã¹ã¯ãããžãã¹ ãšã³ã ãŠãŒã¶ãŒã§ã¯ãªããæè¡è åãã«èšèšãããŠããŸãã
- 補åã®çåçãäœãããã·ã¢åžå Žã§ã®å°å ¥ãæåããŠããªãã
- é«é¡ãªãœãããŠã§ã¢ãšãããªããµããŒãã
ãã·ã¢äŒæ¥åãã®ãœãããŠã§ã¢ã®èŒžå ¥ä»£æ¿ã«é¢ããäžèšã®åºæºãšæšå¥šäºé ã«ãããç§ãã¡ã¯ãªãŒãã³ãœãŒã¹ ã¹ã¿ãã¯ã§ã®ç¬èªã®éçºã«ç§»è¡ããããšã確信ããŸãããç§ãã¡ãéžæãããã©ãããã©ãŒã ã¯ãPython ã§æžãããç¡æã®ãªãŒãã³ãœãŒã¹ ãã¬ãŒã ã¯ãŒã¯ã§ãã Django ã§ãããããã£ãŠãäžèšã®ç®æšã«è²¢ç®ããäž»èŠãªã¢ãžã¥ãŒã«ãç¹å®ããŸããã
- ã¬ããŒãã®ç»é²ã
- ããžãã¹çšèªéã
- æè¡çãªå€é©ã説æããã¢ãžã¥ãŒã«ã
- ãœãŒã¹ãã BI ããŒã«ãŸã§ã®ããŒã¿ ã©ã€ã ãµã€ã¯ã«ãèšè¿°ããã¢ãžã¥ãŒã«ã
- ããŒã¿å質管çã¢ãžã¥ãŒã«ã
ã¬ããŒãã®ç»é²
倧äŒæ¥ã®å éšèª¿æ»ã®çµæã«ãããšãããŒã¿é¢é£ã®åé¡ã解決ããéãåŸæ¥å¡ã¯åé¡ã®æ€çŽ¢ã« 40 ïœ 80% ã®æéãè²»ãããŠããŸãããããã£ãŠãç§ãã¡ã¯ããããŸã§é¡§å®¢ã®ã¿ãå©çšã§ããæ¢åã®ã¬ããŒãã«é¢ããæ å ±ããªãŒãã³ã«ãããšãã課é¡ãèªãã«èª²ããŸããããããã£ãŠãæ°ããã¬ããŒãã®äœæã«ãããæéãççž®ãããããŒã¿ã®æ°äž»åãä¿èšŒãããŸãã
ã¬ããŒãç»é²ã¯ãããŸããŸãªå°åãéšéãéšéã®å
éšãŠãŒã¶ãŒåãã®åäžã®ã¬ããŒã ãŠã£ã³ããŠã«ãªããŸãããäŒç€Ÿã®ããã€ãã®äŒæ¥ãªããžããªã§äœæãããæ
å ±ãµãŒãã¹ã«é¢ããæ
å ±ãçµ±åãããŠããããã®å€ã㯠Rostelecom ã«ãããŸãã
ããããã¬ãžã¹ããªã¯ãéçºãããã¬ããŒãã®åãªãç¡å³ä¹Ÿç¥ãªãªã¹ãã§ã¯ãããŸãããåã¬ããŒãã«ã€ããŠããŠãŒã¶ãŒãã¬ããŒããããç解ããããã«å¿ èŠãªæ å ±ãæäŸãããŸãã
- ã¬ããŒãã®ç°¡åãªèª¬æã
- ããŒã¿å¯çšæ§ã®æ·±ãã
- 顧客ã»ã°ã¡ã³ãã
- èŠèŠåããŒã«ã
- äŒæ¥ã¹ãã¬ãŒãžã®ååã
- ããžãã¹æ©èœèŠä»¶ã
- ã¬ããŒããžã®ãªã³ã¯ã
- ã¢ã¯ã»ã¹çšã®ã¢ããªã±ãŒã·ã§ã³ãžã®ãªã³ã¯ã
- å®æœç¶æ³ã
ã¬ããŒãã§ã¯äœ¿çšç¶æ³ã¬ãã«ã®åæãå©çšã§ããã¬ããŒãã¯ãŠããŒã¯ ãŠãŒã¶ãŒæ°ã«åºã¥ããã°åæã«åºã¥ããŠãªã¹ãã®å é ã«ã©ã³ã¯ä»ããããŸããããã ãã§ã¯ãããŸãããäžè¬çãªç¹æ§ã«å ããŠãã¬ããŒãã®å±æ§æ§æã«ã€ããŠãå€ãšèšç®æ¹æ³ã®äŸã瀺ããŠè©³ãã説æããŸããããã®ãããªè©³çŽ°æ å ±ã«ããããŠãŒã¶ãŒã¯ã¬ããŒããèªåã«ãšã£ãŠåœ¹ç«ã€ãã©ããã®çããããã«åŸãããŸãã
ãã®ã¢ãžã¥ãŒã«ã®éçºã¯ããŒã¿ã®æ°äž»åã«ãããéèŠãªã¹ãããã§ãããå¿ èŠãªæ å ±ãèŠã€ããã®ã«ãããæéãå€§å¹ ã«ççž®ãããŸãããæ€çŽ¢æéã®ççž®ã«å ãããµããŒãããŒã ãžã®çžè«ä»¶æ°ãæžå°ããŸãããã¬ããŒãã®çµ±åç»é²ãéçºããããšã«ãã£ãŠéæããããã XNUMX ã€ã®æçãªçµæãã€ãŸãç°ãªãæ§é åäœã«å¯Ÿããéè€ããã¬ããŒãã®éçºãé²æ¢ããããšã¯æ³šç®ããªãããã«ã¯ãããŸããã
ããžãã¹çšèªé
åãäŒç€Ÿå ã§ãã£ãŠããäŒæ¥ã«ãã£ãŠäœ¿çšãããèšèªãç°ãªãããšã¯çããããåç¥ã§ããããã¯ããåãçšèªã䜿çšããŠããŸãããæå³ã¯ãŸã£ããç°ãªããŸããããžãã¹çšèªéã¯ãã®åé¡ã解決ããããã«èšèšãããŸããã
ç§ãã¡ã«ãšã£ãŠããžãã¹çšèªéã¯ãçšèªãèšç®æ¹æ³ã解説ãããåãªãåèæžã§ã¯ãããŸãããããã¯ãçšèªã®éçºãåæãæ¿èªãçšèªãšäŒç€Ÿã®ãã®ä»ã®æ å ±è³ç£ãšã®é¢ä¿ã®æ§ç¯ã®ããã®æ¬æ Œçãªç°å¢ã§ããããžãã¹çšèªéã«å ¥ãåã«ãçšèªã¯äŒæ¥é¡§å®¢ããã³ããŒã¿å質ã»ã³ã¿ãŒã«ããæ¿èªã®ãã¹ãŠã®æ®µéãçµãå¿ èŠããããŸãããã®åŸåããŠäœ¿çšã§ããããã«ãªããŸãã
äžã§æžããããã«ããã®ããŒã«ã®ç¬èªæ§ã¯ãããžãã¹çšèªã®ã¬ãã«ãããããã䜿çšãããŠããç¹å®ã®ãŠãŒã¶ãŒ ã¬ããŒããããã³ç©çããŒã¿ããŒã¹ ãªããžã§ã¯ãã®ã¬ãã«ãžã®æ¥ç¶ãå¯èœã«ããããšã§ãã
ããã¯ãã¬ãžã¹ã㪠ã¬ããŒãã®è©³çŽ°ãªèª¬æãšç©çããŒã¿ããŒã¹ ãªããžã§ã¯ãã®èª¬æã§çšèªéã®çšèªèå¥åã䜿çšããããšã«ãã£ãŠå¯èœã«ãªããŸãã
çŸåšã4000 ãè¶ ããçšèªãçšèªéã§å®çŸ©ãããåæãããŠããŸããããã䜿çšãããšãäŒæ¥ã®æ å ±ã·ã¹ãã ã«åä¿¡ããå€æŽèŠæ±ã®åŠçãç°¡çŽ åãããé«éåãããŸããå¿ èŠãªã€ã³ãžã±ãŒã¿ãŒãããããã®ã¬ããŒãã«ãã§ã«å®è£ ãããŠããå ŽåããŠãŒã¶ãŒã¯ããã®ã€ã³ãžã±ãŒã¿ãŒã䜿çšãããŠããæ¢è£œã®ã¬ããŒãã®ã»ãããããã«è¡šç€ºããæ¢åã®æ©èœãå¹æçã«åå©çšããããæå°éã®å€æŽãè¡ããããéå§ããããšãªã決å®ã§ããŸããæ°ããã¬ããŒãã®éçºã«é¢ããæ°ãããªã¯ãšã¹ãã
æè¡çãªå€é©ãšDataLineageã説æããã¢ãžã¥ãŒã«
ãããã®ã¢ãžã¥ãŒã«ã¯äœã§ãã?åã«ã¬ããŒãç»é²ãšçšèªéãå®è£ ããã ãã§ã¯ååã§ã¯ãªãããã¹ãŠã®ããžãã¹çšèªãç©çããŒã¿ããŒã¹ ã¢ãã«ã«åºã¥ããŠç¢ºç«ããããšãå¿ èŠã§ãããã®ããã«ããŠããœãŒã¹ ã·ã¹ãã ãã BI èŠèŠåãŸã§ãããŒã¿ ãŠã§ã¢ããŠã¹ã®ãã¹ãŠã®å±€ãä»ããŠããŒã¿ ã©ã€ã ãµã€ã¯ã«ã圢æããããã»ã¹ãå®äºããããšãã§ããŸãããã€ãŸããDataLineage ãæ§ç¯ããŸãã
ç§ãã¡ã¯ãããŒã¿å€æã®ã«ãŒã«ãšããžãã¯ãèšè¿°ããããã«ç€Ÿå ã§ä»¥åã«äœ¿çšãããŠãã圢åŒã«åºã¥ããŠã€ã³ã¿ãŒãã§ã€ã¹ãéçºããŸããã以åãšåãæ å ±ãã€ã³ã¿ãŒãã§ã€ã¹ãä»ããŠå ¥åãããŸãããããžãã¹çšèªéããã®çšèªèå¥åã®å®çŸ©ãåææ¡ä»¶ã«ãªããŸãããããããããžãã¹å±€ãšç©çå±€ã®éã®æ¥ç¶ãæ§ç¯ããæ¹æ³ã§ãã
誰ããããå¿ èŠãšããŠããã§ããããïŒæ°å¹Žé䜿çšããŠããå€ããã©ãŒãããã®äœãåé¡ã§ããã?èŠä»¶ãäœæããããã®äººä»¶è²»ã¯ã©ããããå¢å ããŸããã?ç§ãã¡ã¯ããŒã«ã®å°å ¥äžã«ãã®ãããªçåã«å¯ŸåŠããå¿ èŠããããŸãããããã§ã®çãã¯éåžžã«ç°¡åã§ããäŒç€Ÿã®ããŒã¿ ãªãã£ã¹ãšãŠãŒã¶ãŒå šå¡ããããå¿ èŠãšããŠããŸãã
å®éãåŸæ¥å¡ã察å¿ããå¿ èŠããããåœåã¯æžé¡äœæã®äººä»¶è²»ãè¥å¹²å¢å ããŸãããããã®åé¡ã¯è§£æ±ºããŸãããç·Žç¿ãåé¡é åã®ç¹å®ãæé©åããã®åœ¹å²ãæãããŸãããç§ãã¡ã¯äž»ãªããšãéæããŸãã - éçºãããèŠä»¶ã®å質ãåäžãããŸãããå¿ é ãã£ãŒã«ããçµ±äžãããåèæžãå ¥åãã¹ã¯ãçµã¿èŸŒã¿ãã§ã㯠- ããããã¹ãŠã«ãããå€æèšè¿°ã®å質ãå€§å¹ ã«åäžãããããšãã§ããŸãããç§ãã¡ã¯ãéçºèŠä»¶ãšããŠã¹ã¯ãªãããåŒãæž¡ãæ £è¡ããé¢ããéçºããŒã ã®ã¿ãå©çšã§ããç¥èãå ±æããŸãããçæãããã¡ã¿ããŒã¿ ããŒã¿ããŒã¹ã«ãããååž°åæã®å®è¡ã«å¿ èŠãªæéãå€§å¹ ã«ççž®ãããIT ã©ã³ãã¹ã±ãŒãã®ããããã¬ã€ã€ãŒ (ã·ã§ãŒã±ãŒã¹ ã¬ããŒããéèšããœãŒã¹) ã«å¯Ÿããå€æŽã®åœ±é¿ãè¿ éã«è©äŸ¡ã§ããããã«ãªããŸãã
ããã¯ã¬ããŒãã®äžè¬ãŠãŒã¶ãŒãšã©ã®ãããªé¢ä¿ãããã®ã§ãããã? 圌ãã«ãšã£ãŠã®å©ç¹ã¯äœã§ãã? DataLineage ãæ§ç¯ã§ããæ©èœã®ãããã§ãSQL ããã®ä»ã®ããã°ã©ãã³ã°èšèªã«æ £ããŠããªããŠãŒã¶ãŒã§ããç¹å®ã®ã¬ããŒãã®çæã«åºã¥ããŠãœãŒã¹ãšãªããžã§ã¯ãã«é¢ããæ å ±ãããã«åãåãããšãã§ããŸãã
ããŒã¿å質管çã¢ãžã¥ãŒã«
ããŒã¿ã®éææ§ã確ä¿ãããšããç¹ã§äžã§è¿°ã¹ãããšã¯ãã¹ãŠããŠãŒã¶ãŒã«æäŸããããŒã¿ãæ£ãããšããããšãç解ããããšãªãã«ã¯éèŠã§ã¯ãããŸãããããŒã¿ ã¬ããã³ã¹ ã³ã³ã»ããã®éèŠãªã¢ãžã¥ãŒã«ã® XNUMX ã€ã¯ãããŒã¿å質管çã¢ãžã¥ãŒã«ã§ãã
çŸæ®µéã§ã¯ãããã¯éžæããããšã³ãã£ãã£ã®å°åæã®ã«ã¿ãã°ã§ãã補åéçºã®åœé¢ã®ç®æšã¯ããã§ãã¯ã®ãªã¹ããæ¡åŒµããã¬ããŒã ã¬ãžã¹ããªãšçµ±åããããšã§ãã
ããã¯èª°ã«äœãäžããã®ã§ããããïŒã¬ãžã¹ããªã®ãšã³ã ãŠãŒã¶ãŒã¯ãã¬ããŒãæºåã®èšç»æ¥ãšå®éã®æ¥ä»ããã€ããã¯ã¹ã«ããå®äºãããã§ãã¯ã®çµæãã¬ããŒãã«ããŒãããããœãŒã¹ã«é¢ããæ
å ±ã«ã¢ã¯ã»ã¹ã§ããŸãã
ç§ãã¡ã®å Žåãäœæ¥ããã»ã¹ã«çµ±åãããããŒã¿å質ã¢ãžã¥ãŒã«ã¯æ¬¡ã®ãšããã§ãã
- 顧客ã®æåŸ ãè¿ éã«åœ¢æããŸãã
- ããŒã¿ã®ãããªãå©çšã«é¢ãã決å®ãäžãã
- å®æçãªå質管çãéçºããããã®äœæ¥ã®åæ段éã§ãåé¡ç¹ã®äºåã»ãããååŸããŸãã
ãã¡ããããããã¯æ¬æ ŒçãªããŒã¿ç®¡çããã»ã¹ãæ§ç¯ããããã®æåã®ã¹ãããã§ãããããããã®äœæ¥ãæå³çã«è¡ããããŒã¿ ã¬ããã³ã¹ ããŒã«ãäœæ¥ããã»ã¹ã«ç©æ¥µçã«å°å ¥ããããšã«ãã£ãŠã®ã¿ãã¯ã©ã€ã¢ã³ãã«æ å ±ã³ã³ãã³ããããŒã¿ã«å¯Ÿããé«ãã¬ãã«ã®ä¿¡é Œæ§ãããŒã¿åä¿¡ã®éææ§ãæäŸããç«ã¡äžãé床ãåäžãããããšãã§ãããšç§ãã¡ã¯ç¢ºä¿¡ããŠããŸããæ°ããæ©èœã
ããŒã¿ãªãã£ã¹ããŒã
åºæïŒ habr.com