[B! database] aroma_blackã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

aroma_black id:aroma_black

databaseã«é–¢ã™ã‚‹aroma_blackã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

JJUG CCC 2017 Springã§è«–ç†å‰Šé™¤ãƒ•ãƒ©ã‚°ã‚’ã©ã†ã«ã‹ã™ã‚‹ãŸã‚ã®è©±ã‚’ã—ã¦ãã¾ã—ãŸ ã€FOLIOã‚¹ãƒãƒ³ã‚µãƒ¼ã€‘ - itohiro73â€™s blog
JJUG CCC 2017 Springã§ã€ã€Œãƒ‡ãƒ¼ã‚¿å±¥æ´ç®¡ç†ã®ãŸã‚ã®ãƒ†ãƒ³ãƒãƒ©ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¨Reladomoã®ç´¹ä»‹ã€ã¨ã„ã†è©±ã‚’ã—ã¦ãã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿å±¥æ´ç®¡ç†ã®ãŸã‚ã®ãƒ†ãƒ³ãƒãƒ©ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¨Reladomoã®ç´¹ä»‹ #jjug_ccc #ccc_g3 from Hiroshi Ito ä»Šå›žã®ç™»å£‡ã¯ã€æ ªå¼ä¼šç¤¾FOLIOã®ã‚¹ãƒãƒ³ã‚µãƒ¼ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã™ï¼FOLIOã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ã®å…¥ç¤¾ã‚¨ãƒ³ãƒˆãƒªãƒ¼è¨˜äº‹ã‚‚ã”å‚è€ƒãã ã•ã„ã€‚Toggetterã¯ä¸‹ã®ãƒªãƒ³ã‚¯ã‹ã‚‰ã€‚ togetter.com ä¸–ã®ä¸ã®ã¿ãªã•ã‚“ãŒã€Œè«–ç†å‰Šé™¤ãƒ•ãƒ©ã‚°ã€ã‚’ä½¿ã„ãŸããªã‚‹ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦ã¯ã€å®Ÿã¯ã€Œå‰Šé™¤ã€ã§ã¯ãªãåˆ¥ã®ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ã‚’å®Ÿè£…ã—ãŸã„ã ã‘ã§ã‚ã‚‹ã“ã¨ãŒã»ã¨ã‚“ã©ã ã¨æ€ã„ã¾ã™ã€‚ ãŸã¨ãˆã°è«–ç†å‰Šé™¤ãƒ•ãƒ©ã‚°ã¨ã„ã†åã®æ»äº¡ãƒ•ãƒ©ã‚° - @ledsun blogã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’å‚è€ƒã«ã•ã›ã¦ã„ãŸã ãã¨ã€ä¸‹è¨˜ã®ã‚ˆã†ãªè¦ä»¶ã®ä¾‹ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ»ç¤¾å“¡ãŒé€€è·ï¼ˆãƒ»è»¢
aroma_black 2017/07/31
â€œãƒã‚¤ãƒ†ãƒ³ãƒãƒ©ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«â€

database
ãƒªãƒ³ã‚¯
State of SQL Antipatterns in 2017
2017/07/10 SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³Night Part2 https://connpass.com/event/59946/
aroma_black 2017/07/12
SQL

database
ãƒªãƒ³ã‚¯
SQLè„³ã«å„ªã—ã„MongoDBã‚¯ã‚¨ãƒªãƒ¼å…¥é–€ - taka512's blog
mongoã‚³ãƒžãƒ³ãƒ‰ã‹ã‚‰æŽ¥ç¶šã—ãŸéš›ã«ã‚ªãƒ¼ãƒ«ãƒ‰ã‚¿ã‚¤ãƒ—(SQLè„³)ãŸã‚‹æˆ‘ã€…äººé¡žã«ã‚‚ èª¿ã¹ã‚„ã™ã„å½¢ã§insertã€selectã€updateã‚’è¡Œã†æ–¹æ³•ã‚’èª¿ã¹ã¾ã—ãŸã€‚ å®šç¾©å‚ç…§ // use [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å] use [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å] // show databases show dbs // show tables show collectionså‚ç…§ç³» // select * from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å].find() // select * from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] where x=4 db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å].find({x:4}) // select j from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] where x=4 db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å].find({x:4}, {j:1}) // select * from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] limit 1 db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³
aroma_black 2011/11/08
database

