[B! db] cl-gakuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

cl-gaku id:cl-gaku

dbã«é–¢ã™ã‚‹cl-gakuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

è«–ç†å‰Šé™¤ãƒ•ãƒ©ã‚°ã¨ã„ã†åã®æ»äº¡ãƒ•ãƒ©ã‚° - @ledsun blog
RDB - DELETE_FLAG ã‚’ä»˜ã‘ã‚‹å‰ã«ç¢ºèªã—ãŸã„ã“ã¨ã€‚ - Qiita è«–ç†å‰Šé™¤ãŒäº‘ã€…ã«ã¤ã„ã¦ - mike-neckã®ãƒ–ãƒã‚° Kazuho's Weblog: è«–ç†å‰Šé™¤ã¯ãªãœã€Œç‹ãŒæ‚ªã„ã€ã‹ æµè¡Œã£ã¦ã„ã‚‹ã®ã§ä¹—ã£ã‹ã‚Šã¾ã™ã€‚ çµè«– ã€Œãƒ‡ãƒ¼ã‚¿åˆ¶ç´„ã®å¼·åŠ›ã•ã¨é›†åˆã¨ã—ã¦ã®è¡¨ç¾åŠ›ã‚’æ¨ã¦ãªãŒã‚‰ã€Relational Databaseã‚’ä½¿ã†ã®ã¯ãªãœã‹ï¼Ÿã€ è«–ç†å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ãƒ‡ãƒ¡ãƒªãƒƒãƒˆ å¤§ä½“ä¸‰ã¤ã‚ã‚‹ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®è¨€è‘‰ã§ãªã„ ãƒ‡ãƒ¼ã‚¿åˆ¶ç´„ã®å¼±ã• é›†åˆã¨ã—ã¦èªè˜ã§ããªã„ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®è¨€è‘‰ã§ãªã„ ç§ã®çµŒé¨“ä¸Šã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã€Œè«–ç†å‰Šé™¤ã€ã¨ã„ã†è¨€è‘‰ã‚’èžã„ãŸã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ æ¬¡ã®ã‚ˆã†ãªè¦ä»¶ã¯ã€èžã„ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ ç¤¾å“¡ãŒé€€è·ï¼ˆãƒ»è»¢å±žï¼‰ã™ã‚‹ ï¼ˆå£²æŽ›é‡‘ã®å›žåŽã‚’è«¦ã‚ã¦ï¼‰å£²ä¸Šã‚’æ‰“ã¡æ¶ˆã™ ã€ŒãŠçŸ¥ã‚‰ã›ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã€ã‚’å…¬é–‹æ—¥ãŒãã‚‹ã¾ã§éžè¡¨ç¤ºã«ã™ã‚‹ æ—¢èªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’è¡¨ç¤ºã—ãªã„ ä¿å˜æœŸé–“ãŒéŽãŽãŸã‚¢ãƒ³ã‚±ãƒ¼ãƒˆçµæžœã‚’ã‚ªãƒšãƒ¬
cl-gaku 2020/10/08
database

db

è«–ç†å‰Šé™¤

è¨è¨ˆ

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
tm-versions
TM ï¼ˆï¼´å—å½¢ ERæ‰‹æ³•ã®æ”¹è‰¯ç‰ˆï¼‰ ã¯ã€å®Ÿåœ°ã®ä½¿ç”¨ã®ãªã‹ã§é¨“è¨¼ã‚’ç¶šã‘ã¦ã€ã‹ã¤ã€æ•°å¦ãƒ»ãƒã‚¸ãƒƒã‚¯ ï¼ˆè«–ç†å¦ï¼‰ãƒ»å“²å¦ã®è¦³ç‚¹ã‹ã‚‰æ¤œè¨¼ã‚’ç¶šã‘ã¦ã„ã‚‹ã®ã§ã€æ”¹è‰¯ã‚’æ–½ã—ã¦ãã¦ã„ã¾ã™ã€‚ãã®ãŸã‚ã«ã€ç¾æ™‚ç‚¹ã§ã®ä½“ç³» ï¼ˆæœ€æ–°ã®ä½“ç³»ï¼‰ ã‚’çŸ¥ã‚ŠãŸã„ã¨ã„ã†è¦æœ›ãŒå¤šã„ã®ã§ã€æœ¬ ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ ã§ã€TM ã®æœ€æ–° ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ã‚’è¨˜ã™ã“ã¨ã«ã—ã¾ã—ãŸã€‚TM ã‚’è¦‹ç›´ã—ãŸæŠ˜ã‚Šã«ã€ãã®ã¤ã©ã€æ–°ã—ã„ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ã‚’ç¤ºã—ã¦ã„ãã¾ã™ã€‚ â— TM3.0 ï¼ˆ2022-07-22ï¼‰ â†’ ã€Œãƒ¢ãƒ‡ãƒ« ä½œæˆæŠ€è¡“ TM å…¥é–€ã€ ï¼ˆæŠ€è¡“è©•è«–ç¤¾ï¼‰ â— TM3.0 ã®å…ƒè³‡æ–™ ï¼ˆ2020-12-30ï¼‰ â†’ TM3.0 ã®æŠ€è¡“ ï¼ˆèª¬æ˜Žè³‡æ–™ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ï¼‰ â— TM2.0 ï¼ˆ2015-06-04ï¼‰ â†’ TM2.0 ã®åŸºæœ¬çš„ãªè€ƒãˆã‹ãŸ ï¼ˆèª¬æ˜Žè³‡æ–™ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ï¼‰ â†’ TM2.0 ã®æŠ€è¡“ ï¼ˆèª¬æ˜Žè³‡æ–™ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ï¼‰ â— TM1.0 ï¼ˆ2009-01-23ï¼‰ ã€Œèµ¤æœ¬ã€ ã€Œã„
cl-gaku 2020/10/08
è¨è¨ˆ

