[B! DB] nakamodsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nakamods id:nakamods

DBã«é–¢ã™ã‚‹nakamodsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (16)

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

MongoDBã®æ§˜ãªNoSQLã«å‹¢ã„ãŒã‚ã‚‹ã®ã¯ä½•æ•…ã§ã™ã‹ï¼ŸSQLã¨æ¯”ã¹ã¦ã©ã‚“ãªåˆ©ç‚¹ã‚„æ¬ ç‚¹ãŒã‚ã‚Šã¾ã™ã‹ï¼Ÿ - Quora
å›žç” (3ä»¶ä¸ã®1ä»¶ç›®) ãƒã‚¤ãƒ—ã‚µã‚¤ã‚¯ãƒ«ã¨ã„ã†æ¦‚å¿µã‚’Gartnerã‚°ãƒ«ãƒ¼ãƒ—ãŒæå”±ã—ã¦ã¾ã—ã¦ã€æ§˜ã€…ãªæµè¡Œã‚Šã‚¹ã‚¿ãƒªã®ã‚µã‚¤ã‚¯ãƒ«ã‚’åˆ†æžã™ã‚‹æ¨™æº–çš„ãªæ–¹æ³•ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ãƒã‚¤ãƒ—ã¨ã¯éŽåº¦ãªæœŸå¾…ã‚„ç†±ç‹‚ã‚’æ„å‘³ã™ã‚‹è¨€è‘‰ã§ã™ã€‚ä¸€ç™ºå±‹èŠ¸äººã®äººæ°—ã®ã‚«ãƒ¼ãƒ–ã¿ãŸã„ãªã‚‚ã®ã§ã€ãƒ†ãƒ„andãƒˆãƒ¢ã¿ãŸã„ã«å®‰å®šã™ã‚‹å ´åˆã¨ã€æ¶ˆãˆã¦ã„ãã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚èŠ¸äººã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒDA PUMPã¯ä¸€èŒ¶ã®äººé–“æ€§ã‚‚ã‚ã‚Šã¾ã—ã¦ã€æ¬¡ã¯åŽ³ã—ã„ã‘ã©å®šç€ã™ã‚‹ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ãªã‚“ã ã‹ã®ãƒˆãƒªã‚¬ãƒ¼ã§è©•ä¾¡ãŒä¸ŠãŒã‚Šå§‹ã‚ã€ãƒ”ãƒ¼ã‚¯ã‚’è¿Žãˆã‚‹ã€‚ãã®å¾Œè©•ä¾¡ãŒä¸‹ãŒã£ã¦ã„ãã€åº•ã‚’æ‰“ã¤ã¨å°‘ã—ä¸ŠãŒã£ã¦å®šç€ã™ã‚‹ã¨ã„ã†çµŒéŽã‚’ãŸã©ã‚‹ã¨ã—ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¨åŒã˜ãƒ¢ãƒ‡ãƒ«ã§ã€æµè¡Œã‚Šã®ãƒã‚¤ãƒ†ã‚¯...
nakamods 2019/08/27
DB

ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ
ãƒªãƒ³ã‚¯
Azure Cosmos DB - NoSQL and Relational Database | Microsoft Azure
nakamods 2017/02/19
DB

