[B! db] shin0Oã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shin0O id:shin0O

dbã«é–¢ã™ã‚‹shin0Oã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

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

å°å²©äº•ã“ã¨ã‚Šã•ã‚“ä½œè©žãƒ»ä½œæ›²ãƒ»æŒå”±ã®DBå…¬é–‹ã§ã€AIæŒå£°åˆæˆã®æ°‘ä¸»åŒ–ã¸èºé€²ã€‚NEUTRINOã®æ–°ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã€ŽNo.7ã€ãŒãƒªãƒªãƒ¼ã‚¹ã¸ï½œDTMã‚¹ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³
NEUTRINOã€CeVIO AIã€Synthesizer Vâ€¦â€¦ã¨ã€ã¾ã‚‹ã§äººé–“ã®ã‚ˆã†ã«æŒã†ã€AIæŒå£°åˆæˆã®ä¸–ç•ŒãŒè³‘ã‚ã£ã¦ã„ã¾ã™ãŒã€ä»Šå¹´ã“ã®ä¸–ç•ŒãŒã•ã‚‰ã«å¤§ããå¤‰ã‚ã‚‹å¯èƒ½æ€§ãŒå‡ºã¦ãã¾ã—ãŸã€‚ä¸€èˆ¬ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒè‡ªåˆ†ã®å£°ã‚’åŽéŒ²ã—ã€ãã‚Œã‚’å…ƒã«AIæŒå£°åˆæˆã‚’ã™ã‚‹ãŸã‚ã®çµ±ä¸€ã—ãŸæ¥½æ›²ã®è¦æ ¼ã‚’ä½œã‚Šã€å…¬é–‹ã•ã‚Œã‚‹ã“ã¨ã«ãªã£ãŸã®ã§ã™ã€‚ãã®ä»•çµ„ã¿ã¥ãã‚Šã«è²¢çŒ®ã—ãŸã®ãŒã€å£°å„ªã§ã‚ã‚Šã€ãƒžãƒ«ãƒã‚¯ãƒªã‚¨ã‚¤ã‚¿ãƒ¼ã§ã‚‚ã‚ã‚‹å°å²©äº•ã“ã¨ã‚Šï¼ˆ@koiwai_kotoriï¼‰ã•ã‚“ã€‚AIæŒå£°åˆæˆã®ãŸã‚ã«ã€å°å²©äº•ã•ã‚“ãŒä½œè©žãƒ»ä½œæ›²ã™ã‚‹ã¨ã¨ã‚‚ã«ã€è‡ªã‚‰æŒå”±ã—ãŸãƒ‡ãƒ¼ã‚¿ã€è¨ˆ50æ›²ãŒå…¬é–‹ã•ã‚Œã‚‹ã“ã¨ã¨ãªã‚Šã€ãã‚Œã‚’ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã«ã—ã¦æŒãˆã°ã€ãã‚Œãžã‚Œã®AIæŒå£°åˆæˆãŒã§ãã‚‹ä¸–ç•ŒãŒå®Ÿç¾ã§ãã‚‹ã“ã¨ã«ãªã‚Šãã†ãªã®ã§ã™ã€‚ ãã®ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—ã¨ãªã‚‹å°å²©äº•ã•ã‚“ã®æŒå”±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå…¬é–‹ã«å‘ã‘ã¦ã€æº–å‚™ã‚’é€²ã‚ã¦ã„ã‚‹ã¨ã“ã‚ã§ã™ãŒã€æ£å¼å…¬é–‹å‰ã«ã€å®Ÿéš›ã«æŒã‚ã›ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚½ãƒ•ãƒˆã§ã‚ã‚‹NEUTR
shin0O 2021/04/21
dtm

