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

Ooo id:Ooo

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

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

IBMã€DB2ã‚’ã€ŒDb2ã€ã«ãƒªãƒ–ãƒ©ãƒ³ãƒ‰ã€‚é–‹ç™ºè€…å‘ã‘ã€ŒDb2 Developer Community Editionã€ã‚‚ç„¡å„Ÿå…¬é–‹ã€‚MacOSç‰ˆã‚‚ç”¨æ„
IBMã€DB2ã‚’ã€ŒDb2ã€ã«ãƒªãƒ–ãƒ©ãƒ³ãƒ‰ã€‚é–‹ç™ºè€…å‘ã‘ã€ŒDb2 Developer Community Editionã€ã‚‚ç„¡å„Ÿå…¬é–‹ã€‚MacOSç‰ˆã‚‚ç”¨æ„ IBMã¯ã“ã‚Œã¾ã§ã€ŒIBM DB2ã€ã¨ã—ã¦å±•é–‹ã—ã¦ããŸåŒç¤¾ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ã€æ–°ãŸã«ã€ŒIBM Db2ã€ã¨ã—ã¦ãƒªãƒ–ãƒ©ãƒ³ãƒ‰ã—ã€JSONã‚µãƒãƒ¼ãƒˆã€ã‚¯ãƒ©ã‚¦ãƒ‰ç‰ˆã€é–‹ç™ºè€…å‘ã‘ã®ç„¡å„Ÿç‰ˆãªã©ã®å±•é–‹ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ é–‹ç™ºè€…å‘ã‘ã«ç„¡å„Ÿç‰ˆã¨ã—ã¦æä¾›ã•ã‚Œã‚‹ã®ãŒã€ŒIBM Db2 Developer Community Editionã€ã€‚Windowsã€MacOSã€Linuxç’°å¢ƒã«å¯¾å¿œã—ã€æœ€å¤§ã§4ã‚³ã‚¢CPUã€16GBãƒ¡ãƒ¢ãƒªã€100GBã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾å¿œã€‚åŒç¤¾ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒç°¡å˜ã§ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦15åˆ†ã§ä½¿ã„å§‹ã‚ã‚‰ã‚Œã‚‹ã¨èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ æœ¬ç•ªç’°å¢ƒã«å¯¾å¿œã—ãŸè£½å“ç‰ˆã¨ã—ã¦ã¯ã€ŒIBM Db2 Direct Standard Editionã€ã€ŒIBM Db
Ooo 2017/06/27
db2

db

ibm

database
ãƒªãƒ³ã‚¯
å„ç¨®DBã®Macç”¨GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ - komagataã®ãƒ–ãƒã‚°
å†…éƒ¨ãƒ„ãƒ¼ãƒ«ï¼ˆåƒ•ã‚‰ã§ã„ãˆã°256interns.comã¨ã‹ï¼‰ã¯ç®¡ç†ç”»é¢ä½œã‚‰ãšGUIã‚¢ãƒ—ãƒªã§å¤‰æ›´ã¨ã‹çµæ§‹ä¾¿åˆ©ã§ã™ã€‚ã¨ã¯ã„ãˆã€railsãªã©ã®ã‚¢ãƒ—ãƒªå´ã®ã¿ã§validationã—ã¦ã‚‹ã¨ä¸æ•´åˆãŒèµ·ãã‚‹ã®ã§è¦æ³¨æ„ã€‚ã“ã‚Œå‰æã§åˆ¶ç´„è¿½åŠ ã™ã‚‹ã®ã‚‚ã„ã„ã‹ã‚‚ï¼Ÿ Sequel Pro MySQLã®GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€‚ã“ã‚Œã‚’æ•™ãˆã¦ã‚‚ã‚‰ã£ã¦è¨ã—ã’ã«ä½¿ã£ã¦ã¿ãŸã‚“ã§ã™ãŒã€ä»Šé¢¨ã®Macã®ä½¿ã„å‹æ‰‹ã§ä½¿ãˆã‚‹ã®ãŒã™ã”ãæ°—ã«å…¥ã£ã¡ã‚ƒã„ã¾ã—ãŸã€‚ SSLçµŒç”±ã‚„sshã§å…¥ã£ãŸã‚µãƒ¼ãƒãƒ¼è¸ã¿å°ã«ã—ã¦ã®æŽ¥ç¶šã‚‚ä¸€ç™ºã§ãã¦ä¾¿åˆ©ã€‚ PG Commander PostgreSQLã®GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€‚Sequel Proã«æ¯”ã¹ã‚‹ã¨ä½¿ã„å‹æ‰‹ã¯è‰¯ããªã„ã‘ã©ã€Herokuã®DBã«æŽ¥ç¶šã§ãã‚‹ï¼ã“ã‚ŒãŒãƒ‡ã‚«ã‚¤ã€‚ æŽ¥ç¶šå…ˆã®ãƒ–ã‚¯ãƒžã‚’ï¼•å€‹ä»¥ä¸Šä¿å˜ã—ã¦ãŠãã«ã¯Lisenceã‚’è²·ã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚Herokuã‚’å¤šç”¨ã™ã‚‹ã‹ã‚‰ï¼•å€‹ã‚ã£ã¨ã„ã†é–“ã«è¶…ãˆã¡ã‚ƒã†ã®ã§è²·ã„ã¾ã—ãŸã€‚ B
Ooo 2014/04/19
GUI

