ãã2-3å¹´ã»ã©ãããããéSQLç³»ãã¼ã¿ãã¼ã¹ãããããªè©±é¡ã«ãªã£ã¦ãã¦ãã¾ãããã®ã ã¼ãã¡ã³ããç·ç§°ãã¦ãNoSQL (Not-only SQL)ãã¨å¼ã°ãããã¨ãå¤ãããã§ããã¾ãã§SQLãå¦å®ãã¦ãããã®ãããªèª¤è§£ãæããããç¨èªã§ããããã¨ãã£ã¦ãã¼ã»ããªã¥ã¼åãã¼ã¿ã¹ãã¢ãåæåDBãç·ç§°ã§ããä»ã®å¼ã³æ¹ããªãã®ã§ããã®ã¨ã³ããªã§ã¯NoSQLã¨ããç¨èªã使ããã¨ã«ãã¾ãã OracleãMySQLãªã©ã®SQLãã¼ã¿ãã¼ã¹ãæçãã¦ãã䏿¹ã§ãSQLãã¼ã¿ãã¼ã¹ãç¹å¾´ã¥ããå¼±ç¹ã§ããæè»æ§ã®ãªããå ç¢ãã¨å¼ãæãã«ç ç²ã«ãªã£ãæ´æ°æ§è½ã®ä½ããã¹ã±ã¼ã«ã¢ã¦ãã®é£ãããªã©ããããä½ã§ãããã§ãRDBããããç®çã«å¿ããæ°¸ç¶åããæ¨¡ç´¢ãããæµãã«ãªã£ã¦ãã¾ããã æãåãããã¦ããã£ãã·ã¥ãµã¼ãã®ä¸çã§ããMemcachedã®ãã¤ã·ã³ãã«ãªAPIã®ä½¿ãããããè©ä¾¡ããã䏿¹ãLRUã«ã
We've asked What The Heck Are You Actually Using NoSQL For?. We've asked 101 Questions To Ask When Considering A NoSQL Database. We've even had a webinar What Should I Do? Choosing SQL, NoSQL or Both for Scalable Web Applications. Now we get to the point of considering use cases and which systems might be appropriate for those use cases. What are your options?First, let's cover what are the variou
ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã¯NoSQLãåãè¾¼ã¿å§ãããNewSQLã®ç»å ´ã¨NoSQLã®çµãããã¨ããäºæ³ MySQLã®æ¬¡æãã¼ã¸ã§ã³ã¨PostgreSQLã®æ¬¡æãã¼ã¸ã§ã³ã«ã©ã®ãããªæ°æ©è½ã追å ãããã®ããæ¨æ¥ã䏿¨æ¥ã®2æ¬ã®è¨äºã§ç´¹ä»ãã¾ããã MySQLã®æ¬¡æãã¼ã¸ã§ã³ã¯Memcached APIãåããï¼ MySQL Conference & Expo 2011åºèª¿è¬æ¼ PostgreSQLã®ç¾ç¶ã¨æ¬¡æãã¼ã¸ã§ã³9.1ã®æ°æ©è½ãMySQL Conference & Expo 2011 ãã®2ã¤ã®ãã¼ã¿ãã¼ã¹ã®æ¬¡æãã¼ã¸ã§ã³ã«å ±éãã¦ããã®ããNoSQLã®æ©è½ãåãè¾¼ãã§ãããã¨ã§ããNoSQLã«å¯¾ãããªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã«ããåæãå§ã¾ã£ã¦ãã¾ãã ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ãNoSQLãåãè¾¼ã¿å§ãã MySQLã®æ¬¡æãã¼ã¸ã§ã³ã§ããMySQL 5.6ã«æè¼äºå®ã®æ°æ©è½ã®1
ããã«ã¡ã¯ï¼hiroshiã§ãï¼ ä»åã¯ãæè¿DECOLOGçéã§å¤§ãã¼ã ã®redisã«ã¤ãã¦ããã®å©ç¨ç¨éãå°å ¥æ¹æ³ã«ã¤ãã¦ã話ããããã¨æãã¾ãã ä»åã®ã話ã¨é¢é£ããéå»ã¨ã³ããªã«ä»¥ä¸ãããã¾ãã®ã§ããã¡ãã«ç®ãéãã¦ããã ããä¸ã§æ¬ã¨ã³ããªãèªãã§ããã ãã¨åãããããã¨æãã¾ãã NoSQL redisã¨MySQLã®ãã³ããã¼ã¯æ¯è¼ redisã®ãµã¼ãã¹ã¸ã®æå ¥ rediså°å ¥å¾ã«ãã©ãã«çºçããã®ã¬ãã¼ã DECOLOGã§ã®MySQL Archiveã¨ã³ã¸ã³ã®ä½¿ãæ¹ â¦ã¨ãããã¾ã§ã®ã¨ã³ããªããã¯å®éç¨ã§ãã¦ãã®ãã©ããå¾®å¦ãªã¿ããã«ãªã£ã¦ããããããã¾ããããçµè«ããããã¨å®éç¨ã§ãã¦ã¾ãï¼ ãrediså°å ¥å¾ã«ãã©ãã«çºçããã®ã¬ãã¼ããã§ã¯TTLãè¨å®ããå ´åã«ãã¾ããããªãã±ã¼ã¹ããã£ãã®ã§ãããTTLãªãã®ãã¼ã¿ã§ã¯ç¹ã«åé¡ãªãéç¨ã§ãã¾ããã ç¾å¨ã®redisã®å©ç¨
ã¯ããã« NoSQLï¼Not Only SQLï¼ã¨ããè¨èãæ³¨ç®ãéãã¦ãã¾ããããã¯ãRDBMSã徿ãªãã¨ã¯RDBMSã§ãä¸å¾æãªã¨ããã«ã¯RDBMSã«ãã ããããç¨éã«åã£ããã¼ã¿ã¹ãã¢ã使ãã¾ããããã¨ããèãæ¹ã§ããæè¿ã§ã¯ãããããNoSQLãã¼ã¿ãã¼ã¹ ï¼â key-valueã¹ãã¢ãå種ãã¼ã¿ãã¼ã¹â ï¼â ãæ¬¡ã ã¨ç»å ´ãã¦ãã¦ãã¾ãã ããã§ä»åããæ°åã«æ¸¡ããããããã®NoSQLãã¼ã¿ãã¼ã¹ã®ç¹å¾´ãå ·ä½çãªä½¿ãæ¹ã«ã¤ãã¦ç´¹ä»ãã¦ããã¾ãã RDBMSã®å¼·ã¿ã¨ã¯ ãããããMySQLãPostgreSQLãªã©ã®RDBMSã®å¼±ã¿ãè£ããããæ§ã ãªNoSQLãã¼ã¿ãã¼ã¹ãç»å ´ãã¦ããããã§ãããRDBMSã«ã¯ããããã®å¼·ã¿ããããã¨ãå¿ãã¦ã¯ããã¾ããã RDBMSã®å¼·ã¿ ãã¼ã¿ã®ä¸è²«æ§ ï¼â ãã©ã³ã¶ã¯ã·ã§ã³ï¼ æ´æ°æã®ã³ã¹ããå°ãªãï¼JOINãåæã§ãã¼ãã«ãæ£è¦åããã¦ããï¼
ã©ã³ãã³ã°
ãç¥ãã
ã©ã³ãã³ã°
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}