db
ãƒªãƒ³ã‚¯
æœ€å¼·ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆRDBï¼‰è¨è¨ˆã¨ã¯ï¼Ÿã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã®è¦‹æ¥µã‚æ–¹æ³•ã‚‚ - FLEXYï¼ˆãƒ•ãƒ¬ã‚ã‚·ãƒ¼ï¼‰
â€»2020å¹´6æœˆã«å…¬é–‹ã•ã‚ŒãŸè¨˜äº‹ã§ã™ã€‚ æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼šã®ç†äº‹ã‚’å‹™ã‚ã‚‹åˆåŒä¼šç¤¾Have Fun Techã‚’èµ·æ¥ã—ãŸæ›½æ ¹å£®å¤§ï¼ˆ@soudai1025ï¼‰ã¨ç”³ã—ã¾ã™ã€‚å…ƒæ ªå¼ä¼šç¤¾ã‚ªãƒŸã‚«ãƒ¬å‰¯ç¤¾é•·å…¼CTOã§ã™ã€‚ç›´è¿‘ã§ã¯ã€ã€Žå¤±æ•—ã‹ã‚‰å¦ã¶ RDBã®æ£ã—ã„æ©ãæ–¹ã€ã‚’åŸ·ç†ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒ†ãƒ¼ãƒžã¨ã—ã¦ã€é…åŠ›ã‚„MySQLã¨PostgreSQLã®é•ã„ã€ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã®è¦‹æ¥µã‚ãªã©ã®åŸºç¤ŽçŸ¥è˜ã«åŠ ãˆã€å‹‰å¼·æ³•ãªã©ã‚‚ã”ç´¹ä»‹ã—ã¾ã™ã€‚ RDBé–¢é€£ã®æ±‚äººæ¤œç´¢ã¯ã“ã¡ã‚‰ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã¶é…åŠ›ã‚’ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ç›®ç·šã§è€ƒå¯Ÿ 1.çŸ¥è˜ã®è²»ç”¨å¯¾åŠ¹æžœãŒé«˜ã„ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã¶åˆ©ç‚¹ã¨ã„ã†è¦³ç‚¹ã‹ã‚‰è¨€ã†ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç‰¹å¾´ã¯å¯¿å‘½ãŒé•·ã„ã“ã¨ã¨ç§ã¯è€ƒãˆã¦ã„ã¾ã™ã€‚ Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ç•Œéšˆã§ã¯1å¹´å˜ä½ã§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ãŸã‚Šæµè¡Œã£ã¦ã„ã‚‹è¨€èªžãŒå¤‰ã‚ã£ã¦ã—ã¾ã†ã“ã¨ãŒã‚¶ãƒ©ã«ã‚ã‚Šã¾ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯10å¹´ã€20å¹´ã¨ã„
shin0O 2020/03/26
db

RDB
ãƒªãƒ³ã‚¯
ãƒ–ãƒ©ãƒƒã‚¯ãƒ»ãƒ–ãƒ©ãƒƒã‚¯ä¼æ¥ | Structure and Representation
åŽšç”ŸåŠ´åƒçœãŒå…¬è¡¨ã™ã‚‹åŠ´åƒåŸºæº–é–¢é€£æ³•ä»¤é•åã®ä¼æ¥ã®ä¸€è¦§ã§ã™ã€‚
shin0O 2017/08/08
db