database

db

software

mac
ãƒªãƒ³ã‚¯
æœ€è¿‘ã®Linuxã§æœ‰åŠ¹ã«ãªã£ã¦ã„ã‚‹I/Oãƒãƒªã‚¢æ©Ÿèƒ½ã¨ã€RDBã¸ã®å½±éŸ¿ | Unofficial DB2 BLOG
æ¯”è¼ƒçš„æ–°ã—ã„ã‚«ãƒ¼ãƒãƒ«ã‚’æŽ¡ç”¨ã—ãŸLinuxãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®I/Oãƒãƒªã‚¢ (I/O barrier)æ©Ÿèƒ½ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ãªã£ã¦ã„ã¾ã™ã€‚ä¾‹ãˆã°Redhat Enterprise Linux (RHEL) 6ã‚„SUSE Linux Enterprise Server (SLES) 11ç‰ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç›´å¾Œã®çŠ¶æ…‹ã§ext4ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®I/Oãƒãƒªã‚¢ãŒæœ‰åŠ¹ã«ãªã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ I/Oãƒãƒªã‚¢ã¯ç°¡å˜ã«ã„ã†ã¨ã€ã€Œãƒãƒªã‚¢å‘½ä»¤ã€ã®å¾Œã§ç™ºè¡Œã•ã‚ŒãŸI/Oã¯ã€ãƒãƒªã‚¢å‘½ä»¤ã®å‰ã«ç™ºè¡Œã•ã‚ŒãŸI/Oã®å¾Œã«å¿…ãšå®Ÿè¡Œã•ã‚Œã‚‹ã‚ˆã†ã«ã™ã‚‹ä»•çµ„ã¿ã§ã™ã€‚ã¤ã¾ã‚ŠI/Oã®é †åºï¼ˆç‰©ç†ãƒ‡ã‚£ã‚¹ã‚¯ã«åæ˜ ã•ã‚Œã‚‹é †ç•ªï¼‰ã‚’ã¾ã‚‚ã‚‰ã›ã‚‹ä»•çµ„ã¿ã¨ã„ãˆã¾ã™ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã«I/Oãƒãƒªã‚¢æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚ŒãŸã®ã¯ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ãŒä¸æ•´åˆãªçŠ¶æ…‹ã«ãªã‚‹å¯èƒ½æ€§ã‚’æ¸›ã‚‰ã™ãŸã‚ã§ã™ã€‚ ãã‚‚ãã‚‚ã€æ€¥ãªé›»æºæ–ã§ã‚‚ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ä¸æ•´åˆãŒèµ·ã“
Ooo 2013/11/17
linux