NoSQL
ãƒªãƒ³ã‚¯
ã‚«ãƒ¼ãƒã‚®ãƒ¼ãƒ¡ãƒãƒ³ã®DBã«é–¢ã™ã‚‹è¬›ç¾©ãŒé¢ç™½ã„ã®ã§ãŠã™ã™ã‚ - ã ã„ãŸã„ã‚ˆãã‚ã‹ã‚‰ãªã„ãƒ–ãƒã‚°
ã“ã“ã«æ›¸ãã“ã¨ã«ã‚ˆã£ã¦é€”ä¸ã§ã‚„ã‚ã‚‰ã‚Œãªãã™ã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ã§ã™ã€‚ ãƒãƒƒã‚«ãƒ¼ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚’çœºã‚ã¦ã„ãŸã‚‰ä»¥ä¸‹ã®ã‚ˆã†ãªCSç³»è¬›ç¾©å‹•ç”»ã®ã¾ã¨ã‚ãƒªãƒã‚¸ãƒˆãƒªãŒæµã‚Œã¦ã„ã¾ã—ãŸã€‚ GitHub - Developer-Y/cs-video-courses: List of Computer Science courses with video lectures. ã¸ãƒ¼ã£ã¨æ€ã„ãªãŒã‚‰ä½•å€‹ã‹ãƒãƒã£ã¦ã¿ãŸã¨ã“ã‚ä»¥ä¸‹ã«å‡ºãã‚ã—ã¾ã—ãŸã€‚ 15721.courses.cs.cmu.edu è‹±èªžãŒï¼ˆè‡ªåˆ†ã«ã¨ã£ã¦ï¼‰èžãå–ã‚Šã‚„ã™ãã€å‹•ç”»ã®å“è³ªï¼ˆç”»è³ªã‚„ã‚¹ãƒ©ã‚¤ãƒ‰ãŒã¡ã‚ƒã‚“ã¨è¦‹ãˆã‚‹ã‹ã©ã†ã‹ã¨ã„ã£ãŸéƒ¨åˆ†ï¼‰ã‚‚è‰¯ã„ã‚‚ã®ã§ã‹ã¤èˆˆå‘³ã®ã‚ã‚‹å†…å®¹ã§å‡ºæ¥ã‚Œã°ã‚¹ãƒ©ã‚¤ãƒ‰ã‚‚ãŠã—ã‚ƒã‚Œã§ãƒ»ãƒ»ãƒ»ã¨ãªã‚‹ã¨ãªã‹ãªã‹å°‘ãªã„ã§ã™ãŒã€ã“ã‚Œã¯ã‹ãªã‚Šè¦‹ã‚„ã™ã„ã§ã™ã€‚ ã‚¹ãƒ©ã‚¤ãƒ‰ã‚‚æ¦‚å¿µå›³ãŒé »ç¹ã«ç™»å ´ã—ãŸã‚Šã—ã¦ã€ã“ã‚Œã ã‘ã§ã‚‚èžãå–ã‚Œãªã‹ã£ãŸéƒ¨åˆ†ãªã©ã‚’ã‹ãªã‚Šè£œå®Œã§ãã¾ã™ã€‚ ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«ãƒšãƒ¼ã‚¸
nakamods 2016/12/11
å¤§å¦

DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆå¾¹åº•æŒ‡å—
DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®æŠ€è¡“å‹‰å¼·ä¼šï¼ˆç¬¬3å›žï¼‰ã§ä½¿ç”¨ã—ãŸè³‡æ–™ã§ã™ã€‚ä¸»ã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã¨æ£è¦åŒ–ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã®é™ç•Œã«ã¤ã„ã¦æ£ã—ãèªè˜ã—ã¦ã“ãã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’ç†è§£ã—ãŸã¨è¨€ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚
nakamods 2013/11/29
DB
ãƒªãƒ³ã‚¯
@nippondanji æ°ã®ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆå¾¹åº•æŒ‡å—ï¼ï¼ã€ã¯ç¥žãƒ—ãƒ¬ã‚¼ãƒ³ï¼è„…å¨ã®ä¸»ç¾©ä¸»å¼µã®ä¸€è²«æ€§ä¿è¨¼ã¯ DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®é¡ã ã£ãŸä»¶ï¼ - #garagekidztweetz
ãƒ„ã‚¤ãƒ¼ãƒˆä»Šæ—¥ã¯ã€ç¬¬ 1 å›žã®SQL ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã®å›žã‹ã‚‰è‰¯ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’æä¾›ã—ã¾ãã‚Šãªã‚¨ãƒ³ãƒã‚«ãƒ‡ãƒãƒ»ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚ºã•ã‚“ä¸»å‚¬ã®ç¬¬ 3 å›ž DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å‹‰å¼·ä¼šã«å‚åŠ ã—ã¦ãã¾ã—ãŸã€‚ ä»Šå›žã¯ æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã§æœ‰åãªæ¼¢ã®ä¸ã®æ¼¢ã€ @nippondanji æ°ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã‚’å¾¹åº•æŒ‡å—ã—ã¦ãã‚Œã‚‹ã¨ã„ã†ã“ã¨ã§ã€å…ƒã€… DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒãƒãƒƒã‚¯ã‚°ãƒ©ãƒ³ãƒ‰ã®ã‚ãŸã—ã¨ã—ã¦ã¯ã„ã‹ãªã„ã‚ã‘ã«ã¯ã„ã‹ã‚“ã ã‚ã†ã€ã¨å–œã³å‹‡ã‚“ã§ã„ã£ã¦ãã¾ã—ãŸï¼ å†…å®¹ã¯ã¨ã„ã†ã¨ä¸‹è¨˜ã®æ¦‚è¦ã‚’ã‚«ãƒãƒ¼ã™ã‚‹å†…å®¹ã§ã—ãŸã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹RDBï¼‰ã¯ç™»å ´ã—ã¦ã‹ã‚‰ã‹ãªã‚Šã®æ™‚é–“ãŒçµŒã£ã¦ã„ã¾ã™ã€‚ãã®åãŒç¤ºã™ã‚ˆã†ã«ã€RDBã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’ãƒ™ãƒ¼ã‚¹ã«è€ƒæ¡ˆã•ã‚ŒãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ã—ã‹ã—ãªãŒã‚‰ã€æœªã ã«ç¾å ´ã§ã¯RDBãŒä½¿ã„ã“ãªã•ã‚Œã¦ã„ã‚‹ã¨ã¯è¨€ã„ãŒãŸãã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã¸ã®ç†è§£ã‚‚é€²ã¾ãšã€èª¤ã£ãŸå¸¸è˜ãŒè·‹æ‰ˆã—ã¦ã„ã‚‹ã®ãŒç¾çŠ¶ã§
nakamods 2013/11/29
DB
ãƒªãƒ³ã‚¯
ãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆXã¯ã€Œä¸–ç•Œã¯ä¸€ã¤ã€ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã«ã©ã®ã‚ˆã†ãªã‚µãƒ¼ãƒæ§‹æˆã«ã—ã¦ã„ã‚‹ã®ã‹ï¼Ÿ
ã‚¹ã‚¯ã‚¦ã‚§ã‚¢ãƒ»ã‚¨ãƒ‹ãƒƒã‚¯ã‚¹ã®äººæ°—RPGã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆã€ã‚·ãƒªãƒ¼ã‚ºã®æœ€æ–°ä½œã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆXï¼ˆãƒ‰ãƒ©ã‚¯ã‚¨10ï¼‰ã€ã¯ã‚·ãƒªãƒ¼ã‚ºåˆã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ä½œå“ã¨ãªã‚Šã¾ã—ãŸãŒã€ãã®èˆžå°è£ã¯ä¸€ä½“ã©ã†ãªã£ã¦ã„ãŸã®ã‹ã€‚ã‚²ãƒ¼ãƒ ã®ä¸–ç•Œè¦³ã‚’æ”¯ãˆã‚‹ã‚µãƒ¼ãƒã‚·ã‚¹ãƒ†ãƒ ãŒã©ã®ã‚ˆã†ã«æ§‹æˆã•ã‚Œã¦ã„ã‚‹ã®ã‹ã¨ã„ã†ã“ã¨ã‚„ã€ãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆâ…©ãªã‚‰ã§ã¯ã®ä»•çµ„ã¿ã‚„æ©Ÿèƒ½ã‹ã‚‰é–‹ç™ºã®è‹¦åŠ´è©±ã¾ã§ã€æ ªå¼ä¼šç¤¾ã‚¹ã‚¯ã‚¦ã‚§ã‚¢ãƒ»ã‚¨ãƒ‹ãƒƒã‚¯ã‚¹é–‹ç™ºéƒ¨ãƒ—ãƒã‚°ãƒ©ãƒžæ£®å±±æœ‹è¼ã•ã‚“ãŒèªžã£ã¦ã„ã¾ã™ã€‚ ã‚¿ã‚¤ãƒˆãƒ« | CEDEC 2012 | Computer Entertaintment Developers Conference http://cedec.cesa.or.jp/2012/program/NW/C12_P0040.html æ£®å±±æœ‹è¼ï¼š çš†æ§˜ã€æœ¬æ—¥ã¯ãŠé›†ã¾ã‚Šé ‚ãã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ã“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’æ‹…å½“ã•ã›ã¦é ‚ãã¾ã™ã€æ ªå¼ä¼šç¤¾ã‚¹ã‚¯ã‚¦ã‚§ã‚¢ãƒ»ã‚¨ãƒ‹ãƒƒã‚¯ã‚¹é–‹ç™ºéƒ¨æ‰€å±žã®æ£®å±±æœ‹è¼ã¨
nakamods 2012/08/25
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