company
ãƒªãƒ³ã‚¯
RDBã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã«ã¤ã„ã¦è©±ã‚’ã—ã¦ãƒ™ã‚¹ãƒˆã‚¹ãƒ”ãƒ¼ã‚«ãƒ¼è³žã‚’å–ã£ã¦ããŸ #builderscon - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
Builderscon 2017ã§ç™»å£‡ã—ã¦ãã¾ã—ãŸã€‚ builderscon.io ç™»å£‡è³‡æ–™ã¯ã“ã¡ã‚‰ã§ã™ã€‚ ä»Šå›žã‚‚åƒ•ãŒè¶…çµ¶ãƒªã‚¹ãƒšã‚¯ãƒˆã—ã¦ã‚‹ id:t-wada ã•ã‚“ã¨ ãã“ãã“ãƒªã‚¹ãƒšã‚¯ãƒˆã—ã¦ã‚‹ ç©ºå‰çµ¶å¾Œã®ã‚©ã‚©ï¼ï¼ï¼ï¼è¶…çµ¶æ€’æ¶›ã«ãƒªã‚¹ãƒšã‚¯ãƒˆã—ã¦ã„ã‚‹ä¸Šå¸ã® id:onishi ã•ã‚“ã®åè¨€ã‚’å¼•ç”¨ã•ã›ã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ã“ã‚Œã¯ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã‚„ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã§å“è³ªãŒè¦‹ãˆã‚‹åŒ–ã•ã‚Œã¾ã™ãŒã€Œè¦‹ãˆã‚‹åŒ–ã•ã‚Œã‚‹ã ã‘ã§ã¯å•é¡Œã¯è§£æ±ºã—ãªã„ã€ã¨ã„ã†æœ¬è³ªã‚’ãŠä¼ãˆã—ã¦ã„ã¾ã™ã€‚æˆ‘ã€…ã¯ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãªã®ã§æŠ€è¡“ã§å•é¡Œã‚’è§£æ±ºã—ã¦ã„ãã‚ã‘ã§ã™ã—ã€å•é¡Œã‚’è§£æ±ºã™ã‚‹ãŸã‚ã«ã¯æ‰‹ã‚’å‹•ã‹ã™ã—ã‹ã‚ã‚Šã¾ã›ã‚“ã€‚ã§ã™ã®ã§ã¾ã•ã«ä»Šã®ç¾å ´ã‚’æ”¹å–„ã—ã¦ã„ãã®ã¯ã‚ãªãŸè‡ªèº«ã§ã™ã€‚ ã‚ã¨ã¯ä»Šå¹´ã€è©±ã‚’ã—ã¦ããŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã®ç·é›†ç·¨ã£ã¦æ„Ÿã˜ã§ã™ã€‚ãƒ›ãƒ³ãƒˆã¯å®Ÿä¾‹ã®RDBã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’å…ƒã«ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã—ã¦ã„ããŸã‹ã£ãŸã‚“ã ã‘ã©60åˆ†ã§ã¯çŸã™ãŽã¦ã€Œç¶šç·¨ã«æœŸå¾…ã€ã¿ãŸã„ãªãƒ¬ãƒ™
shin0O 2017/08/07
db

design
ãƒªãƒ³ã‚¯
DBã‹ã‚‰ç›´æŽ¥golangã®ãƒ¢ãƒ‡ãƒ«ã‚’ç”Ÿæˆã™ã‚‹xoã®ã”ç´¹ä»‹ â€” ãã“ã¯ã‹ã¨ãªãæ›¸ãã‚ˆã‚“ã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ
DBã‹ã‚‰ç›´æŽ¥golangã®ãƒ¢ãƒ‡ãƒ«ã‚’ç”Ÿæˆã™ã‚‹xoã®ã”ç´¹ä»‹Â¶ Webã‚¢ãƒ—ãƒªã‚’é–‹ç™ºã—ã¦ã„ã‚‹æ™‚ã«ã€DBã®ãƒ¢ãƒ‡ãƒ«å®šç¾©ã®æ–¹æ³•ã«ã¯ã„ã‚ã„ã‚ãªã‚„ã‚Šæ–¹ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ xo ã¯ã€ DBã‹ã‚‰ç›´æŽ¥ golangã®ãƒ¢ãƒ‡ãƒ«å®šç¾©ã‚’è‡ªå‹•ç”Ÿæˆã™ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ PostgreSQL MySQL Oracle Microsoft SQL Server SQLite ã«å¯¾å¿œã—ã¦ãŠã‚Šã€è‰¯ãä½¿ã‚ã‚Œã‚‹RDBã‚’ã»ã¼ã‚«ãƒãƒ¼ã—ã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«Â¶ goã®ãƒ„ãƒ¼ãƒ«ã§ã™ã®ã§ã€ go get ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã¾ã™ã€‚ $ go get -u golang.org/x/tools/cmd/goimports (ä¾å˜æ€§ã®ãŸã‚) $ go get -u github.com/knq/xo
shin0O 2017/04/14
golang