ext4

database

DB

filesystem

performance
ãƒªãƒ³ã‚¯
DBã‚¹ã‚ãƒ¼ãƒžã‚‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã—ãŸã„ï¼
PostgreSQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2013 LightningTalk ï¼ˆ2013-11-13: migr8.rbã®è¨å®šç®‡æ‰€ã‚’è‹¥å¹²ä¿®æ£ï¼‰ ï¼ˆ2013-11-14: SQLite3ã§ã®è¨å®šç‰ã‚’ä¿®æ£ã€ã€Œmigr8.rb new --table=usersã€ã‚’è¿½åŠ ï¼‰
Ooo 2013/11/13
database

migration

DSL

db

postgresql

sql
ãƒªãƒ³ã‚¯
Cassandraã‚µãƒ¼ãƒã®ãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡æ¸›å°‘ã‚¢ãƒ©ãƒ¼ãƒˆãŒé£›ã‚“ã§ããŸï¼ã£ã¦ã¨ãã«ã©ã†å¯¾å‡¦ã™ã‚‹ã‹ - oranie's blog
ä¹—ã‚‹ã—ã‹ç„¡ã„ã€ã“ã®ãƒ“ãƒƒã‚°ã‚¦ã‚§ãƒ¼ãƒ–ã«ã€‚ ï¼ˆã“ã®ã‚¨ãƒ³ãƒˆãƒªã¨ã“ã®ã‚¨ãƒ³ãƒˆãƒªã®ä¸‰ç•ªç…Žã˜ã§ã™ã€‚ï¼‰ - è¿½è¨˜ Cassandraã¯ãƒ‡ãƒ¼ã‚¿é ˜åŸŸã®Diskä½¿ç”¨é‡ãŒ50%ã§ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ã¨è¨˜è¼‰ã—ã¾ã—ãŸãŒã€ã„ããªã‚Šã‚ºãƒ‰ãƒ³ã¨è½ã¡ã‚‹ã¨ã‹ã§ã¯ç„¡ãã€compactionã‚’å®Ÿè¡Œã—ãŸæ™‚ã«ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ¼ãƒ•ã‚¡ã‚¤ãƒ«ä½œæˆã—ã¾ã™ã€‚ã“ã‚Œã¯å¯¾è±¡ã®SSTableã®ã‚µã‚¤ã‚ºã«ä¾å˜ã—ã¾ã™ã€‚ã§ã€ã“ã®ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ¼ãƒ•ã‚¡ã‚¤ãƒ«ãŒä½œæˆã§ããªããªã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹é–¾å€¤ãŒ50%ã§ã™ã€‚ http://wiki.apache.org/cassandra/CassandraHardware_JP ã‹ã‚‰å¼•ç”¨ MemtableSSTableã§è¿°ã¹ã¦ã„ã‚‹ã‚ˆã†ã«ã€ã‚³ãƒ³ãƒ‘ã‚¯ã‚·ãƒ§ãƒ³ã¯æœ€æ‚ªã®å ´åˆã€ä¸€æ™‚çš„ã«ã²ã¨ã¤ã®ãƒœãƒªãƒ¥ãƒ¼ãƒ (ã¤ã¾ã‚Šãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒª)ã«å¯¾ã—ã¦æœ€å¤§ãã®ãƒ‡ãƒ¼ã‚¿ã¨åŒã˜ã ã‘ã®ç©ºãé ˜åŸŸã‚’è¦æ±‚ã—ã¾ã™ã€‚ - ã¾ãšCassandraã§Diskç©ºãé ˜åŸŸãŒæ¸›å°‘ã™ã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã®ã¯ã»ã¼2ã¤ã€‚ã‚¢
Ooo 2013/07/31
Cassandra

disk

data

db

tips

