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

shin1x1 id:shin1x1

databaseã«é–¢ã™ã‚‹shin1x1ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

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

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

deployment
ãƒªãƒ³ã‚¯
14. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‹ã‘ã‚‹ï¼ˆsoudai1025ï¼‰ | PHPã®ç¾å ´
@soudai1025 ã•ã‚“ã¨ã€Silex é–‹ç™ºçµ‚äº†ã€ISUCONã€PHP ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã§ãƒ–ãƒ¼ãƒ¡ãƒ©ãƒ³ã‚’æŠ•ã’åˆã†ã®ã¯ã‚„ã‚ã‚ˆã†ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã€è¨è¨ˆã€ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã€è‰²ã€…ãªäººã¨è©±ã™ã€æ±äº¬ç§»ä½ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«ã€åˆ¶ç´„ã€è²¬å‹™ã‚’åˆ†ã‘ã‚‹ã€ä¸å‰ãªåŒ‚ã„ã€ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã€ç”Ÿå˜æˆ¦ç•¥ã€ã‚¹ã‚ãƒ«ã®æŽ›ã‘ç®—ã€åå¾©æ¨ªè·³ã³ãªã©ã«ã¤ã„ã¦è©±ã—ã¾ã—ãŸã€‚ Show notes Larry Garfield on Twitter: â€œBig news! #Silex is dead, long live #Symfony Flex. #SymfonyCon https://t.co/TNTvIikHdzâ€ azu on Twitter: â€œ#phpgenba ã§ã“ã‚Œã«ã¤ã„ã¦èžããŸã„ â€œPHP ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã§ãƒ–ãƒ¼ãƒ¡ãƒ©ãƒ³ã‚’æŠ•ã’åˆã†ã®ã¯ã‚„ã‚ã‚ˆã† - Frascoâ€ https://t.co/FFs4ZsZQAVâ€
shin1x1 2017/11/22
ããƒ¼ã ã„ã•ã‚“ï¼ˆ @soudai1025 ï¼‰ã¨åŽéŒ²ã—ãŸå›žã‚’å…¬é–‹ã—ã¾ã—ãŸï¼ #phpgenba

phpgenba

php

database
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã«ã¤ã„ã¦è©±ã‚’ã—ã¦ããŸ #OSO2017 - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
å²¡å±±ã«ã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚»ãƒŸãƒŠãƒ¼å²¡å±±ã¨è¨€ã†æœ€é«˜ã®ã‚¤ãƒ™ãƒ³ãƒˆãŒã‚ã‚Šã¾ã™ã€‚ okayama.open-seminar.org æ˜¨æ—¥ã¯ id:t-wada ã•ã‚“ã‚„ id:naoya ã•ã‚“ã®è³‡æ–™ãŒãƒ›ãƒƒãƒˆã‚¨ãƒ³ãƒˆãƒªãƒ¼å…¥ã‚Šã—ã¦ã¾ã—ãŸã€‚ ã“ã®ç™»å£‡ã¯ãã‚Œã¨åŒã˜ã‚¤ãƒ™ãƒ³ãƒˆã«ãªã‚Šã¾ã™ã€‚ ãã®ä»–ã®æ–¹ã‚‚è¶…è±ªè¯è¬›å¸«é™£ã®ä¸ã§ã€ç§ãŒå‡ºæ¥ã‚‹ç²¾ä¸€æ¯ã®çµŒé¨“ã‚‚è¸ã¾ãˆãŸãŠè©±ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ speakerdeck.com ã“ã®ä¸ã§å‡ºã¦æ¥ã‚‹ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã¯æœ¬å½“ã«ç´ æ™´ã‚‰ã—ã„æœ¬ã§ã™ã€‚ Oracleãƒ™ãƒ¼ã‚¹ãªã®ã§ã™ãŒMySQLã ã‚ã†ãŒPostgreSQLã ã‚ã†ãŒå¿…ãšãŸã‚ã«ãªã‚‹æœ¬ã§ã™ã€‚ ã§ã™ãŒã€ã“ã®æœ¬ã¯æ—¢ã«å»ƒåˆŠã«ãªã£ã¦ãŠã‚Šå†è²©ã®äºˆå®šã‚‚ã‚ã‚Šã¾ã›ã‚“â€¦ åƒ•ã¯å¾Œä¸–ã«çµ¶å¯¾å¿…è¦ãªæœ¬ã®ä¸€ã¤ã ã¨æ€ã£ã¦ã„ã‚‹ã®ã§å†è²©ã®ãŸã‚ã«ã‚‚çš†ã•ã‚“ã®è¦æœ›ã®å£°ã‚’ä¸Šã’ã¦ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ãã—ãŸã‚‰ã‚‚ã—ã‹ã—ãŸã‚‰æœ¬ãŒä¸–ã«å¾©æ´»ã™ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã¾ãŸSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿
shin1x1 2017/05/18
database

