NoSQL ã¯ã髿§èœã®éãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ãæãçšèªã§ããNoSQL ããŒã¿ããŒã¹ã¯ãããã¥ã¡ã³ããã°ã©ããããŒå€ãåæåãªã©åçš®ããŒã¿ã¢ãã«ãå©çšããŸããNoSQL ããŒã¿ããŒã¹ã¯ãéçºã®ãããããã¹ã±ãŒã©ãã«ãªããã©ãŒãã³ã¹ãåªããå¯çšæ§ãé«ãå埩æ§ã§ç¥ãããŠããŸããNoSQL ããŒã¿ããŒã¹ã®äœ¿çšãéå§ããéã«ã¯ã次ã®åç»ã圹ç«ã¡ãŸãã
ãã¯ã€ãããŒã㌠Migration Best Practices â RDBMS to Amazon DynamoDB ãããŠã³ããŒãããŠãã ããã
| ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ | NoSQL ããŒã¿ããŒã¹ | |
| ããŒã¿ã¢ãã« | ãªã¬ãŒã·ã§ãã«ã¢ãã«ã¯ãããŒã¿ãè¡ãšåããæãããŒãã«ãšåŒã°ãã衚圢åŒã®æ§é ã«æ£èŠåããŸããããŒãã«ãåãã€ã³ããã¯ã¹ãããŒãã«éã®é¢ä¿ãªã©ã®ããŒã¿ããŒã¹èŠçŽ ã¯ãã¹ããŒãã«ãã£ãŠå³å¯ã«å®çŸ©ãããŸãã | éãªã¬ãŒã·ã§ãã« (NoSQL) ããŒã¿ããŒã¹ã¯ãéåžžãã¹ããŒããå¿ èŠãšããŸãããå€ãåã»ãããåæ§é å JSONãXMLããŸãã¯é¢é£ããé ç®å±æ§ãå«ããã®ä»ã®ããã¥ã¡ã³ãã®ååŸã«ã¯ãéåžžããŒãã£ã·ã§ã³ããŒã䜿çšãããŸãã |
| ACID ãããã㣠| åŸæ¥ã®ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ç®¡çã·ã¹ãã (RDBMS) ã¯ãACID (äžå¯åæ§ãäžè²«æ§ãç¬ç«æ§ãæ°žç¶æ§) ã§å®çŸ©ãããäžé£ã®ããããã£ããµããŒãããŠããŸããäžå¯åæ§ã¯ããå šéšããŒããããã€ãŸãããã©ã³ã¶ã¯ã·ã§ã³ãå®å šã«å®è¡ããããäžåå®è¡ãããªããã®ã©ã¡ãããšãªãããšãæããŸããäžè²«æ§ã¯ããã£ãããã©ã³ã¶ã¯ã·ã§ã³ãå®è¡ãããããããŒã¿ãå¿ ãããŒã¿ããŒã¹ã¹ããŒãã«åŸãããšãæããŸããç¬ç«æ§ã¯ãåæçºçãããã©ã³ã¶ã¯ã·ã§ã³ãçžäºã«ç¬ç«ããŠå®è¡ãããããšãæããŸããæ°žç¶æ§ã¯ãäºæããªãã·ã¹ãã é害ãåé»ãçºçããŠããç°åžžçºçåã®æåŸã®ç¶æ ãŸã§åŸ©æ§ã§ããããšãæããŸãã | NoSQL ããŒã¿ããŒã¹ã¯ãåŸæ¥ã®ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ç®¡çã·ã¹ãã ïŒRDBMSïŒã® ACID ããããã£ãå®å šã«ã¯ä¿èšŒããªããã®ã®ãæ°Žå¹³æ¹åã«æ¡åŒµã§ããããæè»ãªããŒã¿ã¢ãã«ãå®çŸããŸãããããã£ãŠãåŸæ¥ã® RDBMS ã§ã¢ãŒããã¯ãã£äžã®èª²é¡ãçããå Žåã«ãããã©ãŒãã³ã¹ã®ããã«ããã¯ãã¹ã±ãŒã©ããªãã£ãè€éãªéçšã管çã³ã¹ããšãµããŒãã³ã¹ãã®äžæãšãã£ãåé¡ãè§£æ¶ããã®ã«æé©ãªéžæè¢ã§ãã |
| ããã©ãŒãã³ã¹ | ããã©ãŒãã³ã¹ã¯éåžžããã£ã¹ã¯ãµãã·ã¹ãã ã«å·Šå³ãããŸããæåã®ããã©ãŒãã³ã¹ãå®çŸããã«ã¯ãã¯ãšãªãã€ã³ããã¯ã¹ãããŒãã«æ§é ã®æé©åãå¿ èŠã§ãã | ããã©ãŒãã³ã¹ã¯éåžžãåºç€ãšãªãããŒããŠã§ã¢ã¯ã©ã¹ã¿ã®ãµã€ãºããããã¯ãŒã¯ã¬ã€ãã³ã·ãŒãåŒã³åºãã¢ããªã±ãŒã·ã§ã³ã«äŸåããŸãã |
| æ¡åŒµæ§ | é«éãªããŒããŠã§ã¢ã䜿çšããããšã§ãç°¡åã«ã¹ã±ãŒã« "ã¢ãã" ã§ããŸãããªã¬ãŒã·ã§ãã«ããŒãã«ã忣ã·ã¹ãã ã§äœ¿çšããã«ã¯è¿œå ã®æè³ãå¿ èŠã«ãªããŸãã | äœã³ã¹ããªããŒããŠã§ã¢ã®åæ£ã¯ã©ã¹ã¿ã䜿çšããŠã¹ã±ãŒã« "ã¢ãŠã" ããããšã§ãã¬ã€ãã³ã·ãŒãå¢ããããšãªãã¹ã«ãŒãããããããæ¹åã§ããããã«èšèšãããŠããŸãã |
| API | ããŒã¿ã®ä¿åããã³ååŸèŠæ±ã¯ãæ§é åã¯ãšãªèšèª (SQL) æºæ ã®ã¯ãšãªã䜿çšããŠäŒããããŸãããã®ã¯ãšãªã¯ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ç®¡çã·ã¹ãã (RDBMS) ã«ãã£ãŠè§£æãããå®è¡ãããŸãã | ã¢ããªã±ãŒã·ã§ã³éçºè ã¯ããªããžã§ã¯ãããŒã¹ã® API ã䜿çšããŠãã¡ã¢ãªå ã®ããŒã¿æ§é ã®ä¿åããã³ååŸãç°¡åã«è¡ãããšãã§ããŸããã¢ããªã±ãŒã·ã§ã³ã¯ããŒãã£ã·ã§ã³ããŒã«ãã£ãŠãããŒãšå€ã®ãã¢ãåã»ããããŸãã¯ã¢ããªã±ãŒã·ã§ã³ã®ã·ãªã¢ã©ã€ãºããããªããžã§ã¯ãã屿§ãå«ãåæ§é åããã¥ã¡ã³ãã調ã¹ãŸãã |
| ããŒã« | SQL ããŒã¿ããŒã¹ã§ã¯éåžžãããŒã¿ããŒã¹æåã®ã¢ããªã±ãŒã·ã§ã³ã®éçºãç°¡çŽ åããããã«ãäžé£ã®è±å¯ãªããŒã«ãæäŸãããŸãã | NoSQL ããŒã¿ããŒã¹ã§ã¯éåžžãã¯ã©ã¹ã¿ãŒããã³ã¹ã±ãŒãªã³ã°ã®ç®¡çããŒã«ãæäŸãããŸããåºç€ãšãªãããŒã¿ãžã®ãã©ã€ããªã€ã³ã¿ãŒãã§ã€ã¹ã¯ã¢ããªã±ãŒã·ã§ã³ã§ãã |
åæåããŒã¿ããŒã¹
åæåããŒã¿ããŒã¹ã¯ãããŒã¿è¡ã§ã¯ãªããããŒã¿åã®èªã¿æžãã«æé©åãããŠããŸããããŒã¿ããŒã¹ããŒãã«ã®åæåã¹ãã¬ãŒãžã¯ãå¿
èŠãªç·ãã£ã¹ã¯ I/O ãšããã£ã¹ã¯ããããŒãããå¿
èŠã®ããããŒã¿éã倧å¹
ã«æžå°ããããšãããåæã¯ãšãªã®ããã©ãŒãã³ã¹ã«ãããŠéèŠãªèŠå ã§ãã詳现 »
ããã¥ã¡ã³ãããŒã¿ããŒã¹
ããã¥ã¡ã³ãããŒã¿ããŒã¹ã§ã¯ãåæ§é åããŒã¿ãããã¥ã¡ã³ããšããŠä¿åã§ããŸããéåžžã¯ãJSON ãã©ãŒããããŸã㯠XML ãã©ãŒãããã§ä¿åãããŸããåŸæ¥ã®ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ãšã¯ç°ãªããããããã®éãªã¬ãŒã·ã§ãã« (NoSQL) ããã¥ã¡ã³ãã®ã¹ããŒãã¯äžå®ã§ã¯ãªããã¢ããªã±ãŒã·ã§ã³ããŒã¿ãæè»ã«æŽçãä¿åã§ããä»ã®æ©èœã䜿çšããéã«å¿
èŠãªã¹ãã¬ãŒãžãæžããããšãã§ããŸãã詳现 »
ã°ã©ãããŒã¿ããŒã¹
ã°ã©ãããŒã¿ããŒã¹ã«ã¯é ç¹ãšã蟺ãšåŒã°ããæåãªã³ã¯ãæ ŒçŽãããŸããã°ã©ãã¯ããªã¬ãŒã·ã§ãã«ïŒSQLïŒããã³éãªã¬ãŒã·ã§ãã«ïŒNoSQLïŒããŒã¿ããŒã¹ã«åºã¥ããŠæ§ç¯ã§ããŸããé ç¹ãšèŸºã«ã¯ããããé¢é£ããããããã£ããããŸããæ¬¡ã®å³ã¯ãåéãšãã®è¶£å³ã®é¢ä¿ã瀺ãç°¡åãªã°ã©ãã衚ããŠããŸãã詳现 »
ã¡ã¢ãªå
ããŒå€ã¹ãã¢
ã¡ã¢ãªå
ããŒå€ã¹ãã¢ã¯ NoSQL ããŒã¿ããŒã¹ã§ãããèªã¿åãã®è² è·ã倧ããã¢ããªã±ãŒã·ã§ã³ã¯ãŒã¯ããŒã(ãœãŒã·ã£ã«ãããã¯ãŒã¯ãã²ãŒã ãã¡ãã£ã¢ã®å
±æãQ&A ããŒã¿ã«ãªã©)ãèšç®éã®å€ãã¯ãŒã¯ããŒã(ã¬ã³ã¡ã³ããŒã·ã§ã³ãšã³ãžã³ãªã©)ã«æé©åãããŠããŸããã¡ã¢ãªå
ãã£ãã·ã¥ã¯ãã¢ã¯ã»ã¹ã®åŸ
ã¡æéãçãããããã«ã¡ã¢ãªå
ã«ããŒã¿ã®éèŠãªéšåãæ ŒçŽããããšã«ãããã¢ããªã±ãŒã·ã§ã³ã®ããã©ãŒãã³ã¹ãåäžãããŸãã詳现 »
| SQL |
MongoDB | DynamoDB | Cassandra | Couchbase |
| ããŒãã« | ã³ã¬ã¯ã·ã§ã³ | ããŒãã« | ããŒãã« | ããŒã¿ãã±ãã |
| è¡ | ããã¥ã¡ã³ã |
é ç® | è¡ | ããã¥ã¡ã³ã |
| å |
ãã£ãŒã«ã | 屿§ | å | ãã£ãŒã«ã |
| ãã©ã€ããªã㌠|
ObjectId |
ãã©ã€ããªã㌠| ãã©ã€ããªã㌠| ããã¥ã¡ã³ã ID |
| ã€ã³ããã¯ã¹ | ã€ã³ããã¯ã¹ | ã»ã«ã³ããªã€ã³ããã¯ã¹ | ã€ã³ããã¯ã¹ |
ã€ã³ããã¯ã¹ |
| 衚瀺 | 衚瀺 | ã°ããŒãã«ã»ã«ã³ããªã€ã³ããã¯ã¹ | ãããªã¢ã©ã€ãºããã¥ãŒ | 衚瀺 |
| ãã¹ããããããŒãã«ãŸãã¯ãªããžã§ã¯ã |
åã蟌ãŸããããã¥ã¡ã³ã | ããã | ããã | ããã |
| é
å |
é å | ãªã¹ã | ãªã¹ã | ãªã¹ã |
Amazon DynamoDB ã¯ç°¡åã«äœ¿çšéå§ã§ããŸããå
¥éã¬ã€ãã«åŸãã°ããããæ°åã®ã¯ãªãã¯ã§æåã® DynamoDB ããŒãã«ãäœæã§ããŸãã

