[B! ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] skozawaã®ãƒ

skozawa id:skozawa

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹skozawaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

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

NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼šèª¿æŸ»ã¨æ±ºå®šã®ã‚¬ã‚¤ãƒ€ãƒ³ã‚¹ï¼ˆãã®1ï¼‰ | POSTD
(è¨³æ³¨ï¼š2016/10/1ã€é ‚ãã¾ã—ãŸãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚’å…ƒã«è¨˜äº‹ã‚’ä¿®æ£ã„ãŸã—ã¾ã—ãŸã€‚) å…ˆæœˆã€ãƒãƒ³ãƒ–ãƒ«ã‚¯å¤§å¦ã®åŒåƒšãŸã¡ã¨ä¸€ç·’ã« SummerSOC 2016 ã§NoSQLã®çŠ¶æ³ã«ã¤ã„ã¦ã®è¬›æ¼”ã‚’ã—ã¾ã—ãŸã€‚ãƒ¡ãƒ³ãƒãƒ¼ã¯ã€ Felix Gessert ã€ Wolfram Wingerath ã€ Steffen Friedrich ã€ Norbert Ritter ã§ã—ãŸã€‚ä»Šå›žã¯ãã®è¬›æ¼”ã®è¦ç‚¹ã‚’è¨˜äº‹ã«ã¾ã¨ã‚ã¾ã—ãŸã€‚ Baqend ã‚’è¨ç«‹ã—ã¦é›†ã‚ãŸã€ç§ãŸã¡ã®NoSQLã®æ¿ƒåŽšãªçŸ¥è˜ãŒçš†ã•ã‚“ã«ä¼ã‚ã‚Œã°å¹¸ã„ã§ã™ã€‚ è¦ç´„ ç¾åœ¨ã€ãƒ‡ãƒ¼ã‚¿ã¯ã‹ã¤ã¦ãªã„è¦æ¨¡ã§ç”Ÿã¿å‡ºã•ã‚Œã€æ¶ˆè²»ã•ã‚Œã¦ã„ã¾ã™ã€‚å¢—ãˆç¶šã‘ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã¨ãƒªã‚¯ã‚¨ã‚¹ãƒˆè² è·ã«å¯¾å¿œã™ã‚‹ãŸã‚ã«ã€ã€ŒNoSQLã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã¨ã„ã†ç”¨èªžã§åŒ…æ‹¬ã•ã‚Œã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã®æ–°ã—ã„æ–¹æ³•ãŒç”£ã¿å‡ºã•ã‚Œã¦ãã¾ã—ãŸã€‚ã—ã‹ã—ã€æ•°å¤šãå˜åœ¨ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã¯ã€ä¸å‡ä¸€ã§å¤šæ§˜æ€§ãŒã‚ã‚‹ã®ã§
skozawa 2016/09/11
nosql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã€ãƒ¡ãƒ¢ã€‘å‹‰å¼·ã‚„ç ”ç©¶ã«ä½¿ãˆã‚‹æ¤œç´¢ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - æ¾å®®æ…Žæ²»ã®æ†‚é¬±
ãƒ»å›½ç«‹æƒ…å ±å¦ç ”ç©¶æ‰€ã€ŒCiNii Articlesã€ï¼ˆå¦å”ä¼šåˆŠè¡Œç‰©ãƒ»å¤§å¦ç ”ç©¶ç´€è¦ãƒ»å›½ç«‹å›½ä¼šå›³æ›¸é¤¨ã®é›‘èªŒè¨˜äº‹ç´¢å¼•ãªã©ã®å¦è¡“è«–æ–‡æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ã€€http://ci.nii.ac.jp/ ãƒ»ç¬¬ä¸€æ³•è¦æ ªå¼ä¼šç¤¾ã€€ã€ŒD1-Lawã€ï¼ˆæ³•æƒ…å ±ç·åˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ã€€https://www.d1-law.com/ ãƒ»ProQuestç¤¾ã€ŒProQuestã€ï¼ˆæµ·å¤–ã®è«–æ–‡ãƒ»æ–°èžãªã©ã®å¦è¡“æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ã€€http://www.proquest.com/ ãƒ»å›½ç«‹æƒ…å ±å¦ç ”ç©¶æ‰€ã€ŒCiNii Booksã€ï¼ˆå…¨å›½ã®å¤§å¦å›³æ›¸é¤¨ç‰ãŒæ‰€è”µã™ã‚‹æœ¬ï¼ˆå›³æ›¸ãƒ»é›‘èªŒï¼‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ã€€http://ci.nii.ac.jp/books/ ãƒ»å›½ç«‹æƒ…å ±å¦ç ”ç©¶æ‰€ã€ŒWebCat Plusã€ï¼ˆæ±Ÿæˆ¸æœŸå‰ã‹ã‚‰ç¾ä»£ã¾ã§ã«å‡ºç‰ˆã•ã‚ŒãŸæœ¬ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ã€€http://webcatplus.nii.ac.jp/ â†’é€£æƒ³æ¤œç´¢ãŒä¾¿åˆ© ãƒ»ç·å‹™çœçµ±è¨ˆå±€ã€Œæ”¿åºœçµ±è¨ˆã®ç·åˆ
skozawa 2016/04/23
ç ”ç©¶

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Webã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£æ¦‚è«– - ã‚†ã†ã†ããƒ–ãƒã‚°
å…ˆæœˆæŠ•ç¨¿ã—ãŸ2015å¹´Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åºè«–ã§ã¯ã€Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å¦ã¶é“ã®ã‚Šã¨ä»£è¡¨çš„ãªå®Ÿè£…ãƒ¢ãƒ‡ãƒ«ã®æ¦‚è¦ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ã€å‰å›žåŒæ§˜ã€ä¸»ã«æ–°å’Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒé–“ã®æŽ¥ç¶šç®¡ç†ãƒ¢ãƒ‡ãƒ«ã¨é‹ç”¨äº‹æƒ…ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–ã‚„ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ã¯ä½•ãªã®ã‹ã€ãªãœå¿…è¦ãªã®ã‹ã¨ã„ã£ãŸã“ã¨ãŒä¸»ãªè©±é¡Œã§ã™ã€‚ èƒŒæ™¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–ã¨ã¯ãªã«ã‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®ã‚ªãƒ¼ãƒãƒ˜ãƒƒãƒ‰ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–æ‰‹æ³• ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ã¯ãªã«ã‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°: ãƒ‰ãƒ©ã‚¤ãƒåž‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°: ãƒ—ãƒã‚ã‚·åž‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°å…¨ä½“ã«ã¤ã„ã¦ PostgreSQLã¨MySQL å‚è€ƒè³‡æ–™ ã¾ã¨ã‚ èƒŒæ™¯ 2015å¹´Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åºè«–ã§ã¯ã€Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®è©±ã¨Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§
skozawa 2015/06/30
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
ãƒªãƒ³ã‚¯
ã‚·ãƒ³ãƒ—ãƒ«ã§ç§»è¡Œã—ã‚„ã™ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚° - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
æŠ€è¡“éƒ¨ã®å°é‡Ž(taiki45)ã§ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯ã“ã‚Œã¾ã§æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è² è·å¯¾ç–ã‚’è¡Œã£ã¦ãã¾ã—ãŸãŒã€ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¯è¡Œã‚ã‚Œã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ã—ã‹ã—å…ˆæ—¥ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®èªå¯ã‚µãƒ¼ãƒãƒ¼ãŒåˆ©ç”¨ã—ã¦ã„ã‚‹ MySQL ã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£ã®ãŸã‚ã«ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§åˆã‚ã¦ã®ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’è¡Œã£ãŸã®ã§ã€Rails ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã®ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®äº‹ä¾‹ã®ã²ã¨ã¤ã¨ã—ã¦ãã®éš›ã®æ‰‹æ³•ã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨ãŠã‚‚ã„ã¾ã™ã€‚ æ§‹æˆ Before ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯1ãƒžã‚¹ã‚¿ãƒ¼ã€1ãƒ›ãƒƒãƒˆã‚¹ã‚¿ãƒ³ãƒã‚¤ã€ãƒãƒƒãƒç”¨ã®1ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ã§æ§‹æˆã•ã‚Œã¦ã„ã¾ã™ã€‚Read ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®ã»ã¨ã‚“ã©ã¯ã‚ãƒ£ãƒƒã‚·ãƒ¥å±¤ã«é€ƒã—ã¦ã„ã¾ã™ã€‚ After ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å„ãƒãƒ¼ãƒ«ã«ã¤ããã‚Œãžã‚Œ1å°ãšã¤ãƒžã‚·ãƒ³ãŒå¢—ãˆã¦ã„ã¾ã™ã€‚ ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒå¿…è¦ã«ãªã£ãŸèƒŒæ™¯ èªå¯ã‚µãƒ¼ãƒãƒ¼ã®ã‚¢ã‚¯ã‚»ã‚¹ãƒˆãƒ¼ã‚¯ãƒ³ã®ä½œæˆãƒ»å‰Šé™¤æ™‚ã® Write ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒæ€¥å¢—ã—ã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°è‡ªä½“ã‚‚æ€¥å¢—ã—ã¦ã„ã¦
skozawa 2015/06/23
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