development
ãƒªãƒ³ã‚¯
YAPC::Kansai ã§ RDBã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ãã®2 ã«ã¤ã„ã¦è©±ã—ã¦ãƒ™ã‚¹ãƒˆãƒˆãƒ¼ã‚«ãƒ¼è³žã‚’å–ã£ã¦ããŸ #yapcjapan - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
YAPC::Kansaiã§ãƒˆãƒ¼ã‚¯ã—ã¦ãã¾ã—ãŸã€‚ yapcjapan.org RDBã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã®è©±ã—ã¦ãã¾ã—ãŸã€‚ åŽ»å¹´ã€PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§RDBã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã®è©±ã‚’ã—ã¦ç››ã‚Šä¸ŠãŒã£ãŸã®ã§ãã‚Œã®ç¬¬äºŒå¼¾ã§ã™ã€‚ b.hatena.ne.jp speakerdeck.com åƒ•ãŒä¼ãˆãŸã„äº‹ã¯ãŸã£ãŸã²ã¨ã¤ã€‚ ã“ã®ãƒ–ãƒã‚°ã‚’èªã‚“ã ã‚‰ã™ãè‡ªåˆ†ãŸã¡ã®ã‚µãƒ¼ãƒ“ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢æ‰‹æ®µç¢ºèªã—ã¦ãã ã•ã„ï¼ ãŠå…„ã•ã‚“ã¨ã®ç´„æŸã ãžï¼ï¼ ã“ã®ãƒˆãƒ¼ã‚¯å¿œå‹Ÿã—ãŸã‚‰GitLab.comãŒå¤§äº‹æ•…èµ·ã“ã—ãŸã‚Šã€S3ãŒè½ã¡ãŸã‚Šä¸–ã®ä¸ã§ã¯å¤§å¤‰ãã†ã§ã—ãŸã€‚ www.publickey1.jp ãƒ’ãƒ¥ãƒ¼ãƒžãƒ³ã‚¨ãƒ©ãƒ¼ã¨ã‹ã‚ã‚‹ã‚“ã§ã™ã‚ˆã»ã‚“ã¨ã€‚ åƒ•ã‚‚ã„ã£ã±ã„è¦‹ã¦ããŸã—ã€ã‚„ã£ãŸã—ï¼ˆã‰ãƒ ãªã®ã§æœ¬å½“ã«ã‚‚ã†ã“ã‚Œã ã‘ã¯çµ¶å¯¾ç¢ºèªã—ã¦ã»ã—ã„ã£ã¦æ€ã„ã¾ã™ã€‚ å®Ÿéš›ã«ã€Œãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ç„¡ã„DBã‚’ãƒã‚°ã§é£›ã°ã—ãŸã‚“ã§ã™ã‘ã©ã©ã†ã™ã‚Œã°ã„ã„ã§ã™ã‹ï¼Ÿã€ã¨ã‹ç›¸è«‡æ¥ã¾ã™ã€‚ ã»ã‚“
shin1x1 2017/03/05
database

PostgreSQL

mysql

