[B! å›³] UKIBORIã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

UKIBORI id:UKIBORI

å›³ã«é–¢ã™ã‚‹UKIBORIã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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}}

ã‚ã‹ã‚Šã«ãã„ç·šå½¢ä»£æ•°ã‚’æ“ä½œå¯èƒ½ãªå›³ã§è¡¨ç¾ã™ã‚‹ã“ã¨ã§ç°¡å˜ã«ç†è§£ã§ãã‚‹ç„¡æ–™ã®æ•™ç§‘æ›¸ã€ŒImmersive Mathã€
ã€ŒImmersive Mathã€ã¯ã€æ•°å¦ã®ã†ã¡ãƒ™ã‚¯ãƒˆãƒ«ã‚„è¡Œåˆ—ãªã©ã®è¨ˆç®—ã‚’ç ”ç©¶ã™ã‚‹åˆ†é‡Žã§ã‚ã‚‹ã€Œç·šå½¢ä»£æ•°ã€ã«ã¤ã„ã¦ã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ãªå›³ã‚’ç”¨æ„ã™ã‚‹ã“ã¨ã§ã‚ã‹ã‚Šã‚„ã™ã•ã‚’å‘ä¸Šã•ã›ãŸç„¡æ–™ã®æ•™ç§‘æ›¸ã‚µã‚¤ãƒˆã§ã™ã€‚ Immersive Math https://immersivemath.com/ila/index.html ã‚µã‚¤ãƒˆã®ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ã¯ã“ã‚“ãªæ„Ÿã˜ã€‚ã€Œå®Œå…¨ã«ã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ãªå›³ã‚’å‚™ãˆãŸä¸–ç•Œã§æœ€åˆã®ç·šå½¢ä»£æ•°æœ¬ã€ã¨è¿°ã¹ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ ä¸å¤®ã«è¡¨ç¤ºã•ã‚Œã¦ã„ã‚‹ä¸‰è§’å½¢ã®å›³ã¯ã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ã§ã€å·¦ä¸Šã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã“ã¨ã§å›žè»¢ãƒ»åœæ¢ã‚’åˆ‡ã‚Šæ›¿ãˆã‚‰ã‚Œã‚‹ã»ã‹ã€å„é ‚ç‚¹ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãƒ‰ãƒ©ãƒƒã‚°ï¼†ãƒ‰ãƒãƒƒãƒ—ã™ã‚‹ã“ã¨ã§ä½ç½®ã‚’èª¿æ•´å¯èƒ½ã€‚è‡ªç”±ã«å›³ã‚’ç·¨é›†ã§ãã‚‹ãŸã‚ç†è§£ã—ã‚„ã™ã„ã¨ã„ã†ã‚ã‘ã§ã™ã€‚ ãƒšãƒ¼ã‚¸ã‚’ã‚¹ã‚¯ãƒãƒ¼ãƒ«ã™ã‚‹ã¨ç›®æ¬¡ãŒç¾ã‚Œã¾ã—ãŸã€‚ã¾ãšã¯ã€ŒPreface(åºæ–‡)ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ã€‚ ã€Œã€Žç™¾èžã¯ä¸€è¦‹ã«å¦‚ã‹ãšã€ã¨ã„ã†è¨€è‘‰ã®é€šã‚Šã€ãŸãã•ã‚“ã®è¨€è‘‰ã‚’é‡ã
$ã‚ã‹ã‚Šã«ãã„ç·šå½¢ä»£æ•°ã‚’æ“ä½œå¯èƒ½ãªå›³ã§è¡¨ç¾ã™ã‚‹ã“ã¨ã§ç°¡å˜ã«ç†è§£ã§ãã‚‹ç„¡æ–™ã®æ•™ç§‘æ›¸ã€ŒImmersive Mathã€$
UKIBORI 2024/05/20
å›³

è¡¨ç¾