Oracle

ã‚²ãƒ¼ãƒ
ãƒªãƒ³ã‚¯
SQL vs NoSQLã€ã‚°ãƒ¼ã‚°ãƒ«ã«ãŠã‘ã‚‹æˆ¦ã„ï¼ˆå‰ç·¨ï¼‰ã€‚Google I/O 2012
SQLã¨NoSQLã§ã¯ã©ã¡ã‚‰ãŒå„ªã‚Œã¦ã„ã‚‹ã®ã‹ï¼Ÿ ã‚°ãƒ¼ã‚°ãƒ«ã®æ‹…å½“è€…ãŒãƒ‡ã‚£ãƒ™ãƒ¼ãƒˆï¼ˆã¨ã„ã†ã‚ˆã‚Šå°èŠå±…ï¼š-ï¼‰ã‚’è¡Œã£ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯ã€å…ˆã€…é€±é–‹å‚¬ã•ã‚ŒãŸGoogle I/O 2012ã§è¡Œã‚ã‚ŒãŸã‚‚ã®ã€‚SQLã¨NoSQLã«ã¯æ©Ÿèƒ½çš„ã«ã©ã®ã‚ˆã†ãªé•ã„ãŒã‚ã‚Šã€ã©ã†ä½¿ã„åˆ†ã‘ã‚‹ã¹ããªã®ã‹ã€æ˜Žç¢ºãªèª¬æ˜ŽãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ¡ãƒªãƒƒãƒˆ ã‚°ãƒ¼ã‚°ãƒ«ã®Alfred Fulleræ°ï¼ˆNoSQLæ‹…å½“ï¼‰ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã¯ãƒ•ã‚©ãƒ«ãƒˆãƒˆãƒ¬ãƒ©ãƒ³ãƒˆã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ä¸è¦ã€ãƒ‘ãƒƒãƒã‚‚ç§ãŸã¡ãŒé©ç”¨ã—ã¦ãŠã‚Šã€åˆ©ç”¨è€…ã¯é‹ç”¨ã«ã¤ã„ã¦å¿ƒé…ã™ã‚‹å¿…è¦ãŒãªã„ã€ã¨ã„ã£ãŸãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„åœ°åŸŸåˆ†æ•£ã§ãƒ‡ãƒ¼ã‚¿ã‚‚ä¿å…¨ã•ã‚Œã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒ
nakamods 2012/07/10
NoSQL

SQL

Google

DB
ãƒªãƒ³ã‚¯
Query Language Understood by SQLite
SQL As Understood By SQLite SQLite understands most of the standard SQL language. But it does omit some features while at the same time adding a few features of its own. This document attempts to describe precisely what parts of the SQL language SQLite does and does not support. A list of SQL keywords is also provided. The SQL language syntax is described by syntax diagrams. The following syntax d
nakamods 2011/10/15
sqlite

WebSQLDatabase

html5

JavaScript