db
ãƒªãƒ³ã‚¯
ã€CEDEC 2016 ãƒ•ã‚©ãƒãƒ¼ã‚¢ãƒƒãƒ—ã€‘ç§’é–“100ä¸‡ã‚¯ã‚¨ãƒªã‚’å—ã‘ä»˜ã‘ã‚‹å¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰DBã‚·ã‚¹ãƒ†ãƒ ã®è¨è¨ˆãƒ»é‹ç”¨ãƒŽã‚¦ãƒã‚¦
shin0O 2016/11/10
db
ãƒªãƒ³ã‚¯
è‹¥æ‰‹ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼å¿…èªï¼ï¼•åˆ†ã§ç†è§£ã§ãã‚‹ERå›³ã®æ›¸ãæ–¹ï¼•ã‚¹ãƒ†ãƒƒãƒ—
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ERå›³ã€‚ERå›³ã‚’æ›¸ããŸã„ã‘ã©ã€ã€Œè¨˜æ³•ãŒåˆ†ã‹ã‚‰ãªã„ã€ã€Œã©ã†ã„ã†ã‚¹ãƒ†ãƒƒãƒ—ã§æ›¸ã‘ã°è‰¯ã„ã‹åˆ†ã‹ã‚‰ãªã„ã€ã¨ã„ã†è‹¥æ‰‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚‚å¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ERå›³ã¯ï¼‘ï¼ç¨®é¡žè¿‘ãã‚ã‚Šã€ç¨®é¡žã«ã‚ˆã£ã¦è¨˜æ³•ãŒç•°ãªã‚Šã¾ã™ã€‚ã“ã®ã“ã¨ãŒé›£ã—ã„ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ä¸Žãˆã¦ã„ã¾ã™ãŒã€å®Ÿã¯ãã‚Œã»ã©é›£ã—ã„ã‚‚ã®ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚è¦šãˆã‚Œã°è‰¯ã„ERå›³ã¯ï¼’ç¨®é¡žã ã‘ã§ã™ã€‚ ã—ã‹ã‚‚ã€ã“ã®è¨˜äº‹ã§è§£èª¬ã—ã¦ã„ã‚‹åŸºç¤ŽçŸ¥è˜ã‚’æŠ¼ãˆã‚Œã°ã€ãŸã£ãŸï¼•ã¤ã®ã‚¹ãƒ†ãƒƒãƒ—ã§ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ERå›³ã®åŸºç¤ŽçŸ¥è˜ã‹ã‚‰ERå›³ã®æ›¸ãæ–¹ã¾ã§ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæŠ‘ãˆã¦ãŠãã¹ãERå›³ã®å…¨çŸ¥è˜ã‚’ã©ã“ã‚ˆã‚Šã‚‚åˆ†ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã‚’èªã¿çµ‚ãˆãŸã¨ãã€è‹¥æ‰‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚‚ERå›³ã‚’æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ ã“ã®è¨˜äº‹ã‚’å‚è€ƒã«æœ€é©ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã‚’é€²ã‚ã¦ä¸‹ã•ã„ã€‚ ï¼‘ï¼ŽERå›³ã¨ã¯ ERå›³ã¨ã¯ã€ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ï¼‰ã§ä½¿ã†è¨è¨ˆ
shin0O 2016/10/04
ERå›³ã£ã¦ãƒ„ãƒ¼ãƒ«ãªã„ã—ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰è‡ªå‹•ç”Ÿæˆã•ã›ã‚‹ã»ã†ãŒæ¥½ã£ã½ã„/ ä»Šã¾ã§ã‚„ã£ã¦ããŸã¨ã“ã¯ãˆãã›ã‚‹ã«ã‚ˆã‚‹ä½œå›³ãªã®ã§ã‚³ãƒã‚¯ã‚¿é¡žãŒé©å½“ã ã£ãŸã®ã§å‚è€ƒã«

DB
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ å¹»ã®ç¬¬26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ 26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€ 2015/08/31 @ GMO Yours #ronsakucasual https://atnd.org/events/68902Read less
shin0O 2016/06/29
slideshare

