[B! DWH] InoHiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

InoHiro id:InoHiro

DWHã«é–¢ã™ã‚‹InoHiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹(DWH)ã®4ã¤ã®è¦ä»¶ã«ã¤ã„ã¦ | DevelopersIO
ã“ã‚“ã«ã¡ã¯ã€DIéƒ¨ã®å·å´Žã§ã™ã€‚ DIéƒ¨å†…ã§ã€ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ï¼ˆDWHï¼‰ã®å‹‰å¼·ä¼šã‚’è¡Œã„ã¾ã—ãŸã€‚ãã®ä¸ã‹ã‚‰ã€ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ï¼ˆDWHï¼‰ã®4ã¤ã®è¦ä»¶ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ†ã‚ã‚¹ãƒˆã¯ã„ã¤ã‚‚ã®ã“ã¡ã‚‰ã®æœ¬ã§ã™ã€‚ ã€Œ10å¹´æˆ¦ãˆã‚‹ãƒ‡ãƒ¼ã‚¿åˆ†æžå…¥é–€ã€é’æœ¨å³°éƒŽ è‘— http://www.sbcr.jp/products/4797376272.html DWHã®4ã¤ã®è¦ä»¶ï¼š ã‚µãƒ–ã‚¸ã‚§ã‚¯ãƒˆã”ã¨ã«ç·¨æˆã•ã‚Œã¦ã„ã‚‹ã“ã¨(subject oriented) ãƒ‡ãƒ¼ã‚¿ãŒçµ±åˆã•ã‚Œã¦ã„ã‚‹ã“ã¨(integrated) æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ã‚’æŒã¤ã“ã¨(time variant) ãƒ‡ãƒ¼ã‚¿ãŒæ°¸ç¶šã™ã‚‹ã“ã¨(non-volatile) ãã‚Œãžã‚Œã®é …ç›®ã«ã¤ã„ã¦ã€è©³ã—ãã¿ã¦ã„ãã¾ã™ã€‚ 1. ã‚µãƒ–ã‚¸ã‚§ã‚¯ãƒˆã”ã¨ã«ç·¨æˆã•ã‚Œã¦ã„ã‚‹ã“ã¨(subject oriented) ã‚µãƒ–ã‚¸ã‚§ã‚¯ãƒˆ(subject)ã¨ã¯ã€Œé¡§å®¢ã€ã¨ã‹ã€Œå•†å“ã€ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ã¾ã¨ã¾ã‚Šã®ã‚
InoHiro 2016/07/21
DWH
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿å¯è¦–åŒ–ã«å¤§é‡‘ã‚’ä½¿ã†å¿…è¦ãªã—ï¼ æœ€å¼·BIãƒ„ãƒ¼ãƒ«ã€ŒPowerBIã€ã‚’å°Žå…¥ã—ã¦ã¿ãŸã€‚ | FiNC Developers Blog
ãƒ‡ãƒ¼ã‚¿å¯è¦–åŒ–ã«å¤§é‡‘ã‚’ä½¿ã†å¿…è¦ãªã—ï¼ æœ€å¼·BIãƒ„ãƒ¼ãƒ«ã€ŒPowerBIã€ã‚’å°Žå…¥ã—ã¦ã¿ãŸã€‚ ã¯ã˜ã‚ã¾ã—ã¦ã€‚FiNCã§ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’æ‹…å½“ã—ã¦ã„ã¾ã™è…è°·ã§ã™ã€‚ ç¾åœ¨ã¯ä¸»ã«FiNCã‚¢ãƒ—ãƒªã‚’ã‚°ãƒãƒ¼ã‚¹ã•ã›ã‚‹ãŸã‚ã«ã€KPIã®æ•´å‚™ãƒ»æ”¹å–„ãªã©ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ ä»•äº‹ã§ã¯ã‚¢ãƒ—ãƒªã®ã‚°ãƒãƒ¼ã‚¹ãƒãƒƒã‚¯ã‚’ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€ ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆã§ã¯ãƒœãƒ‡ã‚£ã®ã‚°ãƒãƒ¼ã‚¹ãƒãƒƒã‚¯ï¼ˆç‹ãƒˆãƒ¬ï¼‰ã«ã¯ã¾ã£ã¦ã„ã¾ã—ã¦ã€ ã‚‚ã¨ã‚‚ã¨180cm55kgã®ç—©ã›åž‹ã ã£ãŸã®ã§ã™ãŒã€ ã“ã®3ã‹æœˆã®é–“ã«ã»ã¼ç‹è‚‰ã§ä½“é‡ã‚’10kgå¢—é‡ã•ã›ã‚‹ã“ã¨ã«æˆåŠŸã—ã¾ã—ãŸï¼ ãã‚Œã§ã¯æ—©é€Ÿæœ¬é¡Œã§ã™ï¼ ä»Šå›žã®ãƒ–ãƒã‚°ã§ã¯FiNCã«ãŠã‘ã‚‹ã€BIãƒ„ãƒ¼ãƒ«ã€ŒPowerBIã€ã®å°Žå…¥çµŒç·¯ã¨ã€å°Žå…¥çµæžœã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ 1.PowerBIã®å°Žå…¥çµŒç·¯1-1.BIãƒ„ãƒ¼ãƒ«å°Žå…¥æ¤œè¨Žã®èƒŒæ™¯FiNCã®æ€¥æˆé•·ã«ä¼´ã„ã€ä¸‹è¨˜2ã¤ã®å•é¡ŒãŒç™ºç”Ÿâ€¦ï¼ ãã‚Œã‚‰ã‚’è§£æ±ºã™ã‚‹ãŸã‚ã«BIãƒ„ãƒ¼ãƒ«ã®å°Žå…¥ã‚’æ±ºå®šã—ã¾ã—ãŸã€‚ â—¯å•é¡Œç‚¹ 1.ã‚µãƒ¼ãƒ“ã‚¹æ•°
InoHiro 2016/06/08
Redshiftä½¿ã£ã¦ã„ã¦ã‚‚DWHã¯MySQLã§æ§‹ç¯‰ã—ã¦ã„ã‚‹ã‚“ã ãªã€‚ã‚µãƒžãƒªãƒ¼ã ã‘æ›¸ãå‡ºã—ã¦ã‚‹ã®ã‹ãª

