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

ss_9 id:ss_9

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

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

Apache Cassandra ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ
å®Ÿç¸¾ Cassandra ã¯ã€Digg ã‚’ã¯ã˜ã‚ã€Facebook, Twitter, Reddit, Rackspace, Cloudkick, Cisco, SimpleGeo, Ooyala, OpenX ãªã©ã€å¤§è¦æ¨¡ã§ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ãªãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã‚’æŒã¤å¤šãã®ä¼æ¥ã§å®Ÿéš›ã«ä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚æœ€ã‚‚å¤§è¦æ¨¡ãªå®Ÿåƒã‚¯ãƒ©ã‚¹ã‚¿ã§ã¯ã€150 å°ä»¥ä¸Šã®ãƒžã‚·ãƒ³ã« 100 TB ã‚’è¶…ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãŒæ ¼ç´ã•ã‚Œã¦ã„ã¾ã™ã€‚ é«˜ã„è€éšœå®³æ€§ éšœå®³ã«å‚™ãˆã¦ã€ãƒ‡ãƒ¼ã‚¿ã¯è¤‡æ•°ã®ãƒŽãƒ¼ãƒ‰ã«è‡ªå‹•çš„ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ãƒˆã•ã‚Œã¾ã™ã€‚è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚‚ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã¾ã™ã€‚æ•…éšœã—ãŸãƒŽãƒ¼ãƒ‰ã¯ã€ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ãªã—ã«ãƒªãƒ—ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ éžé›†ä¸çš„ ã‚¯ãƒ©ã‚¹ã‚¿å†…ã®ã™ã¹ã¦ã®ãƒŽãƒ¼ãƒ‰ã¯å¯¾ç‰ã§ã™ã€‚ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚SPOF (å˜ä¸€éšœå®³ç‚¹) ã‚‚ã‚ã‚Šã¾ã›ã‚“ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ä¸»å°Žæ¨© æ›´æ–°ã”ã¨ã«åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¾ãŸã¯éžåŒæœŸãƒ¬ãƒ—ãƒªã‚±
ss_9 2011/05/26
cassandra

db

åˆ†æ•£kvs
ãƒªãƒ³ã‚¯
RDBã®æ©Ÿèƒ½ã‚’NoSQLã§å®Ÿç¾ã™ã‚‹ï¼ˆ1ï¼‰
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯RDBMSã«æ¯”ã¹ã¦ä¸¦åˆ—å‡¦ç†ã§æ€§èƒ½ã‚’ä¸Šã’ã¦ã„ã‘ã‚‹ã¨ã„ã†ç‰¹é•·ãŒã‚ã‚‹åé¢ã€å˜ç´”ãªãƒ‡ãƒ¼ã‚¿æ§‹é€ ã—ã‹æ‰±ãˆãªã„ã¨ã‹ã€ãƒ‡ãƒ¼ã‚¿ã®ä¸¦ã¹æ›¿ãˆãªã©ãŒé›£ã—ã„ã¨ã„ã†é›£ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚ä»Šå›žã‹ã‚‰ã¯ã€NoSQLã‚’ä½¿ã„ãªãŒã‚‰ã‚‚ã€RDBMSãŒå‚™ãˆã‚‹æ©Ÿèƒ½ã‚’éƒ¨åˆ†çš„ã«å®Ÿç¾ã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚ï¼ˆç·¨é›†éƒ¨ï¼‰ é«˜é€Ÿãªåˆ†ã€è¤‡é›‘ãªãƒ‡ãƒ¼ã‚¿åŠ å·¥ãŒè‹¦æ‰‹ãªNoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ å‰å›žã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿å‡ºã™æµã‚Œã‚’è©³ã—ãè¦‹ã¦ã„ãã¾ã—ãŸã€‚å•ã„åˆã‚ã›ã‚’å—ã‘ã¦ã‹ã‚‰çµæžœã‚»ãƒƒãƒˆã‚’å‹•çš„ã«ä½œã£ã¦è¿”ã™RDBMSã®ã‚„ã‚Šæ–¹ã§ã¯ã€åˆ†æ•£ç’°å¢ƒã«ãŠã„ã¦ã¯ååˆ†ãªå‡¦ç†æ€§èƒ½ã‚’ç™ºæ®ã§ããªã„ã¨ã„ã†ã“ã¨ãŒã”ç†è§£é ‚ã‘ãŸã‹ã¨æ€ã„ã¾ã™ã€‚ RDBMSã¯ãƒ‡ãƒ¼ã‚¿ã®çµåˆã‚„æ¤œç´¢ã®ã»ã‹ã«ã‚‚ã€ãƒ‡ãƒ¼ã‚¿é›†è¨ˆã‚„ä¸¦ã¹æ›¿ãˆãªã©ã€SQLã‚’ä½¿ã£ãŸå•ã„åˆã‚ã›å†…å®¹ã«å¿œã˜ã¦ã•ã¾ã–ã¾ãªå½¢ã«ãƒ‡ãƒ¼ã‚¿ã‚’åŠ å·¥ã™ã‚‹æ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚å¤šæ§˜ãªè¦æ±‚ã«å¿œãˆã¦ãã‚Œã‚‹å•ã„åˆ
ss_9 2011/05/26
NoSQL