db
ãƒªãƒ³ã‚¯
ãƒ›ãƒ³ãƒˆä¿¡ã˜ã‚‰ã‚Œãªã„DBæ–‡åŒ–ã ã‘ã©ã€çµ±è¨ˆæƒ…å ±å›ºå®šåŒ–ã¯ãƒžã‚¸ã§ã‚¢ãƒª - ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ã‚¿ãƒ¼å±±æœ¬å¤§ã®ãƒ–ãƒã‚°
ä¿¡ã˜ã‚‰ã‚Œãªã„DB æ–‡åŒ–ã€Œå›ºå®šé•·DBã€ã§ã‚‚ã‚ã†ã‚“ã§ã™ã€‚å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBè¨è¨ˆ - å±±æœ¬å¤§ã®æ—¥è¨˜ã«å¼•ãç¶šãã€å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBã®æ„å¤–ãªä½¿ã„æ–¹ã«ã¤ã„ã¦ã€‚ åƒ•ã‚‰ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ã€çµ±è¨ˆæƒ…å ±ã‚’æ‰‹ä½œæ¥ã§ã‚»ãƒƒãƒˆã—ã¦å›ºå®šåŒ–ã—ã¦ã„ãŸã€‚ ã“ã‚“ãªã“ã¨ã¯æ™®é€šã‚„ã‚‰ãªã„ã‘ã‚Œã©ã€ã—ã‹ã—ãªãŒã‚‰éžå¸¸ã«ã‚·ã‚¹ãƒ†ãƒ ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å®‰å®šã•ã›ã‚‹ã®ã«åŠ¹æžœãŒã‚ã£ãŸã€‚ Oracleã®çµ±è¨ˆæƒ…å ±ï¼ˆã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶çµ±è¨ˆæƒ…å ±ï¼‰ã¨ã¯ ã¾ãšçµ±è¨ˆæƒ…å ±ã¨ã¯ä½•ã‹ã¨ã„ã†ã¨ã“ã‚ã‹ã‚‰å§‹ã‚ã‚‹ã€‚ çµ±è¨ˆæƒ…å ±ã¨ã¯ã€æ£å¼åç§°ã€Œã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶çµ±è¨ˆæƒ…å ±ã€ã¨ã„ã„ã€OracleãŒSQLã‚’è§£æžã—ã¦æœ€é©ãªå®Ÿè¡Œè¨ˆç”»ã‚’ä½œæˆã™ã‚‹ãŸã‚ã«åˆ©ç”¨ã™ã‚‹æƒ…å ±ã§ã‚ã‚‹ã€‚ å®Ÿè¡Œè¨ˆç”»ã‚’ä½œæˆã™ã‚‹æ©Ÿèƒ½ã®ã“ã¨ã‚’CBOï¼ˆã‚³ã‚¹ãƒˆãƒ»ãƒ™ãƒ¼ã‚¹ãƒ»ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ï¼‰ã¨ã„ã†ã€ã“ã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶å‘ã‘ã®çµ±è¨ˆçš„ãªæƒ…å ±ã ã‹ã‚‰ã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶çµ±è¨ˆæƒ…å ±ã¨å‘¼ã°ã‚Œã‚‹ã€‚ çµ±è¨ˆæƒ…å ±ã®å®Ÿä½“ã¯ä½•ã‹ã¨ã„ã†ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å„
shin0O 2015/06/19
db

performance