PowerBI

BI

DWH
ãƒªãƒ³ã‚¯
ç”¨èªžæ•´ç†: Slowly Changing Dimensions - ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹BIã®Pentahoï¼ˆãƒšãƒ³ã‚¿ãƒ›ï¼‰ãƒ–ãƒã‚°
KSKã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ã«ã‚ˆã‚‹pentahoãƒ–ãƒã‚°ã€‚ pentahoã®å¯èƒ½æ€§ã€æ©Ÿèƒ½ã€æä¾›ã‚µãƒ¼ãƒ“ã‚¹ã®çŠ¶æ³ãªã©ã®æœ€æ–°æƒ…å ±ã‚’ãŠå±Šã‘ã—ã¾ã™ã€‚ ãƒ“ã‚¸ãƒã‚¹ã‚¤ãƒ³ãƒ†ãƒªã‚¸ã‚§ãƒ³ã‚¹å¦ç¿’ã‚’é€²ã‚ã‚‹ã¨æ§˜ã€…ãªjargonã«å‡ºãã‚ã—ã¾ã™ã€‚ ãã“ã§ã€ç†è§£ã§ããŸã¨ã“ã‚ã‚’å°‘ã—ãšã¤æ•´ç†ã—ã¦è¡Œã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ä½•ã‹ãŠæ°—ã¥ãã®ç‚¹ãŒã‚ã‚Šã¾ã—ãŸã‚‰ã”æŒ‡æ‘˜ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ ã¾ãšã¯ã€Slowly Changing Dimensionsã«ã¤ã„ã¦ã€‚ Slowly Changing Dimensionsã¯ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã‚’æ§‹ç¯‰ã™ã‚‹ä¸Šã§ç›´é¢ã™ã‚‹ãƒ‡ã‚£ãƒ¡ãƒ³ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ã®æ›´æ–°ã«å¯¾ã™ã‚‹è€ƒãˆæ–¹ã§ã€ä¸‹è¨˜ã®ï¼–ã¤ã®ã‚¿ã‚¤ãƒ—ã«åˆ†é¡žã•ã‚Œã‚‹ã€‚ãƒ©ãƒ«ãƒ•ã‚ãƒ³ãƒœãƒ¼ãƒ«ã•ã‚“ã«ã‚ˆã‚Šï¼™ï¼å¹´å°å‰åŠã«å°Žå…¥ã•ã‚Œã€ãã®å¾Œã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®æ–¹ã€…ã«ã‚ˆã‚Šæ”¹è‰¯ã•ã‚Œã¦ã„ã‚‹ã€‚ ã‚¿ã‚¤ãƒ—ï¼‘ï¼šOverwrite the Value ã‚¿ã‚¤ãƒ—ï¼‘ã¯å˜ã«å¤ã„å±žæ€§å€¤ã‚’æ–°ã—ã„å€¤ã¨ç½®ãæ›ãˆã€å¸¸ã«æœ€æ–°
InoHiro 2016/05/09
BI