troubleshooting
ãƒªãƒ³ã‚¯
ï¼ ITã‚¤ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼
å¹³ç´ ã‚ˆã‚Šã‚¤ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ï¼‹ãƒã‚°ã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ã‚¤ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ï¼‹ãƒã‚°ã¯ã€ŒITãƒ»è£½é€ æ¥ãƒ»ãƒ“ã‚¸ãƒã‚¹é–¢ä¿‚ã®ã‚¤ãƒ™ãƒ³ãƒˆï¼ˆã‚»ãƒŸãƒŠãƒ¼ãƒ»å±•ç¤ºä¼šãƒ»å‹‰å¼·ä¼šãƒ»ã‚³ãƒ³ãƒ†ã‚¹ãƒˆãƒ»Webã‚¤ãƒ™ãƒ³ãƒˆãªã©ï¼‰ã‚’é–‹å‚¬ã™ã‚‹ä¼æ¥ãƒ»ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãŒç™»éŒ²ã—ãŸã‚¤ãƒ™ãƒ³ãƒˆæƒ…å ±ã®ãƒãƒ¼ã‚¿ãƒ«ã‚µã‚¤ãƒˆã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€ã‚¤ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ï¼‹ãƒã‚°ã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªã‚¤ãƒ™ãƒ³ãƒˆæƒ…å ±ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¤ãƒ™ãƒ³ãƒˆæƒ…å ±ã®å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„ã‚¤ãƒ™ãƒ³ãƒˆç´¹ä»‹ã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´6æœˆ30æ—¥ï¼ˆç«ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚¤ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ï¼‹ãƒã‚°ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰
Ooo 2013/07/19
PostgreSQL

database

db
ãƒªãƒ³ã‚¯
Redgate Flyway - Automate database deployments across teams and technologies
Redgate Test Data ManagerImprove your release quality and reduce your risk, with the flexibility to fit your workflow
Ooo 2013/03/23
database

java

DB

DevOps

migration

flyway
ãƒªãƒ³ã‚¯
åˆ†æ•£ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ä¸Šã§ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®å®Ÿè£…
Please select the category that most closely reflects your concern about theÂ presentation, so that we can review it and determine whether it violates our Terms of Use or isn't appropriate for all viewers.
Ooo 2012/09/01
kvs

transaction

DB
ãƒªãƒ³ã‚¯
Mongo DB Casual Talksã«è¡Œã£ã¦ããŸ - matsuou1ã®æ—¥è¨˜
ã‚ã‚“ã¾ã‚ŠMongo DB Casual Talks ã®ãƒ–ãƒã‚°ãŒãªã„ã‚ˆã†ãªã®ã§ã€ã–ã£ãã‚Šæ›¸ãã¾ã™ã€‚ ã€ŒMongo DBã®ã‚¢ãƒ¬ã‚’ã‚¢ãƒ¬ã™ã‚‹ã€ by [twitter:@kuwa_tw] ã•ã‚“ ã‚¯ãƒ©ã‚¹ã‚¿ãŒé…ã„1 å¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’ä¸€æ°—ã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆ oplogãŒè¨±å®¹ç¯„å›²ã‚’è¶…ãˆã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒåœæ¢ PrimaryShardã«ChunkãŒæºœã¾ã£ã¦I/Oãƒã‚¦ãƒ³ãƒ‰ã« è² è·ãŒé«˜ã„ã®ã§Balancerã¯å‹•ã‹ãªã„ ã‚¯ãƒ©ã‚¹ã‚¿ãŒé…ã„2 Shardã™ã‚‹Collectionã®Shardè¨å®šæ¼ã‚Œ PrimaryShardã§ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ãŒå¤šããªã‚Šã¤ã¥ã‘ã¦ãƒ¡ãƒ¢ãƒªãƒžãƒƒãƒ—ãƒ‰ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’ã“ãˆã¦I/Oãƒã‚¦ãƒ³ãƒ‰ Shardã—ã¦ãªã„ã®ã§ã‚‚ã¡ã‚ã‚“Balancerã¯å‹•ã‹ãªã„ æœ¬å½“ã«çªç„¶ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ€ã‚¦ãƒ³ã™ã‚‹ PrimaryShardã¯ä½™è£•ã‚’æŒãŸã›ã¦ãŠã Shardè¨å®šã¯å®šæœŸçš„ã«ç¢ºèªã€ã‚‚ã—ãã¯Shardã®è¨å®šã‚’è‡ªå‹•åŒ–ã™ã‚‹ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
Ooo 2012/07/09
mongodb