oracle
ãƒªãƒ³ã‚¯
æ¥½å¤©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæŒ‘ã‚€ã€ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã®åˆ†æžãƒ»æ´»ç”¨ã¨ã¯ï½œã€Techç·ç ”ã€‘
æ¥½å¤©å¸‚å ´ã®å•†å“æ•°ã¯ç´„8800ä¸‡ã€‚ä¼šå“¡æ•°7000ä¸‡äººè¶…ãŒã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã¯ãƒ”ãƒ¼ã‚¯æ™‚ã«20Gbpsã‚’è¶…ãˆã‚‹ã€‚åŒç¤¾ã¯ã€ã“ã®ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã‚’ã©ã®ã‚ˆã†ã«è§£æžã—ã€æ´»ç”¨ã—ã¦ã„ã‚‹ã®ã‹ã€‚æœ€å‰ç·šã§æ´»èºã™ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«èžã„ãŸã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ã¯ã€Eã‚³ãƒžãƒ¼ã‚¹ã‚’é‹å–¶ã™ã‚‹äº‹æ¥è€…ã«ã€è²´é‡ãªæƒ…å ±ã‚’ã‚‚ãŸã‚‰ã™ã€‚ã©ã®ã‚ˆã†ãªç”»é¢é·ç§»ã§è³¼å…¥ãƒšãƒ¼ã‚¸ã«ãŸã©ã‚Šç€ãã€ä½•ã‚’è³¼å…¥ã—ãŸã‹ã€‚ãã®è¡Œå‹•åˆ†æžã¨è²©å£²ãƒ‡ãƒ¼ã‚¿ã«ã¯ã€æ–°ãŸãªãƒ“ã‚¸ãƒã‚¹ãƒãƒ£ãƒ³ã‚¹ã¨ãªã‚‹å®ã®å±±ãŒã‚ã‚‹ã‹ã‚‰ã§ã‚ã‚‹ã€‚ ä¸€ä¾‹ã‚’æŒ™ã’ã‚Œã°ã€Webã‚µãƒ¼ãƒ“ã‚¹ã®å ´åˆã€ã‚ˆã‚Šãƒ¦ãƒ¼ã‚¶ãƒ¼ã®å¿ƒã«éŸ¿ããƒ¬ã‚³ãƒ¡ãƒ³ãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã®æä¾›ã«ã¤ãªãŒã‚Šã€è¡¨ç¤ºã•ã‚Œã‚‹ç”»é¢ã®ãƒ‘ãƒ¼ã‚½ãƒŠãƒ©ã‚¤ã‚¼ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å¯èƒ½ã«ã™ã‚‹ã€‚ä»–ã«ã‚‚ã€ã‚µãƒ¼ãƒ“ã‚¹ã®å“è³ªã‚’å¤§ããå‘ä¸Šã•ã›ã‚‹æ§˜ã€…ãªãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ã®æ´»ç”¨ãŒå¯èƒ½ã ã€‚ã“ã®ã‚ˆã†ã«ã€å¤šæ§˜ãªä¾¡å€¤ãŒæ½œã‚€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®å¤§é‡ã®ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ã¯ã€äº‹æ¥è€…ã‹ã‚‰è¦‹ã‚Œã°ã¾ã•ã«å®ã®å±±ã¨è¨€ãˆã‚‹ã ã‚ã†ã€‚ ãƒ”ãƒ¼ã‚¯ã‚¿ã‚¤ãƒ ã«ã¯1åˆ†
shin0O 2012/02/11
interview

web