DWH
ãƒªãƒ³ã‚¯
GitHub - activewarehouse/activewarehouse: ActiveWarehouse for Rails - Implement data warehouses with Rails
InoHiro 2016/03/22
Rails

DWH
ãƒªãƒ³ã‚¯
Teradataã ã‘ãŒã‚„ã‚‹ã¨è¨€ã£ãŸMCIFã¨CRMã®çµ±åˆã€ã‚ŠããªéŠ€è¡Œã®ã‚ªãƒ ãƒ‹ãƒãƒ£ãƒãƒ«æˆ¦ç•¥ãƒãƒ£ãƒ¬ãƒ³ã‚¸
åŸºå¹¹ç³»ã¨æƒ…å ±ç³»ã®çµ±åˆã¯ã¾ã ç¾å®Ÿçš„ã¨ã¯è¨€ãˆãªã„ ã“ã®å ´åˆã€OLTPã¨æƒ…å ±ç³»ã®ã‚·ã‚¹ãƒ†ãƒ ãŒçµ±åˆåŒ–ã•ã‚ŒãŸã¨ã„ã†ã‚ˆã‚Šã¯ã€ERPã®ä»•çµ„ã¿ã«BIçš„ãªãƒ¬ãƒãƒ¼ãƒˆæ©Ÿèƒ½ãŒä»˜ã„ãŸã‚‚ã®ã¨æ‰ãˆã‚‹ã®ãŒæ£è§£ã ã‚ã†ã€‚ERPãªã©ã§æ›´æ–°ã•ã‚Œã‚‹ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ãªãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã€ç°¡å˜ãªãƒ¬ãƒãƒ¼ãƒˆç”»é¢ãªã©ã‚’æä¾›ã™ã‚‹ã‚‚ã®ã€‚ã“ã†ã„ã£ãŸä»•çµ„ã¿ã¯ä»Šã‚„ã‚€ã—ã‚å½“ç„¶ã§ã€ERPãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãªã©ã®æ–°ã—ã„ã€Œå£²ã‚Šæ©Ÿèƒ½ã€ã®1ã¤ã¨ã‚‚è¨€ãˆã‚‹ã€‚ ã—ã‹ã—ã€ã“ã®ERPã«åŠ ã‚ã£ãŸBIæ©Ÿèƒ½ã§é«˜åº¦ã§è¤‡é›‘ãªåˆ†æžãŒã§ãã‚‹ã‚ã‘ã§ã¯ãªã„ã€‚ã“ã‚Œã‚’ä½¿ã£ã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§è¤‡é›‘ã‹ã¤é«˜åº¦ãªåˆ†æžå‡¦ç†ã‚’è¡Œãˆã°ã€OLTPå´ã®å‡¦ç†ã«å½±éŸ¿ã‚’åŠã¼ã™ã®ã¯å¿…è‡³ã ã€‚ã•ã‚‰ã«ã€ã„ãã‚‰å‡¦ç†ãŒé€Ÿããªã£ãŸã¨ã¯ã„ãˆã€OLTPç”¨ã«æœ€é©åŒ–ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã€é«˜åº¦ãªåˆ†æžå‡¦ç†ã§ã¯ååˆ†ãªæ€§èƒ½ã‚’ç™ºæ®ã§ããªã„å¯èƒ½æ€§ã‚‚é«˜ã„ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç³»ã®ã‚·ã‚¹ãƒ†ãƒ ã¨æƒ…å ±ç³»ã®ã‚·ã‚¹ãƒ†ãƒ ã®çµ±åˆã¯ã€ä»Šã®ã¨ã“ã‚ã¯ç†æƒ³ã§ã‚ã‚Šç¾å®Ÿçš„ã§ã¯
InoHiro 2015/12/03
DWH
ãƒªãƒ³ã‚¯
ãƒªã‚¯ãƒ«ãƒ¼ãƒˆãƒ©ã‚¤ãƒ•ã‚¹ã‚¿ã‚¤ãƒ«ã®ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿
ãƒªã‚¯ãƒ«ãƒ¼ãƒˆãƒ©ã‚¤ãƒ•ã‚¹ã‚¿ã‚¤ãƒ«ã®ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ 300æœ¬ã®ãƒãƒƒãƒãŒæµã‚Œã€300äººã®åˆ†æžè€…ãŒã‚¯ã‚¨ãƒªã‚’æŠ•ã’ã‚‹ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿åŸºç›¤ ã“ã‚“ã«ã¡ã¯ã€ãƒ‡ãƒ¼ã‚¿åŸºç›¤ãƒãƒ¼ãƒ ã®å¹³æœ¬ã§ã™ã€‚ æˆ‘ã€…ã€ãƒ‡ãƒ¼ã‚¿åŸºç›¤ãƒãƒ¼ãƒ ã®ãƒŸãƒƒã‚·ãƒ§ãƒ³ã¯2ã¤ã‚ã‚Šã¾ã™ã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆãƒ©ã‚¤ãƒ•ã‚¹ã‚¿ã‚¤ãƒ«å„ã‚µãƒ¼ãƒ“ã‚¹ã®åˆ†æžæ‹…å½“è€…ã«å¯¾ã—ã¦ã€ãã®ã‚µãƒ¼ãƒ“ã‚¹ã€ã‚‚ã—ãã¯è¤‡æ•°ã®ã‚µãƒ¼ãƒ“ã‚¹ã«ã¾ãŸãŒã£ãŸãƒ¦ãƒ¼ã‚¶ã®è¡Œå‹•ã‚’åˆ†æžã§ãã‚‹ç’°å¢ƒã‚’æä¾›ã™ã‚‹ å„ã‚µãƒ¼ãƒ“ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã£ãŸOne to Oneã€Cross-useæ–½ç–ã®ãƒãƒƒãƒã‚’é–‹ç™ºãƒ»é‹ç”¨ã—ã€å„ã‚µãƒ¼ãƒ“ã‚¹ã«ä¾¡å€¤ã‚’æä¾›ã™ã‚‹ ä»Šå›žã¯ç¬¬1å›žç›®ã¨ã„ã†ã“ã¨ã§ã€æˆ‘ã€…ãŒæ§‹ç¯‰ãƒ»é‹ç”¨ã—ã¦ã„ã‚‹ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ç’°å¢ƒã®å…¨ä½“åƒã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ åŸºç›¤ã®å…¨ä½“åƒ æˆ‘ã€…ã®åŸºç›¤ã¯ã€ãƒªã‚¯ãƒ«ãƒ¼ãƒˆãƒ©ã‚¤ãƒ•ã‚¹ã‚¿ã‚¤ãƒ«å…¨ã‚µãƒ¼ãƒ“ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’åŽé›†ã—ã¦ã„ã¾ã™ã€‚ åŽé›†ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’åŸºã«ã€åˆ†æžã«ä½¿ã†ãƒžãƒ¼ãƒˆã‚„ãƒ¬ã‚³ãƒ¡ãƒ³ãƒ‰ã«ä½¿ã†ãƒ‡ãƒ¼ã‚¿ã‚’ä½œæˆã—ã¦ãŠã‚Šã€ãƒ¬ã‚³ãƒ¡ãƒ³ãƒ‰ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚µãƒ¼ãƒ“ã‚¹å´ã®DBã¸ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã—ãŸã‚Šã€ãƒ¬
InoHiro 2015/08/07
TD, Redshiftã¯æ—¢è¦–æ„Ÿã€‚JP1ä½¿ã£ã¦ã‚‹ã‚“ã ã€‚åˆ†æžã™ã‚‹äººãŒ300äººã„ã‚‹ã®ã™ã”ã„