db

collection
ãƒªãƒ³ã‚¯
DBã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£
MySQLã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹æ•°ãŒéžå¸¸ã«å¤šã„Webã‚µã‚¤ãƒˆã«ãŠã„ã¦ã€MySQLã®SLAVEã‚µãƒ¼ãƒãƒ¼ã‚’è¤‡æ•°å°ä¸¦ã¹ã¦è² è·åˆ†æ•£ã•ã›ã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ˆãè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ãŸã ã€Webã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¯ä¸€èˆ¬çš„ãªãƒ†ãƒ¼ãƒžãªã®ã§ã„ã‚ã„ã‚ãªã¨ã“ã‚ã§èªžã‚‰ã‚Œã¦ã„ã‚‹ã®ã«å¯¾ã—ã€DBã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¨ã„ã†ãƒ†ãƒ¼ãƒžã¯ä¸€èˆ¬çš„ã§ãªã„ã®ã‹ã‚ã¾ã‚Šèªžã‚‰ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ„Ÿã˜ã¾ã™ã€‚ DBã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ã«ã‚ãŸã£ã¦ä¸€ç•ªè’ã£ã½ã„æ–¹æ³•ã¯ã€Webã‚µãƒ¼ãƒãƒ¼ä¸Šã®ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä¸ã§ã©ã®SLAVEã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šã™ã‚‹ã‹ã‚’ãƒ©ãƒ³ãƒ€ãƒ ã§æ±ºã‚ã‚‹æ–¹æ³•ã§ã™ã€‚ãƒ©ãƒ³ãƒ€ãƒ ã¨è¨€ã£ã¦ã‚‚é•·æ™‚é–“ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã»ã¼æŽ¥ç¶šå…ˆãŒå‡ç‰åŒ–ã•ã‚Œã‚‹ã®ã§ã€ä¸€è¦‹ã“ã®æ–¹æ³•ã§ã‚‚å•é¡Œãªã„ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ã—ã‹ã—ã“ã®æ–¹æ³•ã ã¨ã€æŽ¥ç¶šã—ã«è¡Œã“ã†ã¨ã—ãŸSLAVEã‚µãƒ¼ãƒãƒ¼ãŒé«˜è² è·ã‚‚ã—ãã¯ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ä¸ã§ã‚ã£ã¦ã‚‚æ§‹ã‚ãšæŽ¥ç¶šã—ã«è¡Œã£ã¦ã—ã¾ã†ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªå•é¡Œã‚’è§£æ±ºã™ã‚‹
Ooo 2011/07/22
db

mysql

database
ãƒªãƒ³ã‚¯
MongoDBã§ä½œã‚‹ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ‡ãƒ¼ã‚¿æ–°è§£æžåŸºç›¤
This document discusses using Mongo DB to analyze user data from a game platform. It includes examples of queries on collections like user_charge, daily_charge, user_trace, and daily_trace to retrieve user activity and purchase data for a given date range. It also shows an example of retrieving user registration information and calculating metrics for user retention and engagement. The document dem
Ooo 2011/05/18
mongodb

slide

presentation

database

db
ãƒªãƒ³ã‚¯
Architecture by Accident
This document discusses how architecture emerges even when not initially planned. It begins with an overview of databases, message queues, and caching as common architectural elements that emerge over time. The document then provides examples of how simple applications and data needs can evolve into more complex architectures with multiple servers, databases, caching, and services. It em phasizes t
Ooo 2011/05/09
architecture

database

db

mongodb

redis
ãƒªãƒ³ã‚¯
GitHub - guileen/node-mongoskin: The future layer for node-mongodb-native.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
Ooo 2011/05/09
node.js

javascript

mongodb

db