MongoDB
ãƒªãƒ³ã‚¯
ã‚¹ã‚ãƒ¼ãƒžãƒ‡ã‚¶ã‚¤ãƒ³ - Docs-Japanese - 10gen Confluence
å°Žå…¥ Mongoã§ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ã‚¶ã‚¤ãƒ³ã§ã™ã‚‹ã‚ˆã†ãª"æ£è¦åŒ–"ã¯ãã‚Œã»ã©å¿…è¦ã‚ã‚Šã¾ã›ã‚“ã€‚ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã§ã®"join"ãŒãªã„ã‹ã‚‰ã§ã™ã€‚ä¸€èˆ¬çš„ã«ã¯ã€1ã¤ã®æœ€ä¸Šä½ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ¬ãƒ™ãƒ«ã«å¯¾ã—ã¦ã€1ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã“ã¨ã«ãªã‚‹ã§ã—ã‚‡ã†ã€‚ ã™ã¹ã¦ã®"class"ã«ã¤ã„ã¦ã€ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã“ã¨ã¯ã‚ã¾ã‚Šã—ã¾ã›ã‚“ã€‚ä»£ã‚ã‚Šã«embedã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½¿ã„ã¾ã™ã€‚ä¾‹ãˆã°ã€ä¸‹è¨˜ã®å›³ã§ã¯ã€studentsã¨coursesã®2ã¤ã®ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ãŒã‚ã‚Šã¾ã™ã€‚studentãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯ã€courseã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã‚’å‚ç…§ã™ã‚‹"address"ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’embedã—ã¾ã™ã€‚ scoreã‚’ä»–ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å…¥ã‚Œã€å¤–éƒ¨ã‚ãƒ¼ã¨ã—ã¦studentãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æŒã¤ã“ã¨ã«ãªã‚‹ã§ã‚ã‚ã†ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãªã‚¹ã‚ãƒ¼ãƒžã¨å¯¾æ¯”ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ Embed (çµ„ã¿è¾¼ã¿) vs. Reference (å‚ç…§) M
aroma_black 2011/11/08
reference

mongodb

database
ãƒªãƒ³ã‚¯
NoSQLã‚’RDBã®ä»£ã‚ã‚Šã«ä½¿ã†ã¨ã€ã©ã†ã„ã†æã‚ã—ã„ã“ã¨ãŒèµ·ã“ã‚‹ã‹ã€‚PARTAKEã®ä½œè€…ãŒèªžã‚‹
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã§ã„ã¾æ³¨ç›®ã•ã‚Œã¦ã„ã‚‹ã®ãŒNoSQLã€‚ç‰¹ã«ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¯ã€ã‚°ãƒ¼ã‚°ãƒ«ã®BigTableã€Facebookã‚„TwitterãŒå†…éƒ¨ã§åˆ©ç”¨ã—ã¦ã„ã‚‹Cassandraã‚„Amazonã‚¯ãƒ©ã‚¦ãƒ‰ãŒæä¾›ã—ã¦ã„ã‚‹SimpleDBãªã©ã€ã™ã§ã«å®Ÿéš›ã«ä½¿ã‚ã‚Œå§‹ã‚ã¦ã„ã¾ã™ã€‚ ã§ã¯ãã®NoSQLã‚’ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä»£ã‚ã‚Šã«ä½¿ã£ã¦ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã™ã‚‹ã¨ã©ã†ãªã‚‹ã®ã‹ï¼Ÿ èº«ã‚’ã‚‚ã£ã¦ä½“é¨“ã—ãŸã“ã¨ã‚’è¨˜ã—ãŸShinya Kawanakaæ°ã«ã‚ˆã‚‹ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã€Œé–“é•ã£ãŸæ–¹å‘ã«Cassandraã‚’ä½¿ã£ã¦ã¿ãŸã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ NoSQLã‚’ç”¨ã„ãŸã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã‚‹æ§‹ç¯‰ã©ã†é•ã†ã®ã‹ï¼Ÿ ã¨ã¦ã‚‚åˆ†ã‹ã‚Šã‚„ã™ãã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ã”æœ¬äººã®æ‰¿è«¾ã‚‚ã„ãŸã ã„ãŸã®ã§ã€ãã®å†…å®¹ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ NoSQLã‚’ä½¿ã£ãŸã¨ãã«èµ·ã“ã‚‹æã‚ã—ã„äº‹ä¾‹ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ†ãƒ¼ãƒžã¯ã€ŒNoSQLã‚’
aroma_black 2011/10/31
nosql