DWH

ETL
ãƒªãƒ³ã‚¯
Amazon.co.jp: 10å¹´æˆ¦ãˆã‚‹ãƒ‡ãƒ¼ã‚¿åˆ†æžå…¥é–€ SQLã‚’æ¦å™¨ã«ãƒ‡ãƒ¼ã‚¿æ´»ç”¨æ™‚ä»£ã‚’ç”ŸãæŠœã (Informatics &IDEA): é’æœ¨å³°éƒŽ: æœ¬
InoHiro 2015/05/25
DWH

RDBMS

books
ãƒªãƒ³ã‚¯
Bill Inmon - Wikipedia
This biography of a living person needs additional citations for verification. Please help by adding reliable sources. Contentious material about living persons that is unsourced or poorly sourced must be removed immediately from the article and its talk page, especially if potentially libelous. Find sources:Â "Bill Inmon"Â â€“Â newsÂ Â· newspapersÂ Â· booksÂ Â· scholarÂ Â· JSTOR (June 2016) (Learn how and whe
InoHiro 2014/11/17
wikipedia

DWH
ãƒªãƒ³ã‚¯
Teradataï½œTeradata Japan, Ltd. | æ—¥æœ¬ãƒ†ãƒ©ãƒ‡ãƒ¼ã‚¿æ ªå¼ä¼šç¤¾
InoHiro 2014/06/04
Teradata

DWH
ãƒªãƒ³ã‚¯
1