æ•°å¦

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ãƒžãƒªã‚ªã‚«ãƒ¼ãƒˆã®ERå›³ã«ã¤ã„ã¦è€ƒãˆã‚‹ - Qiita
ã•ã¦ã€ ä»Šå›žã¯ã‚ªãƒ•ã‚£ã‚¹ã«ã¦ã€ŒERå›³ã¨ã¯ï¼Ÿã€ã‚’å¦ã¶ãƒ©ãƒ³ãƒã‚’é–‹å‚¬ã—ã¾ã—ãŸðŸ” ã‚²ãƒ¼ãƒ ã®DBãªã‚“ã¦è€ƒãˆãŸã“ã¨ãŒç„¡ã„ã®ã§ã€ERå›³ã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆã«è‡³ã‚‹ã¾ã§ã‚’è¨˜äº‹ã«æ®‹ã—ã¦ã‚ã’ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€ãƒªãƒªãƒ¼ã‚¹æ™‚ã«åŒåƒšã¿ã‚“ãªã§éŠã‚“ã§ã„ãŸã‚¹ãƒžãƒ›ã‚²ãƒ¼ãƒ ã€Œãƒžãƒªã‚ªã‚«ãƒ¼ãƒˆ ãƒ„ã‚¢ãƒ¼ã€ã‚’ä½¿ã£ã¦ ãƒžãƒªã‚«ãƒ¼ã®ãƒ•ãƒ¬ãƒ³ãƒ‰ãƒ©ãƒ³ã‚ãƒ³ã‚°ç”»é¢ã‚’å‡ºã™ãŸã‚ã«å¿…è¦ãªDBè¨è¨ˆã‚’è€ƒãˆã¾ã™ã€‚ è»½ã„ãƒ©ãƒ³ãƒãªã®ã§ã€äº‹å‰ã«å‚åŠ è€…ãŒé€šå‹¤ä¸ã®é›»è»Šå†…ã§ä½œæˆã§ãã‚‹ãã‚‰ã„ã®ãƒœãƒªãƒ¥ãƒ¼ãƒ ã‚’ç›®æŒ‡ã—ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ãƒ»ãƒ»ãƒ»ï¼Ÿã¨ã„ã†åˆå¿ƒè€…ãƒ¡ãƒ³ãƒãƒ¼ã§ã‚‚ã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã‚„ã™ã„ã‚ˆã†ã«ã€‚ ã“ã†ã„ã†ã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆã¯åˆã‚ã¦ã§ã™ãŒã€å¾ã€…ã«æ…£ã‚Œã¦ã„ããŸã„ã§ã™ã€‚ ã€é–‹å‚¬æ¦‚è¦ã€‘ ãƒ»å‚åŠ è€…ï¼šãƒ•ã‚¡ãƒƒã‚·ãƒ§ãƒ³ ITä¼æ¥ã®PMã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã€äº‹å‹™ãƒ»ãƒ»ãƒ»ãªã©ãªã© ãƒ»é–‹å‚¬æ™‚é–“ï¼š1æ™‚é–“ï¼ˆäº‹å‰ã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆä½œæˆï¼š20ã€œ30åˆ†ç¨‹åº¦ï¼‰ ãƒ»ãã®å¾Œï¼šSQLã‚’åˆå¿ƒè€…ã¨æ›¸ã„ã¦ã¿ã‚‹ãƒ©ãƒ³ãƒã‚‚å®Ÿæ–½ã—ã¾ã—ãŸã€‚ â†’BigQueryãŒSQ
UKIBORI 2024/02/06
å›³

database

