貯èµæœèšã®éçºã¯æéã®ãããçå£ãªä»äºã§ãã
ãããžã§ã¯ãã®åç¶ã¯ããªããžã§ã¯ã ã¢ãã«ãšåºæ¬æ§é ãæåã«ã©ãã ãããèããããŠãããã«å€§ããå·Šå³ãããŸãã
äžè¬ã«åãå ¥ããããŠããã¢ãããŒãã¯ãã¹ã¿ãŒ ã¹ããŒã ãšç¬¬ 3 æ£èŠåœ¢ãçµã¿åãããããŸããŸãªããªãšãŒã·ã§ã³ã§ãããä»ãæãå€ãããŸããã ååãšããŠãååã«åŸã£ãŠïŒåæããŒã¿ - XNUMXNFãã·ã§ãŒã±ãŒã¹ - ã¹ã¿ãŒã ãã®ã¢ãããŒãã¯ãé·å¹Žã®å®çžŸãããã倧éã®èª¿æ»ã«ãã£ãŠè£ä»ããããŠãããçµéšè±å¯ãª DWH ã¹ãã·ã£ãªã¹ããåæãªããžããªãã©ãããã¹ãããèãããšãã«æåã«æãæµ®ã㶠(å Žåã«ãã£ãŠã¯å¯äžã®) ãã®ã§ãã
äžæ¹ã§ãããžãã¹å šè¬ãç¹ã«é¡§å®¢ã®èŠä»¶ã¯æ¥éã«å€åããåŸåããããããŒã¿ã¯ãæ·±ããããåºãããå¢å€§ããåŸåããããŸãã ãããŠããããã¹ã¿ãŒã®äž»ãªæ¬ ç¹ãçŸããå Žæã§ã - éå®çã§ã æè»æ§.
ãããŠãDWH éçºè ãšããŠã®éãã§å± å¿å°ã®è¯ãç掻ã®äžã§ãçªç¶æ¬¡ã®ããã«ãªã£ããšããŸãã
- ãå°ãªããšãäœããããã«å®è¡ããŠãããããèŠãŠã¿ãŸãããããšãã課é¡ãçããŸããã
- æ¥éã«çºå±ãããããžã§ã¯ããåºçŸããå°ãªããšãé±ã«äžåºŠã¯æ°ããæ å ±æºãæ¥ç¶ããããžãã¹ ã¢ãã«ãåæ§ç¯ããŸããã
- ã·ã¹ãã ãã©ã®ãããªãã®ã§ããã¹ãããæçµçã«ã©ã®ãããªæ©èœãå®è¡ããå¿ èŠãããã®ãââã¯ãŸã£ããããããªãããå®éšãè¡ã£ãŠæãŸããçµæã«åžžã«è¿ã¥ããªãããäžè²«ããŠæ¹è¯ãå ããæºåãã§ããŠãã顧客ãçŸããŸããã
- ãããžã§ã¯ã ãããŒãžã£ãŒãæå ±ãæã£ãŠãã£ãŠæ¥ãŸããããããã§ã¢ãžã£ã€ã«ãå®çŸããŸãã!ã
ãŸãã¯ãä¿ç®¡æœèšãä»ã«ã©ã®ããã«æ§ç¯ã§ããããç¥ãããã ããªãããããã!
ãæè»æ§ããšã¯ã©ãããæå³ã§ããïŒ
ãŸããã·ã¹ãã ããæè»ããšåŒã°ããããã«ã©ã®ãããªç¹æ§ãåããŠããªããã°ãªããªãããå®çŸ©ããŸãããã
ãããšã¯å¥ã«ã説æãããŠããããããã£ã¯ç¹ã«æ¬¡ã®ããšã«é¢é£ããå¿
èŠãããããšã«èšåãã䟡å€ããããŸãã ã·ã¹ãã ãã§ã¯ãªã ããã»ã¹ ãã®çºå±ã ãããã£ãŠãéçºæ¹æ³è«ãšããŠã®ã¢ãžã£ã€ã«ã«ã€ããŠèªã¿ããå Žåã¯ãä»ã®èšäºãèªãã æ¹ãããã§ãããã ããšãã°ãããã¬å³¶ã«ã¯ãèå³æ·±ãè³æããããããããŸãïŒ
ããã¯ãéçºããã»ã¹ãšããŒã¿ ãŠã§ã¢ããŠã¹ã®æ§é ããŸã£ããç¡é¢ä¿ã§ããããšãæå³ãããã®ã§ã¯ãããŸããã å šäœãšããŠãã¢ãžã£ã€ã« ã¢ãŒããã¯ãã£åãã®ã¢ãžã£ã€ã« ãªããžããªã®éçºã¯å€§å¹ ã«ç°¡åã«ãªãã¯ãã§ãã ããããå®éã«ã¯ãXNUMX ã€ã®ãããžã§ã¯ã㧠XNUMX ã€ã®åœ¢åŒã®æè»æ§ãå¶ç¶ã«å®çŸããããããKimbal æ°ã DataVault æ°ã«ãããšããŠã©ãŒã¿ãŒãã©ãŒã«æ°ã«ãããšãå€å žç㪠DWH ã®ã¢ãžã£ã€ã«éçºãšããéžæè¢ãååšããããšãå€ãã®ã§ãã
ã§ã¯ããã¬ãã·ãã« ã¹ãã¬ãŒãžã«ã¯ã©ã®ãããªæ©èœãå¿ èŠã§ãããã? ããã§ã®ãã€ã³ãã¯æ¬¡ã® XNUMX ã€ã§ãã
- æ©æçŽåãšè¿ éãªå¯Ÿå¿ - ããã¯ãçæ³çã«ã¯ãæåã®ããžãã¹çµæ (ããšãã°ãæåã®äœæ¥ã¬ããŒã) ãã§ããã ãæ©ããã€ãŸãã·ã¹ãã å šäœãå®å šã«èšèšããã³å®è£ ãããåã«ååŸããå¿ èŠãããããšãæå³ããŸãã ããã«ããã®åŸã®åæ¹èšã®æéãã§ããã ãçãããå¿ èŠããããŸãã
- å埩çãªæ¹è¯ - ããã¯ããã®åŸã®åæ¹åããçæ³çã«ã¯ãã§ã«åäœããŠããæ©èœã«åœ±é¿ãäžããªãããã«ããå¿ èŠãããããšãæå³ããŸãã 倧èŠæš¡ãªãããžã§ã¯ãã§æ倧ã®æªå€¢ãšãªãããšãå€ãã®ã¯ãã®ç¬éã§ããé ããæ©ãããåã ã®ãªããžã§ã¯ããéåžžã«å€ãã®æ¥ç¶ãååŸãå§ãããããæ¢åã®ããŒãã«ã«ãã£ãŒã«ããè¿œå ããããããè¿ãã®ã³ããŒã§ããžãã¯ãå®å šã«ç¹°ãè¿ãæ¹ãç°¡åã«ãªããŸãã ãŸããæ¢åã®ãªããžã§ã¯ãã«å¯Ÿããæ¹åã®åœ±é¿ãåæããæ¹ããæ¹åãã®ãã®ãããæéããããããšã«é©ããŠããæ¹ã¯ããããããéè¡ãéä¿¡æ¥çã®å€§èŠæš¡ãªããŒã¿ ãŠã§ã¢ããŠã¹ããŸã æ±ã£ãããšããªãã§ãããã
- å€åããããžãã¹èŠä»¶ã«åžžã«é©å¿ãã - ãªããžã§ã¯ãå šäœã®æ§é ã¯ãæ¡åŒµã®å¯èœæ§ãèæ ®ããã ãã§ãªãã次ã®æ¡åŒµã®æ¹åæ§ãèšèšæ®µéã§ã¯å€¢ã«ãæããªãã£ããšããããšãèæ ®ããŠèšèšãããå¿ èŠããããŸãã
ãããŠãã¯ããããããã¹ãŠã®èŠä»¶ã XNUMX ã€ã®ã·ã¹ãã ã§æºããããšã¯å¯èœã§ã (ãã¡ãããå Žåã«ãã£ãŠã¯ãããçšåºŠã®æ¡ä»¶ã¯ãããŸãã)ã
以äžã§ã¯ãããŒã¿ ãŠã§ã¢ããŠã¹ã®æãäžè¬çãªã¢ãžã£ã€ã«èšèšææ³ã® XNUMX ã€ãæ€èšããŸãã ã¢ã³ã«ãŒã¢ã㫠О ããŒã¿ä¿ç®¡åº«ã ããšãã°ãEAVã6NF (çŽç²ãªåœ¢åŒ)ãããã³ NoSQL ãœãªã¥ãŒã·ã§ã³ã«é¢é£ãããã¹ãŠã®ãããªåªããæè¡ãæ¬åŒ§ã®å€ã«æ®ãããŠããŸããããã¯ããããã®æè¡ãäœããã®ç¹ã§å£ã£ãŠããããã§ã¯ãªãããã®å Žåãèšäºãè²·åãè ããããã§ããããŸãããå¹³åçãªãã£ã¶ãŒã®ããªã¥ãŒã ã ãã ããããã¯ãã¹ãŠããããžã§ã¯ãã®å šäœçãªã¢ãŒããã¯ã㣠(EAV ãªã©) ã«é¢ä¿ãªããç¹å®ã®ã±ãŒã¹ã§äœ¿çšã§ãããã¯ããã¯ããŸãã¯ã°ããŒãã«ã«ä»ã®æ å ±ã¹ãã¬ãŒãž ãã©ãã€ã (ã°ã©ã ããŒã¿ããŒã¹ãªã©) ãªã©ãå°ãç°ãªãã¯ã©ã¹ã®ãœãªã¥ãŒã·ã§ã³ã«é¢é£ããŠããŸããããã³ãã®ä»ã®ãªãã·ã§ã³ NoSQL)ã
ãå€å žçãã¢ãããŒãã®åé¡ç¹ãšæè»ãªæ¹æ³è«ã«ãã解決ç
ãå€å
žçãªãã¢ãããŒããšã¯ãå€ãè¯ãã¹ã¿ãŒã®ããšãæããŸã (åºç€ãšãªãå±€ã®ç¹å®ã®å®è£
ã«é¢ä¿ãªããKimballãInmonãCDM ã®ä¿¡å¥è
ã¯ãèš±ããã ãã)ã
1. æ¥ç¶ã®å³æ Œãªåºæ°
ãã®ã¢ãã«ã¯ãããŒã¿ã次ã®ããã«æ確ã«åå²ããããšã«åºã¥ããŠããŸãã å¯žæ³ Ðž äºå®ã ãããŠãããã¯ããŸã£ãããè«ççã§ããçµå±ã®ãšãããå§åçå€æ°ã®å Žåã®ããŒã¿åæã¯ãç¹å®ã®ã»ã¯ã·ã§ã³ (次å ) ã«ãããç¹å®ã®æ°å€ææš (äºå®) ã®åæã«åž°çããŸãã
ãã®å Žåããªããžã§ã¯ãéã®æ¥ç¶ã¯ãå€éšããŒã䜿çšããããŒãã«éã®é¢ä¿ã®åœ¢ã§ç¢ºç«ãããŸãã ããã¯éåžžã«èªç¶ã«èŠããŸãããããã«æåã®æè»æ§ã®å¶éã«ã€ãªãããŸãã æ¥ç¶ã®åºæ°ã®å³å¯ãªå®çŸ©.
ã€ãŸããããŒãã«ã®èšèšæ®µéã§ãé¢é£ãªããžã§ã¯ãã®ãã¢ããšã«ãå€å¯Ÿå€ã§é¢é£ä»ããããšãã§ããã®ãããããšã 1 察å€ã®ã¿ã§é¢é£ä»ããããšãã§ããã®ãããŸããã©ã®æ¹åã«ãé¢é£ä»ããããšãã§ããã®ããæ£ç¢ºã«å€æããå¿ èŠããããŸãã ããã«ãããã©ã®ããŒãã«ãäž»ããŒãæã€ã®ããã©ã®ããŒãã«ãå€éšããŒãæã€ã®ããçŽæ¥æ±ºãŸããŸãã æ°ããèŠä»¶ãåãåã£ããšãã«ãã®æ 床ãå€ãããšãããŒã¹ã®ææ»ãã«ã€ãªããå¯èœæ§ãé«ããªããŸãã
ããšãã°ããçŸéåé æžããªããžã§ã¯ããèšèšãããšãã«ãå¶æ¥éšéã®å®£èªãä¿¡é ŒããŠãã¢ã¯ã·ã§ã³ã®å¯èœæ§ãèšå®ããŸããã è€æ°ã®ãã§ãã¯ããžã·ã§ã³ã«å¯Ÿã㊠XNUMX ã€ã®ããã¢ãŒã·ã§ã³ (ãã ããã®éã¯ãããŸãã):
ãããŠãã°ããããŠãååãã¡ã¯åãç«å Žã§è¡åã§ããæ°ããããŒã±ãã£ã³ã°æŠç¥ãå°å
¥ããŸããã è€æ°ã®ããã¢ãŒã·ã§ã³ãåæã«è¡ãã 次ã«ããªã¬ãŒã·ã§ã³ã·ãããå¥ã®ãªããžã§ã¯ãã«åé¢ããŠããŒãã«ãå€æŽããå¿
èŠããããŸãã
(ææ Œãã§ãã¯ãçµåãããŠãããã¹ãŠã®æŽŸçãªããžã§ã¯ããæ¹åããå¿ èŠããããŸã)ã
Data Vault ãšã¢ã³ã«ãŒ ã¢ãã«ã®é¢ä¿
ãã®ç¶æ³ãåé¿ããã®ã¯éåžžã«ç°¡åã§ããããšãå€æããŸããããããè¡ãããã«å¶æ¥éšéãä¿¡é Œããå¿ èŠã¯ãããŸããã ãã¹ãŠã®æ¥ç¶ã¯æåã¯å¥ã®ããŒãã«ã«ä¿åãããŸã ãããŠãããå€å¯Ÿå€ãšããŠåŠçããŸãã
ãã®ã¢ãããŒããææ¡ãããã®ã¯ã ãã³ã»ãªã³ã¹ããã ãã©ãã€ã ã®äžéšãšã㊠ããŒã¿ä¿ç®¡åº« ãããŠå®å šã«ãµããŒããããŠããŸã ã©ãŒã¹ã»ã¬ã³ãã㯠в ã¢ã³ã«ãŒã¢ãã«.
ãã®çµæãæè»ãªæ¹æ³è«ã®æåã®ç¹åŸŽãåŸãããŸãã
ãªããžã§ã¯ãéã®é¢ä¿ã¯èŠªãšã³ãã£ãã£ã®å±æ§ã«ã¯ä¿åãããŸããããå¥ã®çš®é¡ã®ãªããžã§ã¯ããšããŠä¿åãããŸãã
Ð ããŒã¿ä¿ç®¡åº« ãã®ãããªãªã³ã¯ããŒãã«ã¯åŒã°ããŸã ãªã³ã¯ãšã§ ã¢ã³ã«ãŒã¢ãã« - ãã¯ã¿ã€ã äžèŠãããšããããã¯éåžžã«ãã䌌ãŠããŸãããéãã¯ååã ãã§ã¯ãããŸãã (ããã«ã€ããŠã¯åŸè¿°ããŸã)ã ã©ã¡ãã®ã¢ãŒããã¯ãã£ã§ãããªã³ã¯ ããŒãã«ã¯ãªã³ã¯ã§ããŸãã ä»»æã®æ°ã®ãšã³ãã£ã㣠(å¿ ããã 2 ã§ãããšã¯éããŸãã)ã
ãã®åé·æ§ã«ãããäžèŠãããšãå€æŽã«å¯Ÿããå€§å¹ ãªæè»æ§ãåŸãããŸãã ãã®ãããªæ§é ã¯ãæ¢åã®ãªã³ã¯ã®åºæ°ã®å€æŽã ãã§ãªããæ°ãããªã³ã¯ã®è¿œå ã«ãèæ§ãæã¡ãŸããå°åæã®äœçœ®ã«ããããçªç Žããã¬ãžæ åœè ãžã®ãªã³ã¯ãå«ãŸããŠããå Žåããã®ãããªãªã³ã¯ã®åºçŸã¯åçŽã§ããæ¢åã®ãªããžã§ã¯ããããã»ã¹ã«åœ±é¿ãäžããããšãªããæ¢åã®ããŒãã«ã®ã¢ããªã³ã«ãªããŸãã
2. ããŒã¿ã®éè€
æè»ãªã¢ãŒããã¯ãã£ã«ãã£ãŠè§£æ±ºããã XNUMX çªç®ã®åé¡ã¯ãããã»ã©æçœã§ã¯ãããŸããããããããåºæã®ãã®ã§ãã SCD2ã¿ã€ãã®æž¬å® (XNUMX çªç®ã®ã¿ã€ãã®å¯žæ³ã¯ãã£ãããšå€åããŸã)ããã ãããã ãã§ã¯ãããŸããã
åŸæ¥ã®ãŠã§ã¢ããŠã¹ã§ã¯ããã£ã¡ã³ã·ã§ã³ã¯éåžžããµãã²ãŒã ã㌠(PK ãšããŠ) ãšäžé£ã®ããžãã¹ ããŒããã³å±æ§ãå¥ã®åã«å«ãããŒãã«ã§ãã
ãã£ã¡ã³ã·ã§ã³ãããŒãžã§ã³ç®¡çããµããŒãããŠããå ŽåãããŒãžã§ã³æå¹æ§ã®å¢çããã£ãŒã«ãã®æšæºã»ããã«è¿œå ããããœãŒã¹å
ã® XNUMX è¡ã«å¯ŸããŠè€æ°ã®ããŒãžã§ã³ããªããžããªã«è¡šç€ºãããŸã (ããŒãžã§ã³ç®¡çãããå±æ§ã®å€æŽããšã« XNUMX ã€)ã
ãã£ã¡ã³ã·ã§ã³ã«ãé »ç¹ã«å€æŽãããããŒãžã§ã³ç®¡çãããå±æ§ãå°ãªããšã XNUMX ã€å«ãŸããŠããå Žåããã®ãããªãã£ã¡ã³ã·ã§ã³ã®ããŒãžã§ã³ã®æ°ã¯èšå€§ã«ãªããŸã (æ®ãã®å±æ§ãããŒãžã§ã³ç®¡çãããŠããªããããŸã£ããå€æŽãããªãå Žåã§ã)ããŸãããã®ãããªå±æ§ãè€æ°ããå ŽåãããŒãžã§ã³ã®æ°ã¯å€§å¹ ã«å¢å ããŸãããã®æ°ã¯ææ°é¢æ°çã«å¢å ããŸãã ãã®ãã£ã¡ã³ã·ã§ã³ã¯ã倧éã®ãã£ã¹ã¯é åãå æããå¯èœæ§ããããŸããããã£ã¡ã³ã·ã§ã³ã«ä¿åãããããŒã¿ã®å€ãã¯ãä»ã®è¡ã®äžå€å±æ§å€ã®åçŽãªè€è£œã§ãã
åæã«ãéåžžã«é »ç¹ã«äœ¿çšãããŸã éæ£èŠå â äžéšã®å±æ§ã¯ãåèæžãå¥ã®ãã£ã¡ã³ã·ã§ã³ãžã®ãªã³ã¯ãšããŠã§ã¯ãªããå€ãšããŠæå³çã«ä¿åãããŸãã ãã®ã¢ãããŒãã«ãããããŒã¿ ã¢ã¯ã»ã¹ãé«éåããããã£ã¡ã³ã·ã§ã³ã«ã¢ã¯ã»ã¹ããéã®çµåã®æ°ãæžããŸãã
éåžžãããã«ãã次ã®ãããªããšãèµ·ãããŸã åãæ å ±ãè€æ°ã®å Žæã«åæã«ä¿åãããã ããšãã°ãå± äœå°åãšã¯ã©ã€ã¢ã³ãã®ã«ããŽãªã«é¢ããæ å ±ã¯ããã¯ã©ã€ã¢ã³ãããã£ã¡ã³ã·ã§ã³ãšãè³Œå ¥ãããé éãããã³ãŒã«ã»ã³ã¿ãŒã§ã®é話ãã®äºå®ãããã³ãã¯ã©ã€ã¢ã³ã - ã¯ã©ã€ã¢ã³ã ãããŒãžã£ãŒãã«åæã«ä¿åã§ããŸãã ããªã³ã¯ããŒãã«ã
äžè¬ã«ãäžèšã®å 容ã¯éåžžã® (ããŒãžã§ã³ç®¡çãããŠããªã) ãã£ã¡ã³ã·ã§ã³ã«åœãŠã¯ãŸããŸãããããŒãžã§ã³ç®¡çããããã£ã¡ã³ã·ã§ã³ã§ã¯ã¹ã±ãŒã«ãç°ãªãå ŽåããããŸãããªããžã§ã¯ãã®æ°ããããŒãžã§ã³ã®åºçŸ (ç¹ã«åŸããèŠããš) ã¯ãé¢é£ãããã¹ãŠã®ãã£ã¡ã³ã·ã§ã³ã®æŽæ°ã ãã§ãªãããã ããããŒãã« 1 ã䜿çšããŠããŒãã« 2 ãæ§ç¯ããããŒãã« 2 ã䜿çšããŠããŒãã« 3 ãæ§ç¯ããå Žåãªã©ãé¢é£ãªããžã§ã¯ãã®æ°ããããŒãžã§ã³ãã«ã¹ã±ãŒãçã«è¡šç€ºãããŸãã è¡š 1 ã®å±æ§ã 3 ã€ãè¡š 2 ã®æ§ç¯ã«é¢äžããŠããªãå Žåã§ã (ãŸããä»ã®ãœãŒã¹ããååŸããè¡š 3 ã®ä»ã®å±æ§ãé¢äžããŠãã)ããã®æ§ç¯ãããŒãžã§ã³ç®¡çãããšãå°ãªããšãè¿œå ã®ãªãŒããŒããããçºçããæ倧ã§è¿œå ã®ãªãŒããŒããããçºçããŸããè¡š XNUMX ã®ããŒãžã§ã³ã¯ããŸã£ããé¢ä¿ããããŸãããããã«ãã®äžã«ãããŸãã
3. ãªã¯ãŒã¯ã®éç·åœ¢è€éã
åæã«ãå¥ã®ã¹ãã¢ããã³ãã«åºã¥ããŠæ°ããã¹ãã¢ããã³ããæ§ç¯ããããã³ã«ãETL ã«å€æŽãå ãããããšãã«ããŒã¿ããåå²ãããå¯èœæ§ã®ããå Žæã®æ°ãå¢å ããŸãã ããã«ãããåŸç¶ã®åãªããžã§ã³ã®è€éã (ããã³æé) ãå¢å ããŸãã
äžèšã§ ETL ããã»ã¹ãã»ãšãã©å€æŽãããªãã·ã¹ãã ã«ã€ããŠèª¬æããŠããå Žåã¯ããã®ãããªãã©ãã€ã ã«åŸãããšãã§ããŸããå¿ èŠãªã®ã¯ãé¢é£ãããã¹ãŠã®ãªããžã§ã¯ãã«æ°ããå€æŽãæ£ããè¡ãããŠããããšã確èªããããšã ãã§ãã æ¹èšãé »ç¹ã«çºçãããšãããã€ãã®æ¥ç¶ã誀ã£ãŠãæ¬ èœãããå¯èœæ§ãå€§å¹ ã«å¢å ããŸãã
ããã«ããããŒãžã§ã³ç®¡çããããETL ããããŒãžã§ã³ç®¡çãããŠããªããETL ãããå€§å¹ ã«è€éã§ããããšãèæ ®ãããšããã®æ©èœå šäœãé »ç¹ã«æŽæ°ãããšãã«ééããé¿ããããšãéåžžã«å°é£ã«ãªããŸãã
Data Vault ãš Anchor Model ãžã®ãªããžã§ã¯ããšå±æ§ã®ä¿å
æè»ãªã¢ãŒããã¯ãã£ã®äœæè ã«ãã£ãŠææ¡ãããã¢ãããŒãã¯ã次ã®ããã«å®åŒåã§ããŸãã
å€åãããã®ãšå€ãããªããã®ãåºå¥ããå¿ èŠããããŸãã ã€ãŸããããŒãå±æ§ãšã¯å¥ã«ä¿åããŸãã
ãã ããæ··åããŠã¯ãããŸãã ããŒãžã§ã³ç®¡çãããŠããªã å±æ§ä»ã å€æŽãªã: æåã®ãã®ã¯å€æŽå±¥æŽãä¿åããŸããããå€æŽãããå¯èœæ§ããããŸã (ããšãã°ãå ¥åãšã©ãŒãä¿®æ£ãããšããæ°ããããŒã¿ãåä¿¡ãããšã)ãXNUMX çªç®ã®ãã®ã¯æ±ºããŠå€æŽãããŸããã
Data Vault ãšã¢ã³ã«ãŒ ã¢ãã«ã§æ£ç¢ºã«äœãäžå€ãšã¿ãªãããã«ã€ããŠã¯ãèŠç¹ãç°ãªããŸãã
建ç¯çãªèŠ³ç¹ããèŠããš ããŒã¿ä¿ç®¡åº«ãå€æŽãããŠããªããšèããããšãã§ããŸã ããŒã®ã»ããå šäœ - ããã¥ã©ã« (çµç¹ã® TINããœãŒã¹ ã·ã¹ãã ã®è£œåã³ãŒããªã©) ããã³ãµãã²ãŒãã ãã®å Žåãæ®ãã®å±æ§ã¯ãå€æŽã®ãœãŒã¹ããã³/ãŸãã¯é »åºŠã«å¿ããŠã°ã«ãŒãã«åå²ã§ããŸãã ã°ã«ãŒãããšã«åå¥ã®ããŒãã«ãç¶æãã ç¬ç«ããããŒãžã§ã³ã®ã»ããã䜿çšããŸãã
ãã©ãã€ã ã§ã¯ ã¢ã³ã«ãŒã¢ãã« å€åããªããšã¿ãªããã 代çããŒã®ã¿ ãšãã»ã³ã¹ã ä»ã®ãã¹ãŠ (èªç¶ããŒãå«ã) ã¯ããã®å±æ§ã®ç¹æ®ãªã±ãŒã¹ã«ãããŸããã ãã®äžã§ ãã¹ãŠã®å±æ§ã¯ããã©ã«ãã§äºãã«ç¬ç«ããŠããŸããããã£ãŠãåå±æ§ã«ã€ããŠã å¥ã®ããŒãã«.
Ð ããŒã¿ä¿ç®¡åº« ãšã³ãã£ãã£ããŒãå«ãããŒãã«ã¯åŒã³åºãããŸã æ¹èŠã ããã«ã¯åžžã«ã次ã®ãã£ãŒã«ãã®åºå®ã»ãããå«ãŸããŸãã
- èªç¶ãšã³ãã£ãã£ããŒ
- 代çããŒ
- ãœãŒã¹ãžã®ãªã³ã¯
- ã¬ã³ãŒãè¿œå æé
ããã®æçš¿ 決ããŠå€æŽããããããŒãžã§ã³ããããŸããã å€éšçã«ã¯ãããã¯äžéšã®ã·ã¹ãã ã§ãµãã²ãŒããçæããããã«äœ¿çšããã ID ããã ã¿ã€ãã®ããŒãã«ã«éåžžã«äŒŒãŠããŸãããData Vault ã§ã¯ããžãã¹ ããŒã®ã»ããããã®ããã·ã¥ããµãã²ãŒããšããŠäœ¿çšããããšããå§ãããŸãã ãã®ã¢ãããŒãã§ã¯ããœãŒã¹ããã®é¢ä¿ãšå±æ§ã®ããŒããç°¡çŽ åãããŸã (ãµãã²ãŒããååŸããããã«ããã«åå ããå¿ èŠã¯ãªããèªç¶ããŒã®ããã·ã¥ãèšç®ããã ãã§ã) ããä»ã®åé¡ (è¡çªã倧æåãšå°æåãå°å·äžèœãªã©ã«é¢é£ããåé¡) ãçºçããå¯èœæ§ããããŸããæååããŒãªã©ã®æå.p.)ããããã£ãŠãäžè¬çã«ã¯åãå ¥ããããŸããã
ä»ã®ãã¹ãŠã®ãšã³ãã£ãã£å±æ§ã¯ããšåŒã°ããç¹å¥ãªããŒãã«ã«ä¿åãããŸãã è¡æã XNUMX ã€ã®ããã«ãç°ãªãå±æ§ã»ãããä¿åããè€æ°ã®ãµãã©ã€ããå«ããããšãã§ããŸãã
è¡æéã®å±æ§ã®é
åžã¯ã次ã®åçã«åŸã£ãŠè¡ãããŸãã é¢ç¯ã®å€æŽ â XNUMX ã€ã®ãµãã©ã€ãã«ã¯ããŒãžã§ã³ç®¡çãããŠããªãå±æ§ (å人ã®ç幎ææ¥ã SNILS ãªã©) ãä¿åã§ããå¥ã®ãµãã©ã€ãã«ã¯ã»ãšãã©å€æŽãããªãããŒãžã§ã³ç®¡çãããå±æ§ (å§ããã¹ããŒãçªå·ãªã©)ãXNUMX çªç®ã«ã¯é »ç¹ã«å€æŽãããå±æ§ãä¿åãããŸãã (äŸ: é
éå
äœæãã«ããŽãªãæåŸã®æ³šææ¥ãªã©)ã ãã®å ŽåãããŒãžã§ã³ç®¡çã¯ãšã³ãã£ãã£å
šäœã§ã¯ãªããåã
ã®ãµãã©ã€ãã®ã¬ãã«ã§å®è¡ããããããXNUMX ã€ã®ãµãã©ã€ãå
ã®ããŒãžã§ã³ã®äº€å·®ãæå°éã«ãªãããã«å±æ§ãåæ£ããããšããå§ãããŸã (ä¿åãããããŒãžã§ã³ã®ç·æ°ãæžå°ããŸã)ã ïŒã
ãŸããããŒã¿èªã¿èŸŒã¿ããã»ã¹ãæé©åããããã«ãããŸããŸãªãœãŒã¹ããååŸããå±æ§ãåã ã®è¡æã«å«ãŸããããšããããããŸãã
è¡æã¯ãããšéä¿¡ããŸãã å€éšã㌠(ãã㯠1 察å€ã®ã«ãŒãã£ããªãã£ã«å¯Ÿå¿ããŸã)ã ããã¯ãè€æ°ã®å±æ§å€ (ããšãã°ãXNUMX ã€ã®ã¯ã©ã€ã¢ã³ãã«å¯Ÿããè€æ°ã®é£çµ¡å é»è©±çªå·) ããã®ãããã©ã«ããã¢ãŒããã¯ãã£ã§ãµããŒããããŠããããšãæå³ããŸãã
Ð ã¢ã³ã«ãŒã¢ãã« ããŒãæ ŒçŽããããŒãã«ã¯ãšåŒã°ããŸã ã¢ã³ã«ãŒã ãããŠåœŒãã¯æ¬¡ã®ããã«ç¶ããŠããŸãã
- 代çããŒã®ã¿
- ãœãŒã¹ãžã®ãªã³ã¯
- ã¬ã³ãŒãè¿œå æé
ã¢ã³ã«ãŒã¢ãã«ã®èŠ³ç¹ããã®èªç¶ããŒãèæ ®ãããŸã éåžžã®å±æ§ã ãã®ãªãã·ã§ã³ã¯ç解ããã®ãé£ããããã«æãããããããŸãããããªããžã§ã¯ããèå¥ããããã®ç¯å²ãã¯ããã«åºãããŸãã
ããšãã°ãåããšã³ãã£ãã£ã«é¢ããããŒã¿ãç°ãªãã·ã¹ãã ããååŸããããããããç¬èªã®èªç¶ããŒã䜿çšããå Žåã§ãã Data Vault ã§ã¯ãããã«ãããè€æ°ã®ãã (ãœãŒã¹ããšã« XNUMX 〠+ çµ±åãã¹ã¿ãŒ ããŒãžã§ã³) ãšããããé¢åãªæ§é ãçããå¯èœæ§ããããŸãããã¢ã³ã«ãŒ ã¢ãã«ã§ã¯ãåãœãŒã¹ã®ããã¥ã©ã« ããŒãç¬èªã®å±æ§ã«åé¡ãããç¬ç«ããŠããŒããããšãã«äœ¿çšã§ããŸããä»ã®ãã¹ãŠã
ããããããã«ã¯æ³šæãã«ããç¹ã XNUMX ã€ãããŸããç°ãªãã·ã¹ãã ã®å±æ§ã XNUMX ã€ã®ãšã³ãã£ãã£ã«çµåãããŠããå Žåããããããããã€ãã®å±æ§ãååšããå¯èœæ§ããããŸãã ãæ¥çãã®ã«ãŒã«ããã«ãããã·ã¹ãã ã¯ãããŸããŸãªãœãŒã¹ããã®ã¬ã³ãŒãããšã³ãã£ãã£ã® XNUMX ã€ã®ã€ã³ã¹ã¿ã³ã¹ã«å¯Ÿå¿ããããšãç解ããå¿ èŠããããŸãã
Ð ããŒã¿ä¿ç®¡åº« ãããã®ã«ãŒã«ããã©ãŒã¡ãŒã·ã§ã³ã決å®ããå¯èœæ§ãé«ããªããŸã ãã¹ã¿ãŒãšã³ãã£ãã£ã®ããµãã²ãŒãããã ãŸããèªç¶ãªãœãŒã¹ ããŒãšãã®å ã®å±æ§ãä¿åããããã«ã¯äžå圱é¿ãäžããŸããã ããæç¹ã§ããŒãž ã«ãŒã«ãå€æŽãããå Žå (ãŸãã¯ããŒãž ã«ãŒã«ãå®è¡ããå±æ§ãæŽæ°ãããå Žå)ããµãã²ãŒã ãããåãã©ãŒãããããã ãã§ååã§ãã
Ð ã¢ã³ã«ãŒã¢ãã« ãã®ãããªãšã³ãã£ãã£ã¯ããããã次ã®å Žæã«ä¿åãããŸãã å¯äžã®ã¢ã³ã«ãŒã ããã¯ãã©ã®ãããªãœãŒã¹ããæ¥ããã®ã§ãã£ãŠãããã¹ãŠã®å±æ§ãåããµãã²ãŒãã«ãã€ã³ããããããšãæå³ããŸãã 誀ã£ãŠããŒãžãããã¬ã³ãŒããåé¢ããäžè¬ã«ããã®ãããªã·ã¹ãã ã§ããŒãžã®é¢é£æ§ãç£èŠããããšã¯ãç¹ã«ã«ãŒã«ãéåžžã«è€éã§é »ç¹ã«å€æŽãããåãå±æ§ãç°ãªããœãŒã¹ããååŸã§ããå Žåã«ã¯ãã¯ããã«å°é£ã«ãªãå¯èœæ§ããããŸã (ãã ãã確ãã«ããã§ã)ãåå±æ§ããŒãžã§ã³ããã®ãœãŒã¹ãžã®ãªã³ã¯ãä¿æããŠãããããå¯èœã§ã)ã
ãããã«ãããã·ã¹ãã ããã®æ©èœãå®è£ ããå¿ èŠãããå Žåã¯ã éè€æé€ãã¬ã³ãŒãã®ããŒãžããã®ä»ã® MDM èŠçŽ ãã¢ãžã£ã€ã«ææ³ã«ãããèªç¶ããŒã®ä¿åã®åŽé¢ã«ç¹ã«æ³šæãæã䟡å€ããããŸãã ããããããã倧èŠæš¡ãª Data Vault èšèšããããŒãž ãšã©ãŒã®èŠ³ç¹ããçªç¶å®å šã«ãªãå¯èœæ§ããããŸãã
ã¢ã³ã«ãŒã¢ãã« ãšããè¿œå ã®ãªããžã§ã¯ã ã¿ã€ããæäŸããŸãã çµã³ç® ããã¯æ¬è³ªçã«ç¹å¥ã§ã éåã¿ã€ãã®ã¢ã³ã«ãŒãå±æ§ã XNUMX ã€ã ãå«ããããšãã§ããŸãã ããŒãã¯ããã©ãããªãã£ã¬ã¯ã㪠(æ§å¥ãå©å§»ç¶æ³ã顧客ãµãŒãã¹ ã«ããŽãªãªã©) ãä¿åããããã«äœ¿çšãããããšã«ãªã£ãŠããŸãã ã¢ã³ã«ãŒãšã¯ç°ãªããããã㯠é¢é£ããå±æ§ããŒãã«ããããŸããããã®å¯äžã®å±æ§ (åå) ã¯åžžã«ããŒãšåãããŒãã«ã«ä¿åãããŸãã ã¢ã³ã«ãŒãçžäºã«æ¥ç¶ãããã®ãšåãæ¹æ³ã§ãããŒãã¯ã¿ã€ ããŒãã« (Tie) ã«ãã£ãŠã¢ã³ã«ãŒã«æ¥ç¶ãããŸãã
ããŒãã®äœ¿çšã«é¢ããŠæ確ãªæèŠã¯ãããŸããã äŸãã°ã
Data Vault ãšã¢ã³ã«ãŒ ã¢ãã«ã®ãã XNUMX ã€ã®éèŠãªéãã¯ãå¯çšæ§ã§ãã æ¥ç¶ã®å±æ§:
Ð ããŒã¿ä¿ç®¡åº« ãªã³ã¯ã¯ãããšåãæ¬æ Œçãªãªããžã§ã¯ãã§ããã次ã®ãã®ãæã€ããšãã§ããŸãã èªåã®å±æ§ã 㧠ã¢ã³ã«ãŒã¢ãã« ãªã³ã¯ã¯ã¢ã³ã«ãŒãšã¢ã³ã«ãŒãæ¥ç¶ããããã«ã®ã¿äœ¿çšãããŸãã ç¬èªã®å±æ§ãæã€ããšã¯ã§ããŸããã ãã®éãã«ãããã¢ããªã³ã° ã¢ãããŒããå€§å¹ ã«ç°ãªããŸãã äºå®ã®ãããã«ã€ããŠã¯ããã«èª¬æããŸãã
ãã¡ã¯ãã¹ãã¬ãŒãž
ãããŸã§ã¯ãäž»ã«æž¬å®ã¢ããªã³ã°ã«ã€ããŠèª¬æããŸããã äºå®ã¯å°ãæããã§ã¯ãããŸããã
Ð ããŒã¿ä¿ç®¡åº« ãã¡ã¯ããä¿åããããã®å žåçãªãªããžã§ã¯ãã¯æ¬¡ã®ãšããã§ãã ãªã³ã¯ããã®è¡æã«ã¯å®éã®ã€ã³ãžã±ãŒã¿ãŒãè¿œå ãããŸãã
ãã®ã¢ãããŒãã¯çŽæçã«æããŸãã ããã¯ãåæãããææšãžã®ç°¡åãªã¢ã¯ã»ã¹ãæäŸããäžè¬ã«åŸæ¥ã®ãã¡ã¯ã ããŒãã«ã«äŒŒãŠããŸã (ææšã®ã¿ãããŒãã«èªäœã§ã¯ãªãããé£æ¥ãããããŒãã«ã«ä¿åãããŸã)ã ããããèœãšãç©ŽããããŸããã¢ãã«ã®å žåçãªå€æŽã® XNUMX ã€ã§ãããã¡ã¯ã ããŒã®æ¡åŒµã§ã¯ã æ°ããå€éšããŒããªã³ã¯ã«è¿œå ããã ãããŠãããã«ããã¢ãžã¥ãŒã«æ§ããç Žå£ããããä»ã®ãªããžã§ã¯ããžã®å€æŽãå¿ èŠã«ãªãå¯èœæ§ããããŸãã
Ð ã¢ã³ã«ãŒã¢ãã« æ¥ç¶ã¯ç¬èªã®å±æ§ãæã€ããšãã§ããªãããããã®ã¢ãããŒãã¯æ©èœããŸããã絶察ã«ãã¹ãŠã®å±æ§ãšã€ã³ãžã±ãŒã¿ãŒã XNUMX ã€ã®ç¹å®ã®ã¢ã³ã«ãŒã«ãªã³ã¯ããå¿ èŠããããŸãã ããããã®çµè«ã¯ç°¡åã§ã - ããããã®äºå®ã«ãç¬èªã®ã¢ã³ã«ãŒãå¿ èŠã§ãã ç§ãã¡ãäºå®ãšããŠèªèããããšã«æ £ããŠãããã®ã«ãšã£ãŠã¯ãããã¯èªç¶ã«èŠãããããããŸãããããšãã°ãè³Œå ¥ã®äºå®ã¯ãã泚æããŸãã¯ãåé æžããšãããªããžã§ã¯ããã»ãã·ã§ã³ãžã®ãµã€ã蚪åãªã©ã«å®å šã«éå ã§ããŸãã ãããããã®ãããªèªç¶ãªã茞éç©äœããèŠã€ããã®ãããã»ã©ç°¡åã§ã¯ãªãäºå®ããããŸããããšãã°ãæ¯æ¥ã®å§ãŸãã«å庫ã«ããååã®æ®éªžãªã©ã§ãã
ãããã£ãŠãã¢ã³ã«ãŒ ã¢ãã«ã§ãã¡ã¯ã ããŒãå±éãããšãã«ã¢ãžã¥ãŒã«æ§ã®åé¡ã¯çºçããŸãã (察å¿ããã¢ã³ã«ãŒã«æ°ãããªã¬ãŒã·ã§ã³ã·ãããè¿œå ããã ãã§ååã§ã) ãããã¡ã¯ãã衚瀺ããã¢ãã«ã®èšèšã¯ããã»ã©æ確ã§ã¯ãªããã人工çãªãã¢ã³ã«ãŒã衚瀺ãããå¯èœæ§ããããŸããããžãã¹ ãªããžã§ã¯ã ã¢ãã«ãäžæçã«è¡šç€ºãããŸãã
æè»æ§ãå®çŸããæ¹æ³
ã©ã¡ãã®å Žåã§ããçµæãšããŠåŸãããæ§é ã«ã¯æ¬¡ã®ãã®ãå«ãŸããŸãã å€§å¹ ã«å€ãã®ããŒãã«åŸæ¥ã®æž¬å®ãããåªããŠããŸãã ããããããã¯ããããããããŸãã ãã£ã¹ã¯å®¹éãå€§å¹ ã«æžå° åŸæ¥ã®ãã£ã¡ã³ã·ã§ã³ãšåãããŒãžã§ã³åãããå±æ§ã»ããã䜿çšããŸãã åœç¶ã®ããšãªãããããã«ã¯éæ³ã¯ãããŸããããã¹ãŠã¯æ£èŠåã«é¢ãããã®ã§ãã ãµãã©ã€ã (Data Vault å ) ãŸãã¯åã ã®ããŒãã« (ã¢ã³ã«ãŒ ã¢ãã«) å šäœã«å±æ§ãåæ£ããããšã§ãå±æ§ãåæž (ãŸãã¯å®å šã«æé€) ããŸãã ä»ã®å±æ§ãå€æŽãããšãäžéšã®å±æ§ã®å€ãéè€ãã.
ã®ããã« ããŒã¿ä¿ç®¡åº« è³éã¯ãµãã©ã€ãéã®å±æ§ã®é åã«ãã£ãŠç°ãªããŸãã ã¢ã³ã«ãŒã¢ãã« â ã¯ã枬å®ãªããžã§ã¯ãããšã®å¹³åããŒãžã§ã³æ°ã«ã»ãŒæ£æ¯äŸããŸãã
ãã ããã¹ããŒã¹ã®ç¯çŽã¯ãå±æ§ãåå¥ã«ä¿åããããšã®éèŠãªå©ç¹ã§ã¯ãããŸãããäž»ãªå©ç¹ã§ã¯ãããŸããã ãã®ã¢ãããŒãã¯ãé¢ä¿ãåå¥ã«ä¿åããããšãšäœµããŠãã¹ãã¢ãäœæããŸãã ã¢ãžã¥ãŒã«èšèšã ã€ãŸãããã®ãããªã¢ãã«ã«åã ã®å±æ§ãšæ°ãããµããžã§ã¯ãé åå šäœã®äž¡æ¹ãè¿œå ãããšã次ã®ããã«ãªããŸãã äžéšæ§é ãªããžã§ã¯ãã®æ¢åã®ã»ãããå€æŽããã«äžæžãããŸãã ãããŠããããããã説æãããŠããæ¹æ³è«ãæè»ã«ãããã®ã§ãã
ããã¯ãåæ°çç£ãã倧éçç£ãžã®ç§»è¡ã«ã䌌ãŠããŸããåŸæ¥ã®ã¢ãããŒãã§ã¯ãã¢ãã«ã®åããŒãã«ãç¬èªã§ç¹å¥ãªæ³šæãå¿ èŠã§ããå Žåãæè»ãªæ¹æ³è«ã§ã¯ãããã¯ãã§ã«æšæºã®ãéšåãã®ã»ããã§ãã äžæ¹ã§ãããŒãã«ã®æ°ãå¢ããããŒã¿ã®ããŒããšååŸã®ããã»ã¹ãããè€éã«ãªãã¯ãã§ãã äžæ¹ã圌ãã¯æ¬¡ã®ããã«ãªããŸãã å žåçãªã ã€ãŸãããããããããªã èªååããã³ã¡ã¿ããŒã¿äž»å°åã ãã©ã®ããã«æ§ç¯ããã?ããšãã質åã¯ããã®çããæ¹åèšèšã®äœæ¥ã®éèŠãªéšåãå ããå¯èœæ§ããããŸãããä»ã§ã¯ãŸã£ãã䟡å€ããããŸãã (ã¢ãã«ã®å€æŽãäœæ¥ããã»ã¹ã«åãŒã圱é¿ã«ã€ããŠã®è³ªåãåæ§ã§ã) ïŒã
ããã¯ããã®ãããªã·ã¹ãã ã§ã¯ã¢ããªã¹ãããŸã£ããå¿ èŠãªããšããæå³ã§ã¯ãããŸãããäŸç¶ãšããŠèª°ããå±æ§ãæã€ãªããžã§ã¯ãã®ã»ããã調ã¹ãŠãããããã¹ãŠã©ãã«ã©ã®ããã«ããŒãããããå€æããå¿ èŠããããŸãã ããããäœæ¥éã ãã§ãªãããšã©ãŒã®å¯èœæ§ãã³ã¹ããå€§å¹ ã«åæžãããŸãã åæ段éãš ETL ã®éçºäžã®äž¡æ¹ã§ãéèŠãªéšåã¯ã¡ã¿ããŒã¿ã®ç·šéã«åæžã§ããŸãã
ããŒã¯ãµã€ã
äžèšã®ãã¹ãŠã«ãããã©ã¡ãã®ã¢ãããŒããçã«æè»ã§ãæè¡çã«é²æ©ããå埩çãªæ¹åã«é©ãããã®ã«ãªããŸãã ãã¡ããããè»èã®æšœãããããŸãããããã«ã€ããŠã¯ãã§ã«æšæž¬ã§ãããšæããŸãã
æè»ãªã¢ãŒããã¯ãã£ã®ã¢ãžã¥ãŒã«æ§ã®åºç€ãšãªãããŒã¿å解ã¯ãããŒãã«æ°ã®å¢å ã«ã€ãªãããããã«å¿ããŠã ãªãŒããŒããã ãµã³ããªã³ã°æã«çµåããŸãã ãã£ã¡ã³ã·ã§ã³ã®ãã¹ãŠã®å±æ§ãåçŽã«ååŸããã«ã¯ãåŸæ¥ã®ã¹ãã¢ã§ã¯ XNUMX åã®éžæã§ååã§ãããæè»ãªã¢ãŒããã¯ãã£ã§ã¯äžé£ã®çµåå šäœãå¿ èŠã«ãªããŸãã ããã«ãã¬ããŒãã®ããããã¹ãŠã®çµåãäºåã«äœæã§ããå Žåãæå㧠SQL ãäœæããããšã«æ £ããŠããã¢ããªã¹ãã¯äºéã«èŠåŽããããšã«ãªããŸãã
ãã®ç¶æ³ã容æã«ããããã€ãã®äºå®ããããŸãã
倧ããªãã£ã¡ã³ã·ã§ã³ãæäœããå Žåããã®ãã¹ãŠã®å±æ§ãåæã«äœ¿çšãããããšã¯ã»ãšãã©ãããŸããã ããã¯ãã¢ãã«ãäžèŠããããã«èŠãããããçµåãå°ãªãå¯èœæ§ãããããšãæå³ããŸãã Data Vault ã¯ãå±æ§ããµãã©ã€ãã«å²ãåœãŠããšãã«ãäºæ³ãããå ±æé »åºŠãèæ ®ã«å ¥ããããšãã§ããŸãã åæã«ããããŸãã¯ã¢ã³ã«ãŒèªäœã¯äž»ã«èªã¿èŸŒã¿æ®µéã§ãµãã²ãŒããçæããã³ãããã³ã°ããããã«å¿ èŠã§ãããã¯ãšãªã§äœ¿çšãããããšã¯ã»ãšãã©ãããŸãã (ããã¯ç¹ã«ã¢ã³ã«ãŒã«åœãŠã¯ãŸããŸã)ã
ãã¹ãŠã®çµåã¯ããŒã«ãã£ãŠè¡ãããŸãã ããã«ããããå§çž®ããããããŒã¿ã®ä¿åæ¹æ³ã«ãããå¿ èŠãªå Žå (å±æ§å€ã«ãããã£ã«ã¿ãŒåŠçãªã©) ã®ããŒãã«ã®ã¹ãã£ã³ã®ãªãŒããŒããããåæžãããŸãã ããã«ãããå€æ°ã®çµåãå«ãæ£èŠåãããããŒã¿ããŒã¹ããã®ãµã³ããªã³ã°ã®æ¹ããè¡ããšã«å€ãã®ããŒãžã§ã³ãå«ã XNUMX ã€ã®éããã£ã¡ã³ã·ã§ã³ãã¹ãã£ã³ãããããé«éã«ãªãå¯èœæ§ããããŸãã
ããšãã°ãããã§ã¯
ãšã³ãžã³ã«å€§ããäŸåããŸãã ææ°ã®ãã©ãããã©ãŒã ã®å€ãã«ã¯ãå
éšçµåæé©åã¡ã«ããºã ãåãã£ãŠããŸãã ããšãã°ãMS SQL ãš Oracle ã¯ãããŒã¿ãä»ã®çµå以å€ã§äœ¿çšãããŠããããæçµçãªéžæ (ããŒãã«/çµåã®åé€) ã«åœ±é¿ãäžããªãå ŽåãããŒãã«ãžã®çµåããã¹ããããã§ããŸãããŸããMPP Vertica ã¯ãããŒãã«ãžã®çµåããã¹ããããã§ããŸãã
ããã«ãã©ã¡ãã®ã¢ãŒããã¯ãã£ã«ãã ç¹å¥ãªåãã«ãããããŒã¿ ã¢ã¯ã»ã¹ã容æã«ãªããŸã (ã¯ãšãª ããã©ãŒãã³ã¹ã®èŠ³ç¹ãšãšã³ã ãŠãŒã¶ãŒã®äž¡æ¹ã®èŠ³ç¹ãã)ã äŸãã°ã ãã€ã³ãã€ã³ã¿ã€ã ããŒãã« Data Vault ãŸã㯠ç¹å¥ãªããŒãã«é¢æ° ã¢ã³ã«ãŒã¢ãã«ã§ã
åèšã§
æ€èšãããŠããæè»ãªã¢ãŒããã¯ãã£ã®äž»ãªæ¬è³ªã¯ããã®ãèšèšãã®ã¢ãžã¥ãŒã«æ§ã§ãã
ãã®ããããã£ã«ããã次ã®ããšãå¯èœã«ãªããŸãã
- ã¡ã¿ããŒã¿ã®å±éãšåºæ¬ç㪠ETL ã¢ã«ãŽãªãºã ã®äœæã«é¢é£ããåææºåãè¡ã£ãåŸã 顧客ã«æåã®çµæãè¿ éã«æäŸãã ãããæ°åã®ãœãŒã¹ ãªããžã§ã¯ãããã®ããŒã¿ãå«ãããã€ãã®ã¬ããŒãã®åœ¢åŒã ãªããžã§ã¯ã ã¢ãã«å šäœã (æäžäœã¬ãã«ã§ãã£ãŠã) 培åºçã«èããå¿ èŠã¯ãããŸããã
- ããŒã¿ ã¢ãã«ã¯ãããã 2 ïœ 3 åã®ãªããžã§ã¯ãã§åäœãå§ãã (ãããŠäŸ¿å©ã«ãªã) ããšãã§ããŸãã åŸã
ã«æé·ãã ïŒã¢ã³ã«ãŒã¢ãã«ã®ãã³ã©ã€ã«ã€ããŠïŒ
é©çšããã è糞äœãšã®çŽ æŽãããæ¯èŒ)ã - 察象é åã®æ¡å€§ãæ°ãããœãŒã¹ã®è¿œå ãªã©ãã»ãšãã©ã®æ¹å æ¢åã®æ©èœã«ã¯åœ±é¿ããããã§ã«åäœããŠãããã®ãå£ããªã¹ã¯ããããŸãã.
- æšæºèŠçŽ ãžã®å解ã®ãããã§ããã®ãããªã·ã¹ãã ã® ETL ããã»ã¹ã¯åãããã«èŠãããã®èšè¿°ã¯ã¢ã«ãŽãªãºã åã«é©ããŠãããæçµçã«ã¯ ãªãŒãã¡ãŒã·ã§ã³.
ãã®æè»æ§ã®ä»£åã¯ã ããã©ãŒãã³ã¹ã ããã¯ããã®ãããªã¢ãã«ã§èš±å®¹å¯èœãªããã©ãŒãã³ã¹ãéæããããšãäžå¯èœã§ããããšãæå³ãããã®ã§ã¯ãããŸããã å€ãã®å Žåãå¿ èŠãªææšãéæããã«ã¯ãããå€ãã®åªåãšçŽ°éšãžã®æ³šæãå¿ èŠã«ãªãå ŽåããããŸãã
ã¢ããª
ãšã³ãã£ãã£ã®çš®é¡ ããŒã¿ä¿ç®¡åº«
Data Vault ã®è©³çŽ°æ
å ±:
ãšã³ãã£ãã£ã®çš®é¡ ã¢ã³ã«ãŒã¢ãã«
ã¢ã³ã«ãŒ ã¢ãã«ã®è©³çŽ°:
æ€èšãããã¢ãããŒãã®å ±éã®ç¹åŸŽãšçžéç¹ããŸãšããè¡š:
åºæïŒ habr.com