cookpad
ãƒªãƒ³ã‚¯
SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ£ã—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚‹ã®ã¯ èª°ã®å½¹å‰²ï¼Ÿ
SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã¯ã€SQLãã®ã‚‚ã®ã¨åŒã˜ãã‚‰ã„ã®æ´å²ãŒã‚ã‚‹â€•â€• ã‚ã‚‹äººã¯ã€SQLã¯ãã‚‚ãã‚‚é…ã„ã‚‚ã®ã ã¨ã™ã‚‰è¨€ã†ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã€SQLã®æ´å²ãŒå§‹ã¾ã£ãŸé ƒã¯æ£ã—ã‹ã£ãŸã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ä»Šã¨ãªã£ã¦ã¯å…¨ã å½“ã¦ã¯ã¾ã‚‰ãªã„ã§ã—ã‚‡ã†ã€‚ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã¯ä»Šã‚‚ä¸€èˆ¬çš„ã§ã‚ˆãã‚ã‚‹ã“ã¨ã§ã™ã€‚ã©ã†ã—ã¦ãã†ãªã£ã¦ã—ã¾ã†ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ SQLè¨€èªžã¯ã€æã‚‰ãæœ€ã‚‚æˆåŠŸã—ãŸç¬¬4ä¸–ä»£è¨€èªž(4GL)ã§ã—ã‚‡ã†ã€‚ãã®æœ€å¤§ã®åˆ©ç‚¹ã¯ã€ã€Œä½•ã‚’ã€ã¨ã€Œã©ã®ã‚ˆã†ã«ã€ ã‚’åˆ†é›¢ã§ãã‚‹ã“ã¨ã§ã™ã€‚SQLæ–‡ã¯ã€ã©ã®ã‚ˆã†ã«ãã‚Œã‚’å®Ÿè¡Œã™ã‚‹ã‹ã‚’è¨˜è¿°ã›ãšã«ã€å˜ç´”ã« ä½•ã‚’å¿…è¦ã¨ã—ã¦ã„ã‚‹ã‹ã®ã¿ã®è¨˜è¿°ã«ãªã£ã¦ã„ã¾ã™ã€‚ä»¥ä¸‹ã®ã‚ˆã†ãªä¾‹ã‚’è€ƒãˆã¦ã¿ã¾ã—ã‚‡ã†ã€‚ SELECT date_of_birth FROM employees WHERE last_name = 'WINAND'SQLã®ã‚¯ã‚¨ãƒªã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’è¦æ±‚ã™ã‚‹è‹±èªžã®æ–‡ã¨ã—ã¦èª
skozawa 2014/10/19
SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹
ãƒªãƒ³ã‚¯
PPDB:Japanese - æ—¥æœ¬èªžè¨€ã„æ›ãˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
The Paraphrase Database : Japaneseã¯æ—¥è‹±å¯¾è¨³ã‚³ãƒ¼ãƒ‘ã‚¹ã‹ã‚‰å¦ç¿’ã•ã‚ŒãŸæ—¥æœ¬èªžã®è¨€ã„æ›ãˆãƒ‡ãƒ¼ã‚¿é›†ã§ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ æœ€æ–°ç‰ˆï¼šPPDB:Japanese 0.0.1 ä»•æ§˜æƒ…å ± ä¸€è¡Œã«ã¤ãä¸€ã¤ã®è¨€ã„æ›ãˆã‚’ç¤ºã™ã€‚ SOURCE:j ||| TARGET:j' ||| (FEATURE=VALUE)* ||| ALIGNMENT ãƒ•ãƒ¬ãƒ¼ã‚ºã¯å½¢æ…‹ç´ ã”ã¨ã«åŠè§’ã‚¹ãƒšãƒ¼ã‚¹ã§åŒºåˆ‡ã‚‰ã‚Œã€ã¾ãŸè¨€ã„æ›ãˆç¢ºçŽ‡ã‚‚ãã‚Œãžã‚ŒP(j'|j)ã¨P(j|j')ãŒåŠè§’ã‚¹ãƒšãƒ¼ã‚¹åŒºåˆ‡ã‚Šã§ä¸Žãˆã‚‰ã‚Œã¾ã™ã€‚ ç¿»è¨³ ã• ã‚Œ ãŸ ||| ç¿»è¨³ ||| 0.0125435775455 0.00034585476357 ||| 37435 2 56 è«–æ–‡æƒ…å ± ä»¥ä¸‹ã®æƒ…å ±ã‚’ã”åˆ©ç”¨ãã ã•ã„ã€‚ æ°´ä¸Š é›…åšï¼ŒGraham Neubigï¼ŒSakriani Saktiï¼Œæˆ¸ç”° æ™ºåŸºï¼Œä¸æ‘ å“². æ—¥æœ¬èªžè¨€ã„æ›ãˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹ç¯‰ã¨
skozawa 2014/02/04
è‡ªç„¶è¨€èªžå‡¦ç†

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã‚³ãƒ¼ãƒ‘ã‚¹
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ã®ç¾…é‡ç›¤
PostgreSQLã®ãƒãƒ¼ãƒ«ç®¡ç†ã¨ãã®æ³¨æ„ç‚¹ï¼ˆOpen Source Conference 2022 Online/Osaka ç™ºè¡¨è³‡æ–™ï¼‰NTT DATA Techno logy & Innovation
skozawa 2013/11/17
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

æŠ€è¡“
ãƒªãƒ³ã‚¯
ã“ã‚Œã ã‘ã¯è¦šãˆã¦ãŠããŸã„!!MySQL ã®ï¼–ã¤ã®è‡ªå‹•å¤‰æ› - sakaikã®æ—¥ã€…é›‘æ„Ÿï½ž(T)ç·¨
MySQLã¯ã¨ã¦ã‚‚æ°—ãƒã¤ã‹ã„å±‹ã•ã‚“ã§ã‚ã‚‹ã€‚æˆ‘ã€…ãŒæŠ•ã’ã‚‹å¤šå°‘ã‚ã„ã¾ã„ãªæŒ‡ç¤ºã‚‚é ‘å¼µã£ã¦è§£é‡ˆã—ã€ãªã‚“ã¨ã‹æ–‡å¥ã‚’è¨€ã‚ãšã«å®Ÿè¡Œã—ã¦ã¿ã‚ˆã†ã¨æŒ‘æˆ¦ã—ã¦ã¿ã¦ãã‚Œã‚‹ã€‚ ä»Šæ—¥ã¯ãã‚“ãªMySQLãŒã‚±ãƒŠã‚²ã«è§£é‡ˆã—ã¦ãã‚Œã‚‹è‡ªå‹•å¤‰æ›ã«ã¤ã„ã¦ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã†ã€‚ã“ã®è‡ªå‹•å¤‰æ›ã€ã‚±ãƒŠã‚²ãªMySQLã®å¥¥ã‚†ã‹ã—ã•æ•…ã€å‡ºã—ãŸæŒ‡ç¤ºã¨ç•°ãªã‚‹å‹•ä½œã‚’ã•ã‚ŒãŸã“ã¨ã«æ°—ãŒã¤ã‹ãªã„ã“ã¨ãŒã‚ã‚‹ã€‚ã“ã“ã§ç´¹ä»‹ã™ã‚‹ï¼–ã¤ã®è‡ªå‹•å¤‰æ›ã‚’ã—ã£ã‹ã‚Šè„³ãƒŸã‚½ã«ãŸãŸãè¾¼ã‚“ã§ãŠã‘ã°ã€ç„¡ç”¨ãªãƒˆãƒ©ãƒ–ãƒ«ã«ãƒãƒžã‚‹æ™‚é–“ã‚‚æ¸›ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã€‚ ï¼‘ï¼Ž[æ•°å€¤] ç¯„å›²å¤–ã®æ•°å€¤ã¯é ã‚’æŠ¼ã•ãˆã¤ã‘ã‚‰ã‚Œã‚‹ intã‚„smallintã€bigintãªã©ã®æ•°å€¤åž‹ã«ã¯ã€æ‰±ãˆã‚‹ç¯„å›²ãŒæ±ºã¾ã£ã¦ã„ã‚‹ã€‚ä¾‹ãˆã°intåž‹ãªã‚‰æœ€å¤§21å„„ã¡ã‚‡ã£ã¨ã ï¼ˆunsignedã®å ´åˆã¯43å„„å¼±ï¼‰ã€‚ã“ã‚Œã‚ˆã‚Šå¤§ãã„æ•°å—ã‚’ç™»éŒ²ã™ã‚‹ã‚ˆã†æŒ‡ç¤ºã‚’å‡ºã™ã¨MySQLã¯ã©ã†ã™ã‚‹ã‹ã€‚ãã†ã€é ‘å¼µã£ã¦å…¥ã‚Œã‚‰ã‚Œã‚‹ã¨ã“ã‚ã¾ã§å…¥ã‚Œã¦ãã‚Œã‚‹ã®ã§ã‚ã‚‹ã€‚ã€Œå…¥ã‚Œã‚‰ã‚Œã‚‹ã¨ã“
skozawa 2013/07/18
MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MongoDBãŒé©ã•ãªã„ã‚±ãƒ¼ã‚¹ - ä¸å¹´engineerã®ç‹¬ã‚Šè¨€ - crumbjp
> åŽŸæ–‡(Why Mongo DB is a bad choice for storing our scraped data) ç§è‡ªèº«ã¯Mongo DBã‚’æŽ¨é€²ã™ã‚‹ç«‹å ´ãªã®ã ãŒã€ç¢ºã‹ã«Mongo DBã«é©ã•ãªã„ã‚±ãƒ¼ã‚¹ã¯ã‚ã‚‹ã€‚ é—‡é›²ã«æŽ¨é€²ã—ã¦ã‚‚çµå±€ã¯å…¨å“¡ãŒã‚¢ãƒ³ãƒãƒƒãƒ”ãƒ¼ã«ãªã‚‹ã®ã§ã€ã“ã®æ§˜ãªãƒã‚¿ã‚‚ã©ã‚“ã©ã‚“ç´¹ä»‹ã—ã¦ã„ã“ã†ã¨æ€ã†ã€‚ ã“ã®è¨˜äº‹ã¯Mongo DBã‚’å¾¹åº•çš„ã«ä½¿ã„å°½ãã—ãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæ›¸ã„ã¦ã„ã‚‹æ§˜ã§çŠ¶æ³ãŒè‰¯ãè§£ã£ãŸã€‚ ã¡ã‚‡ã£ã¨é›£ã—ã„æ‰€ã‚‚ã‚ã‚‹ã®ã§è¦ç‚¹ã‚’æ„è¨³ã—ã¦ã€è»½ãè§£èª¬ã‚’æ›¸ã„ã¦ã¿ã‚‹ã€‚ ï¼ˆã‚‚ã¡ã‚ã‚“æ˜¯éžåŽŸæ–‡ã§èªã‚€ã®ã‚’ãŠå‹§ã‚ã™ã‚‹ï¼‰ çŠ¶æ³ æœ€åˆã¯Mongo DBã§ã†ã¾ãå‹•ã„ã¦ã„ãŸãŒã€ã ã‚“ã ã‚“è‹¦åŠ´ãŒå¢—ãˆã¦ãã¦ å…ƒã€…ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’åˆ·æ–°ã™ã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§Mongo DBã‹ã‚‰åˆ¥ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã«ä¹—ã‚Šæ›ãˆã‚‹äº‹ã«ã—ãŸã€‚ ã‚·ã‚¹ãƒ†ãƒ ã®è¦æ¨¡ è©³ã—ãæ›¸ã‹ã‚Œã¦ã„ãªã„ãŒã€ï¼‘ãƒŽãƒ¼ãƒ‰è¾ºã‚Šæ•°TBã¨ã‚ã‚‹ã®ã§Shardingç’°å¢ƒã§ã¯ãªã„ã‹ã¨æ€ã‚ã‚Œã‚‹ã€‚
skozawa 2013/05/21
MongoDB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ Cassandraã€Mongodbã€SQLiteã€H2ã€MySQLã€Postgres - cypher256's blog
ä¸‹è¨˜ã®ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒè‰¯ã•ã’ãª SQLite ã‚’ä½¿ç”¨äºˆå®šã§ã™ãŒã€ã‚‚ã£ã¨é€Ÿã„ã‚‚ã®ãŒç„¡ã„ã‹ç¢ºèªã®ãŸã‚ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚SQL åˆ©ç”¨å‰æã§ã™ãŒã€NoSQL ãŒåœ§å€’çš„ãªæ€§èƒ½ã‚’å‡ºã™å ´åˆã¯æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã§ KVS ã‚‚ç¢ºèªã—ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ä»¶æ•°ã¯ 1 å„„ä»¶ç¨‹åº¦ã€JDBC SQL åˆ©ç”¨å¯èƒ½ INSERTã€UPDATE ã¯ãƒãƒƒãƒ SELECT ã¯ä¸»ã‚ãƒ¼ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã‚’é‡è¦– å°†æ¥ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®ãŸã‚ã®åˆ†æ•£ã¯ã‚ã‚Šãˆã‚‹ãŒã€ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³ã§é…ã„ã®ã¯ã ã‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ è¨ˆæ¸¬ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å ã‚¿ã‚¤ãƒ— å½¢æ…‹ è©•åˆ¤ è¨ˆæ¸¬ã«ã¤ã„ã¦ã®å‚™è€ƒ SQLite RDB çµ„ã¿è¾¼ã¿ â€»2 ãŠã‚‚ã¡ã‚ƒã€Androidæ¨™æº– JDBCæ“ä½œ â€»1 H2 RDB çµ„ã¿è¾¼ã¿ â€»2 çµ„ã¿è¾¼ã¿æœ€é€Ÿ JDBCæ“ä½œ â€»1 Derby RDB çµ„ã¿è¾¼ã¿ â€»2 Javaæ¨™æº–ã§
skozawa 2012/10/14
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
MySQLã‚’ã•ã‚‰ã«ç†è§£ã™ã‚‹ãŸã‚ã«èªã‚“ã è¨˜äº‹ã¾ã¨ã‚ - $shibayu36->blog;
æœ€è¿‘MySQLã®å‹‰å¼·ã‚’ã—ã¦ã„ã¾ã—ãŸã€‚å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQLã‚’èªã‚€ã¹ãã¨ã„ã†è©±ã‚’èžã„ã¦ã„ãŸã®ã§ã™ãŒã€ã‹ãªã‚Šç¶²ç¾…çš„ã«æ›¸ã‹ã‚Œã¦ã„ã¦ã€ä»Šã®çŸ¥è˜ã§ã¯ã©ã‚ŒãŒé‡è¦ãªã®ã‹ã‚ã‹ã‚‰ãªã„çŠ¶æ…‹ã§ã—ãŸã€‚ãã“ã§è‰²ã€…èª¿ã¹ã¦ã¿ã¦ã€å‚è€ƒã«ãªã‚‹è¨˜äº‹ã‚’ã„ãã¤ã‹è¦‹ã¤ã‘ãŸã®ã§ã€å°‘ã—ã¾ã¨ã‚ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¾ã¨ã‚ãŸè¨˜äº‹ã‚’èªã‚“ã§ã€å¤§ä½“ä»¥ä¸‹ã®ã“ã¨ãŒç†è§£ã§ãã¾ã—ãŸã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã‚ã‚Œæ–¹ã¨ãã®æ§‹é€ (MyISAMã¨InnoDB) EXPLAINã®è©³ã—ã„ä½¿ã„æ–¹ã€è¦‹æ–¹ InnoDBã®ç‰¹æ€§ ALTER TABLEã®ç‰¹æ€§ ãƒ¬ãƒ—ãƒªé…å»¶ ã¾ãšæœ€åˆã« Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã® ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“[å®Ÿè·µ]å…¥é–€ (Software Design plus)posted with amazlet at 12.06.02æ¾ä¿¡ å˜‰ç¯„ æŠ€è¡“è©•è«–ç¤¾ å£²ã‚Šä¸Šã’ãƒ©ãƒ³ã‚ãƒ³ã‚°: 9767 Amazon.co.jp ã§è©³ç´°ã‚’è¦‹ã‚‹ æ¾ä¿¡ã•ã‚“ã®æ›¸ã„ãŸã€ŒWebã‚¨ãƒ³ã‚¸
skozawa 2012/06/04
MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
1