2017/09/05 db tech showcase Tokyo 2017 http://www.db-tech-showcase.com/dbts/tokyo
PostgreSQLã¨MySQLã使ããªãã©ã£ã¡ï¼Â ãã¼ã¿ãã¼ã¹å°éå®¶ã8ã¤ã®è¦ç¹ã§å¾¹åºæ¯è¼ï¼ ãªã¼ãã³ã½ã¼ã¹ã®ãã¼ã¿ãã¼ã¹ã¨ãã¦ããæ¯è¼ãããPostgreSQLã¨MySQLãã©ããªé·æã»çæãããã®ã§ãããï¼Â ããããã®å°éå®¶ã«ãã対è«ã§æããã«ãã¾ãã ã¨ã³ã¸ãã¢ã¨ãã¦åãã¦ããã¨å¿ ãç´é¢ããæ©ã¿ãããã¯ããã©ã®ãªã¬ã¼ã·ã§ãã«ã»ãã¼ã¿ãã¼ã¹ï¼ä»¥ä¸ãRDBï¼ãé¸ã¶ã®ãæåãªã®ãï¼ãã§ãã RDBãã¨ã«é·æã¨çæã¯ç°ãªã£ã¦ãã¾ãããã®ããèªç¤¾ãµã¼ãã¹ã«ãããããªãRDBãé¸ãã§ãã¾ãã¨ããããããã«ããã¯ã¨ãªãéçºã»éç¨ã«ãã©ãã«ãçããã±ã¼ã¹ã¯å°ãªãããã¾ããã ãªãã§ãããæ¯è¼æ¤è¨ãããã®ããPostgreSQLã¨MySQLãã¨ãã«ãªã¼ãã³ã½ã¼ã¹RDBã®ããã¡ã¯ãã¹ã¿ã³ãã¼ãã§ãããé«ãæ§è½ã¨æ°å¤ãã®æ©è½ãæã£ã¦ãã¾ãã ã§ã¯ã両è ã¯å ·ä½çã«ã©ã®ãããªé·æã»çæãããã®ã§ãããããã
NTTãã¼ã¿ã¨PostgreSQLãæãã ç·åæ¦ãPostgreSQLãæ¥µéã¾ã§ä½¿ãåã£ããã®å ã«è¦ããã®ã¨ã¯ï¼ï¼åç·¨ï¼ NTTãã¼ã¿ãªã¼ãã³ã½ã¼ã¹DAY2015 ç¾å¨ã®ã·ã¹ãã æ§ç¯ã§ã¯ããªã¼ãã³ã½ã¼ã¹ã®ã½ããã¦ã§ã¢ã使ããã¨ã¯å½ããåã«ãªã£ã¦ãã¦ãã¾ããPostgreSQLã¯ããããä¸ã§ä¸»ã«ã¨ã³ã¿ã¼ãã©ã¤ãºåãã®ãã¼ã¿ãã¼ã¹ã¨ãã¦çå®ã«äºä¾ãå¢ããã¦ãã¦ãã¾ãã ãã®ä¸ã§ãPostgreSQLãå¤§è¦æ¨¡ãªããã·ã§ã³ã¯ãªãã£ã«ã«ãªã·ã¹ãã ã®ä¸ã§ä½¿ãã«ã¯ãã©ã®ãããªãã¦ãã¦ãæ±ããããã®ãããªã¼ãã³ã½ã¼ã¹ã®å©ç¨ã«ç©æ¥µçãªNTTãã¼ã¿ããã®äºä¾ãã1æ26æ¥ã«éå¬ãããã¤ãã³ããNTTãã¼ã¿ãªã¼ãã³ã½ã¼ã¹DAY 2015ãã®ã»ãã·ã§ã³ãNTTãã¼ã¿ã¨PostgreSQLãæãã ç·åæ¦ãPostgreSQLãæ¥µéã¾ã§ä½¿ãåã£ããã®å ã«è¦ããã®ã¨ã¯ï¼ãã§ç´¹ä»ãã¦ãã¾ããè¬æ¼å 容ããã¤ã¸ã§ã¹ãã«ãã¾ã
èªåã¯ä¸å¿æ«ãMySQLã®éçºè ã ã£ãã®ã§ãMySQLã§ã§ãããã¨ã§ããªããã¨ã¯ããããã訳ã§ããç¾å®çãªåé¡ã¨å¯¾å³ãããã¨ï¼å¹´éãMySQLã¯ä½¿ãããã¨ã«ãã使ããªãããã§ãããããã¨æ§ç¯ãã¦ãã¾ãã¨ãã¢ã©ã¼ãã¡ã¼ã«ãå ¨ãæ¥ãªãã®ã§ãæ°´ã空æ°ã®ããã«åå¨ãå¿ãã¦ãã¾ãã¾ããã§ãã使ããªããã¨ã«ã¯å ¨ãä½¿ãæ°ãããªãããã§â¦ãã¨ããããã§MySQLã¯çµå±éã«ãã¾ã触ãã¦ãã¾ãããéãããç¯å²ã§ã¯å®æãè¦ã¦ããã¨ããããã§ããããã ãã¼ã¿ãå¦çãã¦ä½ã貯ãã¦å©ç¨ã§ãããã®ããã¼ã¿ãã¼ã¹ã¨ãããªãã°ãMySQLãé©ç¨ããæ°ãèµ·ããªããããªé åããã£ã¦ãè¿å¹´ã¯ãã®ãããªé åã«æãå¥ã®éå ·ãåºã¦ãã¦ãã¾ãã ä»åã¯è¶£åãå¤ãã¦ãããããç¾ç¶MySQLã§ã¯æ±ããªãåé¡ã®è§£æ±ºæ³ã模索ãããã¨ã«ã¤ãã¦å°ã触ãã¾ããMySQLãé¢ãã話é¡ã§ããããã¤ãé ãæªæ¥ã«MySQLã®ä¸çã«æã£ã¦å¸°ãäºæããç¥ãã¾ã
å½ãµã¤ãã§ã¯ãæ¥æ¬å½å ã¡ã¼ã«ã¼ã®èªåè»ã«é¢ããã¹ããã¯æ°å¤ãè»ç¨®ãã°ã¬ã¼ãå¥ã« 確èªãããã¨ãã§ãã¾ããã¨ã³ã¸ã³ã¹ããã¯ãè»ä¸¡ã¹ããã¯ãã¿ã¤ã¤ããã¤ã¼ã«ã®ãµã¤ãºã«ãæè¼ããã¦ããããããªã¼ã®è¦æ ¼ã èªåè»ç¨ãèªåè»ééç¨ãèªè³ 責ä¿éºæã®éé¡ãªã©ãããããèªåè»ã«é¢ããæ°å¤(ã¹ããã¯)ãã覧ã«ãªãã¾ããã¾ãã é¢é£ããå°éç¨èªã®è§£èª¬ãæ²è¼ãã¦ãã¾ãã
æ¦è¦ ãæ¼¢åãã¼ã¿ãã¼ã¹ããã¸ã§ã¯ããã¯ãUnicode / UCS (Universal Multiple-Octet Coded Character Sets) ã«ãã£ã¦ç¬¦å·åãããæ¼¢åï¼CJKçµ±åæ¼¢åï¼ã®æ å ±äº¤æã»æ¤ç´¢ç §åã»åæã«å½¹ç«ã¤æ§ã ãªãã¼ã¿ãã¼ã¹ãæ´åãããã¨ãç®çã«ã2003å¹´åº¦ã«æ¥æ¬å¦è¡æ¯èä¼ç§å¦ç ç©¶è²»è£å©éã»ç ç©¶ææå ¬éä¿é²è²»ï¼ãã¼ã¿ãã¼ã¹ï¼ã®æ´å©ãåãã¦éå§ãã¾ããã å種漢åãã¼ã¿ãã¡ã¤ã«ã¯ãGitHubã«ã¦ç®¡çããã¦ãããGitHubãµã¼ãããåå¾ãããã¨ãã§ãã¾ãã ã©ã¤ã»ã³ã¹ã«ã¤ã㦠æ¬ããã¸ã§ã¯ãã®ãã¼ã¿ã¯ãGPLã©ã¤ã»ã³ã¹ããã³MITã©ã¤ã»ã³ã¹ã«ã¦é å¸ãã¦ãã¾ãã GPLã©ã¤ã»ã³ã¹ã«ããé å¸ IDSãã¼ã¿ï¼ids.txtï¼ èª¬æè§£å注ï¼å æ¸é³å表çãå«ãï¼ãã¼ã¿ 宿¬å»£é»ãã¼ã¿ å¸çåå ¸ãã¼ã¿ MITã©ã¤ã»ã³ã¹ã«ããé å¸ ä¸è¨ä»¥å¤ã®ãã¹ã¦ã®ãã¼ã¿ï¼ä»¥ä¸ãå«
ããã«ã¡ã¯ãæè¡é¨ã®åå·ã§ãã ä»åã¯ã¯ãã¯ãããã®éçºç°å¢æ§æãç¹ã«éçºç¨ãã¼ã¿ãã¼ã¹ã®æ§æã«ã¤ãã¦ãç´¹ä»ãã¾ãã éçºç°å¢ã®æ§æ ã¯ãã¯ãããã®ã·ã¹ãã ç°å¢ã¯ä»¥ä¸ã®ãããªãã§ã¤ãºã«åããã¦ãã¾ãã â» ããã¯cookpad.comã®æ§æã§ããµãã·ã¹ãã ãåå¥ã®ãµã¼ãã¹ã¯ãã®è¦æ¨¡ãç¹æ§ã«å¿ãã¦æ§æãç°ãªãã¾ãã development éçºè ãå®éã«éçºãè¡ãç°å¢ã§ããã¯ãã¯ãããã§ã¯ä»®æ³ç°å¢ã¯ç¨ãããæå ã®ãã·ã³ã§Railsã¢ããªã±ã¼ã·ã§ã³ãåããã¦éçºãè¡ã£ã¦ãã¾ãã ãã¼ã¿ãã¼ã¹ã¯ãã¼ã«ã«ã§ã¯ãªããéçºè å ¨ä½ã§å ±éã®éçºç¨ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ãã¦ãã¾ãã test æå ã§ãã¹ããå®è¡ããå ´åã¯ããã¼ã«ã«ãã·ã³ã®ãã¼ã¿ãã¼ã¹ãå©ç¨ãã¾ããCIï¼rrrspecï¼ãªã©ã®å ´åãåæ§ã§ããã¹ãå®è¡ãµã¼ãã¼ã®ãã¼ã¿ãã¼ã¹ãå©ç¨ããã¾ãã staging stagingã¨ããã°æºæ¬çªç°å¢ã¨ãã¦ãæ¬
ãã©ããæ å ±ããã©ããåè£ã®ç´¹ä»ããã©ããå ¥å£é¸æã®ããå ¥ãå¾ã®æç¸¾ã
DeClang èªçï¼Clang ãã¼ã¹ã®ãããã³ã°å¯¾çã³ã³ãã¤ã©ãDeNA TechCon 2020 ã©ã¤ãé ä¿¡ã
æè¿ãã©ãã宿ã«ãNoSQLã«ããã°åä»ãªDBè¨è¨ããéæ¾ããããã¨èãã¦ãã人ãå¤ãããã«æãã¦ä»æ¹ããªããã ãå¾ ã£ã¦æ¬²ãããæ¬å½ã«NoSQLã¨å¼ã°ãããã¼ã¿ãã¼ã¹ã使ãã°ã¢ããªã±ã¼ã·ã§ã³ã®éçºã»éç¨ã®è¦ãã¿ããéããããã®ã ãããããã¡ããããããªãã¨ã¯ç¡ãï¼ï¼çµ¶å¯¾ã«ã ï¼ï¼ãã¨ç§ã¯èããã仿¥ã¯ãã®çç±ã«ã¤ãã¦èªããã¨æãã ãã©ã³ã¶ã¯ã·ã§ã³å æ¥ããªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã«ãããDBè¨è¨ã«ã¤ãã¦ã»ããã¼ã§è§£èª¬ããã°ããã ãããªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã«ããããã¼ã¿ã®æ´åæ§ã¯ä½ãDBè¨è¨ã ããæ ä¿ãã¦ããããã§ã¯ãªãããªã¬ã¼ã·ã§ãã«ã¢ãã«ã¨åãããã以ä¸ã«æ¬ ãããªãã®ããã©ã³ã¶ã¯ã·ã§ã³ã ã ãã©ã³ã¶ã¯ã·ã§ã³ããããããã§ããã©ã³ã¶ã¯ã·ã§ã³çµäºå¾ã®ã¹ãã¼ã¿ã¹ã¯ãæåããã失æãã®2ã¤ãããªãã¨ãããã¨ãä¿è¨¼ããããããªãã¡ãªã¼ã«ã»ãªã¢ã»ããã·ã³ã°ã ããããã©ã³ã¶ã¯ã·ã§ã³ã®éä¸ã§ä½ããã®
During Phase 1, only users who are logged in can access the AI chat feature. SQL Fiddle is free to use and ad-free! Want to help us? It takes 10 seconds Step 1: Like & Share our EFE Bulk Extensions videos Step 2: Like & Share our EFE Bulk Insert videos Thank During Phase 1, only users who are logged in can access the AI Editor feature. SQL Fiddle is free to use and ad-free! Want to help us? It tak
BigQueryã¯ã«ã©ã åãã¼ã¿ã¹ãã¢ã®ä¸ç¨®ã§ããã©ãã¤ãã¯ã©ã¹ã®å¤§è¦æ¨¡ãã¼ã¿ã«å¯¾ãã¦å¤§éã®ä¸¦åå¦çãè¡ããã¨ã§é«éã«çµæãå¾ããã¨ãå¯è½ãã°ã¼ã°ã« ä½è¤ä¸æ²æ°ã®çºè¨ã«ããã¨ã OLAP/DWH/Data Miningã§è¡ããããããªread onlyã®ad hocã¯ã¨ãªããããã¦é«éï¼æ°ç§ãæ°åç§ï¼ã«å®è¡ãã¾ãã ã¨ã®ãã¨ã SQLã«ããåãåãããå¯è½ ãã®é«éæ§ã«å ããBigQueryã§ã¯SQLãåãåããè¨èªã«ä½¿ããã¨ããç¹ã«ã大ããªç¹å¾´ãããã¾ããæ°ç§ç¨åº¦ã®ã¬ã¹ãã³ã¹ã¨SQLæã«ããè¨è¿°ã¯ãå¤§è¦æ¨¡ãã¼ã¿ã«å¯¾ããã¢ãããã¯ãªå¦çãè¡ãã®ã«é©ãããµã¼ãã¹ã ã¨ãããã§ãããã BigQueryã®SQLã®æ§æã¯ãQuery Referenceãã§è§£èª¬ããã¦ãã¾ãããSELECTæã«FROMãWHEREãJOINãHAVINGãGROUP BYãORDER BYãLIMITãªã©ã使ãããã
BrewersCapTheorem - ããªã¥ã¯ã¼ã® CAP å®ç ç®æ¬¡ ãã®ææ¸ã«ã¤ã㦠ããªã¥ã¯ã¼ã® CAP å®ç - Amazon 㨠eBay ã®ã¯ã¼ã«ã¨ã¤ã ããªã¥ã¯ã¼ã®(CAP)å®ç ä¸è²«æ§ (Consistency) å¯ç¨æ§ (Availability) åå²èæ§(Partition Tolerance) å®çã®éè¦æ§ å³è§£ã§è¨¼æ CAP ã¨æãåã 1. åå²èæ§ã諦ãã 2. å¯ç¨æ§ã諦ãã 3. ä¸è²«æ§ã諦ãã 4. BASE ã«è·³ã¶ 5. åé¡ããããã¦è¨è¨ãã ã¾ã¨ã åèæç® ããªã¥ã¯ã¼ã® CAP å®ç ãã®ææ¸ã«ã¤ã㦠"Brewer's CAP Theorem - The kool aid Amazon and Ebay have been drinking" ã®æ¥æ¬èªè¨³ã§ã. http://www.julianbrowne.com/article/view
ã»ãã¼ã¿ãã¼ã¹çãªè¦³ç¹ã§ã®ã½ã¼ã·ã£ã«ã²ã¼ã ã®ç¹å¾´ ã»ãã¼ã¿ã¢ãã« ã»ã½ã¼ã·ã£ã«ã²ã¼ã ã«å¾æ¥åRDBMSã使ãã¹ããã�æµè¡ãã®NoSQLã§è¡ãã¹ãã ã»è² è·å¯¾ç (ã¢ã¼ããã¯ãã£é¢) ã»è² è·å¯¾ç (ãã¼ã«é¢) ã»ã¤ã³ãã©ã¨ã³ã¸ãã¢ã®ãã£ãªã¢ã«ã¤ãã¦
ã¬ããªã±ã¼ã·ã§ã³ãã¦ãMySQLã§ããã¹ã¿ãã¹ã¬ã¼ããé害忢ããå ´åã®ãªã«ããªãã©ã³ ã§ãæ²ããã´ã¼ã«ã§ãããããã¹ã¿ãè½ã¡ã¦ããã¼ããå¯ã¦ããããããã«ãããããã»ã¼ã§ããã®ã§ãã»ã¨ãã©ãµã¼ãã¹ã忢ãããã¨ãªãããã§ã¤ã«ãªã¼ãããæ§ãã¹ã¯ãªã¼ã³ãã£ã¹ãã«åãã¾ããã åãè¾¼ã¿ãã¬ã¤ã¤ã¼ã ã¨ãå°ããã¦ããããªãã¨æãã®ã§ããªã³ã¯ç´æ¥ã§ã¿ã¦ãã ããã http://www.irori.org/pub/mysql-mm.mov ç»å ´ãããã¹ã ç»å ´ãããã¹ãã¯2å°ãdb901ã¨db902ã§ãã æåã¯ãdb901ãæ´æ°ç³»ã¯ã¨ãªãåãããã©ã¤ããªã§db900ã®æµ®åIPã¢ãã¬ã¹ãæã£ã¦ãã¾ãã ç»é¢åå² ç»é¢ã¯5åå²ãã¦ãã¾ãã å·¦ä¸ = ãselect sysdate(),@@server_idããdb900ã«å¯¾ãã¦(sleep 1ããªãã)å»¶ã ã¨å®è¡ãã¾ãããã å³ä¸ = ping -n
Photo by shindotv ããæè¿ãæµ·å¤ã®ããã°ã§ãNoSQLãã¨ããåèªãã¡ããã¡ããã¨è¦ãããã«ãªãã¾ããã ããã¯æ°ãããã¼ã¿ãã¼ã¹ã®ã ã¼ãã¡ã³ãã§ããSQL=ãªã¬ã¼ã·ã§ãã«ãã§ã¯ãªããã¼ã¿ãã¼ã¹ã®äºãæãã¦ãã¾ãã NoSQL DBãµã¼ãã®æåãªç©ã¯ãFacebookããªãªã¼ã¹ãããCassandraããErlangã§æ¸ããããCouchDBããæ¥æ¬ããã¯ãmixiããªãªã¼ã¹ãã¦ãããTokyoTyrantããããã¾ãã ã¾ãGoogle App Engineã§ã¯ãDataStoreã¨ããBigTableãã¼ã¹ã®NoSQLãµã¼ãã¹ãæä¾ããã¦ãã¾ãã ããç¨åº¦ã¦ã¼ã¶ãéããã³ã³ã·ã¥ã¼ãåããµã¼ãã¹ã¯ã大æµã®å ´åããã©ã¼ãã³ã¹ã¨ã®æ¦ãã¨ãªãã¾ãã æè¡èªã®ä¸ã§ããã¹ã±ã¼ã«ã¢ã¦ãææ³ãçãªè¨äºãç®ã«ãããã¨ãå¢ãã¦ãããã¨ããããå¤ãã®ãµã¤ãéå¶è ããããã©ã¼ãã³ã¹ã®åé¡ãæ±
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}