CEDEC 2013 - å¾¹åºçã«ãã¥ã¼ã³ãããã¤ããªããã¢ããªãD.O.T. Defender of Texelãã®å¶ä½
CEDEC 2013 - å¾¹åºçã«ãã¥ã¼ã³ãããã¤ããªããã¢ããªãD.O.T. Defender of Texelãã®å¶ä½
æ¬é£è¼ã§ã¯ç¬¬ä¸ç·ã®Perlããã«ã¼ãåæ¿ããã§å·çãã¦ããã¾ããä»åã®ããã«ã¼ã¯DeNAã®å¶ç°è£äºããã§ããã¼ãã¯ãé«éãªWeb APIã®å®è£ ã¨ãã¹ããã§ãã Web APIã®åºç¤ç¥è ã¯ããã¾ãã¦ãDeNAã§Mobageãªã¼ãã³ãã©ãããã©ã¼ã ã®Web APIï¼ä»¥éMobage APIï¼ãå®è£ ãã¦ããxaicronã§ããMobageãªã¼ãã³ãã©ãããã©ã¼ã ã¯ãMobageã®æ©è½ãWeb APIãéãã¦å¤é¨ã®éçºè ã«å ¬éãããã¨ã«ãããã½ã¼ã·ã£ã«ã²ã¼ã ãã¦ã¼ã¶ã«æä¾ãããµã¼ãã¹ã§ãã ç°¡åã«èª¬æããã¨Web APIã¨ã¯ãHTTPãå©ç¨ãã¦ãããã¯ã¼ã¯è¶ãã«å¦çãè¡ããçµæãè¿ãããã¿ã§ããæè¿ã§ã¯JSONï¼JavaScript Object Notationï¼ã¨ãããã©ã¼ããããå©ç¨ãã¦ãã¼ã¿ã®ããã¨ãããããã¨ãå¤ããªã£ã¦ãããMobage APIãåºæ¬çã«ã¯JSONãåãåã£ã¦å¦çãè¡
æ ªå¼ä¼ç¤¾ãã¯ã·ã£ éçºé¨ ã·ã¹ãã éç¨ã°ã«ã¼ãã®é·éã§ããæ®æ®µã¯ãã¯ã·ã£ã®ã¢ããªã±ã¼ã·ã§ã³éç¨ãæ å½ãã¦ããã¾ããä»åããæ°åã«ããããæè¿Webã¢ããªã±ã¼ã·ã§ã³ã®ã¹ã±ã¼ã©ããªãã£ã®åéã§è©±é¡ã«ãªã£ã¦ããmemcachedã«ã¤ãã¦ãå¼ç¤¾éçºé¨ ç ç©¶éçºã°ã«ã¼ãã®ååã¨ã¨ãã«ãä½¿ãæ¹ãå 鍿§é ãéç¨ã«ã¤ãã¦è§£èª¬ããã¦é ãã¾ãã memcachedã¨ã¯ memcachedã¯ãLiveJournalãéå¶ãã¦ããDanga Interactive社ã§ãBrad Fitzpatrickæ°ãä¸å¿ã¨ãªã£ã¦éçºãããã½ããã¦ã§ã¢ã§ããç¾å¨ã§ã¯mixiãã¯ã¦ãªãFacebookãVoxãLiveJournalãªã©ããã¾ãã¾ãªãµã¼ãã¹ã§Webã¢ããªã±ã¼ã·ã§ã³ã®ã¹ã±ã¼ã©ããªãã£ãåä¸ãããéè¦ãªè¦ç´ ã«ãªã£ã¦ãã¾ãã å¤ãã®Webã¢ããªã±ã¼ã·ã§ã³ã¯ãRDBMSã«ãã¼ã¿ãæ ¼ç´ããã¢ããªã±ã¼ã·ã§ã³ãµã¼ãã§ãã®ãã¼ã¿
åå¼·ä¸ã®äººã«ã¯ããããã PostgreSQL Exercisesã使ãã°ãï¼ååã®ã¾ã¾ã ãï¼ãã©ã¦ã¶ä¸ã§PostgreSQLã®åå¼·ããããã¨ãã§ããã 課é¡ãä¸ããããã®ã§ããããå®ç¾ããããã®å½ä»¤ãæ¸ãã¦ããã°OKã ã å®è¡çµæããã®å ´ã§ãããã®ã§çè§£ããããã ããã ãªããåéãããããããã®ã§ãããããè§£ããã¨ãã§ããã°ä¸å¿åºæ¬ã¯ãã¹ã¿ã¼ãããã¨ã«ãªãã®ã§ã¯ãªãããããèå³ããã人ã¯ãã£ã¬ã³ã¸ãã¦ã¿ãã¨ããã§ããªã
ãé¢é£è¨äºã æ¬å 容ã«ã¤ãã¦ã®ã¢ãããã¼ãè¨äºãå ¬éãã¦ãã¾ãããããã¦ã確èªãã ããï¼ç·¨éé¨ï¼ Security&Trustã¦ã©ããï¼60ï¼ ä»å¤ãããããå®å ¨ãªSQLã®å¼ã³åºãæ¹ ï½ é«æ¨æµ©å æ°ã«èãã¦ã¿ã http://www.atmarkit.co.jp/fsecurity/column/ueno/60.html Webã¢ããªã±ã¼ã·ã§ã³ã«å¯¾ããæ»æææ³ã®1ã¤ã§ããSQLã¤ã³ã¸ã§ã¯ã·ã§ã³ã®åå¨ã¯ãããªãåºãç¥ãããããã«ãªã£ãããããããã®å¯¾çã¯ã¾ã æ¬å½ã«çè§£ããã¦ããªãããã«æããããã©ã¼ã ããæ¸¡ãããå¤ã®ç¹æ®æåãã¨ã¹ã±ã¼ãããããPHPã®magic_quotes_gpcã¨ãã£ãèªåã¨ã¹ã±ã¼ãæ©è½ããªã³ã«ããã ãã§å¯¾çããã¤ããã«ãªã£ã¦ããªãã ãããã åºæ¬ã¯ãã¡ãããã»ã«ã³ããªã¼ãã¼SQLã¤ã³ã¸ã§ã¯ã·ã§ã³ããã«ããã¤ãæåãå©ç¨ããSQLã¤ã³ã¸ã§ã¯ã·ã§ã³ã®æ»æãã¿ã¼ã³ãããã®å¯¾
ã¡ãªã¿ã«ããã®åæã®ããã«å¿ è¦ã¨ãããMapReduceã®ã³ã¼ãã§ãããããã®ãµã¤ãºã¯ããã20ã¹ãããã ã¨ãããYahoo!ã®ãã¬ã¼ã³ãã¼ã¿ã¼ã§ãããã¨ãªãã¯ã»ãã«ãã·ã¥ãã¤ã©ã¼æ°ã«ããã¨ããã¨ãçµé¨ã®æµ ãã¨ã³ã¸ãã¢ã§ãã£ã¦ããMapReduceã«ããããã°ã©ãã³ã°ã¯å¯è½ã§ããã¨ãããã ã¾ããVISAã®ã¸ã§ã¼ã»ã«ãã³ã¬ã æ°ããããè²´éãªãã¼ã¿ãæä¾ããã¦ããã®ã§ä»¥ä¸ã«ç´¹ä»ãããå社ã§ã¯ã1æ¥ã«1åãã©ã³ã¶ã¯ã·ã§ã³ãçºçããããã2å¹´éã§700åå¼·ã®ãã©ã³ã¶ã¯ã·ã§ã³ãã°ãèç©ããããã®ãã¼ã¿éã¯36ãã©ãã¤ãã«è³ãã¨ãããããããã¹ã±ã¼ã«ã®ãã¼ã¿ãã徿¥ã®RDBãç¨ãã¦åæããã«ã¯ãç´1ã«æã®æéãå¿ è¦ã¨ããã¦ããããHadoopãç¨ãããã¨ã§13åã«ç縮ãããã¨ããã ããã¾ã§ã¯ãYahoo!ã«ããVISAã«ãããè¨å¤§ãªãã¼ã¿ãRDBã«æ¼ãè¾¼ãã»ãã«æ¹æ³ã¯ãªãããã®åæã«æ°åæ¥ãè¦ãã
åå ±å ã¯9æ27æ¥ãã·ã³ã¯ã¿ã³ã¯ãåå ±å çæ´»ç·åç ç©¶æãã20å¹´éã«ããã£ã¦å®æ½ãã¦ããçæ´»è æèã®å®ç¹è¦³æ¸¬èª¿æ»ãçæ´»å®ç¹ãã®ãã¼ã¿ãç¡æã§ä¸è¬å ¬éãããçæ´»ç·ç ã®Webãµã¤ãã§ããã¼ã¿ãåé²ããExcelãã¡ã¤ã«ã¨ã質å票ã®PDFãã¡ã¤ã«ããã¦ã³ãã¼ãã§ãããã¦ã¼ã¶ã¼ç»é²ãªã©ãä¸è¦ã ã å調æ»ã¯1992å¹´ãã20å¹´éã«ããã£ã¦éå¹´ã§å®æ½ãåãå°åï¼é¦é½åã»éªç¥åï¼ãåã対象è è¨å®ï¼20ï½69æ³ã®ç·å¥³ï¼ã«åãã¦åã質åãç¶ç¶ãã¦åããåçãæç³»åã§è¦³æ¸¬ãã¦ããã è¡£ãé£ãä½ãå¥åº·ãéã³ãå¦ã³ãåããå®¶æãææã»çµå©ãæ¶è²»ãæ å ±ãã¡ãã£ã¢æ¥è§¦ãç¤¾ä¼æèãå½éåã¨æ¥æ¬ãå°çç°å¢ãªã©ãçæ´»è ã«é¢ãããã¾ãã¾ãªé åãç¶²ç¾ ãé ç®ã¯ç´1500ã«ããã¶ã ãé·å¹´ã«ããã£ã¦èç©ãã¦ããç¬èªã®çæ´»è ç ç©¶ã®è³ç£ããããããã¯â社ä¼å ¨ä½ã®è³ç£âã«ãã¦ãããããã¨ç¡æå ¬éãæ±ºããã¨ãããç ç©¶è ããã¼ã±ãã¿ã¼ã®ã»ã
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ã¡ã³ããã³ã¹
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}