SQL

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: ãƒ¢ãƒ€ãƒ³ãªMySQLã®é–‹ç™ºç’°å¢ƒã®æ§‹ç¯‰æ–¹æ³•
é…ã‚Œã°ã›ãªãŒã‚‰ ãƒ¢ãƒ€ãƒ³ãª Perl ã®é–‹ç™ºç’°å¢ƒã®æ§‹ç¯‰æ–¹æ³• ãƒ¢ãƒ€ãƒ³ãªPHPã®é–‹ç™ºç’°å¢ƒã®æ§‹ç¯‰æ–¹æ³• ãƒ¢ãƒ€ãƒ³ãªPythonã®é–‹ç™ºç’°å¢ƒã®æ§‹ç¯‰æ–¹æ³• ãƒ¢ãƒ€ãƒ³ãª Java ã®é–‹ç™ºç’°å¢ƒã®æ§‹ç¯‰æ–¹æ³• ã«ç¶šã„ã¦ã¿ã‚‹ã€‚MySQLã¯è¨€èªžã˜ã‚ƒãªã„ã‘ã©ã€‚ ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ç‰MySQLã‚’ã‚½ãƒ¼ã‚¹ã‹ã‚‰ãƒ“ãƒ«ãƒ‰ã™ã‚‹ã®ã§ãªã‘ã‚Œã°ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ç‰ã¯å¿…è¦ãªã„ã‘ã©ã€ã©ã†ã›ã‚¢ãƒ—ãƒªé–‹ç™ºã«å¿…è¦ãªã®ã§ã€ŒMySQLãªã‚“ã‹ã„ã¤ã§ã‚‚ãƒãƒƒã‚¯ã—ã¦ã‚„ã‚‹ãžï¼ã€ã¨ã„ã†æ„æ°—è¾¼ã¿ã‚’ç¤ºã™ãŸã‚ã«å…¥ã‚Œã¦ãŠã“ã†ã€‚OSXãªã‚‰Xcodeã€Linuxãªã‚‰GCCã€‚æœ€æ–°ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã˜ã‚ƒãªã„ã¨ãƒ¤ãƒ€ï¼ã¨ã„ã†ç²‹ãªäººã«ã¯Bazaarã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚ãŠå‹§ã‚ã—ãŸã„ã€‚Bazaarã¯è¨€ã‚ãšã¨çŸ¥ã‚ŒãŸåˆ†æ•£ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã§ã‚ã‚Šã€MySQLé–‹ç™ºãƒãƒ¼ãƒ ã‚‚æŽ¡ç”¨ã—ã¦ã„ã‚‹ã€‚æœ€æ–°ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯æ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã§ã‚²ãƒƒãƒˆå¯èƒ½ã ã€‚ shell> bzr branch lp:mysql-server/5.1 mysql-5.1
nakamods 2010/09/26
mysql

é–‹ç™ºç’°å¢ƒ

DB

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
PHPã¨MongoDBã§å¦ã¶æ¬¡ä¸–ä»£ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ :: handsOut.jp
ã‚¹ãƒ©ã‚¤ãƒ‰1: PHP ã¨ Mongo DB ã§å¦ã¶æ¬¡ä¸–ä»£ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ä½è—¤ç¢å“‰LOCAL PHP éƒ¨ ã‚¹ãƒ©ã‚¤ãƒ‰2: ã‚¹ãƒ©ã‚¤ãƒ‰3: çªç„¶ã§ã™ãŒ ã‚¹ãƒ©ã‚¤ãƒ‰4: 4æœˆã‹ã‚‰æœå¹Œå¸‚æ°‘ã«ãªã‚Šã¾ã™!!!!! ã‚¹ãƒ©ã‚¤ãƒ‰5: å‹é”ãŒå°‘ãªã„ã®ã§çš†ã•ã‚“éŠã‚“ã§ã‚„ã£ã¦ãã ã•ã„ ã‚¹ãƒ©ã‚¤ãƒ‰6: â€¢ Mongo DB ã£ã¦ä½•?â€¢ ä½¿ã„æ–¹â€¢ ä»–ã® DBMS ã¨ã®æ¯”è¼ƒâ€¢ MapReduceâ€¢ ã¾ã¨ã‚ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ ã‚¹ãƒ©ã‚¤ãƒ‰7: ãã‚‚ãã‚‚ä½•ã®è©±? ã‚¹ãƒ©ã‚¤ãƒ‰8: Mongo DB ã™ã”ã„ã‚ˆ! ã‚¹ãƒ©ã‚¤ãƒ‰9: Mongo DB ã£ã¦ä½•? ã‚¹ãƒ©ã‚¤ãƒ‰10: http://www.mongo db.org/ ã‚¹ãƒ©ã‚¤ãƒ‰11: Mongo DB (from "humongous") is a scala ble, highperformance,open source, schema-free, documentorienteddatabas
nakamods 2010/07/15
php

mongodb

DB

web
ãƒªãƒ³ã‚¯
WTF is a SuperColumn? An Intro to the Cassandra Data Model â€” Arin Sarkissian
For the last month or two the Digg engineering team has spent quite a bit of time looking into, playing with and finally deploying Cassandra in production. Itâ€™s been a super fun project to take on â€“ but even before the fun began we had to spend quite a bit of time figuring out Cassandraâ€™s data modelâ€¦ the phrase â€œWTF is a â€™super columnâ€™â€ was uttered quite a few times. If youâ€™re coming from an RDBM
nakamods 2010/07/15
cassandra

DB