DB

åˆ†æ•£kvs
ãƒªãƒ³ã‚¯
åˆ†æ•£ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ã€Œokuyamaã€ Wiki - åˆ†æ•£ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ã€Œokuyamaã€ - OSDN
æœ€è¿‘ã®æ›´æ–° (Recent Changes)2011-01-14TitleIndex 2010-01-07FrontPage æœ€æ–°ãƒªãƒªãƒ¼ã‚¹æƒ…å ±okuyama (0.9.5)2013-09-20 16:08 Wikiã‚¬ã‚¤ãƒ‰(Guide)Wikiã®æ–‡æ³• ãƒªãƒ³ã‚¯ã®ç¨®é¡žã¨æ–‡æ³• ãƒ–ãƒãƒƒã‚¯ãƒ—ãƒã‚»ãƒƒã‚µ æ‹¡å¼µæ–‡æ³• ã‚µã‚¤ãƒ‰ãƒãƒ¼ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆWikiã§ã®åºƒå‘Šè¨å®š ã‚µã‚¤ãƒ‰ãƒãƒ¼ (Side Bar)ã“ã®ã‚µã‚¤ãƒ‰ãƒãƒ¼ã«ã¤ã„ã¦ ã“ã®ã‚µã‚¤ãƒ‰ãƒãƒ¼ã®ç·¨é›† ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªåž‹åˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ ã€Œokuyamaã€=====================ã€€Javaã§å®Ÿè£…ã•ã‚ŒãŸã€ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªåž‹åˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã€Œokuyamaã€ã«èˆˆå‘³ã‚’ æŒã£ã¦é ‚ãã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ä»¥ä¸‹ç°¡å˜ãªèª¬æ˜Žã§ã™ã€‚ ç°¡å˜ãªæ©Ÿèƒ½èª¬æ˜Žã¨ã‚µãƒ³ãƒ—ãƒ«ã®å®Ÿè¡Œæ–¹æ³•ã‚’ä»¥ä¸‹ã«è¨˜ã—ã¾ã™ã€‚ æ©Ÿèƒ½èª¬æ˜Ž 1.Key-Valueã‚¹ãƒˆã‚¢ Key-Valueã‚¹ãƒˆã‚¢ã‚’å®Ÿç¾ã—
ss_9 2011/05/26
okuyama

DB

åˆ†æ•£kvs
ãƒªãƒ³ã‚¯
Apache Cassandra - Wikipedia
Apache Cassandraï¼ˆã‚¢ãƒ‘ãƒƒãƒ ã‚«ã‚µãƒ³ãƒ‰ãƒ©ï¼‰ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã§ã‚ã‚‹ã€‚å…ƒã¯Facebookç¤¾ã«ãŠã„ã¦å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã®ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸã‚‚ã®ã§ã‚ã‚‹ã€‚Facebookã®ãƒ‡ãƒ¼ã‚¿ãƒãƒ¼ãƒ ã‚’çŽ‡ã„ã‚‹Jeff Hammerbacherã¯Cassandraã‚’Amazon DynamoDBã®ã‚ˆã†ãªã‚¤ãƒ³ãƒ•ãƒ©ã‚¹ãƒˆãƒ©ã‚¯ãƒãƒ£ä¸Šã§å‹•ä½œã™ã‚‹BigTableãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã§ã‚ã‚‹ã¨è¡¨ç¾ã—ã¦ã„ã‚‹ã€‚ Cassandraã¯ã‚¤ãƒ™ãƒ³ãƒãƒ¥ã‚¢ãƒ«ãƒ»ã‚³ãƒ³ã‚·ã‚¹ãƒ†ãƒ³ã‚·ãƒ¼ã«ã‚ˆã‚Šæ§‹é€ åŒ–ã•ã‚ŒãŸã‚ãƒ¼ãƒ»ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’æä¾›ã™ã‚‹ã€‚ã‚ãƒ¼ã¯è¤‡æ•°ã®å€¤ã«ãƒžãƒƒãƒ”ãƒ³ã‚°ã•ã‚Œã€ã“ã‚Œã‚‰ã¯column familyã¨ã—ã¦ã‚°ãƒ«ãƒ¼ãƒ”ãƒ³ã‚°ã•ã‚Œã‚‹ã€‚column familyã¯Cassandraãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒä½œæˆã•ã‚Œã‚‹éš›ã¯å›ºå®šã•ã‚Œã¦ã„ã‚‹ãŒã€å¾Œã«familyã«å¯¾ã—åˆ—ã‚’è¿½åŠ ã™ã‚‹ã“ã¨ã¯å¯èƒ½ã§ã‚ã‚‹ã€‚ã•ã‚‰ã«ã€åˆ—ã¯ç‰¹å®šã®ã‚ãƒ¼ã«ã®ã¿è¿½åŠ ã•ã‚Œã‚‹ã®ã§ã€ã©ã®
ss_9 2011/05/26
DB