development
ãƒªãƒ³ã‚¯
Droonga
Droongaã«ã¤ã„ã¦ Droongaã¯ã€ã‚¹ãƒˆãƒªãƒ¼ãƒ æŒ‡å‘ã®å‡¦ç†ãƒ¢ãƒ‡ãƒ«ã‚’æŽ¡ç”¨ã—ãŸåˆ†æ•£å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚æ¤œç´¢ã€æ›´æ–°ã€é›†ç´„ãªã©ã®å¤šãã®æ“ä½œãŒãƒ‘ã‚¤ãƒ—ãƒ©ã‚¤ãƒ³ã‚’é€šã˜ã¦è¡Œã‚ã‚Œã‚‹ã“ã®ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚Šã€Droongaã¯é«˜ã„æŸ”è»Ÿæ€§ã¨æ‹¡å¼µæ€§ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚ã¾ãŸã€Droongaã¯æ—¢å˜æ“ä½œã®çµ„ã¿åˆã‚ã›ã«ã‚ˆã‚‹è¤‡é›‘ãªæ“ä½œã«ã‚‚å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯Rubyã§ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’é–‹ç™ºã—ã¦ã€ç‹¬è‡ªã®æ“ä½œã‚’Droongaã«åŠ ãˆã‚‹äº‹ãŒã§ãã¾ã™ã€‚ è©³ç´°ã¯æ¦‚è¦ã‚’ã”è¦§ãã ã•ã„ã€‚ å°†æ¥ã®Droongaã«ã¤ã„ã¦ã¯ãƒãƒ¼ãƒ‰ãƒžãƒƒãƒ—ã‚’ã”è¦§ãã ã•ã„ã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ Droongaã‚’ã‚ˆã‚ŠåŠ¹æžœçš„ã«ä½¿ã†ãŸã‚ã«ã€ä»¥ä¸‹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒå½¹ç«‹ã¤ã§ã—ã‚‡ã†ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é †ï¼šDroongaã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é †ã®èª¬æ˜Žã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ï¼šDroongaã®ä½¿ã„æ–¹ã‚’å®Ÿä¾‹ã‚’é€šã—ã¦è§£èª¬ã—ã¾ã™ã€‚ ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ï¼šè©³ç´°ãªä»•æ§˜ã«ã¤ã„ã¦ã®èª¬æ˜Žã§ã™ã€‚ ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ï¼šDroonga
shin1x1 2013/11/29
"Droongaã¯ã€ã‚¹ãƒˆãƒªãƒ¼ãƒ æŒ‡å‘ã®å‡¦ç†ãƒ¢ãƒ‡ãƒ«ã‚’æŽ¡ç”¨ã—ãŸã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿å‡¦ç†ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚"

Droona

database
ãƒªãƒ³ã‚¯
LMDB | symas
An ultra-fast, ultra-compact, crash-proof, key-value, embedded data store Symas LMDB is an extraordinarilyÂ fast, memory-efficient database we developed for theÂ OpenLDAP Project.Â With memory-mapped files, LMDB has the read performance of a pure in-memory database while retaining the persistence of standard disk-based databases. Bottom line, with only 32KB of object code, LMDB may seem tiny. But itâ€™
shin1x1 2013/08/20
database

benchmark

leveldb

MDB

sqlite
ãƒªãƒ³ã‚¯
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
shin1x1 2013/03/23
database

java