database

cassandra
ãƒªãƒ³ã‚¯
ã„ãã‚ãŸã‚Šã°ã£ãŸã‚Šã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨æ•™è¨“
ã‚¹ãƒ©ã‚¤ãƒ‰ã®ä½œè€…ã§ã‚ã‚‹Gleicon Moraesã¯ã€ã“ã‚Œã‚‰ã®å›³ã‚’ç¤ºã—ãŸä¸Šã§ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¬ãƒ ãƒ†ãƒ¼ãƒ—ã®ã‚ˆã†ã«ã¤ãŽã¯ãŽã§ä½¿ãˆã‚‹ã‚ˆã†ãªä¸‡èƒ½è–¬ã§ã¯ãªã„ã€‚ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚„éžæ£è¦åŒ–ãªã©ã¯æ¤œè¨Žã™ã¹ãã‚ˆã„é¸æŠžè‚¢ã§ã‚ã‚Šã€ã¾ãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ä»¥å¤–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚é¸æŠžè‚¢ã¨ã—ã¦ã„ã‚Œã‚‹ã¨ã‚ˆã„ã ã‚ã†ã¨èª¬ã„ã¦ã„ã¾ã™ã€‚ ãã—ã¦æ¬¡ã®ã‚ˆã†ãªã€Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–“é•ã£ãŸä½¿ã„æ–¹10é …ç›®ã€ã‚’ç¤ºã—ã¦ã„ã‚‹ã®ã§ã™ï¼ˆè¨³ã¯å‰è¿°ã®è¨˜äº‹ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–“é•ã£ãŸä½¿ã„æ–¹10é …ç›®ã€ã‹ã‚‰ï¼‰ã€‚ Dynamic table creationï¼ˆå‹•çš„ãªãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆï¼‰ Table as cacheï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã—ã¦ä½¿ã†ï¼‰ Table as queueï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚ãƒ¥ãƒ¼ã¨ã—ã¦ä½¿ã†ï¼‰ Table as log fileï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒã‚°ã¨ã—ã¦ä½¿ã†ï¼‰ Distributed Global Lockingï¼ˆåˆ†æ•£ã—ãŸã‚°ãƒãƒ¼ãƒãƒ«ãªãƒãƒƒã‚¯ï¼‰
aroma_black 2011/05/18
database

architecture
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–“é•ã£ãŸä½¿ã„æ–¹10é …ç›®
ä¸€èˆ¬çš„ãªã‚·ã‚¹ãƒ†ãƒ ã§åºƒãåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ãŒã€ã‚·ã‚¹ãƒ†ãƒ ã®é€²åŒ–ã¨å…±ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚‚è¤‡é›‘ã«ãªã‚ŠãŒã¡ã§ã™ã€‚RestMQã®ä½œè€…ã€Gleicon Moraesæ°ã®å…¬é–‹ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰ãŒã‚·ã‚¹ãƒ†ãƒ ãŒè¤‡é›‘åŒ–ã—ã¦ã„ãæ§˜åã‚’ã‚ã‹ã‚Šã‚„ã™ãèª¬æ˜Žã—ãŸä¸Šã§ã€Œã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã‚’æç¤ºã—ã¦ã„ã¾ã—ãŸã€‚ ãã‚Œã«ã‚ˆã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ å‹•çš„ãªãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã—ã¦ä½¿ã† ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚ãƒ¥ãƒ¼ã¨ã—ã¦ä½¿ã† ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒã‚°ã¨ã—ã¦ä½¿ã† åˆ†æ•£ã—ãŸã‚°ãƒãƒ¼ãƒãƒ«ãªãƒãƒƒã‚¯ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ ä½¿ã‚ã‚Œãªã„é …ç›® JOINåœ°ç„ ORMã«ã‚ˆã£ã¦ç¹°ã‚Šè¿”ã•ã‚Œã‚‹ã‚¯ã‚¨ãƒª è² è·ã®ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ« ã©ã‚Œã‚‚ç†ç”±ãŒã‚ã£ã¦æŽ¡ç”¨ã•ã‚Œã‚‹ãƒ‡ã‚¶ã‚¤ãƒ³ã§ã™ãŒã€ç¢ºã‹ã«å¾Œã«å•é¡Œã‚’å¼•ãèµ·ã“ã—ãŸçµŒé¨“ã‚‚ã‚ã‚Šè€³ãŒç—›ã„æ„Ÿã˜ã§ã™ãã€‚ã‚¹ãƒ©ã‚¤ãƒ‰å†…ã§ã¯ãã‚Œãžã‚Œã®å•é¡Œã«ã¤ã„ã¦ã®è§£æ±ºç–ã¨ã—ã¦Mongo DBã‚„RestMQãªã©ã®åˆ©ç”¨ã‚’é€²ã‚ã¦ã„ã¾ã™ã€‚ã€Œ
aroma_black 2011/05/18
programming