cassandra

åˆ†æ•£kvs
ãƒªãƒ³ã‚¯
okuyamaooã®æ—¥è¨˜
Setsunaã®Version-0.0.2ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ Github Sourceforge.jpãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ ä»Šå›žã®ãƒªãƒªãƒ¼ã‚¹ã§ä¸€ç•ªå¤§ããªè¿½åŠ æ©Ÿèƒ½ã¯Serverãƒ¢ãƒ¼ãƒ‰ã®è¿½åŠ ã§ã™ã€‚ 0.0.1ã®æ™‚ã¯ã€Setsunaã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã‚‹æ–¹æ³•ã¯ãƒ‘ã‚¤ãƒ—å…¥åŠ›ã—ã‹ãªã‹ã£ãŸã®ã§ã€ ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§ä½•ã‹ã®å‡ºåŠ›ã‚’ãƒ‘ã‚¤ãƒ—ã§Setsunaã«ç¹‹ãã—ã‹ãªã‹ã£ãŸã®ã§ã€ SetsunaãŒå‹•ã„ã¦ã„ã‚‹ã‚µãƒ¼ãƒä»¥å¤–ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’Setsunaã«æµã›ãªã‹ã£ãŸ ã®ãŒä¸ä¾¿ã§ã—ãŸã€‚ãã“ã§NetWorkè¶Šã—ã«ãƒ‡ãƒ¼ã‚¿ã‚’æµã›ã‚‹ã‚ˆã†ã«ã“ã®æ©Ÿèƒ½ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ èµ·å‹•æ–¹æ³•ã¯ç°¡å˜ã§"-server true"ã¨ã„ã†è¡¨è¨˜ã‚’ä»˜ã‘ã‚‹ã ã‘ã§ã™ã€‚ãŸã Serverãƒ¢ãƒ¼ãƒ‰ã® å ´åˆã¯setsuna.jarå†…ã«å«ã¾ã‚Œãªã„ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ã‚‚ä¾å˜ã—ã¦ã„ã‚‹ã®ã§å¾“æ¥ã®-jaræŒ‡å®šã§ã® èµ·å‹•ã¯å‡ºæ¥ãªããªã£ã¦ã„ã¾ã™ã€‚ä»¥ä¸‹ãŒèµ·å‹•ã‚µãƒ³ãƒ—ãƒ«ã§ã™ã€‚ java -classpath
ss_9 2011/05/26
okuyama

DB

åˆ†æ•£kvs
ãƒªãƒ³ã‚¯
ã‚‚ã†1ã¤ã®ã€DBã®ã‹ãŸã¡ã€åˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã¨ã¯
ã‚‚ã†1ã¤ã®ã€DBã®ã‹ãŸã¡ã€åˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã¨ã¯ï¼šåˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã®æœ¬å‘½ã€ŒBigtableã€ï¼ˆ1ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ RDBã¨ã¯åˆ¥ã®ã€ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æ³¨ç›®ã‚’æµ´ã³ã¦ã„ã‚‹ã€Œåˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã€ã€‚ãã®æœ¬å‘½ã¨ã‚‚ã„ãˆã‚‹ã€Googleã®æ•°ã€…ã®ã‚µãƒ¼ãƒ“ã‚¹ã®åŸºç›¤æŠ€è¡“ã€ŒBigtableã€ã«ã¤ã„ã¦å¾¹åº•è§£èª¬ ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€Œåˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã€ ã‚°ãƒ¼ã‚°ãƒ«ãŒã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ä¸–ç•Œã‚’ã“ã“ã¾ã§å¸ã‘ã‚“ã§ããŸæœ€å¤§ã®ç†ç”±ã¯ä½•ã§ã—ã‚‡ã†ã‹ã€‚å®Ÿã¯ã€ãã‚Œã¯åŒç¤¾ã®å„ªã‚ŒãŸæ¤œç´¢æŠ€è¡“ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã‚°ãƒ¼ã‚°ãƒ«ãŒæˆã—é‚ã’ãŸæœ€ã‚‚å¤§ããªãƒ–ãƒ¬ãƒ¼ã‚¯ã‚¹ãƒ«ãƒ¼ã®1ã¤ã¯ã€åŒç¤¾ãŒç”Ÿã¿å‡ºã—ãŸå·¨å¤§ãªåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã€ã€ŒBigtableã€ã«ã‚ã‚Šã¾ã™ã€‚ Bigtableã¯ã€Googleæ¤œç´¢ã‚’ã¯ã˜ã‚ã€YouTubeã‚„Google Mapã€Google Earthã€Google Analyticsã€Goog
ss_9 2011/05/26
DB