flyway
ãƒªãƒ³ã‚¯
Data Models
Data Models: A Comprehensive Guide to Structuring Information for Optimal Insights and Decision-Making In the realm of data management, the use of effective data models plays a pivotal role in organizing and representing information in a structured and meaningful way. Data models serve as the blueprint for databases, facilitating efficient data storage, retrieval, and analysis. This article delves
shin1x1 2012/10/16
database
ãƒªãƒ³ã‚¯
dbpatterns.com
This domain may be for sale!
shin1x1 2012/10/16
database
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5) - SH2ã®æ—¥è¨˜
ã¨ã„ã†ã‚ã‘ã§ã€JPOUG> SET EVENTS 20120721 | Japan Oracle User Groupã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é€šå¸¸ã®å‹‰å¼·ä¼šã¨æ¯”ã¹ã¦ç™ºè¡¨è€…ã¨è´è¬›è€…ã®ä¸€ä½“æ„Ÿã‚’å¢—ã™ãŸã‚ã®å·¥å¤«ãŒãªã•ã‚Œã¦ã„ã¦ã€ã¨ã¦ã‚‚è‰¯ã‹ã£ãŸã¨æ€ã„ã¾ã™ã€‚æœ‰é™ã‚³ãƒ¼ãƒ’ãƒ¼ã‹ã¨æ€ã£ãŸã‚‰ç„¡é™ãƒ“ãƒ¼ãƒ«ã ã£ãŸã®ã‚‚é©šãã§ã™ã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5)ã¨é¡Œã—ã¦éŽåŽ»4å›žåˆ†ã®ã¾ã¨ã‚ã¨è‡ªä½œãƒ„ãƒ¼ãƒ«ã®ç´¹ä»‹ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚JdbcRunnerã¯Oracle Databaseã€MySQLã¨PostgreSQLã®é–“ã§TPC-Bã¨TPC-Cã®æ€§èƒ½æ¯”è¼ƒãŒã§ãã‚‹å”¯ä¸€ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã®ã§ã€ã„ã‚ã„ã‚è©¦ã—ã¦ã¿ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚è©¦ã—ãŸçµæžœ
shin1x1 2012/07/24
database