db
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒç®¡ç†è€…æ—¥èªŒ ã‚·ãƒªãƒ¼ã‚ºãƒ»ã‚¯ãƒãƒ¼ãƒ«ã¨DoSã®é•ã„ã¨æ¥å‹™å¦¨å®³ç½ªã¨(5) - ãã®å¾Œã®å¿µåŠ›ãƒ‡ãƒãƒƒã‚°
å¤šãã®æ–¹ã®å°½åŠ›ã«ã‚ˆã£ã¦ã€å°‘ã—ãšã¤è‰²ã€…ãªæƒ…å ±ãŒæ˜Žã‚‰ã‹ã«ãªã£ã¦ã€å½“ã¦æŽ¨é‡ã§ã€Œã§ã¯ãªã„ã‹ã€ã¨æ›¸ã„ã¦ã„ãŸéƒ¨åˆ†ã‚’å¤–ã›ãã†ãªã¨ã“ã‚ã‚‚å‡ºã¦ããŸã—ã€é€†ã«ã€ã“ã‚Œã¯é–“é•ã£ã¦ã„ãŸã¨ã„ã†éƒ¨åˆ†ã‚‚å‡ºã¦ããŸã€‚ æœ€è¿‘ã§ã¯ã€ä¸€éƒ¨ã§ã¯èªžæ„ŸãŒå¥½è©•ã ã£ãŸ å¿µåŠ›ãƒ‡ãƒãƒƒã‚°[http://www.nantoka.com/~kei/diary/?20100714S1#T201007141S3] ã®ãƒ‡ãƒãƒƒã‚°ã‹ã‚‰ã€‚ æƒ…å ±ãŒå°‘ãªã„ã‹ã‚‰ã“ãã€ä¸€æ¬¡æƒ…å ±ã¯è²´é‡ã§ã€ã‚ˆã‚Šæ£ã—ã„ã¨æ€ã‚ã‚Œã‚‹æƒ…å ±ã‚’é›†ã‚ã‚‹ã¨ã“ã‚ã‹ã‚‰å§‹ã‚ã‚‹ã®ãŒã€å¿µåŠ›ãƒ‡ãƒãƒƒã‚°ã®é‰„å‰‡ãªã®ã«ã€ãã®éƒ¨åˆ†ã§æ‰‹ã‚’æŠœã„ãŸç½°ãŒå½“ãŸã£ãŸã€‚ DBæŽ¥ç¶šã‚’Cookieã«åŸºã¥ãã‚»ãƒƒã‚·ãƒ§ãƒ³ã«ã‚ˆã£ã¦ç®¡ç†ã™ã‚‹ä½œã‚Šã«ãªã£ã¦ã„ã‚‹ã€‚ Cookieã‚’é£Ÿã‚ãªã„ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å—ã‘ã‚‹ã¨ã€ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«DBæŽ¥ç¶šãŒç”Ÿæˆã•ã‚Œã‚‹ã€‚ DBæŽ¥ç¶šã‚’å«ã‚ãŸã‚µãƒ¼ãƒãƒªã‚½ãƒ¼ã‚¹ã¯ã€ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã«ã‚ˆã£ã¦ã‚»ãƒƒã‚·ãƒ§ãƒ³ãŒç ´æ£„ã•ã‚Œã‚‹ã¾ã§è§£æ”¾ã•ã‚Œãšã€ç¢ºä¿ã•ã‚ŒãŸ
shin0O 2010/08/22
å¿µåŠ›ãƒ‡ãƒãƒƒã‚°ã¨ã„ã†ã®ã¯èªžæ„ŸãŒã‚ˆã™ãŽã‚‹

db

web

security
ãƒªãƒ³ã‚¯
MySQLã§ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ã®ãªã„ALTER TABLEã®æ¤œè¨Ž - SH2ã®æ—¥è¨˜
MySQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚«ãƒ©ãƒ è¿½åŠ ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†ç·¨æˆãªã©ã‚’è¡Œã†ã¨ã€ãã®é–“ãƒ†ãƒ¼ãƒ–ãƒ«ã«å…±æœ‰ãƒãƒƒã‚¯ãŒã‹ã‹ã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãã®ãŸã‚ã“ã‚Œã‚‰ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å‡¦ç†ã¯ã€é€šå¸¸åˆ©ç”¨è€…ã®å°‘ãªã„æ·±å¤œæ—©æœå¸¯ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¢ã‚ã¦å®Ÿæ–½ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚æœ¬æ—¥ã¯ãã‚Œã‚’ç„¡åœæ¢ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®ã¾ã¾ã§ã§ããªã„ã‹ã¨ã„ã†è©±é¡Œã§ã™ã€‚ åŸºæœ¬çš„ãªã‚¢ã‚¤ãƒ‡ã‚¢ ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å¯¾è±¡ã®å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€ä½œæ¥ç”¨ã®ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Šã¾ã™ ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€ã‚«ãƒ©ãƒ è¿½åŠ ãªã©ã®å¤‰æ›´ã‚’åŠ ãˆã¾ã™ ãã®é–“ã€å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦è¡Œã‚ã‚Œã‚‹æ›´æ–°å‡¦ç†ã«ã¤ã„ã¦å·®åˆ†ã‚’è¨˜éŒ²ã—ã¦ãŠãã¾ã™ ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã®å¤‰æ›´ãŒçµ‚ã‚ã£ãŸã‚‰ã€è¨˜éŒ²ã—ã¦ãŠã„ãŸå·®åˆ†ãƒ‡ãƒ¼ã‚¿ã‚’ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã«åæ˜ ã—ã¾ã™ å·®åˆ†ãƒ‡ãƒ¼ã‚¿ã®åæ˜ ãŒçµ‚ã‚ã£ãŸã‚‰ã€å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã¨ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…¥ã‚Œæ›¿ãˆã¾ã™ ã“ã‚Œã¨ä¼¼ãŸã‚ˆã†ãªã“ã¨ã‚’è€ƒãˆãŸæ–¹ã¯çµæ§‹ã„ã‚‰ã£ã—ã‚ƒã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãŸã ã€è¨€ã†ã¯æ˜“ã—ã€è¡Œã†ã¯é›£ã—ã§ã™ã€‚æ•´åˆæ€§ãŒãã¡ã‚“ã¨å–ã‚Œã‚‹ã‹ã©ã†
shin0O 2010/07/04
web

MySQL

db
ãƒªãƒ³ã‚¯
MySQL ã‚’ä½¿ã£ãŸãŠæ‰‹è»½ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼å®Ÿè£… - ãƒ‰ãƒ¯ãƒ³ã‚´ ç ”ç©¶é–‹ç™ºãƒ–ãƒã‚°
ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã§ã¯ã€MySQL ã‚’ä½¿ã£ã¦ç°¡å˜ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã‚’æ‰‹è»½ã«å®Ÿè£…ã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¨ã¯ã€ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’ä¸€æ™‚çš„ã«æºœã‚ã¦ãŠãã€é †æ¬¡å‡¦ç†ã™ã‚‹ãŸã‚ã®ä»•çµ„ã¿ã§ã™ã€‚è¿…é€Ÿãªãƒ¬ã‚¹ãƒãƒ³ã‚¹ãŒå¿…è¦ãª Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦ã€æ™‚é–“ã®ã‹ã‹ã‚‹å‡¦ç†ã‚’éžåŒæœŸã«è¡Œã†ãŸã‚ã«ã€ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ã§é †æ¬¡å‡¦ç†ã—ã¦ã„ãã‚ˆã†ãªå ´åˆã«åˆ©ç”¨ã§ãã¾ã™ã€‚ ç°¡å˜ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¨è¨€ã£ã¦ã‚‚ã€å¤§è¦æ¨¡ãªé‹ç”¨ã«ã‚‚è€ãˆã‚‰ã‚Œã‚‹ç¨‹åº¦ã®é€Ÿåº¦ã¨å …ç‰¢æ€§ã‚’æŒã¡ã¾ã™ã€‚ ã¾ãŸã€ã“ã“ã§è§£èª¬ã—ã¦ã„ã‚‹æ–¹æ³•ã§ä½œã‚‰ã‚ŒãŸãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¯ã€å¼Šç¤¾ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ãƒ‹ã‚³ãƒ‹ã‚³å‹•ç”»ã«æœ€è¿‘è¿½åŠ ã•ã‚ŒãŸtwitteré€£æºæ©Ÿèƒ½ã§ã‚‚åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã‚’ä½œã‚‹ã«ã‚ãŸã£ã¦ ä»Šå›žå®Ÿè£…ã™ã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¯ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®è¿½åŠ (push)ã‚’é«˜é€Ÿã«è¡Œã†äº‹ãŒã§ãã‚‹ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®å–å¾—(pop)ã¯ã‚ã‚‹ç¨‹åº¦é«˜é€Ÿã«è¡Œã†äº‹ãŒã§ãã‚‹ å¤šãã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰åŒæ™‚ã« p
shin0O 2010/01/26
programming

development

db

queue

niconico
ãƒªãƒ³ã‚¯
1