web
ãƒªãƒ³ã‚¯
Cassandraä¿®è¡Œ â€” sklave
æ—¥æ›œå¤§å·¥ã¯Python3kã«ã—ã‚ˆã†ã‹ > Python3kã¯MySQLãƒ‰ãƒ©ã‚¤ãƒç„¡ã„ã®ã‹ > ã˜ã‚ƒã‚Cassandraä½¿ã£ã¦ã¿ã‚‹ã‹ > thriftã‚‚Python3kç„¡ã„ã˜ã‚ƒã‚“ > ã˜ã‚ƒã‚2.6ã§Cassandraã‹ã€ã¨ã„ã†çµŒè·¯ã«ã‚ˆã‚ŠCassandraã«ãƒˆãƒ©ã‚¤ã—ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ä¿®è¡Œä¸ã®èº«ã§ã‚ã‚‹æ•…ã€æƒ…å ±ã®æ£ç¢ºæ€§ã¯ç„¡æ‹…ä¿ã€‚ ãŸã‚ã—ãŸCassandraã¯0.5.1 Cassandraã¨ã¯ Cassandraã¨ã¯ã€ã‚‚ã¨ã‚‚ã¨FacebookãŒé–‹ç™ºã—ã¦ã€ç¾åœ¨ã¯Apacheã§ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã•ã‚Œã¦ã„ã‚‹åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚æœ€è¿‘ã€TwitterãŒMySQLã‹ã‚‰ç§»è¡Œã—ãŸã“ã¨ã§è©±é¡Œã«ãªã£ãŸã€‚ ã„ã‚ã‚†ã‚‹NoSQL(ã“ã®å‘¼ã³æ–¹ã¯å¥½ãã˜ã‚ƒãªã„ã‘ã©)ã®ã‚¸ãƒ£ãƒ³ãƒ«ã«å±žã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã®è¡¨ç¾åŠ›çš„ã«ã¯ DataStore(GAE) > Cassandra > Key-Value Storeãã‚‰ã„ã®ã‚‚ã®ãªã‚“ã˜ã‚ƒãª
nakamods 2010/07/15
cassandra

DB

web

python
ãƒªãƒ³ã‚¯
ã•ã‚‰ã«MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹7ã¤ã®æ–¹æ³•
MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†è¨˜äº‹ãŒã¨ã¦ã‚‚å¥½è©•ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚è¨˜äº‹ã‚’èªã‚“ã§é ‚ã„ãŸçš†ã•ã‚“ã€ã‚ã‚ŠãŒã¨ã†ã€‚ ã“ã®è¨˜äº‹ã«å¯¾ã™ã‚‹ä¾¿ä¹—ï¼ˆï¼Ÿï¼‰ã§Webå±‹ã®ãƒã‚¿å¸³: PostgreSQLã‚’é«˜é€ŸåŒ–ã™ã‚‹16ã®ãƒã‚¤ãƒ³ãƒˆã¨ã„ã†è¨˜äº‹ã‚’æ›¸ã„ã¦é ‚ã„ãŸã‚ˆã†ã ãŒã€ãã¡ã‚‰ã®æ–¹ã‚‚ã‹ãªã‚Šäººæ°—ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚ä»–äººãŒä½œã£ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«æ”¹è‰¯ã‚’åŠ ãˆã‚‹ã¨ã„ã†ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ç²¾ç¥žã‚‚åŸºæœ¬ã¯ä¾¿ä¹—ã§ã‚ã‚‹ã®ã§ã€ä¾¿ä¹—ã«ã¤ã„ã¦ã¯å¤§ã„ã«è³›æˆã—ãŸã„ã¨ã„ã†ã‹ã‚€ã—ã‚å–ã‚Šä¸Šã’ã¦ãã‚Œã¦ã‚ã‚ŠãŒã¨ã†ï¼ï¼ã¨æ€ã†ã‚ã‘ã§ã‚ã‚‹ãŒã€ã“ã“ã§ã•ã‚‰ã«ä¿ºã¯ã“ã†è€ƒãˆã‚‹ã€‚ ã¨ã€‚ Webå±‹ã®ãƒã‚¿å¸³ã•ã‚“ã®è¨˜äº‹ã§ã¯16ã®ãƒã‚¤ãƒ³ãƒˆãŒç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãŒã€æ¼¢ï¼ˆã‚ªãƒˆã‚³ï¼‰ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã®è¨˜äº‹ã¯10ã®æ–¹æ³•ã ã£ãŸã®ã§ã‚ã¨6ã¤è¶³ã‚Šãªã„ã€‚ã‚ªãƒˆã‚³ã¯æ•°ã§å‹è² ï¼ï¼ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã¯ãƒã‚¿ã‚’æŒ¯ã‚Šçµžã£ã¦ã•ã‚‰ã«7ã¤ã®MySQLé«˜é€ŸåŒ–ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ 1. ã‚¤ãƒ³ãƒ†ãƒ«ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©
nakamods 2010/07/13
mysql