ãƒ„ãƒ¼ãƒ«

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
dbtã§è¦‹ã‚„ã™ã„ERå›³ã‚’ç”Ÿæˆã™ã‚‹ - yasuhisa's blog
èƒŒæ™¯: dbtã‚’ä½¿ã£ã¦ã„ã¦ã‚‚ERå›³ã¯æ¬²ã—ã„! ã©ã†ã‚„ã£ã¦ERå›³ã‚’ç”Ÿæˆã™ã‚‹ã‹ ã©ã†ã‚„ã£ã¦ERå›³ã‚’è¦‹ã‚„ã™ãã™ã‚‹ã‹ ã¾ã¨ã‚ èƒŒæ™¯: dbtã‚’ä½¿ã£ã¦ã„ã¦ã‚‚ERå›³ã¯æ¬²ã—ã„! dbtã¯ãƒ¢ãƒ‡ãƒ«é–“ã®ãƒªãƒãƒ¼ã‚¸ãªã©å¯è¦–åŒ–ãŒå¾—æ„ãªãƒ„ãƒ¼ãƒ«ã§ã¯ã‚ã‚Šã¾ã™ãŒã€ä¸‡èƒ½ãªã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ¢ãƒ‡ãƒ«ã®ç”ŸæˆéŽç¨‹ãªã©ã¯ãƒªãƒãƒ¼ã‚¸ã§æ‹…ä¿ã§ãã¾ã™ãŒã€åˆ†æžæ™‚ã«ã€Œã©ã‚Œã¨ã©ã®ãƒ¢ãƒ‡ãƒ«ãŒJOINã§ãã¦ã€JOINã™ã‚‹éš›ã®ã‚ãƒ¼ã¯ã“ã‚Œã‚’ä½¿ã£ã¦ã€ã¨ã„ã†ERå›³ã§æ‰±ã†ã‚ˆã†ãªå¯è¦–åŒ–ã¯ãƒ‡ã‚£ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ã§ãã¾ã›ã‚“ã€‚ DWHã‚’ä½œã£ã¦ã„ã‚‹å´ã‹ã‚‰ã™ã‚‹ã¨ã€Œã“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã‚ã®è¾ºã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ä¸€ç·’ã«ä½¿ã†ã¨ä¾¿åˆ©ã§ã€ã„ã¤ã‚‚ã‚ã®ã‚ãƒ¼ã§JOINã—ã¦ã€ã¨ã„ã†ã®ãŒé ã®ä¸ã«å…¥ã£ã¦ã„ã‚‹ã“ã¨ãŒå¤šã„ãŸã‚ã€ERå›³ãŒãªãã¦ã‚‚ã©ã†ã«ã‹ãªã‚‹ã“ã¨ã‚‚å¤šã„ã§ã—ã‚‡ã†ã€‚ã—ã‹ã—ã€åˆ†æžã«æ…£ã‚Œã¦ã„ãªã„äººã‚„åˆ†æžã«æ…£ã‚Œã¦ã„ã‚‹äººã§ã‚ã£ã¦ã‚‚ã€æ™®æ®µã¨ç•°ãªã‚‹ãƒ‰ãƒ¡ã‚¤ãƒ³ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è§¦ã‚‹ã¨ãã¯ERå›³ãŒæä¾›ã—ã¦ãã‚Œã‚‹æƒ…å ±ã¯æœ‰ç”¨ã§ã™ã€‚ã¡ãªã¿ã«
UKIBORI 2024/02/04
å›³

ã‚ã¨ã§èªã‚€

database
ãƒªãƒ³ã‚¯
ã€å…¥é–€ã€‘åŸºæœ¬è¨è¨ˆ
ã¯ã˜ã‚ã« ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã®ä»•äº‹ã‚’ã™ã‚‹éš›ã«ã€ãŠå®¢ã•ã‚“ã«ææ¡ˆãƒ™ãƒ¼ã‚¹ã®è¦ä»¶å®šç¾©ã‚„è¨è¨ˆã‚’ã™ã‚‹æ©Ÿä¼šãŒå¢—ãˆã¦ããŸã®ã§ã€ç§ã®çµŒé¨“ã«åŸºã¥ã„ã¦åŸºæœ¬è¨è¨ˆã®å…·ä½“çš„ãªãƒ—ãƒã‚»ã‚¹ã‚„è€ƒãˆæ–¹ã«ã¤ã„ã¦ã€æ•´ç†ã—ã¦ã„ãã¾ã™ã€‚ ä»¥å‰æŠ•ç¨¿ã—ãŸè¨˜äº‹ã®ç¶šãã§ã™ãŒã€æœªèªã§ã‚‚ã“ã®è¨˜äº‹ã‚’ç†è§£ã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã®å¯¾è±¡è€… åŸºæœ¬è¨è¨ˆã®æ€è€ƒãƒ—ãƒã‚»ã‚¹ã‚’å¦ã³ãŸã„äºº ãƒ“ã‚¸ãƒã‚¹ã‚µã‚¤ãƒ‰ã®è¦ä»¶ã‚’ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚µã‚¤ãƒ‰ã®ã‚·ã‚¹ãƒ†ãƒ ã«è½ã¨ã—è¾¼ã‚€æµã‚Œã‚’å¦ã³ãŸã„äºº ãƒ“ã‚¸ãƒã‚¹ã‚µã‚¤ãƒ‰ã¨ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚µã‚¤ãƒ‰ã®ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³èƒ½åŠ›ã‚’å‘ä¸Šã•ã›ãŸã„äºº å…·ä½“çš„ãªäº‹ä¾‹ã‚’é€šã—ã¦åŸºæœ¬è¨è¨ˆã‚’å¦ã³ãŸã„äºº å‰æ ç´¹ä»‹ã™ã‚‹å†…å®¹ã¯ã‚ãã¾ã§ä¸€ä¾‹ã§ã‚ã‚Šã€ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚„ãƒãƒ¼ãƒ ã®çŠ¶æ³ã«å¿œã˜ã¦èª¿æ•´ãŒå¿…è¦ã§ã™ è‡ªåˆ†ã®çµŒé¨“ã«åŸºã¥ã„ãŸå†…å®¹ã‚’è¨€èªžåŒ–ã—ã¦ã„ã¾ã™ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆè¦æ¨¡ã¯10åã‹ã‚‰20åã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’æƒ³å®šã—ã¦ã„ã¾ã™(å¤§è¦æ¨¡ãªãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’æƒ³å®šã—ã¦ã„ã¾ã›ã‚“) ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã®å…¨ä½“åƒ ä»Šå›žã¯ä¸‹è¨˜
UKIBORI 2023/11/09
è¨è¨ˆ