db
ãƒªãƒ³ã‚¯
è«–ç†å‰Šé™¤ãŒäº‘ã€…ã«ã¤ã„ã¦ - mike-neckã®ãƒ–ãƒã‚°
ä»Šæ—¥æœã‚¤ãƒã§è¦‹ãŸã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒã“ã‚Œã§ã—ãŸã€‚ qiita.com è«–ç†å‰Šé™¤ã®å¼Šå®³ã¯è‰²ã€…ãªã¨ã“ã‚ã§è¨€ã‚ã‚Œã¦ã„ã‚‹ã‘ã©ã€åƒ•ã®è¶³ã‚Šãªã„é ã§ç†è§£ã—ã¦ã„ã‚‹æ‰€ã«ã‚ˆã‚‹ã¨ã€äºŒã¤ã®å€¤ã—ã‹æŒãŸãªã„å‰Šé™¤ãƒ•ãƒ©ã‚°çš„ãªã‚‚ã®ã¯ã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£ãŒäº‘ã€…ã§æ¤œç´¢æ¡ä»¶ã«ã¤ã‘ã¦ã‚‚æ€§èƒ½ä¸Šçš„ã«ã‚‚ã‚ˆããªã„ã—ã€æ„å‘³ãŒãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ è«–ç†å‰Šé™¤ã‚’å®Œå…¨ã«æ‚ªã ã¨ã¯è¨€ã„ã¾ã›ã‚“ãŒã€è«–ç†å‰Šé™¤ã‚’æ¥µåŠ›æŽ’ã—ãŸã„äººãŸã¡ã¯ã€åŸºæœ¬çš„ã«ãƒ‡ãƒ¼ã‚¿ãã®ã‚‚ã®ã‚’å‰Šé™¤ã™ã‚‹ã€ã‚‚ã—ãã¯è«–ç†å‰Šé™¤ã¨ã„ã†ã®ã¯ã¾ã è¦ä»¶çš„ã«æœªç¢ºå®šãªè¦ç´ ãŒéš ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’ç¤ºã™ãƒ•ãƒ©ã‚°ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ åƒ•ãŒITã®æ¥ç•Œã§ã‚ãƒ£ãƒªã‚¢ã‚’ã‚¹ã‚¿ãƒ¼ãƒˆã—ã¦ã‹ã‚‰2å¹´ç›®ãã‚‰ã„ã«é…ç½®ã•ã‚ŒãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã¯Tå—åž‹ERæ‰‹æ³•ã¨ã„ã†ã®ã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’ã—ã¦ã„ã¦ã€ãã“ã§ã‹ãªã‚Šé›ãˆã‚‰ã‚ŒãŸã‚ã‘ã§ã™ãŒã€ãã®æ™‚ã«ã¯ã ã„ãŸã„ã“ã®ã‚ˆã†ãªåŽŸå‰‡ã‚’å©ãã“ã¾ã‚Œã¾ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã«çŠ¶æ…‹ã‚’æŒãŸã›ãªã„ ç©¶æ¥µã«ã¯æ©Ÿæ¢°ãŒèªè˜ã™ã‚‹ã‚ãƒ¼ã¨ã€äººé–“ã«ã¨ã£ã¦æ„
cl-gaku 2020/07/06
db

database

è¨è¨ˆ