åˆ†æ•£kvs
ãƒªãƒ³ã‚¯
Datatypes In SQLite
1. Datatypes In SQLite Most SQL database engines (every SQL database engine other than SQLite, as far as we know) uses static, rigid typing. With static typing, the datatype of a value is determined by its container - the particular column in which the value is stored. SQLite uses a more general dynamic type system. In SQLite, the datatype of a value is associated with the value itself, not with i
ss_9 2011/05/12
db

Sqlite3
ãƒªãƒ³ã‚¯
SQLite3ã‚’ä½¿ç”¨ã™ã‚‹ - Python Tips
è»½é‡ãƒ»é«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹SQLiteã‚’Pythonã‹ã‚‰æ‰±ã†ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Python2.5ã‹ã‚‰æ¨™æº–ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«å…¥ã‚Šã¾ã—ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä½œæ¥ã¯ä¸è¦ã§ã™ã€‚ ä½¿ç”¨æ–¹æ³• sqlite3ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ #!python2.6 # -*- coding: utf-8 -*- import sqlite3 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ con = sqlite3.connect("data.db") ãƒ•ã‚¡ã‚¤ãƒ«ãŒã™ã§ã«å˜åœ¨ã™ã‚‹ã¨ãã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ãŒãªã„ã¨ãã¯æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ã€‚ isolation_levelã«Noneã‚’æŒ‡å®šã™ã‚‹ã¨ã€è‡ªå‹•ã‚³ãƒŸãƒƒãƒˆãƒ¢ãƒ¼ãƒ‰ã«ãªã‚Šã¾ã™ã€‚ con = sqlite3.connect('temp.db', isolation_level=None) ç‰¹åˆ¥ãªåå‰ã§ã‚ã‚‹ ":memory:" ã‚’ä½¿ã†ã¨RAMä¸Šã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ c
ss_9 2011/05/12
python

DB

sqlite3
ãƒªãƒ³ã‚¯
å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’é«˜é€Ÿã«æŠ•å…¥ã™ã‚‹ã«ã¯ â€” Let's Postgres
FORCIA, Inc. æ¿åž£ è²´è£• PostgreSQL ã«å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’é«˜é€Ÿã«å–ã‚Šè¾¼ã‚€æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ COPY ã¨ã„ã†å°‚ç”¨ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã†ã¨ INSERT ã‚ˆã‚Šã‚‚ãšã£ã¨é«˜é€Ÿã§ã™ã€‚ ã¾ãŸã€COPY ã‚’ä½¿ã†éš›ã«ã²ã¨å·¥å¤«ã™ã‚‹ã¨ã€ã•ã‚‰ã«é€Ÿããªã‚Šã¾ã™ã€‚ é«˜é€Ÿã«ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒ¼ãƒ‰ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ INSERT ã®ä»£ã‚ã‚Šã« COPY FROM ã‚’ä½¿ã† PostgreSQL ã«ã¯ COPY FROM ã¨ã„ã†å¤§é‡ãƒ‡ãƒ¼ã‚¿å–ã‚Šè¾¼ã¿å°‚ç”¨ã®ã‚³ãƒžãƒ³ãƒ‰ãŒã‚ã‚Šã¾ã™ã€‚ COPY ã‚³ãƒžãƒ³ãƒ‰ã¯å¤–éƒ¨ã‹ã‚‰ã‚¿ãƒ–åŒºåˆ‡ã‚Š (.tsv) ã‚„ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Š (.csv) ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã‚ã‚‹ä¸Šã«ã€INSERT ã‚ˆã‚Šã‚‚ãšã£ã¨é«˜é€Ÿã§ã™ã€‚ åŒæ§˜ã«ã€pg_dump ã‚³ãƒžãƒ³ãƒ‰ã‚‚ -d ã‚„ --inserts ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä»˜ã‘ã‚‹ã¨ INSERT ã‚’ä¸¦ã¹ãŸãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œã£ã¦ã—ã¾ã„ã¾ã™ã€‚ ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä»˜ã‘ãªã„ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯é«˜é€Ÿãª COPY å½¢å¼ãªã®ã§ã€
ss_9 2010/11/26
DB

Postgres
ãƒªãƒ³ã‚¯
1