database
ãƒªãƒ³ã‚¯
Cassandraãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«å…¥é–€ - Arin Sarkissian - Digital Romanticism
ã“ã®è¨˜äº‹ã¯ã€Arin Sarkissianæ°ã®ãƒ–ãƒã‚°è¨˜äº‹ã€Œhttp://arin.me/blog/wtf-is-a-supercolumn-cassandra-data-modelã€ã‚’æ°ã®è¨±å¯ã‚’å¾—ã¦ç¿»è¨³ã—ãŸã‚‚ã®ã§ã™ã€‚ï¼ˆåŽŸæ–‡å…¬é–‹æ—¥ï¼š2009å¹´9æœˆ1æ—¥ï¼‰ ã“ã“ï¼‘ã€ï¼’ãƒ¶æœˆã¨ã„ã†ã‚‚ã®ã€Diggã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒãƒ¼ãƒ ã¯Cassandraã«ã¤ã„ã¦èª¿ã¹ã€éŠã³ã€æœ€çµ‚çš„ã«ã¯ãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ã«ãƒ‡ãƒ—ãƒã‚¤ã™ã‚‹ãŸã‚ã«ã‹ãªã‚Šã®æ™‚é–“ã‚’è²»ã‚„ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¯å®Ÿã«æ¥½ã—ã„ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã—ãŸãŒã€æ¥½ã—ããªã‚‹å‰ã«Cassandraã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦ç†è§£ã™ã‚‹ãŸã‚ã«ç›¸å½“ã®æ™‚é–“ã‚’è²»ã‚„ã—ãŸã®ã§ã™ã€‚ã€Œ'super column'ã£ã¦ä½•ã ã‚ˆã€ã¨ã„ã†ãƒ•ãƒ¬ãƒ¼ã‚ºãŒä½•åº¦ã‚‚å£ã«ã•ã‚Œã¾ã—ãŸã€‚ ã‚‚ã—ã‚ãªãŸã®ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ãŒRDBMSãªã‚‰ã°ï¼ˆã»ã¨ã‚“ã©ã¿ã‚“ãªãŒãã†ã§ã—ã‚‡ã†ãŒï¼‰ã€Cassandraã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦å¦ã¶éš›ã«ã€ã„ãã¤ã‹ã®ãƒãƒ¼ãƒŸãƒ³ã‚°è¦ç´„ã§
Ooo 2010/07/05
Cassandra

database

NoSQL

kvs

DB
ãƒªãƒ³ã‚¯
ã¸ã€œãŸã®ã‚ã‚‚:Riak ã¨ Cassandra ã¨ HBaseã€ã‚ã‚‰ã¾ãƒ¼! - livedoor Blogï¼ˆãƒ–ãƒã‚°ï¼‰
2010å¹´05æœˆ25æ—¥ Riak ã¨ Cassandra ã¨ HBaseã€ã‚ã‚‰ã¾ãƒ¼! Mozilla Blog Riak and Cassandra and HBase, Oh My!ã®å‹æ‰‹è¨³ã€‚å„åˆ†æ•£ KVS ã®ç‰¹å¾´ãŒåˆ†æžã•ã‚Œã¦ã„ã¦èˆˆå‘³æ·±ã„â€¦â€¦ã¨æ€ã£ã¦è¨³ã—ã¦ã¿ãŸã€‚ã“ã®ç„¡æ§˜ãªã‚¿ã‚¤ãƒˆãƒ«ã¯ Google ç¿»è¨³ã«ã‚ˆã‚‹ã€‚ Riak ã¨ Cassandra ã¨ HBaseã€ã‚ã‚‰ã¾ãƒ¼! æˆ‘ã€…ã¯ã€SoCorro Crash ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ãŠã„ã¦ HBase ã¨ã®çµ±åˆã‚’é€²ã‚ã¦ã„ã‚‹ãŒã€ãã®è©±ã¯ã¡ã‚‡ã£ã¨ç½®ã„ã¦ãŠã„ã¦ã€ä»Šå›žã¯ãƒ¡ãƒˆãƒªãƒƒã‚¯ãƒ»ãƒãƒ¼ãƒ ãŒå·»ãè¾¼ã¾ã‚Œã¦ã„ã‚‹åˆ¥ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã¤ã„ã¦è©±ã‚’ã—ã‚ˆã†ã€‚ Mozilla Labs Test Pilotã¯ã€å®Ÿä¸–ç•Œã® Firefox ãƒ¦ãƒ¼ã‚¶ã‚’ã‹ã‚‰é›†ã‚ãŸãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æžã—ã¦ã€ãƒ¦ãƒ¼ã‚¶ãƒ»ã‚¨ã‚¯ã‚¹ãƒšãƒªã‚¨ãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®å®Ÿé¨“ã‚’ã—ãŸã‚Šã€å®šé‡çš„ãƒ‡ãƒ¼ã‚¿ã‚’é›†ã‚ãŸã‚Šã™ã‚‹ãŸã‚ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã ã€‚ ç§
Ooo 2010/07/03
hbase