è«–ç†å‰Šé™¤

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
è«–ç†å‰Šé™¤ã¯ãªãœã€Œç‹ãŒæ‚ªã„ã€ã‹
ã€Œè«–ç†å‰Šé™¤ãŒäº‘ã€…ã«ã¤ã„ã¦ - mike-neckã®ãƒ–ãƒã‚°ã€ã‚’èªã‚“ã§ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«ãŠã„ã¦ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã®æ›¸ãæ›ãˆã‚’ã™ã‚‹ãªã€immutableãªãƒžã‚¹ã‚¿ã¨æ›´æ–°ãƒã‚°ã«ã‚ˆã£ã¦å…¨ã¦ã‚’æ§‹æˆã—ã‚ã€ã¨ã„ã†ã“ã®è¨˜äº‹ã®ä¸»å¼µã¯ãƒ¢ãƒ‡ãƒªãƒ³ã‚°è«–ã¨ã—ã¦å…¨ãæ£ã—ã„ã€‚ ã ãŒã€æ®‹å¿µãªã“ã¨ã«ã€ãƒ‡ã‚£ã‚¹ã‚¯ã‚„ãƒ¡ãƒ¢ãƒªãŒè²´é‡ãªè³‡æºã ã£ãŸæ™‚ä»£ã®æŠ€è¡“ã§ã‚ã‚‹RDBã¯ã€ãã®ã‚ˆã†ãªãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã«åŸºã¥ã„ã¦è¨è¨ˆã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯å¿…ãšã—ã‚‚é©ã—ã¦ã„ãªã„ã€‚ ç¬¬ä¸€ã®å•é¡Œã¯ã€RDBã«å¯¾ã—ã¦ãªã•ã‚Œã‚‹æ§˜ã€…ãªã€Œæ›´æ–°ã€ï¼ˆãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ï¼‰ã¯ä¸å®šå½¢ï¼ˆã©ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã©ã®ã‚ˆã†ã«ä¿®æ£ã™ã‚‹ã‹ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä¾å˜ï¼‰ã ã¨ã„ã†ç‚¹ã€‚ä¸å®šå½¢ãªã€Œæ›´æ–°ã€ã‚’æ™‚ç³»åˆ—ã«ãã£ã¦RDBã«è¨˜éŒ²ã—ã¦ã„ãã®ã¯ã€è¨è¨ˆã¨ä¸¦èµ°æ€§ã®ç‚¹ã«ãŠã„ã¦å›°é›£ã‚ã‚‹ã„ã¯ç…©é›‘ãªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒå¿…è¦ã«ãªã‚‹ï¼ˆã¨ã„ã†ã‹ã€ãã®ã‚ˆã†ãªã€Œã‚¤ãƒ™ãƒ³ãƒˆã€ã«ã‚ˆã‚‹ã€Œå¤‰åŒ–ã€ã¯REDOãƒã‚°ã«æ›¸ãã€ãã®æ›´æ–°ã•ã‚ŒãŸã€ŒçŠ¶æ…‹ã€ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã«åæ˜ ã—ã¦ã„ãã¨ã„ã†ã®ãŒ
cl-gaku 2020/07/06
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

è«–ç†å‰Šé™¤

è¨è¨ˆ

db

database