é«˜é€ŸåŒ–

DB

web
ãƒªãƒ³ã‚¯
Not Only NoSQL!! é©šç•°çš„ãªã¾ã§ã«WRITEæ€§èƒ½ã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³
Webã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ã€ä¸–ç•Œä¸ã‹ã‚‰ã®ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’æŒãå¿…è¦ãŒã‚ã‚‹ãŸã‚ã€ã„ãã‚‰ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã‚ˆã†ã¨ã‚‚ä¸€å°ã®RDBMSã§ã¯æŒããã‚‹ã“ã¨ãŒå‡ºæ¥ãªã„ã®ãŒå¸¸ã ã€‚MySQLã¯æœ€åˆã‹ã‚‰ãƒžã‚¹ã‚¿ãƒ¼ãƒ»ã‚¹ãƒ¬ãƒ¼ãƒ–åž‹ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ãŒæè¼‰ã•ã‚Œã¦ãŠã‚Šã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’ãŸãã•ã‚“ã¶ã‚‰ä¸‹ã’ã‚‹ã“ã¨ã«ã‚ˆã£ã¦å‚ç…§ã®è² è·ã‚’ã‚¹ãƒ¬ãƒ¼ãƒ–ã«å‰²ã‚ŠæŒ¯ã‚‹ã¨ã„ã†ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã«ã‚ˆã£ã¦ãã®å•é¡Œã«å¯¾å‡¦ã—ã¦ããŸã€‚ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã‚ˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã¯ã€å‚ç…§ï¼ˆï¼PVï¼‰ãŒå¤šã„Webã‚µã‚¤ãƒˆã¨éžå¸¸ã«ç›¸æ€§ãŒè‰¯ãã€å¹¾å¤šã®Webã‚µã‚¤ãƒˆã«ãŠã„ã¦å®Ÿç¸¾ã‚’ä½œã£ã¦ãã¦ã„ã‚‹ã—ã€ã¾ã ã¾ã åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚µã‚¤ãƒˆã®ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ãŒåŠ‡çš„ã«å¢—åŠ ã—ã¦ãã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚ˆã‚‹è² è·åˆ†æ•£ã§ã¯è¿½ã„ã¤ã‹ãªããªã£ã¦ããŸã€‚ãã“ã§äººã€…ãŒã¨ã£ãŸé¸æŠžè‚¢ã¯ã€memcachedã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§ã‚ã‚‹ã€‚memcachedã¯ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåž‹ã®é«˜é€ŸãªKVSã§ã‚ã‚Šã€å‚ç…§ãƒ»æ›´æ–°æ€§èƒ½ã¯MySQLã‚ˆã‚Šæ ¼æ®µã«é«˜ã„ã€‚M
nakamods 2010/07/13
mysql

DB