database
ãƒªãƒ³ã‚¯
DBã®ã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã€ãŒå¿…è¦ãªç†ç”±ã€€ ï¼ˆPostgreSQLã§ï¼Œãƒ•ã‚¡ãƒ³ãƒˆãƒ ãƒ»ãƒªãƒ¼ãƒ‰ã‚’é˜²æ¢ã™ã¹ãã‚µãƒ³ãƒ—ãƒ«äº‹ä¾‹ï¼‰ - ä¸»ã«è¨€èªžã¨ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«é–¢ã—ã¦
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ï¼Œã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã€ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚ ä»¥ä¸‹ã§ã¯ï¼Œãã‚ŒãŒ ãªãœå¿…è¦ãªã®ã‹ï¼Ÿ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒ¬ãƒ™ãƒ«ã§ã¯ï¼Œã©ã†ã—ã¦é§„ç›®ãªã®ã‹ï¼Ÿ PostgreSQLã§ã¯ï¼Œã©ã†ã‚„ã£ã¦ãƒ¬ãƒ™ãƒ«ã‚’å¤‰æ›´ãƒ»ç¢ºèªã™ã‚‹ã®ã‹ï¼Ÿ ãªã©ã‚’å–ã‚Šä¸Šã’ã‚‹ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ« ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã¨ã¯ï¼š è¤‡æ•°ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒåŒæ™‚ã«å®Ÿè¡Œã•ã‚ŒãŸå ´åˆã«ã€ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®å½±éŸ¿ãŒã©ã®ãã‚‰ã„ã€Œåˆ†é›¢ã€ã™ã‚‹ã‹ï¼Œã®ãƒ¬ãƒ™ãƒ«ã€‚ ANSIè¦æ ¼ã§ã¯ï¼Œï¼”ã¤ã®ãƒ¬ãƒ™ãƒ«ãŒã‚ã‚‹ã€‚ READ UNCOMMITTED ï¼ˆä¸€ç•ªä½Žã„ï¼‰ READ COMMITTED REPEATABLE READ SERIALIZABLEï¼ˆä¸€ç•ªé«˜ã„ï¼‰ å¾¹åº•æ¯”è¼ƒ!! PostgreSQL vs MySQLã€€ç¬¬ï¼“å›žï¼šãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æ¯”è¼ƒ http://thinkit.co.jp/free/article/060... ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã«è©³ã—ã
aroma_black 2011/01/31
database
ãƒªãƒ³ã‚¯
- ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é€²åŒ–çš„è¨è¨ˆ
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é€²åŒ–çš„è¨è¨ˆ Martin Fowler Pramod Sadalage åŽŸæ–‡(Evolutionaly Database Design) ã“ã“ä½•å¹´ã‹ã§ç§ãŸã¡ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºã«å³ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆã‚’é€²åŒ–ã•ã›ã‚‹ã“ã¨ã‚’å¯èƒ½ã«ã™ã‚‹æŠ€æ³•ã‚’ç·¨ã¿å‡ºã—ãŸã€‚ã“ã®ã“ã¨ã¯ã‚¢ã‚¸ãƒ£ã‚¤ãƒ«ãƒ¡ã‚½ãƒƒãƒ‰ã«ã¨ã£ã¦éžå¸¸ã«é‡è¦ã§ã‚ã‚‹ã€‚ã“ã®æŠ€æ³•ã¯ç¶™ç¶šçš„ã‚¤ãƒ³ãƒ†ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³åŠã³è‡ªå‹•åŒ–ã•ã‚ŒãŸãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–‹ç™ºã«é©ç”¨ã—ã€ã‹ã¤DBAã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºè€…ãŒå¯†æŽ¥ã«å”åŠ›ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦æˆã‚Šç«‹ã¤ã€‚ã“ã®æŠ€æ³•ã¯é–‹ç™ºä¸ã®ã‚·ã‚¹ãƒ†ãƒ ã‚„æ—¢ã«é–‹ç™ºã•ã‚ŒãŸã‚·ã‚¹ãƒ†ãƒ ã«å¯¾ã—ã¦ã‚‚æ©Ÿèƒ½ã™ã‚‹ã€‚ å¤‰åŒ–ã«å¯¾å¿œã™ã‚‹ åˆ¶é™äº‹é … ãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹é›† DBAã¯é–‹ç™ºè€…ã¨å¯†æŽ¥ã«å”åŠ›ã—åˆã† å…¨å“¡ãŒè‡ªåˆ†ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ä¿æœ‰ã™ã‚‹ é–‹ç™ºè€…ã¯å…±æœ‰ãƒžã‚¹ã‚¿ãƒ¼ã«é »ç¹ã«çµåˆã™ã‚‹ ã‚¹ã‚ãƒ¼ãƒžã¨ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‹ã‚‰æˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã™ã¹ã¦ã®å¤‰æ›´ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒªãƒ•ã‚¡
aroma_black 2010/11/12
database