performance
ãƒªãƒ³ã‚¯
NoSQLç™»å ´ã®èƒŒæ™¯ã€CAPå®šç†ã€ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã®åˆ†é¡ž
ãã®ä¾‹ã¨ã—ã¦Beckæ°è‡ªèº«ãŒéŽåŽ»ã«å–ã‚Šçµ„ã‚“ã§ããŸç”Ÿå‘½ä¿é™ºä¼šç¤¾ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä¾‹ã«æŒ™ã’ã¾ã™ã€‚ãã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯æ¯Žæ—¥ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãŒå¤‰åŒ–ã™ã‚‹ãŸã‚ã€SQLã¨ORM(Object-Relational Mappingï¼‰ã§ã¯å¯¾å¿œã§ããšã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®Gemstoneã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§å¯¾å¿œã§ããŸã¨è¿°ã¹ã¦ã„ã¾ã™ã€‚ ã“ã†ã—ãŸSQLã ã‘ã§ã¯æº€ãŸã›ãªã„ã•ã¾ã–ã¾ãªè¦ä»¶ã€ä¸Šè¨˜ã®å›³ã«ã‚ã‚‹ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžã®å¯å¡‘æ€§ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿èªã¿è¾¼ã¿ã€æ›¸ãè¾¼ã¿ã€å‡¦ç†ã®æŸ”è»Ÿæ€§ãªã©ã‚’æº€ãŸã™ãŸã‚ã«ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä»¥å¤–ã®NoSQLãªè£½å“ãŒé–‹ç™ºã•ã‚ŒãŸã€‚ã“ã‚ŒãŒNoSQLã®ç™»å ´ã®èƒŒæ™¯ã«ã‚ã‚‹ã¨Beckæ°ã¯è§£èª¬ã—ã¾ã™ã€‚ä¸€æ–¹ã§ã€ã“ã†ã—ãŸã•ã¾ã–ã¾ãªNoSQLã‚’ã€NoSQLã¨ã„ã†è¨€è‘‰ã§è¡¨ã™ã®ã¯é©å½“ã§ã¯ãªã„ã¨ã„ã†æ†‚æ…®ã‚‚ç¤ºã—ã¦ã„ã¾ã™ã€‚ Here is where the futility of defining NoSQ
shin1x1 2010/04/03
database

nosql
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: InnoDBã§COUNT()ã‚’æ‰±ã†éš›ã®æ³¨æ„äº‹é …ã‚ã‚Œã“ã‚Œã€‚
InnoDBã‚’ä½¿ã†ã¨ãã€MyISAMã¨æ¯”è¼ƒã—ã¦åº¦ã€…ã‚„ã‚ŠçŽ‰ã«æŒ™ã’ã‚‰ã‚Œã‚‹ãƒã‚¤ãƒ³ãƒˆã¨ã—ã¦ã€ŒCOUNT()ãŒé…ã„ã€ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚ç¢ºã‹ã«InnoDBã«ãŠã„ã¦è¡Œæ•°ã‚’å¼¾ãå‡ºã™ã®ã«ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ãŒå¿…è¦ãªã®ã ãŒã€ãã‚‚ãã‚‚MyISAMã®COUNT()ãŒé€Ÿã„ï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã®è¡Œæ•°ã‚’ä¿æŒã—ã¦ã‚‹ï¼‰ã®ãŒç‰¹æ®Šãªã®ã§ã‚ã£ã¦ã€InnoDBãŒé…ã„ã‚ã‘ã§ã¯ãªã„ã®ã§ã‚ã‚‹ã€‚ã¨ã¯ã„ãˆã€é«˜é€ŸãªCOUNT()ã«ã¤ã„ã¦ã¯éœ€è¦ãŒå¤šãã€ã“ã®å•é¡Œã«ã¯å¤šãã®äººå–ã‚Šçµ„ã‚“ã§ãŠã‚‰ã‚Œã‚‹ã‚ˆã†ã ã€‚ã—ã‹ã—ãªãŒã‚‰ã€COUNT()ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã¯æœªã èªžã‚‰ã‚Œã¦ã„ãªã„ç‚¹ãŒã‚ã‚‹ã‚ˆã†ã«è¦‹å—ã‘ã‚‰ã‚Œã‚‹ã®ã§ã€ä»Šæ—¥ã¯COUNT()ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ COUNT(*)ã€COUNT(col)ã€COUNT(1)ã®é•ã„åŸºæœ¬çš„ãªã“ã¨ã§ã¯ã‚ã‚‹ãŒã€COUNT(*)ã¨COUNT(col)ã§ã¯æ„å‘³ãŒç•°ãªã‚‹ãŸã‚ã€ç•°ãªã‚‹çµæžœãŒè¿”ã•ã‚Œã‚‹å ´åˆãŒã‚ã‚‹ã€‚COUNT(*)ã¯ãƒ•ã‚§ãƒƒ
shin1x1 2010/03/09
mysql

database
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: é«˜åº¦ã«é€²åŒ–ã—ãŸåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¯ RDBMS ã¨è¦‹åˆ†ã‘ãŒã¤ã‹ãªã„ï¼Ÿ (shibuya.pm #12 ã‚¹ãƒ©ã‚¤ãƒ‰)
é–‹ç™ºã—ã¦ã„ã‚‹ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã§ã‚ã‚‹ Incline ã¨ Pacific ã«ã¤ã„ã¦ã¯ YAPC::Asia 2009 ã‚’å§‹ã‚ã„ã‚ã„ã‚ãªæ‰€ã§è©±ã‚’ã™ã‚‹æ©Ÿä¼šã‚’ã„ãŸã ã„ã¦ããŸã®ã§ã€ä»Šå›žã¯ã€ãªãœ RDBMS ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’æŽ¡ç”¨ã—ãŸã®ã‹ã¨ã„ã†èƒŒæ™¯ã‚’ä¸å¿ƒã«èª¬æ˜Žã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚æ¦‚å¿µçš„ãªè©±ãŒå¤šãã¦åˆ†ã‹ã‚Šã«ãã‹ã£ãŸã¨æ€ã„ã¾ã™ï¼ˆã™ã¿ã¾ã›ã‚“ï¼‰ãŒã€ç´°ã‹ãªç‚¹ã«ã¤ã„ã¦ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ (BPStudy#25ç™ºè¡¨è³‡æ–™)ã‚’å‚ç…§ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ã¾ãŸã€ä¸ã§å‡ºã¦ããŸã€Œå®Ÿä½“åŒ–ãƒ“ãƒ¥ãƒ¼ã€ã«ã¤ã„ã¦ã¯ã€Materialized view - Wikipedia, the free encyclopediaãŒè‰¯ãã¾ã¨ã¾ã£ã¦ã„ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚Incline ã¯ä¸€è¨€ã§ã„ã†ã¨ã€RDBã§æ§‹æˆã•ã‚Œã‚‹shardç¾¤ã®ä¸Šã§ read-only ã‹ã¤ eventually co
shin1x1 2009/12/01
database
ãƒªãƒ³ã‚¯
1