web

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿åž‹ (ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã‚¨ãƒ³ã‚¸ãƒ³)
Microsoft SQL Server ã«æ ¼ç´ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã¯ã™ã¹ã¦ã€ã“ã‚Œã‚‰ã®åŸºæœ¬ãƒ‡ãƒ¼ã‚¿åž‹ã®ã„ãšã‚Œã‹ã¨ã®äº’æ›æ€§ãŒå¿…è¦ã§ã™ã€‚cursor ãƒ‡ãƒ¼ã‚¿åž‹ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«åˆ—ã«å‰²ã‚Šå½“ã¦ã‚‹ã“ã¨ãŒã§ããªã„å”¯ä¸€ã®ã‚·ã‚¹ãƒ†ãƒ ãƒ‡ãƒ¼ã‚¿åž‹ã§ã™ã€‚ã“ã®ãƒ‡ãƒ¼ã‚¿åž‹ã¯ã€å¤‰æ•°ãŠã‚ˆã³ã‚¹ãƒˆã‚¢ãƒ‰ ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã ã‘ä½¿ç”¨ã§ãã¾ã™ã€‚ ä¸€éƒ¨ã®åŸºæœ¬ãƒ‡ãƒ¼ã‚¿åž‹ã«ã¯ã‚·ãƒŽãƒ‹ãƒ ãŒã‚ã‚Šã¾ã™ã€‚ãŸã¨ãˆã°ã€rowversion ã¯ timestamp ã®ã‚·ãƒŽãƒ‹ãƒ ã§ã‚ã‚Šã€national character varying ã¯ nvarchar ã®ã‚·ãƒŽãƒ‹ãƒ ã§ã™ã€‚ã‚·ãƒŽãƒ‹ãƒ ã®å‹•ä½œã®è©³ç´°ã«ã¤ã„ã¦ã¯ã€ã€Œãƒ‡ãƒ¼ã‚¿åž‹ã®ã‚·ãƒŽãƒ‹ãƒ (Transact-SQL)ã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ æ¬¡ã® 2 ç¨®é¡žã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©ãƒ‡ãƒ¼ã‚¿åž‹ã‚’ä½œæˆã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ åŸºæœ¬ãƒ‡ãƒ¼ã‚¿åž‹ã‹ã‚‰ä½œæˆã•ã‚Œã‚‹åˆ¥åãƒ‡ãƒ¼ã‚¿åž‹ã€‚ã“ã®ã‚ˆã†ãªãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©ãƒ‡ãƒ¼ã‚¿åž‹ã‚’ä½¿ã†ã¨ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆå†…ã«æ ¼ç´ã™ã‚‹å€¤ã®ç¨®é¡žã‚’èª¬æ˜Žã§ãã‚‹ã‚ˆ
nakamods 2009/10/21
SQLServer2008

DB

SQLServer
ãƒªãƒ³ã‚¯
SQL Serverã¨ADO.NETã‚’ç”¨ã„ãŸBLOBï¼ˆãƒã‚¤ãƒŠãƒªãƒ©ãƒ¼ã‚¸ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆï¼‰ã®å‡¦ç†æ–¹æ³•
Textã€NTextã€Imageã®å„ãƒ‡ãƒ¼ã‚¿åž‹ã¯ã€SQL Serverã®ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ä½¿ç”¨ã•ã‚Œã¦ã„ãŸã‚‚ã®ã§ã™ã€‚ã“ã‚Œã‚‰ã®ä»£ã‚ã‚Šã«æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿åž‹ã§ã‚ã‚‹varchar(MAX)ã€nvarchar(MAX)ã€varbinary(MAX)ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã‚’ãŠå‹§ã‚ã—ã¾ã™ã€‚ è¡¨1ã‹ã‚‰åˆ†ã‹ã‚‹ã‚ˆã†ã«ã€å¤§ããªãƒã‚¤ãƒŠãƒªãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿åž‹ã¯varbinary(MAX)ã§ã™ã€‚å¾“ã£ã¦ä»¥ä¸‹ã§ã¯ã€.NETã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦varbinary(MAX)ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ç”¨ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ BLOBã‚’SQL Serverã«æ ¼ç´ã™ã‚‹ ãƒã‚¤ãƒŠãƒªãƒ‡ãƒ¼ã‚¿ã«ã¯ã•ã¾ã–ã¾ãªç¨®é¡žã®ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚Wordæ–‡æ›¸ã€PDFå½¢å¼ã®é€ã‚ŠçŠ¶ã€å†™çœŸã€è£½å“ç”»åƒã€Rawãƒ‡ãƒ¼ã‚¿ã¯ã™ã¹ã¦ã€BLOBãƒ‡ãƒ¼ã‚¿ã®ä¾‹ã§ã™ã€‚.NETã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦BLOBã‚’æ ¼ç´ã™ã‚‹ã«ã¯ã€æ¬¡ã®2ã¤ã®æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ BLOBã‚’ãƒ‡ã‚£ã‚¹ã‚¯ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦æ ¼ç´ã™ã‚‹ BLOB
nakamods 2009/06/24
SQLServer

ADO.NET

BLOB

.net

IT

DB
ãƒªãƒ³ã‚¯
1