Cassandra

KVS

db

nosql

Riak
ãƒªãƒ³ã‚¯
ç‹¬ã‚Šè¨€v6 Â» VoltDBç™»å ´ â€“ RDBMSã®ã‚ˆã†ã§RDBMSã§ã¯ãªã„æ–°ã‚·ã‚¹ãƒ†ãƒ
æœ€è¿‘ã¾ãŸè¶…ä¸¦åˆ—DBã®ãƒ‡ã‚¶ã‚¤ãƒ³ã‚’é€²ã‚ãŸã‚ŠRethinkDBã®è©±ã‚’æ›¸ã„ã¦ã¿ãŸã‚Šã¨ã¾ãŸRDBMSã¥ã„ã¦ã„ã‚‹ãŒã€ãã‚“ãªã“ã¨ã‚’ã—ã¦ã„ã‚‹ã†ã¡ã«ä¸–ã®ä¸ã§ã¯å®Ÿéš›ã«ä¸¦åˆ—DBãŒç™»å ´ã—ã¦ã—ã¾ã£ãŸã€‚ INGRES,POSTGRES,Illustraï¼ˆã¨ã€èª°ã‚‚çŸ¥ã‚‰ãªã„Mariposa)ã¨ã€RDBMSã®ä¸–ç•Œã§é©æ–°çš„ãªä»•äº‹ã‚’ã—ã¦ã„ã‚‹Michael Stonebrakeråšå£«ã€‚æœ€è¿‘ä½•ã‚„ã£ã¦ã„ã‚‹ã®ã‹ã¨æ€ã£ãŸã‚‰ã„ã¤ã®é–“ã«ã‚„ã‚‰H-Storeãªã‚‹æ–°åž‹ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã«æºã‚ã£ã¦ã„ã¦ã€ãã‚ŒãŒã„ã¤ã®é–“ã«ã‹SQLæ©Ÿèƒ½ã‚’ã‚‚ã£ã¦VoltDBã¨ã„ã†ãƒ—ãƒãƒ€ã‚¯ãƒˆã¨ã—ã¦ã‚„ã£ã¦ããŸã€‚ã‹ã‚Œã“ã‚Œ40å¹´è¿‘ãæ¥ç•Œã®ç¬¬ä¸€ç·šã«ã„ã‚‹ã“ã¨ã«ãªã‚‹ã€‚ ã€ŒNoSQLã€ã‚’ä¸Šå›žã‚‹æ€§èƒ½ã‚’ç›®æŒ‡ã™æ¬¡ä¸–ä»£åž‹é«˜é€ŸSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒVoltDBã€ç™»å ´ ãªã©ã¨ã„ã†è¨˜äº‹ã‚’è¦‹ã¦ã³ã£ãã‚Šã—ãŸæ¬¡ç¬¬ã ã€‚NoSQLä¸¦ã®æ€§èƒ½ã¨RDBMSä¸¦ã®ACIDæº–æ‹ ã€ãã—ã¦SQLæ§‹æ–‡ãŒä½¿ãˆã‚‹ã¨ã„ã†ã€ã“ã‚Œã¾ãŸå¤¢ã®ã‚ˆã†ãªã‚·
Ooo 2010/06/01
RDBMS

