Spring Bootã«ããAPIããã¯ã¨ã³ãæ§ç¯å®è·µã¬ã¤ã 第2ç ä½å人ãã®éçºè ããInfoQã®ããããã¯ãPractical Guide to Building an API Back End with Spring BootããããSpring Bootã使ã£ãREST APIæ§ç¯ã®åºç¤ãå¦ãã ããã®æ¬ã§ã¯ãåºçæã«æ°ãããªãªã¼ã¹ããããã¼ã¸ã§ã³ã§ãã Spring Boot 2 ã使ç¨ãã¦ãããããããSpring Boot3ãæè¿ãªãªã¼ã¹ãããéè¦ãªå¤...
ãã¤ã¼ãä»æ¥ã¯ã第 1 åã®SQL ã¢ã³ããã¿ã¼ã³ã®åããè¯ã³ã³ãã³ããæä¾ãã¾ãããªã¨ã³ãã«ããã»ãã¯ããã¸ã¼ãºãã主å¬ã®ç¬¬ 3 å DB ã¨ã³ã¸ãã¢ã®ããã®åå¼·ä¼ã«åå ãã¦ãã¾ããã ä»å㯠漢(ãªãã³)ã®ã³ã³ãã¥ã¼ã¿éã§æåãªæ¼¢ã®ä¸ã®æ¼¢ã @nippondanji æ°ããã¼ã¿ãã¼ã¹è¨è¨ãå¾¹åºæåãã¦ãããã¨ãããã¨ã§ãå ã DB ã¨ã³ã¸ãã¢ãããã¯ã°ã©ã³ãã®ãããã¨ãã¦ã¯ãããªãããã«ã¯ãããã ãããã¨åã³åãã§ãã£ã¦ãã¾ããï¼ å 容ã¯ã¨ããã¨ä¸è¨ã®æ¦è¦ãã«ãã¼ããå 容ã§ããã ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ï¼ä»¥ä¸RDBï¼ã¯ç»å ´ãã¦ããããªãã®æéãçµã£ã¦ãã¾ãããã®åã示ãããã«ãRDBã¯ãªã¬ã¼ã·ã§ãã«ã¢ãã«ããã¼ã¹ã«èæ¡ãããã½ããã¦ã§ã¢ã§ããããããªãããæªã ã«ç¾å ´ã§ã¯RDBã使ãããªããã¦ããã¨ã¯è¨ããããããªã¬ã¼ã·ã§ãã«ã¢ãã«ã¸ã®ç解ãé²ã¾ãã誤ã£ã常èãè·æãã¦ããã®ãç¾ç¶ã§
ï¼»éå ±ï¼½ãªã©ã¯ã«ãOracle 12cã«ã¤ã³ã¡ã¢ãªã¨ã«ã©ã åãã¼ã¿ãã¼ã¹ã®è¿½å æ©è½ãçºè¡¨ï½Oracle OpenWorld 2013 ç±³ãªã©ã¯ã«ä¸»å¬ã®ã¤ãã³ããOracle OpenWorld 2013ãããµã³ãã©ã³ã·ã¹ã³ã§éå¹ãã¾ããã å社CEOã®ã©ãªã¼ã»ã¨ãªã½ã³æ°ã¯æåã®åºèª¿è¬æ¼ã«ç»å£ãç¾å¨ãã¼ã¿ãã¼ã¹ã®æ°ããæè¡ã¨ãã¦æ³¨ç®ããã¦ããã¤ã³ã¡ã¢ãªã¨ã«ã©ã åãã¼ã¿ãã¼ã¹ã®æ©è½ããªãã·ã§ã³ã¨ãã¦Oracle Database 12cã«è¿½å ããã¨çºè¡¨ãããã«ã¤ã³ã¡ã¢ãªå¦çã«åªãã32TBã¡ã¢ãªæè¼å¯è½ãªæ°åSPARCãµã¼ããçºè¡¨ãã¦ãã¾ãã åºèª¿è¬æ¼ã®å 容ããã¤ã¸ã§ã¹ãã§ç´¹ä»ãã¾ãã Oracle Databaseã®In-Memroyãªãã·ã§ã³çºè¡¨ ç±³ãªã©ã¯ã«CEO ã©ãªã¼ã»ã¨ãªã½ã³æ°ããæ©å«ãªè¡¨æ ã§ç»å ´ã
ã«ã©ã åãã¼ã¿ãã¼ã¹ã§ãã©ã³ã¶ã¯ã·ã§ã³å¦çãå®ç¾ããã«ã©ã¯ãªã¨ã¯ï¼ ã¤ã³ã¡ã¢ãªã¨ã«ã©ã åãã¼ã¿ãã¼ã¹ã®å¯è½æ§ã調ã¹ãï¼ãã®5ï¼ SAPã®HANAã¯ãæåããã¤ã³ã¡ã¢ãªãã¼ã¿ãã¼ã¹ã¨ã«ã©ã åãã¼ã¿ãã¼ã¹ã®æè¡ãç¨ãã¦é«éãªéè¨ãåæå¦çã¨é«éãªãã©ã³ã¶ã¯ã·ã§ã³å¦çã¨ã両ç«ããããã¨ãç®æãã¦éçºãããã¨ãHANAã®éçºè ã§ããSAPã®å ±ååµæ¥è ã§ããããã½ã»ãã©ãã¿ãã¼æ°ã¯HANAã®è¨è¨ææ³ã¨å®è£ ã解説ããèæ¸ãIn-Memory Data Managementãã§æ¸ãã¦ãã¾ãã ããã§ã¯ããã®æ¸ç±ããã³å ¬éããã¦ããè«æãEfï¬cient Transaction Processing in SAP HANA Database â The End of a Column Store Mythãï¼SAP HANAãã¼ã¿ãã¼ã¹ã«ãããå¹æçãªãã©ã³ã¶ã¯ã·ã§ã³å¦ç â ã«ã©ã ã¹ãã¢ç¥è©±ã®çµçï¼ãã
ã«ã©ã åãã¼ã¿ãã¼ã¹ã¯ãªãéè¨å¦çãé«éã§ããã©ã³ã¶ã¯ã·ã§ã³ãè¦æãªã®ããã¤ã³ã¡ã¢ãªã¨ã«ã©ã åãã¼ã¿ãã¼ã¹ã®å¯è½æ§ã調ã¹ãï¼ãã®4ï¼ ç¾å¨ä¸»æµã¨ãªã£ã¦ããOracleãSQL ServerãDB2ãªã©ã®ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã¯äºå®ä¸ãã¹ã¦ãè¡ï¼ãã¼ï¼æåã§å é¨ã®å¦çãè¡ã£ã¦ãã¾ããä¸æ¹ã§ãæè¿æ¥éã«æ³¨ç®ããã¦ããã®ããåæåã§å é¨å¦çãè¡ãã大éãã¼ã¿ã®éè¨ãåæå¦çã«åªãããã«ã©ã åãã¼ã¿ãã¼ã¹ãï¼ãããã¯ã«ã©ã æåãã¼ã¿ãã¼ã¹ãã«ã©ã ãã¼ãã¼ã¿ãã¼ã¹ï¼ã§ãã ã«ã©ã åãã¼ã¿ãã¼ã¹ã¯Sybase IQãNetezzaãVerticaãªã©ãã¼ã¿ã¦ã§ã¢ãã¦ã¹å°ç¨ã®ãã¼ã¿ãã¼ã¹ã§ä¸»ã«æ¡ç¨ããã¦ãã¾ããã¾ããSQL Serverã«ã¯ãColumnStore IndexããOracle Exadataã«ã¯ãHybrid Columnar Compressionãã¨å¼ã°ããã«ã©ã åãã¼ã¿ãã¼ã¹ã®
å¾æ¥ã®ãã¼ã¿ãã¼ã¹ãã¡ã¢ãªã«è¼ããã ãã§ã¯ã ããªã®ãï¼ ã¤ã³ã¡ã¢ãªã¨ã«ã©ã åãã¼ã¿ãã¼ã¹ã®å¯è½æ§ã調ã¹ãï¼ãã®2ï¼ ç¾ä»£ã®ãµã¼ãã¯1å°ã§è¤æ°ã®ããã»ããµãåããæ°ç¾ã®ã¬ãã¤ãããæ°ãã©ãã¤ãã®ã¡ã¤ã³ã¡ã¢ãªãæè¼å¯è½ã§ããããã¯å¤ãã®ä¼æ¥ã§å©ç¨ããã¦ãããã¼ã¿ãã¼ã¹ããã®ã¾ã¾ã¡ã¢ãªã«è¼ãã»ã©ã®å®¹éã§ãã 大éã®ã¡ã¢ãªãæè¼ãããµã¼ããç¨ããã°ãOracle DatabaseãSQL ServerãDB2ãªã©å¾æ¥ã®ãã£ã¹ã¯ãã¼ã¹ã®ãã¼ã¿ãã¼ã¹ã§ãããã¼ã¿ãã¼ã¹ãã¾ããã¨ã¡ã¤ã³ã¡ã¢ãªã®ãããã¡ãã£ãã·ã¥ã«è¼ãããã¨ãã§ãã¾ããããããã°ãã£ã¹ã¯ã¢ã¯ã»ã¹ã®ããã«ããã¯ã¯äºå®ä¸ã»ã¨ãã©ãªããããããé«éãªãã¼ã¿ãã¼ã¹ã¢ã¯ã»ã¹ãå®ç¾ãã¾ãã ã ã¨ãããããã¼ã¿ãã¼ã¹ããã¹ã¦ã¡ã¢ãªã«è¼ããæ©è½ãåããã¤ã³ã¡ã¢ãªãã¼ã¿ãã¼ã¹ãããããã使ãå¿ è¦ã¯ããã®ã§ããããï¼ ãã®çåã¯ã以åã®è¨äºããã£ãã·ã¥ã®å¤§ã
ã¤ã³ã¡ã¢ãªãã¼ã¿ãã¼ã¹ãã«ã©ã åãã¼ã¿ãã¼ã¹ã¯ä½¿ãç©ã«ãªãã®ãï¼ ã¤ã³ã¡ã¢ãªã¨ã«ã©ã åãã¼ã¿ãã¼ã¹ã®å¯è½æ§ã調ã¹ãï¼ãã®1ï¼ ERPãã³ãæ大æã®SAPã¯2010å¹´ãæ°è¦ã«éçºãããã¼ã¿ãã¼ã¹ãSAP HANAãï¼å½æã®å称ã¯ãSAP High-Performance Analytics Applianceãï¼ãçºè¡¨ãã¾ããã HANAã®è£½ååãèæ¯ã«ãSAPã¯2012å¹´5æã«ãã¼ã¿ãã¼ã¹å¸å ´ã¸ã®æ¬æ ¼åå ¥ã宣è¨ãããªã©ã¯ã«ãIBMããã¤ã¯ãã½ããã¨ãã¼ã¿ãã¼ã¹å¸å ´ã§ç«¶åãã¦ãããã¨ã表æãããã¦ä»å¹´2013å¹´2æã«ã¯ã¤ãã«ERPã¨çµã¿åããããSAP Business Suite powered by SAP HANAãã®åºè·ãéå§ããæ¥åã¢ããªã±ã¼ã·ã§ã³ã®ããã¯ã¨ã³ããã¼ã¿ãã¼ã¹ã¨ãã¦HANAã®æ¬æ ¼å©ç¨ãéå§ãã¾ããã HANAã«ã¯ãããã¾ã§ä¸»æµã ã£ããªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã¨ã¯ç°ãªã
2013å¹´3æ26æ¥ããçºçãã¦ããä½æ°åºæ¬å°å¸³ãããã¯ã¼ã¯ã·ã¹ãã ï¼ä½åºãããï¼ã®é害ã®åå ãããã¼ã¿ãã¼ã¹ï¼DBï¼ã«æ å ±ãæ¸ãè¾¼ãéã®æåã³ã¼ãã®èª¤ãï¼æååãï¼ã«ãã£ããã¨ããé害ãå½±é¿ããå¸çºæã®åè¨ã231ã«åãã§ãããã¨ãªã©ãåãã£ããç·åçã4æ2æ¥ã«çºè¡¨ããï¼é¢é£è¨äºï¼å ¨å½200ã®èªæ²»ä½ã§ä½åºããããå©ç¨ä¸å¯è½ã«ãªãé害ãçºçï¼ã ä»åã®é害ã¯ãèªæ²»ä½ã«ããä½æ°åºæ¬å°å¸³ã·ã¹ãã ã¨ä½åºããããæ¥ç¶ãããã³ãã¥ãã±ã¼ã·ã§ã³ãµã¼ãã¼ãã®ãã¼ãã¦ã¨ã¢ã¨OSã231ã®èªæ²»ä½ã§æ´æ°ããããã«ä¼´ããã³ãã¥ãã±ã¼ã·ã§ã³ãµã¼ãã¼ã®ã¢ããªã±ã¼ã·ã§ã³ã«å¯¾ãã¦ãæ°OSã«å¯¾å¿ãããä¿®æ£ããã°ã©ã ãé©ç¨ãããã¨ã§çºçããã ã³ãã¥ãã±ã¼ã·ã§ã³ãµã¼ãã¼ã®ã¢ããªã±ã¼ã·ã§ã³ã¯ãæ°åã»ä½æã»çå¹´ææ¥ã»æ§å¥ã¨ãã4ã¤ã®ãæ¬äººç¢ºèªæ å ±ãããDBãµã¼ãã¼ã§ãããOracle Databaseãã«ä¿åããéã«ãä½åºã
Making Snapshot Isolation Serializable åè â 2013å¹´çãªä½ç½®ä»ã ã¾ãã¡ããã©å¹´åº¦ã®éå§ãªã®ã§ãä»å¹´ã¯èªåçã«ã¯RDBMSé¢é£ã®ä½ç½®ä»ãã¨ãæ´çãã¦ããã¾ããå»å¹´ã®å¾åãããããã®åãã§ãããNoSQLçãªçºå±ã¨åããã¦ãæ¬æ ¼çãªDBå帰ãå§ã¾ã£ã¦ããæãã§ããNoSQLç³»ã®ã»ã¼è´å½çãªå¼±ç¹ã®ä¸ã¤ãtransactionå¦çã§ãããã¨ã¯ææãå¤ãã¨ããã§ããè¦ããã«ãã¼ã¿ãæ¸ãè¾¼ãã¦ãä¸æ´åãçºçãã¾ãããã¨ãããã¨ã«ãªã£ã¦ãã¾ãã¾ããããã§ã¯ãªããªã使ããªããã¨ããã®ãç¾ç¶ã§ãããã ãªã®ã§ãRDBMã®æè¯ã®ãã¦ãã¦ã§ããtransactionå¦çã¨NoSQLçãªåæ£å¦çãã¡ããã¨æ´åæ§ã¨ããããã«ãã¾ããããã¨ããèªç¶ãªæµãã¯å¾åãããããå¼·ãè¦è«ãåãã§ãããã(ã§ãããã©ããã¯å¥ã§ããã) ããã§ããããããªãããã®æã®ãã®ãRDBMSãµ
æ¬æ¸ã¯DBè¨è¨ãSQLè¨è¿°ã®éã«é¿ããã¹ãäºæã1ç« ã§1ã¤ã25åç´¹ä»ããæ¸ç±ã§ãããªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ãä¸å¿ã«æ®ããã·ã¹ãã éçºã«ã¯ãæ§ã ãªå ´é¢ã§é¥ãããã失æï¼ã¢ã³ããã¿ã¼ã³ï¼ãããã¾ããæ¬æ¸ã¯ãã¼ã¿ãã¼ã¹è«çè¨è¨ããã¼ã¿ãã¼ã¹ç©çè¨è¨ãã¯ã¨ãªã®è¨è¿°ãã¢ããªã±ã¼ã·ã§ã³éçºã¨ãã4ã¤ã®ã«ãã´ãªã«åããããããã®åéã«ãããã¢ã³ããã¿ã¼ã³ãç´¹ä»ãã失æãé¿ããããã®ããè¯ãæ¹æ³ãç´¹ä»ãã¾ããè¤æ°ã®å¤ãæã¤å±æ§ãå帰çãªããªã¼æ§é ã®æ ¼ç´ãããå°æ°å¤ã®ä¸¸ããNULLã®æ±ãã«èµ·å ããåé¡ãå ¨ææ¤ç´¢ãSQLã¤ã³ã¸ã§ã¯ã·ã§ã³ãMVCã¢ã¼ããã¯ãã£ãªã©ãå®è·µçãã¤å¹ åºããããã¯ãç¶²ç¾ ãã¾ããæ¥æ¬èªçã§ã¯ãMySQLã®ã¨ãã¹ãã¼ãã¨ãã¦èåãªå¥¥éå¹¹ä¹æ°ã«ããã¢ã³ããã¿ã¼ã³ãåé²ããã¼ã¿ãã¼ã¹ã«é¢ãããã¹ã¦ã®ã¨ã³ã¸ãã¢å¿ æºã®ä¸åã§ãã æ¬æ¸ã¸ã®ç§°è³ã®å£° ç£è¨³è ã¾ããã ã¯ããã« Ié¨ ãã¼ã¿ãã¼ã¹è«
SQLã¨NoSQLã§ã¯ã©ã¡ããåªãã¦ããã®ãï¼ ã°ã¼ã°ã«ã®æ å½è ããã£ãã¼ãï¼ã¨ããããå°èå± ï¼-ï¼ãè¡ã£ãã»ãã·ã§ã³ãGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeããå ¬éããã¦ãã¾ãã ãã®ã»ãã·ã§ã³ã¯ãå ã é±éå¬ãããGoogle I/O 2012ã§è¡ããããã®ãSQLã¨NoSQLã«ã¯æ©è½çã«ã©ã®ãããªéãããããã©ã使ãåããã¹ããªã®ããæ確ãªèª¬æãåèã«ãªãã¾ãã ãã¤ã©ã¤ããç´¹ä»ãã¾ãããã ã¯ã©ã¦ãã«ããããã¼ã¿ãã¼ã¹ã®ã¡ãªãã ã°ã¼ã°ã«ã®Alfred Fulleræ°ï¼NoSQLæ å½ï¼ã ã¯ã©ã¦ãã¯ãã©ã«ããã¬ã©ã³ãã§ã¡ã³ããã³ã¹ä¸è¦ãããããç§ãã¡ãé©ç¨ãã¦ãããå©ç¨è ã¯éç¨ã«ã¤ãã¦å¿é ããå¿ è¦ããªããã¨ãã£ãã¡ãªãããããã ãã¼ã¿ã®ã¬ããªã±ã¼ã·ã§ã³ãå°ååæ£ã§ãã¼ã¿ãä¿å ¨ãããã¤ã³ã¿ã¼ãã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}