ãƒ“ã‚¸ãƒã‚¹

å›³

ã‚ã¨ã§èªã‚€

ä»•äº‹
ãƒªãƒ³ã‚¯
DDDã§ã®è¦ä»¶å®šç¾©ã€œå®Ÿè£…ã¾ã§ã®æµã‚Œã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™
æœ¬è¨˜äº‹ã§ã¯ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºæ‰‹æ³•ã®ä¸€ã¤ã§ã‚ã‚‹DDDï¼ˆdomain-driven designï¼‰ã‚’ä½¿ã£ã¦è¦ä»¶å®šç¾©ã€œå®Ÿè£…ã‚’è¡Œã†éš›ã®ãƒ—ãƒã‚»ã‚¹ã‚„ãƒã‚¤ãƒ³ãƒˆã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã„ãã¾ã™ã€‚ ï¼ˆæ›¸ç±ã€Œãƒ‰ãƒ¡ã‚¤ãƒ³é§†å‹•è¨è¨ˆãƒ¢ãƒ‡ãƒªãƒ³ã‚°/å®Ÿè£…ã‚¬ã‚¤ãƒ‰ã€ã®å†…å®¹ã‚’å¤§ã„ã«å‚è€ƒã«ã•ã›ã¦ã„ãŸã ã„ã¦ã„ã¾ã™ãŒã€ç‹¬è‡ªã®å†…å®¹ãƒ»è€ƒå¯Ÿã‚‚è¨˜è¼‰ã—ã¦ã„ã‚‹ã¤ã‚‚ã‚Šã§ã™ã€‚ï¼‰ DDD ã¨ã¯ï¼Ÿ DDDï¼ˆdomain-driven designï¼‰ã¯æ—¥æœ¬èªžã«è¨³ã™ã¨ãƒ‰ãƒ¡ã‚¤ãƒ³é§†å‹•è¨è¨ˆã§ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºæ‰‹æ³•ã®ä¸€ã¤ã§ã™ã€‚ ãƒ‰ãƒ¡ã‚¤ãƒ³é§†å‹•ã¨ã„ã†è¨€è‘‰ã‹ã‚‰ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ã¨ã„ã†ã‚‚ã®ãŒé‡è¦ãã†ã ã¨ã„ã†ã“ã¨ã¯ä¼ã‚ã£ã¦ãã‚‹ã¨æ€ã„ã¾ã™ãŒã€ãã‚‚ãã‚‚ãƒ‰ãƒ¡ã‚¤ãƒ³ã¨ã„ã†è¨€è‘‰ãŒæŠ½è±¡çš„ã§ã‚ã‹ã‚Šã«ãã„ã§ã™ã‚ˆãã€‚ ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ç›´è¨³ã™ã‚‹ã¨ã€Œé ˜åŸŸã€ã§ã™ãŒã€DDD ã§æŒ‡ã—ã¦ã„ã‚‹ã€Œé ˜åŸŸã€ã¨ã¯ã€Œã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§å•é¡Œè§£æ±ºã—ã‚ˆã†ã¨ã™ã‚‹å¯¾è±¡é ˜åŸŸã€ã§ã™ã€‚ ãã—ã¦ã€â‘ ãƒ‰ãƒ¡ã‚¤ãƒ³ã«ã¤ã„ã¦ã®ç†è§£ã‚’æ·±ã‚ã¦ãƒ¢ãƒ‡ãƒ«ã‚’ä½œæˆã—ï¼ˆDDD ã§ã¯ã€å¾Œ
UKIBORI 2023/10/13
DDD

é–‹ç™º

å›³

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
Nomnoml
Association types association - association -> association <-> dependency --> dependency <--> generalization -:> implementation --:> composition +- composition +-> aggregation o- aggregation o-> ball and socket -o) ball and socket o<-) ball and socket ->o note -- hidden -/- Class diagram types [class] [<abstract> abstract] [<instance> instance] [<reference> reference] [<package> package|components
UKIBORI 2023/10/03
tool

å›³
ãƒªãƒ³ã‚¯
1