Database Lounge Tokyo #4 https://database-lounge-tokyo.connpass.com/event/54855/ ã§è©±ããè³æã åç»ã¯ãã£ã¡ https://www.youtube.com/watch?time_continue=1&v=VTEAJHJHIpY Read less
éå¼ãSQLæ§æéã¯ãããããã¨ããï¼ãã®æ¹æ³ã調ã¹ãããSQLã®éå¼ãã®ãªãã¡ã¬ã³ã¹ã§ãï¼ ãã¹ã¦ã®é ç®ã«ãµã³ãã«ãç¨æãã¦ããã¾ãã®ã§ãããããã°åèã«ãã¦ãã ããï¼ ãã©ã¦ã¶ã®æ¤ç´¢æ©è½(Ctrl + F)ã使ç¨ããã¨å¹ççã«SQLã調ã¹ããã¨ãã§ãã¾ãï¼ æ¬ãã¼ã ãã¼ã¸ã¯ç¾å¨ç²¾åçã«ä½æä¸ã§ã
2014-11-26 ãæè¡æ¸ã®ã¿å³é¸ã2014å¹´11æã®Kindleæ大50% OFF ã»ã¼ã« Kindleã¹ãã¢ã§ãæ大50%OFF ãè²·ãå¾ã»ã¼ã«ãã¨ãKindleæ¬ãã¤ã³ãéå ã»ã¼ã«ããå§ã¾ãã¾ãããæéã¯ããããä»ææ«ã¾ã§ï¼ä»åãå¤æ°ã®æ¬ãã»ã¼ã«å¯¾è±¡ã¨ãªã£ã¦ãã¾ããããã®ãã¡æè¡æ¸ã ããæãåºãã¦ãªã¹ãã¢ãããã¦ã¿ã¾ãããä»åã®ç®çã¯ã詳解UNIXããã°ã©ãã³ã° 第3çãã§ãããããå ã8000å以ä¸ããæ¬ãªã®ã§ãåé¡å¹æã§5000åè¿ãå®ããªã£ã¦ãã¾ããã¶åãæ¬ãªã®ã§ãé»åæ¸ç±ã®æ©æµãæ大éã«åãããã¾ãã(Kindleçã¯ãªããã¼å¯¾å¿ãªã®ã§ããã©ã³ããµã¤ãºçèªç±ã«å¤æ´ã§ãã¾ããæ¬ãã¹ãã£ã³ãã¦JPEGç»åã ããè²¼ãä»ãããããªããããã¼ãªé»åæ¸ç±ã§ã¯ãªãã®ã§ãæ¬ã®ãã¼ã¿ãµã¤ãºãå°ããæãããã¦ãã¾ããgoodã)ãªã¹ãã¢ãããã¦ã¦æ°ä»ãããã§ãããä»åã»ã¼ã«å¯¾è±¡ã«ãªã£ã¦ãã
æ±å¤§åé£å·ç 究室ã®æ©æ°´ãããæ¥æ¬PostgreSQLã¦ã¼ã¶ä¼ã§è©±ããããæ§è½æ¸¬å®éããã¨ã¦ãåå¼·ã«ãªã£ãã ã¹ã©ã¤ãã¨YouTubeåç»ãå ¬éããã¦ãã¾ããYouTube ã«ã¯ã¹ã©ã¤ãã«ã¯æ¸ããã¦ããªã話ããåºã¦ãã¦ã説æãé常ã«ããããããã§ããããããã¢ã«ãããã¯ã§æå 端ã®ç 究ãããã¦ããæ¹ãæ å ±çºä¿¡ãããã®ã¯ã¨ã¦ãããããã id:hayamiz ããã®ãã¨ã¯ä½å¹´ãåããèªèãã¦ããããåé£å·ç 究室ã§ãã¼ã¿ãã¼ã¹ã®ç 究ãããã¦ããã¨ããã®ã¯åãã¦ç¥ãã¾ããã TOP | Yuto Hayamizu's web site ãè¦ãã§ãã¯ã§ãã æ§è½æ¸¬å®é äºå§ãç·¨ æ§è½æ¸¬å®é äºå§ãç·¨ from Yuto Hayamizu æ§è½æ¸¬å®é å®è·µç·¨ æ§è½æ¸¬å®é å®è·µç·¨ from Yuto Hayamizu ãæ§è½æ¸¬å®é äºå§ãç·¨ãã§ç´¹ä»ããã¦ããæ¬ãè²·ã£ã¦ã¿ã¾ãããããªããªãæ¯ãããã®ãããã
EnterpriseZineï¼ã¨ã³ã¿ã¼ãã©ã¤ãºã¸ã³ï¼ç·¨éé¨ã§ã¯ãæ å ±ã·ã¹ãã æ å½ãã»ãã¥ãªãã£æ å½ã®æ¹ã åãã«ãEnterpriseZine DayãSecurity Online DayãDataTechã¨ããã3ã¤ã®ã¤ãã³ããéå¬ãã¦ããã¾ããããããç·¨éé¨ç¬èªã®åãå£ã§ãæ¥çãã¬ã³ããææ°äºä¾ãç¶²ç¾ ãææ°ã®ååãç¥ããã¨ãã§ããå ´ã¨ãã¦ã好è©ãå¾ã¦ãã¾ãã
ããã¾ã§ã¯ã©ã¤ã¢ã³ããµã¤ãã®ããã°ã©ãã³ã°ä¸å¿ã§ãããã¨ãããããã¾ããµã¼ãã¼ãµã¤ããDBè¨è¨ãããçµé¨ããªãã®ã§ãããæè¿ã«ãªã£ã¦åºå¹¹ç³»ã®DBå¨ãã®æ¥åãæ å½ããããã«ãªã£ã¦ãã¾ããã ç´è¿ã§ã¯ããã§ã«ããTBLã«åé¤ã®ãã©ã°ã®ãããªåãããã®ãè¦ãã¨ããæåã¯ä½ã«ä½¿ãã®ãããããªãã£ãã®ã§ãããã¤ã³ã¿ã¼ãããã§è²ã 調ã¹ããã¡ã«"è«çåé¤"ã¨ããããæ¹ãããã®ãã¨ç¥ã£ããããã§ããç¾ç¶ããããªç¶æ ãªã®ã§ãããèè ã®æ¹ã«è³ªåãããã¾ãã ï¼ï¼ç»é²æ¥æã»ã¦ã¼ã¶ã¼ãæ´æ°æ¥æã»ã¦ã¼ã¶ã¼ã®ã«ã©ã ã«ã¤ã㦠ï¼ï¼TBLãDBè¨è¨ã«ã¤ãã¦ç¾å ´ã§å©ç¨ãããããªãã¯ããã¯ãè¨è¼ãããæ¬ããªã½ã¼ã¹ã«ã¤ã㦠ï¼ï¼ç»é²æ¥æã»ã¦ã¼ã¶ã¼ãæ´æ°æ¥æã»ã¦ã¼ã¶ã¼ã®ã«ã©ã ã«ã¤ã㦠åèã«ããããã«ä»ã·ã¹ãã ã®TBLå®ç¾©ãªã©ãè¦ã¦ããã®ã§ãããå¤ãã®TBLã«ã¬ã³ã¼ãã®ç»é²æ¥æã¨ç»é²ã¦ã¼ã¶ã¼ãã¬ã³ã¼ãã®æ´æ°æ¥æã¨æ´æ°ã¦ã¼ã¶ã¼ã¨ã
æ¦è¦ ã»ã¨ããç©ä»¶ã§8000ä¸å¼±ã®ã¬ã³ã¼ããæ°è¦ã®DBã«å¹ççã«ã¶ã¡è¾¼ãæ¹æ³ãèããå¿ è¦ã« ã»MySQL(Amazon RDS) + Python(mysql.connector)ãæ³å® ã»mysql.connector + pythonã«ã¤ãã¦ã¯ææãªãã(http://nekopuni.holy.jp/?p=927)ã«æ¸ãã¦ããã¾ãã ã»ã³ãããã®ä½ç½®ã«ã¯æ°ãã¤ããã + Multiple Insertæå¼·ãã¨ããã話ã æ¹æ³ãã®1 ã¾ãã¯æåã«ãã£ãæ¹æ³ã1ã¬ã³ã¼ããã¨ã«Insertãã¦ã³ããããã¦ããæ¹æ³ã ä»ã¾ã§DBé¢é£ã§ãã£ãã³ã¼ãã¯ã¬ã³ã¼ãéã大ãããã¨ãªãã£ãã®ã§ä»¥ä¸ã®æ¹æ³ã§ãç¹ã«åé¡ãªãã£ãã å ·ä½çãªç°å¢ã¨ãã¦ã¯ããã¹ããã¼ã¿(csv)ãèªã¿è¾¼ã¿ããããDBã«Insertãã¦ããã¨ãããã®ã csvã®ä¸èº«ã¯æ¥ä»(DATE)ã¨ãã¼ã¿å¤(VALUE)ãã«ã³ãåºåãã«ãªã£ã¦ã
ããã¯ãåããã¼ã¿ãã¼ã¹ãæ±ããã¡æåããï¼ä»¶ç®ã®ããã¸ã§ã¯ãã ã£ãã C++ã®ã½ã¼ã¹ãé£è§£ã§ç«ãå¹ãã¦ããã¨ãã話ã§ãèªåã¯ä½ã¹ãã«ã®è¥é ãç«ã«ãã¹ãã«ã¯ä¸åº¦è¯ãç¨åº¦ã®ããæ°ã¨è²¬ä»»æããã£ã¦ãããææªãå¥ã®ããã¸ã§ã¯ããçµäºããç´å¾ã ã£ããã®ã§æå ¥ãããã®ã§ããã ç¾å ´ã§ãDBãããã¼ã¿ãå¸ãåºããã¼ã«ãSQLãä½ã£ã¦ãããã¨ããã話ãããã¨ä»ç¤¾ãä½ã£ãDBå®ç¾©ãããã¶ã使ãã¥ããã¨ããã ERå³ãDBå®ç¾©ãè¦ãã¦ãã ããã¨è¨ã£ãã®ã ãã©ããããªãã®ã¯ç¡ãã¨ããè¿äºã ä»ãªãããããã辺ã§éãåºãã¨ããã§ãããå½æã¯ããµã¼ãããã¦ãªããã§ãããããã¨ãããã®ããããã®è»½ãæ°æã¡ã§èãã¦ãã¾ããã ã§ãããã¸ã§ã¯ãã®è³æããããã¾ãã£ã¦ä½ã¨ãDBå®ç¾©ã®ãããªãã®ãè¦ã¤ãDBã®ãã¼ã¿ã調æ»ãå§ããã®ã§ããä½ããããããã æ©è½ã®æ°ã«æ¯ãã¦ç°æ§ã«ãã¼ãã«æ°ãå°ãªãã®ã§ãã ãµã¨å¨ããè¦ãã¨ãç
ã»ã¼ã»ã¼åå¿è ã§SQLã®ç·´ç¿ããããã£ã¦ãã人ãç¥èã®å確èªãããã人ã«ãªã¹ã¹ã¡ã®ãµã¤ãã SQLZOO ãã©ã¦ã¶ä¸ã§åä½ããã®ã§ãããã©ãããç°å¢è¨å®ããªãã ãã¼ã¿ãã¼ã¹ããMySQLãOracleãSQL ServerãPostgreãIngresãDB2ããé¸ã¹ãã ç°¡åãªSELECTæããå§ã¾ã£ã¦ãSUMãCOUNTã¿ãããªåºæ¬çãªé¢æ°ã®åé¡ããJOINã使ã£ãã¡ãã£ã¨é£ããã®æ§æãããã å®è¡ç°å¢ä»ãã®ãªãã¡ã¬ã³ã¹ãããã®ãããï¼(è¶ ä¾¿å©ï¼)
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}