SQL

database

VoltDB

DB

NoSQL
ãƒªãƒ³ã‚¯
SQL Serverã¨Oracleã®ä¸€ç•ªå¤§ããªé•ã„ï¼šãƒ™ãƒ³ãƒãƒ£ãƒ¼ç¤¾é•·ã§æŠ€è¡“è€…ã§ï¼šã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ©ã‚¤ãƒ•
æ ªå¼ä¼šç¤¾ã‚¸ãƒ¼ãƒ¯ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã®ä»£è¡¨å–ç· å½¹ã€‚ æ–°ã—ã„ã‚‚ã®ã‚’ç”Ÿã¿å‡ºã—ã¦ä¸–ã®ä¸ã‚’ã‚ã£ã¨ã„ã‚ã›ãŸã„ã€‚ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã£ã¦ã‚„ã¤èµ·ã“ã›ãŸã‚‰ã„ã„ãªã€‚ ã¶ã£ã¡ã‚ƒã‘ã¦ã€SQL Serverã‚‚ã€Oracleã‚‚ã€ãƒ•ãƒªãƒ¼ã®PostgreSQLã‚‚ã€RDBMSã¨ã—ã¦ã®æœ¬è³ªçš„ãªæ€§èƒ½å·®ã¯æœ¬å½“ã«å°ã•ã„ã€‚ãã®ãŸã‚RDBMSã®ãƒ™ãƒ³ãƒ€ãƒ¼ã‚’é¸æŠžã™ã‚‹ã®ã¯ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ã‹ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‹ã€ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ãªã©ã®æ©Ÿèƒ½ã‚„é–¢é€£ãƒ„ãƒ¼ãƒ«ã®ã§ãã¨ã€IDEã¨ã®ç›¸æ€§ãªã©ã‚’æ¤œè¨Žã™ã‚‹ã®ãŒè‰¯ã„ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã—ã€ä¸€èˆ¬çš„ã«ã‚ã¾ã‚Šæ¤œè¨Žã®å¯¾è±¡ã«ãªã£ã¦ãªã„éƒ¨åˆ†ãŒã€å®Ÿã¯ä¸€ç•ªå¤§ããªé•ã„ã ã£ãŸã‚Šã—ã¾ã™ã€‚ã‚ãŸã—ã¯ã€SQL Serverã¨Oracleã®å·®ã§ã€ã‚‚ã£ã¨ã‚‚å¤§ãã„ã®ã¯ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚°ãƒ©ãƒ ï¼ˆãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ãƒ»ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ï¼‰ã®æ›¸ãæ–¹ï¼ˆæ§‹æ–‡ï¼‰ã®é•ã„ã ã¨æ€ã„ã¾ã™ã€‚ å˜ç´”ãªãƒã‚¸ãƒƒã‚¯ã¯Oracleã®æ–¹ãŒæ›¸ãã‚„ã™ã„ã€‚SQL Serverã®Ifãªã©ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆãƒ–ãƒãƒƒã‚¯ã«BEGIN
Ooo 2010/05/11
oracle

SQLServer

db

RDBMS
ãƒªãƒ³ã‚¯
http://agilecatcloud.com/2010/02/10/
Ooo 2010/04/10
Cassandra

cloud

db

nosql
ãƒªãƒ³ã‚¯
Google Groups
î€Content unavailable Click here to try again. If you've seen this page more than once, try switching accounts.
Ooo 2010/04/10
SQL

nosql

community

OSS

DB
ãƒªãƒ³ã‚¯
Good night, Posterous
Posterous Spaces is no longer available Thanks to all of my @posterous peeps. Y'all made this a crazy ride and it was an honor and pleasure working with all of y'all. Thanks to all of the users. Thanks to the academy. Nobody will read this.
Ooo 2010/04/10
Cassandra

hadoop

bigtable

db

hbase
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