development

agile
ãƒªãƒ³ã‚¯
â˜† JSTå¤±æ•—çŸ¥è˜ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ â˜† ç§‘å¦æŠ€è¡“åˆ†é‡Žã® äº‹æ•…ã‚„ å¤±æ•—ã® çŸ¥è˜ã¨ æ•™è¨“
å¤±æ•—çŸ¥è˜ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ç§‘å¦æŠ€è¡“åˆ†é‡Žã®äº‹æ•…ã‚„å¤±æ•—ã®äº‹ä¾‹ã‚’åˆ†æžã—ã€å¾—ã‚‰ã‚Œã‚‹æ•™è¨“ã¨ã¨ã‚‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã—ãŸã‚‚ã®ã§ã€ç§‘å¦æŠ€è¡“æŒ¯èˆˆæ©Ÿæ§‹(JST)ãŒç„¡æ–™ã§æä¾›ã—ã¦ã„ã¾ã™ã€‚
aroma_black 2010/06/11
ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³äº‹ä¾‹é›†

database

çŸ¥è˜
ãƒªãƒ³ã‚¯
key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜
é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ Software Design èªŒ 2010å¹´ 2æœˆå·ã«æŽ²è¼‰ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ Software Design èªŒç·¨é›†éƒ¨ã®äº†æ‰¿ã®å…ƒã«ã€æœ¬ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«æŽ²è¼‰ã—ã¦ãŠã‚Šã¾ã™ã€‚ é¦–è—¤ä¸€å¹¸: "key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜", Software Design 2010å¹´ 2æœˆå·, p.14-21, (æ ª)æŠ€è¡“è©•è«–ç¤¾, 2010å¹´ 1æœˆ 18æ—¥ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ç‰¹ã«PaaSå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºãŒç¾å®Ÿã®ã‚‚ã®ã¨ãªã‚Šã€ ãã“ã§ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ å‹¢ã„ã‚’å¢—ã—ã¦ã„ã¾ã™ã€‚ ãã®ä»£è¡¨ã§ã‚ã‚‹key-valueã‚¹ãƒˆã‚¢ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚‚ãã˜ key-valueã‚¹ãƒˆã‚¢ã¨ã¯ ãªãœkey-valueã‚¹ãƒˆã‚¢ã‹ key-valueã‚¹ãƒˆã‚¢ã®ä½¿ã„ã©ã“ã‚ key-valueã‚¹ãƒˆã‚¢ã¨NoSQLã®
aroma_black 2010/01/27
kvs

database
ãƒªãƒ³ã‚¯
1