ã¯ããã«
Windows Azureã®æ°žç¶çãªããŒã¿ã¹ãã¬ãŒãžã«é¢ããŠã¯ã2ã€ã®ã¯ã©ãŠããªãã·ã§ã³ããããŸããWindowsAzure SQLããŒã¿ããŒã¹ãšWindows AzureããŒãã«ã¹ãã¬ãŒãžã§ãã
Windows Azure SQL Databaseã¯ãSQL Serverã®ã³ã¢æ©èœãã¯ã©ãŠãã«æ¡åŒµãããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ãµãŒãã¹ã§ãã SQL Databaseã䜿çšãããšããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ãœãªã¥ãŒã·ã§ã³ãã¯ã©ãŠãã«å±éã§ããŸãããã®ã¢ãããŒãã®å©ç¹ã«ã¯ã管çã€ã³ãã©ã¹ãã©ã¯ãã£ãé«å¯çšæ§ãã¹ã±ãŒã©ããªãã£ã䜿ãæ £ããéçºã¢ãã«ãããŸããŸãªããŒã¿ã¢ã¯ã»ã¹ãã¬ãŒã ã¯ãŒã¯ãšãŠãŒãã£ãªãã£ãå«ãŸããŸãã SQL Serverç°å¢ã SQL Databaseã¯ãããŒã«ã«SQL ServerããŒã¿ããŒã¹ãWindows Azure SQLã®ããŒã¿ããŒã¹ãšç§»è¡ããšã¯ã¹ããŒããããã³ãªã¢ã«ã¿ã€ã ã§åæããæ©èœãæäŸããŸãïŒ SQL Data Syncã䜿çšïŒã
Windows AzureããŒãã«ã¹ãã¬ãŒãžã¯ãè¿œå ã®æ§é ãå¿ èŠãšãã倧éã®éãªã¬ãŒã·ã§ãã«ããŒã¿ãä¿åããã¢ããªã±ãŒã·ã§ã³ã«åœ¹ç«ã€ããã§ãŒã«ã»ãŒããISO 27001èªå®ã®NoSQLããŒå€ã¹ãã¬ãŒãžãµãŒãã¹ã§ãã ãã®ãµãŒãã¹ã¯ãã¹ããŒããæããªãããŒã¿ãžã®ããŒããŒã¹ã®ã¢ã¯ã»ã¹ãæäŸããŸãã ãã ããã¹ããŒããªãã§æ§é åããŒã¿ãä¿åãããšãããŒã¿éã®é¢ä¿ãäœæã§ããŸããã
é¡èãªéãã«ãããããããäž¡æ¹ã®ãµãŒãã¹ã¯éåžžã«ã¢ã¯ã»ã¹ãããããããŒãžããµãŒãã¹ã§ãããæé99.9ïŒ ã®SLAãæäŸãããŸãã
ããŒãã«ã¹ãã¬ãŒãžãš SQLããŒã¿ããŒã¹
SQL Databaseãšåæ§ã«ãWindows AzureããŒãã«ã¹ãã¬ãŒãžã«ã¯æ§é åããŒã¿ãæ ŒçŽãããŸãã 2ã€ã®ãµãŒãã¹ã®äž»ãªéãã¯ãSQL Databaseã¯SQL Serverãšã³ãžã³ã«åºã¥ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ç®¡çã·ã¹ãã ã§ãããæšæºã®ååãšãªã¬ãŒã·ã§ãã«ã®åºç€ã«åºã¥ããŠæ§ç¯ãããŠãããããTransact-SQLã¯ãšãªãACIDãã©ã³ã¶ã¯ã·ã§ã³ãã¹ãã¢ãããã·ãŒãžã£ãå®è¡å¯èœããã·ãŒãžã£ãªã©ã®æ©èœãæäŸããããšã§ããµãŒããŒåŽã
Windows AzureããŒãã«ã¹ãã¬ãŒãžã¯ãã¢ããªã±ãŒã·ã§ã³ããŒã¿ã¢ãã«ãç¹å®ã®ã¹ããŒãã»ããã«ããã¯ããããšãªããã¯ã©ãŠãããŒã¹ã®ã¢ããªã±ãŒã·ã§ã³ããã°ããäœæã§ããæè»ãªããŒãšå€ã®ãšã³ãã£ãã£ã¹ãã¢ã§ãã ãã®ãµãŒãã¹ã¯ãªã¬ãŒã·ã§ãã«ããŒã¿ã®ãªããžããªã§ã¯ãªããSQLããŒã¿ããŒã¹ãªã©ã®ãªã¬ãŒã·ã§ãã«ããŒã¿ã管çããæ©èœïŒçµåãã¹ãã¢ãããã·ãŒãžã£ãªã©ïŒãæäŸããŸããã Windows AzureããŒãã«ã¹ãã¬ãŒãžã§ã¯ããµãŒããŒåŽã®ã¯ãšãªãµããŒããå¶éãããŠããŸããããã©ã³ã¶ã¯ã·ã§ã³æ©èœããããŸãã ããã«ãåãããŒãã«å ã®ç°ãªãã¬ã³ãŒãã¯ç°ãªãæ§é ãæã€ããšãã§ããWindows AzureããŒãã«ã¹ãã¬ãŒãžã®ãã®ã¢ãããŒãã«ãããåçŽãªãªã¬ãŒã·ã§ãã«ããŒã¿ãå¹ççã«ä¿åããã³æäœã§ããŸãã
ã¢ããªã±ãŒã·ã§ã³ãããªã¬ãŒã·ã§ãã«é¢æ°ã䜿çšããå¿ èŠã®ãªã倧éã®ããŒã¿ãä¿åããã³æäœããå ŽåãWindows AzureããŒãã«ã¹ãã¬ãŒãžã®æ¹ãé©ããŠããå¯èœæ§ããããŸãã ã¢ããªã±ãŒã·ã§ã³ãã¹ããŒãã§æ¥ç¶ãããããŒã¿ã»ãããåŠçããå¿ èŠãããå ŽåãSQL Databaseã¯Windows AzureããŒãã«ã¹ãã¬ãŒãžãããé©åãªãªãã·ã§ã³ã®ããã«èŠããŸãã SQLããŒã¿ããŒã¹ã䜿çšãããWindows AzureããŒãã«ã¹ãã¬ãŒãžã䜿çšãããã決å®ããåã«ãèæ ®ãã¹ãèŠçŽ ãä»ã«ãããã€ããããŸãããã®äžéšã以äžã«ç€ºããŸãã
æè¡çãªèæ ®äºé
ç¹å®ã®ãœãªã¥ãŒã·ã§ã³ã«é©ããã¹ãã¬ãŒãžãã¯ãããžã決å®ããå Žåãã¢ãŒããã¯ããšéçºè ã¯æ¬¡ã®æšå¥šäºé ãèæ ®ããå¿ èŠããããŸãã
次ã®å Žåã«ã¯ã Windows AzureããŒãã«ã¹ãã¬ãŒãžã®äœ¿çšãæ€èšããŠãã ããã
ã»ã¢ããªã±ãŒã·ã§ã³ã¯ã倧éã®ããŒã¿ïŒããšãã°ãæ°ãã©ãã€ãïŒãå®äŸ¡ãªã¹ãã¬ãŒãžã«ä¿åããå¿ èŠããããŸãã
ã»ã¢ããªã±ãŒã·ã§ã³ã¯ãè€éãªé¢ä¿é¢ä¿ã®ãªã倧ããªããŒã¿ã»ãããæ ŒçŽããã³æäœããŸãããã®ããããµãŒããŒåŽã§çµåã䜿çšããããã»ã«ã³ããªã€ã³ããã¯ã¹ãŸãã¯ãµãŒããŒåŽã§å®è¡ãããäœããã®è€éãªããžãã¯ã䜿çšããå¿ èŠããããŸãã
ã»ã¢ããªã±ãŒã·ã§ã³ã«ã¯ããã®æ§é ãç°çš®ã§ãããªããžã§ã¯ããæ ŒçŽããããã®æè»ãªããŒã¿ã¹ããŒã ãå¿ èŠã§ããããã®æ§é ã¯èšèšæ®µéã§æ±ºå®ããã®ãå°é£ã§ãã
ã»ããžãã¹ã«ã¯ãå°ççå€æ§æ§ã䜿çšããå£æ» çãªç¶æ³ã®å Žåã«ããŒã¿ãä¿åããæ©èœãå¿ èŠã§ãã Windows AzureããŒãã«ã¯ãæ°çŸãã€ã«é¢ããåã倧éžã«ãã2ã€ã®ããŒã¿ã»ã³ã¿ãŒã«å°ççã«è€è£œãããŸããããã«ãããçœå®³çºçæã®ããŒã¿ã®å®å šæ§ãããã«åäžããŸãã
ã»ã·ã£ãŒãã£ã³ã°ãããŒãã£ã·ã§ã³åå²ã䜿çšããã«150 GBãè¶ ããããŒã¿ãä¿åããå¿ èŠããããŸãã
ã»ããŒã¿ãæåã§ã·ã£ãŒãã£ã³ã°ããã«ãé«åºŠãªã¹ã±ãŒãªã³ã°ãå¿ èŠã§ãã
次ã®å Žåã«ã¯ã Windows Azure SQLããŒã¿ããŒã¹ã®äœ¿çšãæ€èšããŠãã ããã
ã»ã¢ããªã±ãŒã·ã§ã³ã¯ãé«åºŠãªæ§é åãããé¢ä¿ãšé¢ä¿ãæã€ããŒã¿åŠçãåŠçããŸãã
ã»ããŒã¿ã¯æ¬è³ªçã«ãªã¬ãŒã·ã§ãã«ã§ãããããŒã¿ã®äžææ§ãå¶éãããŸããŸãªçš®é¡ã®ããŒã®ã«ãŒã«ã«ããããŒã¿ã®æŽåæ§ã確ä¿ããããã«ããªã¬ãŒã·ã§ãã«ããŒã¿ã®ãœãããŠã§ã¢ã¢ãã«ã®äž»èŠãªååãå®è£ ããå¿ èŠããããŸãã
ã»ããŒã¿ã®éã¯ãå²ãåœãŠãããã¹ãã¬ãŒãžãŠãããïŒããŒã¿ããŒã¹ïŒããšã«150 GBãè¶ ããããšã¯ã§ããŸãããããã®å¶éãè¶ ããå Žåã¯ããŒã¿ãè€æ°ã®ããŒã¿ããŒã¹ã«åå²ã§ããŸãã
ã»æ¢åã®ããŒã¿æåã¢ããªã±ãŒã·ã§ã³ã¯æ¢ã«SQL Serverã䜿çšããŠããŸãããæ¢åã®ãã¬ãŒã ã¯ãŒã¯ã䜿çšããŠã¯ã©ãŠãã¹ãã¬ãŒãžã«ã¢ã¯ã»ã¹ãããªã³ãã¬ãã¹ã€ã³ãã©ã¹ãã©ã¯ãã£ãšWindows Azureã®éãééçã«ç§»è¡ããæ©èœãå¿ èŠã§ãã
ã»ã¢ããªã±ãŒã·ã§ã³ã§T-SQLã¹ãã¢ãããã·ãŒãžã£ã䜿çšããŠããŒã¿ã¬ã€ã€ãŒå ã§èšç®ãå®è¡ããããã«ãã£ãŠã¢ããªã±ãŒã·ã§ã³ãšããŒã¿ã¹ãã¢éã®ã©ãŠã³ãããªããã®åæ°ãæå°éã«æããäºå®ã§ãã
ã»ã¢ããªã±ãŒã·ã§ã³ã¯ã空éããŒã¿ãããŸããŸãªããŒã¿åãããã³ãŠããªã³ãéèšãè€éãªè¿°èªãå«ãããŒã¿ã¢ã¯ã»ã¹ãã¿ãŒã³ã䜿çšããå¿ èŠããããŸãã
ã»ã¢ããªã±ãŒã·ã§ã³ã¯ããŠãŒãã£ãªãã£ã䜿çšããŠèŠèŠåãšBIããŒã¿ã¢ãã«ãæäŸããŸãã
![]() |
Windows Azureã®å€ãã®ã¢ããªã±ãŒã·ã§ã³ã¯äž¡æ¹ã®ãã¯ãããžãŒãå©çšã§ããŸãããããããçµã¿åãããŠäœ¿çšââããããšããå§ãããŸãã |
Windows AzureããŒãã«ã¹ãã¬ãŒãžãšSQLããŒã¿ããŒã¹ã®æ¯èŒ
以äžã®è¡šã¯ãäž¡æ¹ã®ãµãŒãã¹ã®æ¯èŒèŠå ããŸãšãããã®ã§ãã
äž»ãªæ©èœ
ãã®ã»ã¯ã·ã§ã³ã§ã¯ãWindows AzureããŒãã«ã¹ãã¬ãŒãžãšSQLããŒã¿ããŒã¹ãæäŸããäž»èŠãªæ©èœãæ¯èŒããŸãã
æ¯èŒåºæº | Windows AzureããŒãã«ã¹ãã¬ãŒãž | SQLããŒã¿ããŒã¹ |
ããŒã¿éã®é¢ä¿ | ãã
Windows AzureããŒãã«ã¹ãã¬ãŒãžã¯ãããŒã¿éã®é¢ä¿ãäœæããæ¹æ³ãæäŸããŸããã 代ããã«ããã€ã¢ã°ã©ã ã®ãªãããŒãã«ããããã£ãšç¹å®ã®åœ¢åŒã®ããŒã¿ã®æ§é åã䜿çšããŠãåçŽãªé¢ä¿ãå®è£ ã§ããŸãã | ã¯ã
SQL Serverãšåæ§ã«ãSQL Databaseã§ã¯ãå€éšããŒã䜿çšããŠç°ãªãããŒãã«ã«æ ŒçŽãããããŒã¿éã®é¢ä¿ã決å®ã§ããŸãã |
ãµãŒããŒåŽã®åŠç | ãã
ãµããŒããããæäœïŒ insert ã update ã delete ã select ããµããŒããããªãïŒçµåãå€éšããŒãã¹ãã¢ãããã·ãŒãžã£ãããªã¬ãŒããµãŒããŒåŽã®åŠçã | ã¯ã
SQL Serveré¢æ°ã®æšæºã»ããã¯ãã¹ãã¢ãããã·ãŒãžã£ããã¥ãŒãè€åã€ã³ããã¯ã¹ãçµåãéèšã§ãã |
ãã©ã³ã¶ã¯ã·ã§ã³ãµããŒã | éå®
ãã©ã³ã¶ã¯ã·ã§ã³ã¯ã1ã€ã®ãã©ã³ã¶ã¯ã·ã§ã³ã§åãããŒãã«ãš1ã€ã®ããŒãã£ã·ã§ã³å ã§ãµããŒããããŸã-æ倧100ã®æäœããªããã£ãã¹ãã£ãã¯ãªåæå®è¡æ§ããµããŒããããŸãã | ã¯ã
åŸæ¥ã®ACIDãã©ã³ã¶ã¯ã·ã§ã³ã¯åãããŒã¿ããŒã¹å ã§ãµããŒããããŠããŸãããããŒã¿ããŒã¹éã§ã¯ãµããŒããããŠããŸããã 楜芳ç䞊è¡æ§ããµããŒããããŠããŸãã |
å°ççè€è£œ | ã¯ã
ããã©ã«ãã§ã¯ãããŒãã«ã¯ãªãŒãžã§ã³å ã®ä»ã®ããŒã¿ã»ã³ã¿ãŒã«è€è£œãããŸãã | ãã
çŸåšãSQL Databaseã¯å°åå ã®ä»ã®ããŒã¿ã»ã³ã¿ãŒã«è€è£œãããŠããŸããã |
è¡šã®ã¹ããŒã | ãªã©ãã¯ã¹ãã
åã¬ã³ãŒãã¯ãç¬èªã®ããããã£ã»ãããæã€ããšãã§ããŸãã | ãããŒãžã
ã¹ããŒã ã¯å®çŸ©ãããŠããŸããããã€ã§ãå€æŽã§ããŸãããã¹ãŠã®ã¬ã³ãŒãã¯ãã®ã¹ããŒã ã«æºæ ããå¿ èŠããããŸãã æè»æ§ãé«ããããã«ãXMLã¿ã€ããŸãã¯ã¹ããŒã¹åã®äœ¿çšãæ€èšããŠãã ããã |
æ¢åã®ããŒã«ã«ããŒã¿ãŠã§ã¢ããŠãžã³ã°ãšåç | ãã
ã¯ã©ãŠãã¹ãã¬ãŒãžã«ä»£ããããŒã«ã«ã®éžæè¢ã¯ãããŸããã | ã¯ã
ç¹å®ã®å¶éãããSQL Serverã«çžåœãããã®ã¯ã äžè¬çãªã¬ã€ãã©ã€ã³ãšå¶éã§ãã |
åçŽã¹ã±ãŒãªã³ã° | èªå
PartitionKeyããããã£ã«åºã¥ããŠããŒãã£ã·ã§ã³åå²ãããŸãã ããŒãã«ã¯ç°ãªãããã€ã¹ã®ç°ãªãããŒãã£ã·ã§ã³ã«ä¿åã§ããããã«ããã¯ã©ã€ã¢ã³ãã¯äžŠåã¢ã¯ã»ã¹ãå®è¡ã§ããŸãã | ããã¥ã¢ã«
SQLãã§ãã¬ãŒã·ã§ã³ãŸãã¯ç¬èªã®ææ³ã«ããã·ã£ãŒãã£ã³ã°ã䜿çšããããŒã¿ããŒã¹ã°ã«ãŒãéã®ã·ã£ãŒãã£ã³ã°ã |
ããŒã¿å | ã·ã³ãã«
ã詳现ãã®è¡šãåç §ããŠãã ããã | ã·ã³ãã«ã§è€éãªãŠãŒã¶ãŒå®çŸ©
SQL Databaseã¯ããŠãŒã¶ãŒãåãå®çŸ©ããæ©èœãªã©ãå¹ åºãããŒã¿åããµããŒãããŠããŸãã |
è¿œå æ å ±
ã»ããŒãã«ãäœæãããšããåäžã®åã¯ãªããããŒãã«èªäœã¯æ§é åãããŠããããã¹ããŒãããããŸããã ååã¯ããŒãã«ã«ä¿åãããŠããã¬ã³ãŒãã®äžéšã§ãããåãããŒãã«å ã®ç°ãªãã¬ã³ãŒãã§ã¯ç°ãªãå ŽåããããŸãã ããŒãã«ã¯ãããããã£åãåãã§ã¿ã€ããç°ãªã2ã€ã®ãšã³ãã£ãã£ã§æ§æããããšãã§ããŸãããããããã£åã¯åãã¬ã³ãŒãå ã§äžæã§ããå¿ èŠããããŸãã
ã»Windows AzureããŒãã«ã¹ãã¬ãŒãžã¯ããªã¬ãŒã·ã§ãã«ïŒã¯ãšãªãšãã©ã³ã¶ã¯ã·ã§ã³ã®çµåãšéèšïŒããµããŒãããŠããŸããã åäžã®ããŒãã£ã·ã§ã³ããŒãæã€ãšã³ãã£ãã£ã¯ãåäžã®ãªããžããªã§ãŸãšããŠæäŸãããŸãããã®ããŒã¿ãå¹ççã«æäœãã ãšã³ãã£ãã£ã°ã«ãŒããã©ã³ã¶ã¯ã·ã§ã³ã䜿çšããŠåãã¯ãšãªå ã§å€æŽããããšãã§ããŸãã
ã»ãšã³ãã£ãã£ã°ã«ãŒããã©ã³ã¶ã¯ã·ã§ã³ã䜿çšããå Žåã«èæ ®ããªããã°ãªããªãå¶éãããã€ããããŸããããšãã°ãæ倧ãã±ãããµã€ãºã¯4 MBã§ãããããã±ãŒãžå ã®ãã¹ãŠã®ãšã³ãã£ãã£ã«ã¯1ã€ã®ããŒãã£ã·ã§ã³ããŒãå¿ èŠã§ãã
ã»Windows AzureããŒãã«ã¹ãã¬ãŒãžã¯1ã€ã®ã¯ã©ã¹ã¿ãŒåã€ã³ããã¯ã¹ãæäŸããçµæã¯åžžã«PartitionKeyãšRowKeyã«ãã£ãŠæé ã§äžŠã¹æ¿ããããŸãã PartitionKeyãšRowKeyã®å€ã¯ãããŒãã«å ã®åã¬ã³ãŒããäžæã«èå¥ããŸãããããã®ããããã£ã«åãå€ãæã€2ã€ã®ã¬ã³ãŒããäœæããããšãããšãäŸå€ãã¹ããŒãããŸãã
ã»åž¯åå¹ ã®åºæºã¯ãã¯ãšãªã®çš®é¡ãšãã®è€éããããŒã¿ã¢ã¯ã»ã¹ãã¿ãŒã³ãçµæã»ããã®ãµã€ãºãã¹ãã¬ãŒãžã€ã³ãã©ã¹ãã©ã¯ãã£ãŸã§ã®è·é¢ããããã¯ãŒã¯é 延ãªã©ãå€ãã®å€æ°ãå«ãè€éãªæ¹çšåŒã§ããç¹å®ã®ã¢ããªã±ãŒã·ã§ã³ã®æ©èœã ããŒãã«ã®ãã¹ããã©ã¯ãã£ã¹ã®è©³çŽ°ïŒ post
ã»æ¬¡ã®è¡šã¯ãããããã£ã®ããŒãã«ã§ãµããŒããããŠããããŒã¿åããŸãšãããã®ã§ãã SQLããŒã¿ããŒã¹ã§ãµããŒããããŠããããŒã¿åïŒ ããŒã¿åïŒWindows Azure SQLããŒã¿ããŒã¹ïŒ ã
çš®é¡ | 詳现 |
ãã€ã㪠| æ倧64 KBã®ãã€ãã®é åã |
ããŒã« | ããŒã«ã |
æ¥æ | 64ãããUTCæéã å€ã®ç¯å²ã¯1/1/1601ã12/31/9999ã§ãã |
ããã« | 64ãããã®æµ®åå°æ°ç¹å€ã |
GUID | 128ãããGUIDã |
Int | 32ãããæŽæ°ã |
Int64 | 64ãããæŽæ°ã |
ã²ã | UTF-16ã®å€ã¯æ倧64 KBã§ãã |
é«åºŠãªæ©èœ
æ¯èŒåºæº | Windows AzureããŒãã«ã¹ãã¬ãŒãž | SQLããŒã¿ããŒã¹ |
ããŒã«ã«ã¢ããªã±ãŒã·ã§ã³ãŸãã¯ä»ã®ãã©ãããã©ãŒã ããå©çšå¯èœïŒWindows Azureãé€ãïŒ | ã¯ã | ã¯ã |
äžè²«æ§ã¢ãã« | å³ãã | å³ãã |
Windows Communication FoundationïŒWCFïŒããŒã¿ãµãŒãã¹ã®ãµããŒã | ã¯ã | ã¯ã |
RESTãµããŒã | ã¯ã
ããã©ã«ãã®ãµããŒãã | ã¯ã
ããŒã¿ããŒã¹ã®äžã«ODataã¬ã€ã€ãŒãè¿œå ããããšã«ããRESTããŒã¹ã®ã¢ã¯ã»ã¹ã®ãµããŒãã |
ãã¡ã€ã¢ãŠã©ãŒã«ä¿è·ïŒIPå¶éïŒ | ãã | ã¯ã
ããŒã¿ã«ãŸãã¯ã³ã³ãœãŒã«ããæ§æãããWindows Azureãã¡ã€ã¢ãŠã©ãŒã«ã䜿çšããŸãã |
ãã©ã³ã¶ã¯ã·ã§ã³èª¿æŽåäœ | ã¯ã
詳现- ããã°æçš¿ ã | ã¯ã
詳现- èšäº ã |
蚱容誀差 | ã¯ã
é«ã¬ãã«ã®ãã©ãŒã«ããã¬ã©ã³ã¹ã確ä¿ããããã«ãä¿åãããããŒã¿ã¯ãªãŒãžã§ã³å ã®3ã€ã®ã³ããŒã§è€è£œãããããã«3ã€ã®ã³ããŒãåããªãŒãžã§ã³å ã®å¥ã®ããŒã¿ã»ã³ã¿ãŒã«è€è£œãããŸãã | ã¯ã
ããŒã¿ã»ã³ã¿ãŒã«ã¯ãSQL Databaseã®åã€ã³ã¹ã¿ã³ã¹ã®3ã€ã®ã³ããŒãä¿åãããŸãã |
ãã®ã³ã°ãšã¡ããªã㯠| ã¯ã
詳现- ããã°æçš¿ ã | ãã |
ãã©ã³ã¶ã¯ã·ã§ã³ãã° | ãã | ã¯ã
ãã©ã³ã¶ã¯ã·ã§ã³ãã°ã®ãµã€ãºã¯10 GBã«å¶éããããã©ã³ã¶ã¯ã·ã§ã³ããã1 GBã®å¶éããããŸãã |
è¿œå æ å ±
ã»ãã«ãã€ã³ãã¡ã€ã¢ãŠã©ãŒã«ã䜿çšããŠã管çããŒã¿ã«ã§ã«ãŒã«ãæ§æããããšã«ããããããã¯ãŒã¯ã¬ãã«ã§SQLããŒã¿ããŒã¹ã®ã€ã³ã¹ã¿ã³ã¹ãžã®ã¢ã¯ã»ã¹ãå¶éã§ããŸãã ä»»æã®ã¯ã©ã€ã¢ã³ããããŒãã«ã«æ¥ç¶ã§ããããŒãã«ã¯HTTP / HTTPSãä»ããŠWindows Azureã¹ãã¬ãŒãžã«æ¥ç¶ã§ããŸãã
ã»Windows AzureããŒãã«ã¹ãã¬ãŒãžã¯ãåäžã¬ã³ãŒãããã³ãšã³ãã£ãã£ã°ã«ãŒããã©ã³ã¶ã¯ã·ã§ã³ã®ãã¹ãŠã®æ¿å ¥ãæŽæ°ãåé€ãã©ã³ã¶ã¯ã·ã§ã³ãä¿èšŒããŸãã ãªã¯ãšã¹ãããšã«ã¹ãããã·ã§ããåé¢ãæäŸãããŸãã èŠæ±ã¯ãèŠæ±ã®å®è¡ã®éå§æãããã©ã³ã¶ã¯ã·ã§ã³ã®å®è¡äžã«ããŒãã£ã·ã§ã³ã®è¡šç€ºãå¶åŸ¡ããŸãã è€æ°ã®ããŒãã«éã®äžè²«æ§ã«ã€ããŠã¯ãã¢ããªã±ãŒã·ã§ã³éçºè ã責任ãè² ããŸãã
ã»Windows AzureããŒãã«ã¯ãã°ããµããŒãããŠãããå®è¡äžã®ãã¹ãŠã®ã¯ãšãªã衚瀺ã§ããŸãã ãã®ã³ã°ã¯ãã¯ãšãªã®éçŽã¡ããªãã¯ãæäŸããŸãã
ã»çŸåšãWindows Azure SQL Databaseã¯ãã°ãšã¡ããªãã¯ãæäŸããŠããŸããããã¯ãšãªããã©ãŒãã³ã¹ã®åé¡ã®èšºæãããŒã¿ããŒã¹æ¥ç¶ã®ç£èŠãã¢ã¯ãã£ããªãã©ã³ã¶ã¯ã·ã§ã³ã®è¡šç€ºãã¯ãšãªå®è¡ãã©ã³ã®èª¿æ»ã«åœ¹ç«ã€åç管çãã¥ãŒ ïŒDMVïŒã®ã»ãããåããŠããŸãã
ã»Windows Azure SQLããŒã¿ããŒã¹ã¯SQL Serverãšã³ãžã³ã«åºã¥ããŠãããããTempDBããã©ã³ã¶ã¯ã·ã§ã³ãã°ãªã©ãããã€ãã®æŠå¿µã䜿çšã§ããŸãã ãã©ã³ã¶ã¯ã·ã§ã³ãã°ã®ç¡å¶éãªå¢å€§ãé²ãããã«ãSQLããŒã¿ããŒã¹ã¯ãã°ã®ãµã€ãºã«10 GBã®å¶éã課ããŠããŸãã SQLããŒã¿ããŒã¹ã€ã³ãã©ã¹ãã©ã¯ãã£ã¯ãããã®ãã°ã管çããŸãããçŽæ¥ã¢ã¯ã»ã¹ããããšã¯ã§ããŸããã Windows AzureããŒãã«ã¹ãã¬ãŒãžã«ã¯ããããã®ãã°ã«çžåœãããã®ã¯ãããŸããã代ããã«ãå€æŽå¯èœãªããŒã¿ã§ã¯ãªãããªã¯ãšã¹ãã远跡ãããã®ã³ã°ãšã¡ããªãã¯ããããŸãã
ã»ãã«ãããã³ãç°å¢ã§ã®ãªãœãŒã¹ã®éå°ãªäœ¿çšãé²ãããã«ãäž¡æ¹ã®ãµãŒãã¹ã¯èª¿æŽã¡ã«ããºã ã䜿çšããŸããããããã®ãµãŒãã¹ã®åäœåçã«ãã£ãŠç°ãªããŸãã ããšãã°ãSQLããŒã¿ããŒã¹ã§ã¯ã ãœãã調æŽãšããŒã調æŽã® 2ã€ã®èª¿æŽæŠç¥ã䜿çšãããŸã ããããã«ã€ããŠã¯ã ãã¡ãã§ç¢ºèªã§ããŸã ã
容éãšã¯ã©ãŒã¿
æ¯èŒåºæº | Windows AzureããŒãã«ã¹ãã¬ãŒãž | SQLããŒã¿ããŒã¹ |
æ倧ã¬ã³ãŒããµã€ãº | 1 Mb
次ã®3ã€ã®å¿ é ããããã£ãå«ã255å以äžã®ããããã£ïŒ PartitionKey ã RowKey ã Timestamp ã | 2 GB
æ倧1024åïŒã¹ããŒã¹åã䜿çšãããå Žåã¯30,000ïŒã varcharïŒmaxïŒ ã varbinaryïŒmaxïŒ ã xml ã text ãããã³imageã䜿çšãããšãè¿œå ã®2 GBã䜿çšã§ããŸãã |
æ倧ããŒã¿ãµã€ãº | ããŒãã«ããã100 TB
1ã€ã®ã¹ãã¬ãŒãžã¢ã«ãŠã³ãïŒããŒãã«ãBLOBãããã³ãã¥ãŒãå«ãïŒã®ãµã€ãºã¯æ倧100 TBã§ãããŒãã«ã®æ倧ãµã€ãºã¯100 TBã§ãã | DBããã150 GB
å°æ¥çã«ããŒã¿ããŒã¹ã®äžéãµã€ãºãå¢ããå¯èœæ§ã¯ãããŸãããSQLãã§ãã¬ãŒã·ã§ã³ã«æ³šæããŠãã ããã |
åäžã®ã¯ãšãªã§è¿ãããã¬ã³ãŒãã®æå€§æ° | 1,000
1ã€ã®èŠæ±ã§1000ã¬ã³ãŒããè¶ ããªãã çµæããã®éãè¶ ããå Žåãç¶ç¶ããŒã¯ã³ãè¿ãããŸãã | ç¡å¶é
æ£ããæ§æãããŠããªãå ŽåãèŠæ±ãšæ¥ç¶ã®ã¿ã€ã ã¢ãŠããåå ã§æ°éå¶éã«åé¡ãããå¯èœæ§ããããŸãã |
è¿œå æ å ±
ã»Windows AzureããŒãã«ã¹ãã¬ãŒãžã¯ãå¿çããããŒã§ç¶ç¶ããŒã¯ã³ã䜿çšããŠãããŒã¿ã»ããã«1000ãè¶ ããã¬ã³ãŒããããããšã瀺ããŸãã ãã®ããŒã¯ã³ã䜿çšããŠãæ®ãã®ããŒã¿ãååŸã§ããŸãã ãªã¯ãšã¹ãããšã«ã¹ãããã·ã§ããã®äžè²«æ§ããããŸãããããŒã¯ã³ãå«ããªã¯ãšã¹ãã®å Žåãç¶ç¶ã¯ãããŸããã
ã»ããŒãã«ã¬ã³ãŒãå ã®ãã¹ãŠã®ããããã£ã®åèšãµã€ãºã¯1 Mbãè¶ ããããšã¯ã§ããŸããããã®å¶éã«ã¯ãããããã£åãšãã®å€ã®ãµã€ãºãå«ãŸããŸããããã«ã¯ãPartitionKeyããã³RowKeyã®å¿ é ããããã£ãå«ãŸããŸãã
ã»SQL Databaseã¯çŸåšã5 GBïŒWebãšãã£ã·ã§ã³ïŒãã150 GBïŒBusinessãšãã£ã·ã§ã³ïŒãŸã§ã®ãµã€ãºã®ããŒã¿ââããŒã¹ããµããŒãããŠããŸãã ããŒã¿éãå¢å ããŠãæ§æãããããŒã¿ããŒã¹ã®ãµã€ãºã¯å¢å ããªããããéçºè ã¯ãããã®å¶éå ã«åãŸãããã«ããŒã¿ã®ãµã€ãºãå¶åŸ¡ããå¿ èŠããããŸãã
ã»åçŽãªSQLããŒã¿ããŒã¹ããŒãã«ã®åæ°ã¯1024ïŒããŒã«ã«SQL Serverã«é¡äŒŒïŒã«å¶éãããåã¯ã¹ããŒã¹ã§ãããŒãã«ã«ã¯æ倧30,000ã®åãå«ããããšãã§ããŸãããã®ãã¡ã®1023ã¯ã¹ããŒã¹ã§ã¯ãªãã28976ã¯ã¹ããŒã¹ã§ããå¿ èŠããããŸã
éå¶ç®¡ç
æ¯èŒåºæº | Windows AzureããŒãã«ã¹ãã¬ãŒãž | SQLããŒã¿ããŒã¹ |
管çãããã³ã«ãšãŠãŒãã£ãªã㣠| REST over HTTP / HTTPS
Windows Azure Storage ExplorerãŸãã¯Cloud Storage Studioãªã©ã®ãµãŒãããŒãã£ãŠãŒãã£ãªãã£ã䜿çšã§ããŸãã | ODBC / JDBC
REST over HTTP / HTTPS 管çããŒã¿ã«ãŸãã¯SQL Server Management Studioã䜿çšã§ããŸãã |
ããŒã¿ã¢ã¯ã»ã¹ | OData
HTTPïŒSïŒREST APIãŸãã¯Windows Azure SDKã®äžéšã§ããWCF Data Servicesçšã®.NETã¯ã©ã€ã¢ã³ãã©ã€ãã©ãªã䜿çšããŠããŒã¿ã«ã¢ã¯ã»ã¹ã§ããŸãã | ODBC / JDBC
ADO.NETãODBCãªã©ã®åŸæ¥ã®ããŒã¿ã¢ã¯ã»ã¹ãã¯ãããžã䜿çšããŠäœæãããã¢ããªã±ãŒã·ã§ã³ã䜿çšã§ããŸãããããã®ãã¯ãããžã¯ãSQL Serverãšéä¿¡ããŠãã³ãŒããžã®æå°éã®å€æŽã§SQLããŒã¿ããŒã¹ã®ã€ã³ã¹ã¿ã³ã¹ã«ã¢ã¯ã»ã¹ã§ããŸãã |
Java APIãµããŒã | ã¯ã | ã¯ã |
ãµããŒã
Node.js API | ã¯ã | ã¯ã |
ãµããŒã
PHP API | ã¯ã | ã¯ã |
ãµããŒã
LINQ | ã¯ã | ã¯ã |
ãµããŒã
Python | ã¯ã | ãã |
ãªãã©ã€ã³éçº | ã¯ã
Windows Azure SDKããã®ããŒã«ã«ã¹ãã¬ãŒãžãšãã¥ã¬ãŒã¿ãŒã®ååšã | ãã
SQL Expressããã³SQL Serverã®ä»ã®ãšãã£ã·ã§ã³ã¯ãWindows Azure SQL Databaseã¯ã©ãŠãç°å¢ãå®å šã«ãšãã¥ã¬ãŒãããªãä»ã®è£œåã§ãã |
è¿œå æ å ±
ã»SQL ServerãããŒã«ã«ã«ã€ã³ã¹ããŒã«ããããšã§SQLããŒã¿ããŒã¹ããšãã¥ã¬ãŒãã§ããŸããããã®æ¹æ³ã§ã¯ã調æŽããã®ä»ã®å¶éãªã©ãã¯ã©ãŠããµãŒãã¹ã«åºæã®ç¶æ³ãã·ãã¥ã¬ãŒãã§ããŸããã
ã»Windows Azure SQLããŒã¿ããŒã¹ã¯ãã€ã³ã¿ã©ã¯ãã£ããªã¯ãšãªå®è¡ç°å¢ãæäŸããŸãã ãŸããSSMSãODBCããµããŒããããµãŒãããŒãã£ãŠãŒãã£ãªãã£ãªã©ã®ã³ã³ãœãŒã«ãŠãŒãã£ãªãã£ããSQLããŒã¿ããŒã¹ã«ã¢ã¯ã»ã¹ããããšãã§ããŸãã
ã»SQL ServerãšSQL Databaseã«ã¯ç°ãªãT-SQLæ©èœããããŸã-äžéšã®æ©èœã¯å¶éãããŠãããããŸã£ãããµããŒããããŠããŸãããäžéšã«ã¯å€§ããªéãããããŸãïŒããŒã¿ããŒã¹ãšãã§ãã¬ãŒã·ã§ã³ã®äœæãªã©ïŒã
èªèšŒãšæ¿èª
æ¯èŒåºæº | Windows AzureããŒãã«ã¹ãã¬ãŒãž | SQLããŒã¿ããŒã¹ |
èªèšŒ | 察称ããŒ
å ±æã¢ã¯ã»ã¹çœ²å ãŠãŒã¶ãŒèªèšŒã«ã¯ã512ãããã®HMACããŒã䜿çšãããŸãã | SQLèªèšŒ
ãŠãŒã¶ãŒèªèšŒã§ã¯ãæšæºã®SQLèªèšŒã䜿çšãããŸãã |
圹å²ããŒã¹ã®ã¢ã¯ã»ã¹ | ãã | ã¯ã
SQLã®æšæºããŒã¿ããŒã¹ããŒã«ãšã¢ããªã±ãŒã·ã§ã³ããµããŒããããŠããŸãã |
Windows Azure Active DirectoryïŒä»¥åã®ACSïŒ | ãã | ãã |
IDãããã€ããŒãšã®ãã§ãã¬ãŒã·ã§ã³ | ãã | ãã |
è¿œå æ å ±
ã»SQL DatabaseããµããŒãããããŒã«ããŒã¹ã®ã¢ã¯ã»ã¹ã¢ãã«ã¯ãèªã¿åãå°çšãæžã蟌ã¿å°çšãèªã¿åã/æžã蟌ã¿ãªã©ã®ããŸããŸãªã¢ãŒããèšå®ããããã®å¹ åºããªãã·ã§ã³ãæäŸããŸãã
ã»èšŒææžãŸãã¯Active Directoryã«åºã¥ããã§ãã¬ãŒã·ã§ã³èªèšŒãçŸåšãµããŒãããŠãããµãŒãã¹ã¯ãªããããè³æ Œæ å ±ãååã«ä¿è·ãããŠããããšãããšãã°æå·åãããŠããããšã確èªããå¿ èŠããããŸãã
Windows AzureããŒãã«ã¯ã ããŒãã«SAS ïŒå ±æã¢ã¯ã»ã¹çœ²åïŒã䜿çšããŠURLã«çœ²åããæ©èœãæäŸããŸãã SASã§ã¯ãã¢ã«ãŠã³ãã«ç§å¯éµãçºè¡ããã«äžæçãªã¢ã¯ã»ã¹ãçºè¡ã§ããŸãã
è²»çš
æ¯èŒåºæº | Windows AzureããŒãã«ã¹ãã¬ãŒãž | SQLããŒã¿ããŒã¹ |
ä¿ç®¡è²»çš | 0.125ãã«
1æ¥ãããã®è² è·ã«åºã¥ããŠèšç®ããã1ãæãããã®ã®ã¬ãã€ããããã | ããŒã¿ããŒã¹ã®ãµã€ãºã«åºã¥ããŠèšç®ãããŸãã |
ååŒè²»çš | 0.01ãã«
100,000ãã©ã³ã¶ã¯ã·ã§ã³ã | 0.00ãã«
SQL Databaseã§ã¯ããã©ã³ã¶ã¯ã·ã§ã³ã¯æ¯æãããŸããã |
ææååŒ | å
šéš
ãã©ã³ã¶ã¯ã·ã§ã³ã³ã¹ãã¯ã¹ãã¬ãŒãžã³ã¹ãã«è¿œå ãããŸãã | ãªã
ã³ã¹ãã¯ãã©ã³ã¶ã¯ã·ã§ã³ã®æ°ã«äŸåãããããŒã¿ããŒã¹ã®ãµã€ãºã«ã®ã¿äŸåããŸãã |
ã¢ãŠãããŠã³ãã³ã¹ã | 0.12ãã«-0.19ãã«
ã®ã¬ãã€ãããšãå°åã«ãã | 0.12ãã«-0.19ãã«
ã®ã¬ãã€ãããšãå°åã«ãã |
è¿œå æ å ±
ã»çºä¿¡ãã©ãã£ãã¯ã®ã³ã¹ãã¯ãã€ã³ã¿ãŒãããäžã®ããŒã¿ã»ã³ã¿ãŒã®å¶éãè¶ ããããŒã¿ã®åèšéã«åºã¥ããŠèšç®ãããŸãã æ°éã¯äžå®æéèæ ®ãããŸãã
ã»SQL Databaseãšã¯ç°ãªããWindows AzureããŒãã«ã¹ãã¬ãŒãžã¯è¿œå ã®ãã©ã³ã¶ã¯ã·ã§ã³ã³ã¹ãã課ããŸãã ãã®æ¯æãã¢ãã«ã§ã¯ããã©ã³ã¶ã¯ã·ã§ã³ã®é »åºŠãç·ã³ã¹ãã«åœ±é¿ããèŠå ãšããŠèæ ®ããå¿ èŠããããŸãã
ãããã«
Windows AzureããŒãã«ã¹ãã¬ãŒãžãšWindows Azure SQLããŒã¿ããŒã¹ã®ã©ã¡ãã䜿çšãããã¯ãå€ãã®èŠå ã«äŸåããŸãããããã®èŠå ã¯ãã¢ããªã±ãŒã·ã§ã³ã®ç¹å®ã®ç¹æ§ããã®ã¢ãŒããã¯ãã£ãè² è·ã®çš®é¡ãããŒã¿ã¢ã¯ã»ã¹ãã¿ãŒã³ã«å€§ããäŸåããŸãã
Windows AzureããŒãã«ã¹ãã¬ãŒãžã¯ãæ倧æ°ãã©ãã€ãããã³æ°ååã¬ã³ãŒãã®ã¹ã±ãŒã©ãã«ãªã¯ã©ãŠãã¹ãã¬ãŒãžã«å€§éã®ããŒã¿ãä¿åããæ©èœããµããŒãããŠããŸãã ãã®ã¬ãã«ã®ã¹ã±ãŒãªã³ã°ãå®è£ ããããã«ãWindows AzureããŒãã«ã¹ãã¬ãŒãžã¯ãåçŽã¹ã±ãŒãªã³ã°ã¢ãã«ã䜿çšããŠè€æ°ã®ã¹ãã¬ãŒãžããŒãéã§ã¬ã³ãŒããåæ£ããŸãããµãŒãã¹ã¯ãNoSQLã¢ãã«ã䜿çšããŠãã®ã¬ãã«ã®ã¹ã±ãŒãªã³ã°ãå³å¯ãªäžè²«æ§ã§ãµããŒãããŸãã 倧éã®éãªã¬ãŒã·ã§ãã«ããŒã¿ãŸãã¯åçŽãªããŒã¿ãæ ŒçŽã§ããå®äŸ¡ãªã¹ãã¬ãŒãžãå¿ èŠãªå Žåã¯ã Windows AzureããŒãã«ã¹ãã¬ãŒãžã® 䜿çšãæ€èšããŠãã ãã ã
䜿ãæ £ããããŒã«ãããŸããŸãªåé¢ã¬ãã«ã§ã®ACIDãã©ã³ã¶ã¯ã·ã§ã³ãµããŒããé«åºŠãªããŒã¿åŠçæ©èœãæäŸããªããããªã³ãã¬ãã¹ã®SQL Serverãã¯ã©ãŠãã«æ¡åŒµããWindows Azure SQLããŒã¿ããŒã¹ã®äœ¿çšãæ€èšããŠãã ããã ããŒã¿ããªã¬ãŒã·ã§ãã«ã§ãããããŒã¿ã管çããéã«ãããèæ ®ããå¿ èŠãããå ŽåãSQL Databaseã䜿çšããã®ãæé©ãªãªãã·ã§ã³ã§ãã
解決çã¯1ã€ã®ãã¯ãããžãŒãéžæããããšã§ã¯ãªãããšã«æ³šæããŠãã ãããç¹å®ã®ã·ããªãªã§äž¡æ¹ã®ãã¯ãããžãŒãæé©ãªæ¹æ³ã§äœ¿çšããæ¹æ³ã決å®ã§ããŸãã