Immutable
ãƒªãƒ³ã‚¯
ã‚¤ãƒŸãƒ¥ãƒ¼ã‚¿ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« - kawasima
ã¯ã˜ã‚ã« CRUDã®ã†ã¡UPDATEãŒã‚‚ã£ã¨ã‚‚ã‚·ã‚¹ãƒ†ãƒ ã‚’è¤‡é›‘åŒ–ã™ã‚‹ã€‚æ›´æ–°ã«ã¯è¤‡é›‘ãªãƒ«ãƒ¼ãƒ«ãŒä¼´ã†ã‹ã‚‰ã ã€‚æ¥å‹™çš„ã«è¤‡é›‘ãªãƒ«ãƒ¼ãƒ«ãŒå˜åœ¨ã™ã‚‹ã®ã¯ä»•æ–¹ãªã„ã“ã¨ã‚‚ã‚ã‚‹ãŒã€ã‚·ã‚¹ãƒ†ãƒ ã€è¨è¨ˆã§è¤‡é›‘ã•ã‚’æ›´ã«å¢—ã•ãªã„ã‚ˆã†ã«ã—ãŸã„ã€‚UPDATEã«ç€ç›®ã—ã€ãã®ç™ºç”Ÿã‚’ã§ãã‚‹ã ã‘å‰Šã‚‹ã“ã¨ã«ã‚ˆã£ã¦è¤‡é›‘ã•ã‚’ãŠã•ãˆã‚‹ãŸã‚ã«ã¯ã€ã¾ãšãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã‚’ãã®ã‚ˆã†ã«è¨è¨ˆã—ã¦ãŠã‹ãªã‘ã‚Œãªãªã‚‰ãªã„ã€‚ã“ã®ã‚¤ãƒŸãƒ¥ãƒ¼ã‚¿ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¯ã€ãã‚Œã‚’æ‰‹åŠ©ã‘ã™ã‚‹æ‰‹æ³•ã§ã€æ‰‹é †ã«æ²¿ã£ã¦å®Ÿæ–½ã™ã‚Œã°ã‚ã‚‹ç¨‹åº¦ã®ã‚¹ã‚ãƒ«ã®ãƒãƒ©ã¤ãã‚‚å¸åŽã§ãã‚‹ã‚ˆã†ã«çµ„ã¿ç«‹ã¦ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ æ‰‹é † Step1. ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’æŠ½å‡ºã™ã‚‹ ã¾ãšã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’æŠ½å‡ºã™ã‚‹ã¨ã“ã‚ã‹ã‚‰å§‹ã‚ã‚‹ã€‚ 5W1HãŒã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®å€™è£œ å¾“æ¥å“¡,æ‚£è€…,ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼,é¡§å®¢,ç”Ÿå¾’,... è£½å“,ã‚µãƒ¼ãƒ“ã‚¹,ã‚³ãƒ¼ã‚¹,æ›²,... æ™‚é–“,æ—¥ä»˜,æœˆ,å¹´,å¹´åº¦,... é€ä»˜å…ˆ,URL,IPã‚¢ãƒ‰ãƒ¬ã‚¹,... æ³¨æ–‡,è¿”å“,å…¥é‡‘,å‡ºé‡‘,å–å¼•,
cl-gaku 2020/03/11
db

ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°

è¨è¨ˆ
ãƒªãƒ³ã‚¯
SQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ãã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ–ãƒƒã‚¯
é–‹ç™ºè€…å‘ã‘ã®SQLã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è§£èª¬ã‚µã‚¤ãƒˆã€ç®¡ç†ã«ã¤ã„ã¦ã®é–“é•ã„ãªã„çŸ¥è˜ã‚’æä¾›ã—ã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é–‹ç™ºæ™‚ã«ã¯å¿˜ã‚Œã‚‰ã‚ŒãŒã¡ã§ã‚ã‚‹ä¸€æ–¹ã§ã€éžå¸¸ã«åŠ¹æžœçš„ãªSQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³•ã§ã™ã€‚Use The Index, Lukeã§ã¯ã€Hibernateãªã©ã®ORMãƒ„ãƒ¼ãƒ«ã®è§£èª¬ã«ã¨ã©ã¾ã‚‰ãšã€SQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åŸºç¤Žã‹ã‚‰èª¬æ˜Žã—ã¾ã™ã€‚ Use The Index, Lukeã¯SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã®Webä¸Šã®ç„¡æ–™ç‰ˆã§ã™ã€‚ã‚µã‚¤ãƒˆã‚’æ°—ã«å…¥ã£ã¦é ‚ã‘ãŸã‚‰ã€ãœã²æ›¸ç±ã‚‚è³¼å…¥ã—ã¦ã¿ã¦ä¸‹ã•ã„ã€‚ã¾ãŸã€ã“ã®ã‚µã‚¤ãƒˆã®é‹å–¶ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹æ§˜ã€…ãªã‚°ãƒƒã‚ºã‚‚è²©å£²ã—ã¦ã„ã¾ã™ã€‚ MySQLã€Oracleã€SQL Serverãªã©ã«ãŠã‘ã‚‹SQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹Use The Index, Lukeã§ã¯ã€ãƒ™ãƒ³ãƒ€ã«ã¨ã‚‰ã‚ã‚Œãªã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®èª¬æ˜Žã‚’å¿ƒãŒã‘ã¦ã„ã¾ã™ã€‚è£½å“ç‰¹æœ‰ã®äº‹æŸ„ã«ã¤ã„ã¦ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªè¡¨ç¤ºã‚’ã—ã¦ã„ã¾ã™ã€‚ Db2 (LUW)U
cl-gaku 2019/10/03
DBAã®æˆ¦å£«ã«ãªã‚‹ã‹

SQL

db

database

performance

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ å¹»ã®ç¬¬26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ 26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€ 2015/08/31 @ GMO Yours #ronsakucasual https://atnd.org/events/68902Read less
cl-gaku 2017/07/14
ã‚ã¨ã§èªã‚€

db

è¨è¨ˆ

è«–ç†å‰Šé™¤
ãƒªãƒ³ã‚¯
1