æè¿ãMSTUãšäžç·ã«çµç¹ããæåã®æè²ãããžã§ã¯ãã§ããMail.Ru Technoparkã«ãã£ãŠ 5幎ãçµéããŸããã N.E. ããŠãã³ã 圌ã®ä»äºã®éã«ããããžã§ã¯ãã¯ã ãã¯ãã¹ãã£ã¢ Mail.Ru ïŒVMKã¢ã¹ã¯ã¯å·ç«å€§åŠïŒã ãã¯ããã¬ãã¯Mail.Ru ïŒMIPTïŒã ãã¯ãããªã¹Mail.Ru ïŒSPbPUïŒã ãã¯ãã¢ãã Mail.Ru ïŒMEPhIïŒãªã©ãåœå ã®ä»ã®æã匷åãªæè¡å€§åŠã§ãéå§ãããŸããã äŒçµ±çã«1æ25æ¥ã«ç¥ãããŠããåŠçã®æ¥ãèšå¿µããŠãITæè²ãå§ãŸã£ãçµç·¯ãæè²ãããžã§ã¯ããã©ã®ããã«çŸããçºå±ããããä»æ¥ã®æ§åããããŠææºå€§åŠã®ãããã§ãããã¯ã©ãããããŸããã ãã¯ãããŒã¯ã¯æåã®ãã®ã§ãããæ°å¹Žã¶ãã®ãã®ã§ããã ãœãªã¥ãŒã·ã§ã³ãšã¢ãããŒããå®æããã®ã¯ãã¯ãããŒã¯ã§ãã£ããããåŸã§ä»ã®ãããžã§ã¯ãã®åºç€ã圢æãããããããã«ã€ããŠè©³ãã説æããŸãã ãããŠãå çã«åºãæž¡ããŸãã
ãã¯ãããŒã¯
2011幎11æããå é§çããªæè²ãããžã§ã¯ãã®ç«ã¡äžããçºè¡šããŸããã 12æãæåã®åŠçã°ã«ãŒãïŒ42人ïŒãåéããã1ææ«ãŸã§ã«ãMail.Ruã°ã«ãŒãã®ã¹ã¿ããããæåž«ããŒã ãçµæããããã¬ãŒãã³ã°ããã°ã©ã ãæ¿èªãããŸããã åŠçã®3段éã®éžæãéçºãããŸããïŒæåã«ããªã³ã©ã€ã³ãã¹ãã次ã«ãã«ã¿ã€ã ã®å°éé¢æ¥ãšäººäºé¢æ¥ã 6ãæåŸãæåã®ã»ãã·ã§ã³ãéå¬ããã42人äž31人ãç¡äºã«çµäºãã2012幎9æãŸã§ã«ãã¯ãããŒã¯ã®åŠçæ°ã¯91人ã«å¢å ããŸããã 確ãã«ããã®ãã¡56人ã®ã¿ãã»ãã·ã§ã³ãçµäºããŸããã
ãã®1幎åŸã®2013幎5æã«ããã¯ãããŒã¯ã¯RAECã«ãããšæé«ã®æè²ãããžã§ã¯ãã®ãªã¹ãã«å ¥ããŸããã 9æãŸã§ã«ã1ã€ã®å Žæã®ç«¶äºã¯5ã7人ã§ããã è±åŽå²©ç§åŠã¯168人ã®åŠçã«ãã£ãŠãããããŸããã 16ã®åéã§æ§æãããæ°ãããã¬ãŒãã³ã°ããã°ã©ã ãäœæããã24人ã®æåž«ãç¥èãå ±æããŸããã åã幎ã®11æã«ãããããŒããç§åŠãšæè²ãã§Runetè³ãåè³ããŸããã 2幎åŸããã¯ãããŒã¯ã§æåã®åæ¥åŒãè¡ãããŸããã æåã®ã»ããïŒ42人ïŒã®ãã¡ã17人ããã£ããã·ã¥ã©ã€ã³ã«éãããã®ãã¡14人ã®åæ¥çãMail.Ru Groupã«å€åããŸããã ãã®æãŸã§ã«ããã¯ãããŒã¯ã®è¬å ã®223人ã®åŠçã19ã®åéã§è¬çŸ©ã«åå ããŸããã
次ã®ããã³ãã£ã¢ã¯3幎éã®ãã¯ãããŒã¯ã§ãã 222人ã®åŠçãèšç·Žãåãã22ã®åéã§è¬çŸ©ãåããŸããã ãã®æç¹ã§ã40人ããã§ã«Mail.Ru Groupã§ã®ã€ã³ã¿ãŒã³ã·ãããå®äºããæ¡çšãããŸããã MSTUã®ãã¹ãŠã®åŠçåãã ããŠãã³ã®ããã¯ãã¹ã¿ãŒãããã£ã³ããªã³ã·ãããéå¬ãããŸããããã®äžã§ãåŠçã®ç掻ã楜ã«ããã¢ãã€ã«WebãµãŒãã¹ã®ã³ã³ã»ãããäœæããå¿ èŠããããŸããã 250人ããã£ã³ããªã³ã·ããã«åå ãã46ã®ãããžã§ã¯ããçºè¡šããŸããã
ãã¯ãã¹ãã£ã¢
2014幎2æã«ã2çªç®ã®æè²ãããžã§ã¯ããšããŠãã¯ãã¹ãã£ã¢ãç«ã¡äžããŸãããããã¯ã¢ã¹ã¯ã¯å·ç«å€§åŠã®å£ã®äžã§å±éãããŸããã ãã¢ããœãã å€ãã®ç¹ã§ãã¯ãããŒã¯ã§åŸãçµéšãèæ ®ããŸãããããã¯ãã¹ãã£ã¢ã¯ç²ç®çãªã³ããŒã§ã¯ãããŸããã§ããã
- Technoparkããã°ã©ã ã¯ãè² è·ã®é«ãã·ã¹ãã ã®Webéçºè ããã³ã¢ãŒããã¯ãããã¬ãŒãã³ã°ããããã«èšèšãããŠããããã¯ãã¹ãã£ã¢ã§ã¯ããã°ããŒã¿ã®åéã®å°é家ããã¬ãŒãã³ã°ããŸãã
- Technosphereã§ã¯ã2ã4ã³ãŒã¹ã®åŠçãåãå ¥ããŸãã
- ãã¹ãŠã®æè²ãããžã§ã¯ãã®å ¥åŠè©Šéšã®ã¹ããŒã ã¯åãã§ãããšããäºå®ã«ããããããïŒåŠçã¯ãªã³ã©ã€ã³ãã¹ããåéšããé¢æ¥ã«åæ ŒããŸãïŒããã¯ãã¹ãã£ã¢ã§ã¯é«çæ°åŠã®åºç€ç¥èã«éç¹ã眮ããŠããŸãã
- ãã¯ãã¹ãã£ã¢ã§ã¯ãçåŸãšæåž«ã®éã®éå ¬åŒã®ããŒãã£ã³ã°ãè¯ãäŒçµ±ã«ãªããŸãããããã§ã¯ãå¿ãã話ããèå³ã®ãããããã¯ã«ã€ããŠå°ããããšãã§ããŸãã ãããã®äŒè°ãPergolasãšåŒã³ãŸããã
ãã¯ãã¹ãã£ã¢ãžã®æåã®åéã§ã¯ãã³ã³ãã¹ãã¯1äŒå Žããã3人ã§ã1幎åŸã«ã¯5人ã§ãããåããŠ42人ãåéããŸãããã2åŠæã«è¡ãããšãã§ããã®ã¯10人ã ãã§ããã
åœåããã¬ãŒãã³ã°ããã°ã©ã ã¯1幎éèšèšããã6ã€ã®åéã§æ§æãããŠããŸããïŒå€§éã®ããŒã¿ã®ç¥çåŠçã®ããã®ã¢ã«ãŽãªãºã ãã€ã³ã¿ãŒãããã¢ããªã±ãŒã·ã§ã³ã®éçºã§DBMSã䜿çšããæ¹æ³ãC ++ã§ã®ãã«ãã¹ã¬ããããã°ã©ãã³ã°ããã¹ããæ å ±æ€çŽ¢ãHadoopã ãããã1幎åŸãããã°ã©ã ãæ¹èšããé幎ã«ããã 4åŠæã®éãåŠçã¯10ã®åéãç 究ãã倧éã®å®ç¿ãè¡ããŸãã åæã«ãæºåã³ãŒã¹ãã¢ã«ãŽãªãºã ãšããŒã¿æ§é ããéçºãããŸããã
ãŸããåŠçãMail.Ruã°ã«ãŒãã§çŽé¢ããŠããå®éã®ã¿ã¹ã¯ãæ±ãã©ããäœæããŸããã ããšãã°ãåæã¢ã«ãŽãªãºã ãæ¹åããç¹å®ã®ãã¥ãŒãªã¹ãã£ãã¯ãäœæããããšããŸãã ã€ãŸãã圌ãã¯äŒç€Ÿãšã®å®æçãªã€ã³ã¿ãŒã³ã·ããäžã«è¡ãã®ãšåãããšãè¡ããŸãã 2015幎ã®ç§ä»¥æ¥ãç 究宀ã¯ç 究ãå®æœãå§ããŸããã ããšãã°ããã¥ãŒã©ã«ãããã¯ãŒã¯ã䜿çšããŠããŸããŸãªããžãã¹äžã®åé¡ã解決ããå¯èœæ§ãç 究ãããŠãããããŸããŸãªã¢ã«ãŽãªãºã ã®å®è£ ãäœæãããŠããŸãã
ãã¯ããã©ãã¯
2015幎9æãMIPTã§3çªç®ã®æè²ãããžã§ã¯ãTechnotrekãéå§ãããŸããã ä»åã¯å®éšããããããã«12åéã®2幎éã®ããã°ã©ã ãéçºããŸããã ããããéžæã·ã¹ãã ã¯2ã€ã®æ®µéã§äœæãããŸãããæåã¯ãªã³ã©ã€ã³ãã¹ãã§ããã®åŸã¯æè¡é¢æ¥ã§ãã ãã¯ãããŒã¯ããã¯ãã¹ãã£ã¢ãšã¯ç°ãªãããã¹ãŠã®ã³ãŒã¹ã®åŠçã¯ããã«ãã¯ããã¬ãã¯ã®ã³ãŒã¹ãåè¬ãå§ããŸããã
æåã®2ã€ã®ãããžã§ã¯ããšåæ§ã«ãTechnotrekã«ã¯ç¬èªã®å°éåéã§ããã¢ãã€ã«éçºããããŸãã
2016幎ã®æ¥ã«ãå ¥åŠãã¹ãã«åæ Œããä»ã®ãã¹ãŠã®MIPTåŠçåãã«ããC ++ããã°ã©ãã³ã°ããšãiOSã¢ããªã±ãŒã·ã§ã³éçºãã®2ã€ã®ãªãŒãã³ã³ãŒã¹ãéå§ããŸããã çŸåšãTechnotrackã«ã¯ããLinuxã·ã¹ãã 管çãããé«è² è·ãããžã§ã¯ãã®DBMSãããç£æ¥çšããã°ã©ãã³ã°ããã³ããŒã¿æ§é ã®çŽ¹ä»ãããAndroidã¢ããªã±ãŒã·ã§ã³éçºãã®4ã€ã®ãªãŒãã³ã³ãŒã¹ããããŸãã
ãã¯ãããªã¹
2016幎9æãOdnoklassnikiã¯æ°ããæè²ãããžã§ã¯ããç«ã¡äžããŸãããä»åã¯ããŒã¿ãŒãµã³ã¯ãããã«ãã«ã¯å·¥ç§å€§åŠãšå ±åã§ã ãã¹ãŠã®ã³ãŒã¹ã®åŠçãšå€§åŠé¢çã¯ãã¯ãããªã¹ã«å ¥åŠã§ããŸãã 3段éã®éžæïŒæåã®ãã¹ããå«ãã¢ã³ã±ãŒãã詳现ãªãªã³ã©ã€ã³ãã¹ããæåŸã«Javaã³ãŒãã®äœæãšèªã¿åãã«é¢ããæè¡é¢æ¥ã æåã®ã»ããã«ã¯ãé«è² è·ã®Javaã¢ããªã±ãŒã·ã§ã³ã®èšèšãšéçºã«é¢ãã2幎éã®ã³ãŒã¹ãéå§ãã40人ã®åŠçãå«ãŸããŠããŸããã 4ã€ã®å ¬éè¬åº§ã®ãã¡æåã®Javaå ¥éãå®äºããŸããã ãŸãããã¢ãã€ã«éçºãããC ++ããã°ã©ãã³ã°ããããã«ãã¹ã¬ããããã°ã©ãã³ã°ããèšç»ãããŠããŸãã
ãã¯ãã¢ãã
5çªç®ã®æè²ãããžã§ã¯ãïŒMEPhIãšã®å ±åãããžã§ã¯ãïŒã¯ãä»ã®ãã¹ãŠã®ãããžã§ã¯ããšã¯ç°ãªããŸãããã®ãã¬ãŒã ã¯ãŒã¯å ã«ã¯ãå ¥åŠè©Šéšã«åæ ŒããåŸã«åŠç¿ã§ãããªãŒãã³ã³ãŒã¹ã®ã¿ããããŸãã ã¯ã©ã¹ã¯ãè¬çŸ©ãã»ãããŒããŠã§ãããŒããã¹ã¿ãŒã¯ã©ã¹ãäŒè°ãªã©ãããŸããŸãªåœ¢åŒã§éå¬ãããŸãã çŸåšããJavaã§ã®éçºãããPythonã§ã®ããã°ã©ãã³ã°ãããPerlã§ã®ããã°ã©ãã³ã°ãã®3ã€ã®ã³ãŒã¹ããããŸãã
ä»æ¥ã®æè²ãããžã§ã¯ãã§ã¯ãMail.Ru Groupã®100人以äžã®åŸæ¥å¡ãæããŠããŸãã ç§ãã¡ã¯åœŒãã«ãæããŠããæãèšæ¶ã«æ®ãç¬éã«ã€ããŠå°ããããšã«ããŸããã 以äžã®åœŒãã®ç©èªãèªãã§ãã ããã ãããŠãæåã®èšèã¯æåž«ã§ã¯ãªãããã¹ãŠã®æè²ãããžã§ã¯ãã®èµ·æºã«ç«ã£ã人ã«ãã£ãŠèšãããŸãã
Dmitry2121 VoloshinãMail.Ru Groupã®å ç 究ããã³æè²ãã£ã¬ã¯ã¿ãŒ
MSTUã§ãã¯ãããŒã¯ã®å»ºèšã«åå ããã®ã¯å¶ç¶ã®ããšã§ãã ç§ã¯ãæè²ããã»ã¹ããã¬ãŒãã³ã°ããã°ã©ã ã®äœæã§ã¯ãªãã建èšãã®ãã®ãæå³ããŸãã 2012幎2æã«ç§ãMail.Ru GroupããŒã ã«å ãã£ããšããç§ã¯ãã©ã¢ãã³ãšããŠã掻åããŠãããšã¯æããªãã£ãã ãã®æãŸã§ã«ãVolodya Gabrielyanã¯ãã¹ãŠSkyLightã®æ§ç¯ã«æºãããæã«ã¯ããããåºãŠããŠãææã®éžæããã¶ã€ããŒãšã®ã³ãã¥ãã±ãŒã·ã§ã³ã®è€éãã«é¢ãã質åã«å·§ã¿ã«çããããšãã§ããŸããã 䞊è¡ããŠãMSTUã§ãããžã§ã¯ãã®æœèšãéžæããèŠç©ããã«åæããæ宀ã®å®¶å ·ã®è²ãšã¹ã¿ã€ã«ã«ã€ããŠè©±ãåããŸããã ä¿®çã®æºåã¯ã»ãŒ6ãæç¶ããŸããã MSTUã®äž»èŠãªæè²çšå»ºç©ïŒGUKïŒã¯æŽå²çãªå»ºç©ã§ãããå建ããã®ã¯ããã»ã©ç°¡åã§ã¯ãªããšããäºå®ã«ãããç¶æ³ã¯è€éã§ããã ããã«ã€ããŠã¯ãŠã£ãã·ã¥ãªã¹ãã®å€ããå£ããã MSTUåŽããã¯ãããã»ã¹ã¯IUã®åŠéšé·ã§ããAndrei Proletarskyã«ãã£ãŠæšé²ãããŸããã ç§ãã¡ã¯åæ段éã§é »ç¹ã«åœŒãšå£è«ãããŸããã
çŽ6ãæåŸãæ·å°ã®æ¹ä¿®ãéå§ããŸããã åŠé·ã®æµã¿ãããGUKã®3éïŒåŠé·ïŒã®éšå±ãäžããããŸããã ããã«ã¯å€ãã®åŠå®ã§ããªãå©ç¹ãããããã®äžã€ã¯å€©äºã®é«ãã§ããã ãããŠã1ã€ã®å°ããªæ¬ é¥ïŒããã¯ç§ãã¡ã®ç®çã«ãšã£ãŠååã§ã¯ãªãããšãå€æããŸããã åŸã«å€æããããã«ã60人ã«å°ãªããšã1人ã®ã¹ããªãŒãã³ã°èŠèŽè ãå¿ èŠã§ãããéšå±ã®æ åãäžååã§ããã éšåçã«ã¯ããã®åé¡ã¯å€å§åšæ宀ãç ç²ã«ããŠå¹³æºåããããšãææ¡ãããŸããïŒ20人ã®ãã¡2人ããããã40人ã«1人ã«ãªããŸãïŒãããåãã®ããã«40人ã¯60人ã§ã¯ãããŸãããè³ïŒ2éãäœãããšã«ããŸããã é«ã倩äºã«ã€ããŠèšåããŸãããïŒ ããã§ãå·¥åŠç³»å€§åŠã§ãããã圌ãã¯éšå±ã«éå±æ§é ç©ã溶æ¥ããããšã«æ±ºããŸãããããã¯å¹³å±ã®éšå±ã«å¥ã®åºãå ããã§ãããã
建èšããã»ã¹å šäœã®ãã¡ããããšããœãŒããç§ã®èšæ¶ã«èœã¡ãæåéãã¯ã©ãã·ã¥ããŸããã ç§ãã¡ã«å²ãåœãŠãããéšå±ã«ã¯æ±ããããŸãã 3çªç®ã®åŠé·ã®äžã«ããã«ããã€ãã®ããã¢ãä¿æãããã¢ãªã³ã°ã ãŸããæ®å¿µãªããããããã®åã¯æ宀å ã«éåžžã«ããŸãé 眮ãããŠããããåŠçã®ãã¯ã€ãããŒãã®å¯èŠé åãéšåçã«ãããã¯ããŠããŸãã 倧ãŸããªä»äžãã®æ®µéã§ããã£ãã»ã°ãªã·ã³ãšç§ã¯éšå±ãèŠãŠãæšè£œã®ã©ã°ã«æ²¿ã£ãŠãããã®è¬å ã«åãããŸããã ãããŠãã¡ããã圌ãã¯åæºããŸãããäœãã§ãããã©ãã«ãããŠå€ã«åºãå¿ èŠãããããã§ããããšãã°ãåç· åœ¹äŒã§èµ·ãã£ãŠããããšãæŸéããç»é¢ãè¿œå ããå¿ èŠããããŸãã 圌ãã¯èãçž®ããç«ã¡å»ã£ãã
åŽåè ã¯ç§ãã¡ãèããããšãå€æããŸããã åŸã§å€æããããã«ã圌ãã¯æè²ããã»ã¹ã«å¯ŸããŠéåžžã«ææã§ç æ°ã§ãã
ãã£ããè·è¡ããŠèŠ³å®¢ã®ããšã«æ»ã£ããšãã2人ã®åŽåè ã1æ¬ã®æ±ãéãã§ããã®ãèŠãŸããã 足ã厩ããã æ³ååã¯ç§ã®é ã®äžã«æãç³ãŸããGUKãæããŸããã ç§ãèããŸããïŒããã§æ»ã¬ã®ã¯ããããšã§ãã å°ãªããšããMSTUã®æ·å°ã®äžéšã倱ãããããšã«ã€ããŠåŠé·ãšäŒè©±ããã®ãåŸ ã£ãŠããŸããã stè¿·ããåºãŠãç§ã¯è©±ããã Volodya Gabrielyanèªèº«ãç§ã®éåŒãã«æºè¶³ããŠãããšæããŸãã 宣èªã®çç¥ã¯2åéç¶ããŸããããã©ã®ãããªç¶æ³ã§ããããåçŸããããšã¯ãããŸããã åŽåè ã¯ç§ãäžå¯§ã«èŠã€ããæ±ã®ç Žå£ãæ¢ããŸããã 圌ãã®è·é·ãçŸããŸããã æããªã£ãŠããŸããã
ãã¡ããçµäºããŸããã æ±ã¯éããããè£åŒ·æã§è£åŒ·ãããŸããã ãããŠãã»ãŒ5幎éãMSTUã®åªç§ãªåŠçããããã®æ宀ã§å匷ããŠããŸãã ããããç§ãããã«è¡ããšããç§ã¯ããã§ãªããããããã®æ±ãšå€©äºãèŠããŸãã GUKã¯ç§ã®é ã®äžã§æãç³ãŸããŠããŸããïŒ æãã§ãã
Mailããžãã¹ãŠãããããã³Mail.RuããŒã¿ã«ã®ããããã¶ã€ããŒã§ããMitya Osadchukã¯ãTechnoparkã§ãDesigning Interfacesãã³ãŒã¹ãæããŠããŸãã
äžæ£è¡çºã¯ãæãå€ãåŠçèžè¡ã§ãã è©Šéšã«é²ããšãããªãã¯ç¹å¥ãªãšãŒãžã§ã³ãã§ãããå®å šã«ç¹å¥ãªæè¡ãåããŠããããã«èŠããŸãã ç§ã¯äœãåŠã°ããããŒãã·ãŒããæºåããå·§åŠã«çããæžããæåž«ã¯äœãæ°ã¥ãããããªãã¯ã¹ãŒããŒãã¹ãã³ã°ã¹ãã«ãšæéå ã«ããŒã«ãŒãã§ã€ã¹ãããèœåã®ãããã§åªããè©äŸ¡ãè¿«ãããŠããŸãã
æšæž¬ãã人ã¯ã»ãšãã©ããŸããããæåž«ã®åŽã§ã¯ããã¹ãŠããŸã£ããéã«èŠããŸãã åŠçãã©ãã ãããŸãå€è£ ãããšããŠããåŠçãæ¥ãå Žæã座ã£ãå Žæããå§ããŠãããã¹ãŠã¯éåžžã«äžç®ãŒãããŸãã åãã«ãã£ãŠãèŠãç®ã«ãã£ãŠãã»ãšãã©æ¯ã«ãã£ãŠã誰ãæµ®æ°ããŠããã®ãã¯æããã§ãã ãããã£ãŠãã¢ããã€ã¹ã®äžéš-èªåãæ °ããªãã§ãã ãããããªãã¯ãã€ã§ãã©ãã§ããããªãã®ã¹ãã«ã§ã¯ãªãcã§ããããšãèŠãããšãã§ããŸãããæåž«ã¯åœŒãããªããçãããã©ããã«äŸåããŸãã ãããŒãããã§ã¯ãªããç¥èãæã£ãŠæ¥ãŠãã ããïŒ
å¥ã®èå³æ·±ãç¹ã¯ãããŠãã³ã«ã®é£å ã§ãã åŠçã®é·ãéå¿ããããŠããå°è±¡ã ãã®äžã§ãããªãã¯ã¡ããã©äžåäžåã«è²»ãããšè¥ããªããŸãã BelyashiãèããäŸ¡æ Œããã¹ãŠãåäŸã®é ã®ããã«ãã åŠçé£å ã«æè¬ãããšãéå±ããŸãã
Dmitry nikiasi Isaikinãäž»èŠã¢ãã€ã«ã¡ãŒã«Mail.Ruããã°ã©ããŒã¯ããã¯ãããŒã¯ã§ã³ãŒã¹ãäžçŽC / C ++ããã°ã©ãã³ã°ããæããŸãã
é¢æ¥ã§ã ç§ã¯åŠçã«å°ããŸãïŒ
-人çã§äœãããã®ãäžçªå¥œãã§ããïŒ
-ããªããïŒ
ç§ã¯é·ãéã圌ãã©ã®ããã«ããªããããããéåžžã«èå³ãæã£ãŠæããŠãããŸããã ãŸã ãã®åŠçãé£ããŠè¡ã£ãããã§ãïŒ ãŸããäºåã®ãªã³ã©ã€ã³ãã¹ãã§ã»ãŒæºç¹ãç²åŸããéåžžã«çŸãã1人ã®å¥³ã®åã«ã€ããŠã®è©±ãããããšãèŠããŠããŸããã察é¢ã€ã³ã¿ãã¥ãŒã§ã¯å®å šã«ãŒãã§ããã ããã§ããªã圌女ããããããŠããã®ããšå°ãããããšãã圌女ã¯äœãç解ããŠããªããªããå¿ããçããŸããïŒç§ã¯å¥³ã®åã§ããã¯ãã§ããç§ã¯äœãç¥ãå¿ èŠã¯ãããŸããããããŠããªããäœããããå¿ èŠããããªããããªãã¯ãã€ãç·ã«å°ããããšãã§ããŸãã
Sergei boogerwooger Prilutskyãäž»èŠããã°ã©ããŒãããžãã¹ãŠããããMail and Mail.Ru Portalã¯ããã¯ãããŒã¯ã§ãã€ã³ã¿ãŒãããã¢ããªã±ãŒã·ã§ã³ã»ãã¥ãªãã£ãã³ãŒã¹ãæããŠããŸãã
ç§ãã¡ã¯éå¶åŸ¡ã«åº§ã£ãŠããŸããåŠçã¯ã¯ã©ãã¯ã¯ã©ãã¯ãç Žããã·ãªã¢ã«çæã¢ã«ãŽãªãºã ã埩å ããå¿ èŠããããŸãã 圌ãã¯æ¬¡ã®ããã«ç»å ŽããŸãïŒããªããŠã¯ã¬ã€ãžãŒãªæ©èœãã³ãŒãã®ãã¬ãŒã¹ãšãã¬ãŒã¹ããããŠããã¯åžžã«æ°ãã䟡å€ããããããŸããã ã©ãããã³ãŒããªã®ãããããŸããããæš©éãç¶æããå¿ èŠããããŸãããæ éã«è¿œè·¡ããããªã©ãšçããŠããŸãã ãã§ã«èªåã§å°æããŠã座ã£ãŠãããèŠããã§ããã ãã°ããããŠãããç§ãã¡ã¯ãã¹ãŠrandïŒïŒé¢æ°ããã¬ãŒã¹ããŠãããšããäºå®ã«è¿œãã€ããŸããã A-æš©éã
åŠçã«ã¯ãå®éã®WebãµãŒãã¹ã調æ»ããã»ãã¥ãªãã£ãæ¹åããããã®æšå¥šäºé ãå«ããšãã»ã€ãæžããšããã¿ã¹ã¯ãäžããããŸããã åŠçã¯ãã©ãŒã ãCookieãªã©ãæ laã«çªã£èŸŒãã§ãããšæ³å®ãããŠããŸããããããããŒã ã¯å°ãäžæ¯ã«ãªãããªã³ã©ã€ã³ã¹ãã¢ãæãåºããSQLã€ã³ãžã§ã¯ã·ã§ã³ãXSSãèŠã€ããŠã管çããã«ã«ã¢ã¯ã»ã¹ããã»ãšãã©éä¿¡ãããŸãããµã€ã管çè ã®ãã¹ã¯ãŒãã P-å€åã
AllodsããŒã ã®äž»ä»»ããã°ã©ããŒã§ããArtyom bozaro Navrotskyã¯ããã¯ãããŒã¯ã®ããŒã¿ããŒã¹ã³ãŒã¹ãæããŠããŸãã
2016幎ã®ç§ããããã¯ãããŒã¯ã§DBMSã³ãŒã¹ãå®æœããŠããŸãã ãããããããšããã
ãã¯ãããŒã¯ã®ãŠã§ããµã€ããããã³ãŒã¹ããã°ã©ã ã®äžè¬çãªã¢ã€ãã¢ãåŸãŠã以åã®è¬çŸ©ã®ã¹ã©ã€ãã䜿çšããŠPavel Shcherbininã®ãã¬ãŒã³ããŒã·ã§ã³ãåããæºåãéå§ããŸããã ã¡ãªã¿ã«ã2013幎ãããã®ã³ãŒã¹ã«é¢ããã¡ã¢ä»ãã®ãããªãåºãŠããŸããããããããªããšãæåã®è¬çŸ©ãè¡ãã®ãã¯ããã«å°é£ã«ãªããŸãã
ææ çãªèŠ³ç¹ããæãé£ããã®ã¯ãæåã®è¬çŸ©ãšæåã®ã³ã³ãããŒã«ã§ããã ç§ã®é ã®äžã§ã®æåã®è¬çŸ©ã®èšç»ã¯ãäžé±éåã»ã©ã§åœ¢ã«ãªããŸããã åé¡ã¯ãåã«ããŒãã«è¡ã£ãŠã¹ã©ã€ãã§ã¹ããŒãªãŒãèªãããšãã§ããªããšããããšã§ããè¬çŸ©ã¯çžäºã«é¢é£ããŠãããçŸåšã®è¬çŸ©ã®çµããã«ã¯ã次ã«äœãèšãããç¥ãå¿ èŠããããŸãã
ããã§ããåé¡ã®çŽç²ã«æè¡çãªåŽé¢ã§ãããã¬ãŒã³ããŒã·ã§ã³ã«ãã£ãŠãããªãå€ãã®èŠçãããããããŸããã æåã®2ãæéãPowerPointã§ãã¬ãŒã³ããŒã·ã§ã³ãä¿®æ£ããéã«èŠåŽããŸããã æ倧ã®äžäŸ¿ã¯ãWindowsãžã®ãã€ã³ããããã³å¿ èŠãªããŒãžã§ã³ã®Microsoft Officeãåããå³å¯ã«å®çŸ©ãããã³ã³ãã¥ãŒã¿ãŒãããã³ãœãŒã¹ã³ãŒãã§ã®æ§æã®åŒ·èª¿è¡šç€ºã«ãã£ãŠçºçããŸããã ã³ãŒã¹ã®éäžã§è§£æ±ºçãèŠã€ããŸãããã·ã£ã¯ãŒïŒ https://github.com/shower/shower ïŒã䜿çšããŠãã¹ãŠã®ãã¬ãŒã³ããŒã·ã§ã³ãåé 眮ããã¹ã©ã€ãã®æºåã«ãããæéãå€§å¹ ã«ççž®ããŸããã ç§ã®æ°æã¡ã«ãããšãç§ã¯ç®¡çããŸãããããã¡ããééããªãã§ããŸããã§ããã 次ã®åŠæããã£ãšè¯ããªãããšãé¡ã£ãŠããŸãã
Mail.Ru Groupã®æŠç¥ãšåæã®ãã£ã¬ã¯ã¿ãŒã§ããAlexander gornal Gornyã¯ããã¯ãã¹ãã£ã¢ã®Webéçºã®ã³ãŒã¹ãæãããã¯ãããŒã¯ã®åŠçåãã®å€§åŠé¢ãããžã§ã¯ããå®æœããŸããã
ãã¯ãããŒã¯ãç«ã¡äžãããšããç§ãè¬åž«ãåããã¯ãã ã£ãæåã®ã€ãã³ãã®1ã€ã§ãã€ã³ã¿ãŒããããšã€ã³ã¿ãŒããããããžã§ã¯ãéçºè ã®è·æ¥ãã©ãã»ã©åªããŠããããæããŠãã ããã ã€ãã³ããéå¬ããååã¯äºåã«èŠåããŸããïŒ
-ããŠãã³ã«ã«æ¥ãŠãã ããã ããã«é©åãªèŽè¡ãèŠã€ããæ¹æ³ãæããŠãã ããã
ç§ã¯åœŒïŒ
-æ°ã§èŠ³å®¢ãèŠã€ããããªããšããããšã§ããïŒ
-ããŠãã³ã¯è€éã§ãç¥ããªããã°ããã«èŠã€ããã®ã¯é£ããã
-ç§ã¯å€§äººã§ãããªãããªãã¯ç§ãã ãŸããŠããŸããïŒ å¯ŸåŠã§ããŸãã
20åã§å°çããŸãã æ¡ä»¶ä»ãã§ã302人ã®èŠ³å®¢ãå¿ èŠã§ããã3éã«äžãããŸãã ããã¯301ãããã¯303ã§ãã302ã¯éããŸãã ç§ã¯åºãèµ°ãå§ããŸãã-芳客ã¯ããŸããã ãŸãã§æªãã£ããã®ããã«ãé»è©±ã¯ãã®æç¹ã§åº§ã£ãŠããã®ã§ãååã«å©ããæ±ããããšãã§ããªããªããŸããã åæ ŒããçåŸã«ã302ã¯ã©ãã§ããïŒããšå°ããŸãã æåã®äººã¯ç¥ããªãã2çªç®ã®äººã¯ç¥ããªãã3çªç®ã®äººã¯ããååŸã«è¡ããé段ãäžããäžãã302ã«ãªããŸãããšèšããŸãã ç§ã¯æ¥ãŠã302ã§ã¯ãªãã302ããããMail.Ruã°ã«ãŒãã®ã€ãã³ãã¯ããã§ã¯è¡ãããŸããã ç§ã¯ããã§åŠçã«å°ããŸãïŒãæ¬åœã®302ã¯ã©ãã§ããïŒã æåã®äººã¯ç¥ããªãã2çªç®ã®äººã¯ç¥ããªãã3çªç®ã®äººã¯èšãïŒããããããã¯ããªãã«ãšã£ãŠãããªããšã§ãã-ããããŠãã©ããã£ãŠããã«çãã®ã§ããïŒã-ãããã«ãããã«ãããã«ããããŠããã«ãããã ãããŠãããªãã¯ãã§ã«ãããèŠã€ããã§ããããã ç§ã¯è¡ã£ããæ¥ããããŠãèªåã茪ã«ãªã£ãŠæ©ããŠããããšãç解ããŠããŸãã
èŠããã«ãç§ã¯ããŠãã³ã«ã20åéèµ°ãåããŸããã äžåºã«éããåãçªãèŠãããšãäœåºŠããããŸããããç§ã¯å¿ããæãã§ããŸããã ç§ã¯ã»ãšãã©é ããŠããããããã©ãŒãã³ã¹ã¯è¯ãã£ãããä»ã§ã¯ããŠãã³ã«ãé£ããããšããã£ãããšèŠããŠããã
Anton meph1st0 ReznikovãClouds Mail.Ruã®Webããã¯ãšã³ãéçºããŒã ã®ããŒã ãªãŒããŒã¯ãããã€ãã®Mail.Ru Groupæè²ãããžã§ã¯ãã§ãªãŒãã³Perlããã°ã©ãã³ã°ã³ãŒã¹ãæããŠããŸãã
ãã¯ãã¹ãã£ã¢ã®åæ¥çã«ã€ã³ã¿ãŒã³ã·ããã®ããã«ã€ã³ã¿ãã¥ãŒãããšãæéãçµããã«è¿ã¥ãããããžã§ã¯ãã«é¢ãã質åã«ã¹ã ãŒãºã«å€ãããŸããã Tarantoolã«ã€ããŠè©±ããšãã¿ã€ããã¹ãèŠã€ãã£ãæ¥ä»ã§åäœããè«æ±ã³ãŒãã瀺ããŸããã
ã400ãã®ä»£ããã«ã100ããšæžãããŠããŸããããããã¯2100幎ã«ãæã€ãããšã«ãªã£ãŠããããã¹ãã§ã¯2000幎ãã2099幎ãŸã§ã®æéãã«ããŒããŸããã 圌ãã¯ç¬ã£ãŠãå¥ããŸããã ã¯ããVladãããããã®åŠçã®ååã§ããã圌ã¯ä»ãå幎éã¯ã©ãŠãã§åããŠããŸãã
Mail.Ru Groupã¡ãã£ã¢ãããžã§ã¯ãã®ãã¯ãã«ã«ãã£ã¬ã¯ã¿ãŒã§ããPavel dzirtik Shcherbinin㯠ããã¯ãããŒã¯ã§ããŒã¿ããŒã¹ã³ãŒã¹ãæããŸããã
çåŸãã¡ã¯æã éåžžã«é£ãã質åãããŸããããã¡ããã¡ãé£ããã§ããããªãã¯ç解ããŠããŸããããªãã¯çµ¶å¯Ÿã«äœã«çããã¹ããããããŸããã ãããŠãããã¯ããªãã®èœåã ãšæãããŸãããããã«çãããããã®ã¯ãããŸããã ãã®ãããªã±ãŒã¹ããããŸããã課é¡ã®éçšã§ãçåŸãšç§ã¯çåŸã®ã©ãããããã®ããããã§æé ã®äœæãéå§ã§ããŸããã§ããã å€éšããŒãæ£ãããã³ã°ãããããšãã§ããŸããã§ããã ãããŠãããã«å®éã«äœãèµ·ãã£ãã®ãåãããŸããã§ãããããããç解ããããšã¯éåžžã«èå³æ·±ããã®ã§ããã è¬çŸ©ã¯çµäºããã©ããããããåããæãè¿ãã«ãã§ã«åº§ã£ãŠãããã«ãã§ã«æ°ä»ããŠããŠãééããèŠã€ããŸããã è¬çŸ©ã®1æéåŸãç§ã¯TechnoparkããŒã¿ã«ã«ç¶æ³ãåæããŠè§£æ±ºçã説æããæçš¿ãå ¬éããŸããã
é衚瀺ã®ããã¹ã
ä»æ¥ã®ã»ãããŒã§ã¯ã次ã®åé¡ããããŸããã
ããã«å¯ŸåŠããã«ã¯ã以äžãåç §ããå¿ èŠããããŸãã
å®éãNOT NULLã«å¯ŸããŠSET NULLãå®è¡ããããšã¯ã§ããŸããã
NOT NULLãDEFAULT 0ãèšå®ããã€ãã³ããNO ACTIONã«å€æãããããåé¡ãçªç¶è§£æ±ºããããšããŸãã
ãŸãïŒ ä»äœïŒ
ãŸãã確ãã«ïŒ
user_idå®çŸ©ã¯ãusersããŒãã«ã®idãšã¯ç°ãªããŸã
ãããŠ
ãã¹ãŠãæããŸãããïŒ
æå!!!
CREATE TABLE IF NOT EXISTS `mydb`.`forums` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(45) NOT NULL, `users_id` INT NOT NULL DEFAULT 0, PRIMARY KEY (`id`), INDEX `fk_forums_users1_idx` (`users_id` ASC), CONSTRAINT `fk_forums_users1` FOREIGN KEY (`users_id`) REFERENCES `mydb`.`users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL) ENGINE = InnoDB; ERROR 1215 (HY000): Cannot add foreign key constraint
ããã«å¯ŸåŠããã«ã¯ã以äžãåç §ããå¿ èŠããããŸãã
mysql> SHOW ENGINE INNODB STATUS; ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2014-02-26 21:39:44 690 Error in foreign key constraint of table mydb/forums: FOREIGN KEY (`users_id`) REFERENCES `mydb`.`users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL) ENGINE = InnoDB: You have defined a SET NULL condition though some of the columns are defined as NOT NULL.
å®éãNOT NULLã«å¯ŸããŠSET NULLãå®è¡ããããšã¯ã§ããŸããã
NOT NULLãDEFAULT 0ãèšå®ããã€ãã³ããNO ACTIONã«å€æãããããåé¡ãçªç¶è§£æ±ºããããšããŸãã
CREATE TABLE IF NOT EXISTS `mydb`.`forums` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(45) NOT NULL, `users_id` INT NOT NULL DEFAULT 0, PRIMARY KEY (`id`), INDEX `fk_forums_users1_idx` (`users_id` ASC), CONSTRAINT `fk_forums_users1` FOREIGN KEY (`users_id`) REFERENCES `mydb`.`users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; ERROR 1215 (HY000): Cannot add foreign key constraint
ãŸãïŒ ä»äœïŒ
mysql> SHOW ENGINE INNODB STATUS; ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2014-02-26 21:46:06 690 Error in foreign key constraint of table mydb/forums: FOREIGN KEY (`users_id`) REFERENCES `mydb`.`users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB: Cannot find an index in the referenced table where the referenced columns appear as the first columns, or column types in the table and the referenced table do not match for constraint. Note that the internal storage type of ENUM and SET changed in tables created with >= InnoDB-4.1.12, and such columns in old tables cannot be referenced by such columns in new tables. See http://dev.mysql.com/doc/refman/5.6/en/innodb-foreign-key-constraints.html for correct foreign key definition.
ãŸãã確ãã«ïŒ
user_idå®çŸ©ã¯ãusersããŒãã«ã®idãšã¯ç°ãªããŸã
`users_id` INT NOT NULL DEFAULT 0
ãããŠ
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT
ãã¹ãŠãæããŸãããïŒ
CREATE TABLE IF NOT EXISTS `mydb`.`forums` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(45) NOT NULL, `users_id` INT UNSIGNED NOT NULL, PRIMARY KEY (`id`), INDEX `fk_forums_users1_idx` (`users_id` ASC), CONSTRAINT `fk_forums_users1` FOREIGN KEY (`users_id`) REFERENCES `mydb`.`users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;
æå!!!
Mail.Ru Cloudã¢ãŒããã¯ãã®Vladimir codesign Perepelitsaã¯ãããã€ãã®Mail.Ru Groupæè²ãããžã§ã¯ãã§ãªãŒãã³ãªPerlããã°ã©ãã³ã°ã³ãŒã¹ãæããŠããŸãã
***
ç§ã¯åææ¥ã«ã¬ãã¹ã³ãåããŸãã-ãã¯ãã¹ãã£ã¢ã®Perlã§ã®ããã°ã©ãã³ã°ã«é¢ãããªãŒãã³ã³ãŒã¹ã®äžéšãšããŠã®è¬çŸ©ã ãã€ãã®ããã«ãã¢ã¹ã¯ã¯å·ç«å€§åŠã®æ¬é€šã§å€æ¹6æã«å§ãŸããšæããŸããã åãæ¥ã«ã空枯ã®å°äžéé§ ã«ããç§ã®ãªãã£ã¹ã§ãã¬ãŒãã³ã°ãè¡ãããŸããã ååŸ3æã«ãçåŸã®äžäººãé»è©±ããããèªå® ã§åŠç蚌ãå¿ããŠããŸã£ããšèšããç§ã¯èŠåå¡ã«äœãèšããªããšèšã£ãã ç§ã¯èšããŸãïŒãåé¡ã¯äœã§ããïŒ å¿ããŠããŸã£ã-圌ãšäžç·ã«å®¶ã«åž°ããªãããã 圌ã¯çããŸãïŒãè¬çŸ©ã¯ä»ã§ããã -ãããã§ã¯-ä»ïŒã-ãããŠãä»ã3æã§ããã ç¿æ £ãããç§ã¯ã¬ãã¹ã³ã6ã§ãããšæ±ºããŸããããããŠãç§ã¯ã¹ã±ãžã¥ãŒã«ãèŠãŸããã§ããã ç§ã¯æãïŒåææ¥ãç§ã¯ããã«ã¢ã¹ã¯ã¯å·ç«å€§åŠã«çããŸãã ç§ã¯èšããŸãããå®éãç§èªèº«ã¯ããã«ããŸãããæéãæ··ä¹±ãããŸããããããã«ãªããŸãã çåŸã«èŠåããŸããã ç§ã¯ããã«éããŠãç«ã¡å»ã£ãŠãããã²ãŒã¿ãŒããã¹ã«è¿œã蟌ã¿ãŸãããããŠãããã¯1æé以äžã瀺ããŸãã ãã®åãæ¥ã«ããµãŒã¯ã«ãªãã©ã€ããã§ã¹ãã£ãã«ãéå¬ãããŠããŸããã ã¢ã¹ã¯ã¯å·ç«å€§åŠã«çãããšãã§ãããæµ·è»ã®å ¥å Žããããã¯ãããŠãããããã²ãŒã¿ãŒã¯ããã衚瀺ããŸããã äžè¬çã«ãç§ã¯1æé20åé ããŸããã ããããæãå°è±¡çãªã®ã¯ãèŽè¡å šäœã§ãã åææ¥ãã³ãŒã¹ã¯çŽç²ã«ä»»æã§ãããæåž«ã¯é ããŸããã誰ããåŸ ã£ãŠããŸããã ãããŠèª°ãéé£ããŸããã§ããããç§èªèº«ã¯ãšãŠãæ¥ããŠããŸããã
***
äžçã«äœäººã®Perlããã°ã©ããŒããããã®èª¿æ»ãå®æœããŸããã ããã€ãã®åæããããåããŸããã ããšãã°ãæ¯æäœäººãCPANã©ã€ãã©ãªã蚪åããåŽååžå Žã«ãããšãäžçã®ããã°ã©ããŒã®ç·æ°ã¯äœäººã§ããã äžçäžã®ããã°ã©ããŒã®10ïŒ ãPerlã§æžããŠããããããã®çµ±èšãåŸãŸããã ãããŠãã³ãŒã¹å šäœãéããŠããã®äŸ¡å€ãäœããã®åœ¢ã§ç¢ºèªããŸãã æ¯èŒç話ããšã40人ãã³ãŒã¹ã®æåã®å®è¡ã«æ¥ãŸãã-4人ãåæ¥ããŸããã 70人ã2åç®ã«åå ãã7人ã解æŸãããŸããã ãããã£ãŠãåœéç 究ã¯åãã€ããªãã :)
ç§ãã¡ã®æ¥ã
ãã¯ãããŒã¯ãç«ã¡äžããŠãã5幎ãçµã¡ãŸããã ãã¯ãã¹ãã£ã¢ã¯ãã§ã«ã»ãŒ3幎åã«ããããã¯ããã¬ãã¯ã¯ãŸããªã1.5幎ã«ãªããŸãã ãããžã§ã¯ãã®äººæ°ã¯é«ãŸãã€ã€ãããŸããååã®ç«¶äºã¯æ¬¡ã®ãšããã§ãã
- ãã¯ãããŒã¯ãšãã¯ãã¹ãã£ã¢ã§ã¯ãå Žæããšã«9人ã
- ãã¯ããã¬ãã¯ã§-å Žæããšã«6人ã
- æè¿ç«ã¡äžãããããã¯ãããªã¹ãšãã¯ãã¢ãã ã§ã¯ã1人ããã5人ã§ãã
ãããªãã£ã³ãã«ã®è¬çŸ©ããŒãã®è£å ããã¬ãŒãã³ã°ããã°ã©ã ã®ã¬ãã¥ãŒãç¶ç¶ããæ¯å¹Ž40ã50ã®ãã¹ã¿ãŒã¯ã©ã¹ãšåå¥ã®ã¯ã©ã¹ãå®æœããŠããŸãã çŸåšã10ã®ãªã³ã©ã€ã³ã³ãŒã¹ãããããã¯ãããŒã¯ããã¯ãã¹ãã£ã¢ããã¯ããã¬ãã¯ã®æåž«ãæããŠããŸãã ç§ãã¡ã®ãããžã§ã¯ãã«åå ããŠãããã¹ãŠã®äººã«æè¬ããŸãïŒåŠçãæåž«ãæè²ã®æ¹åæ§ã®ããŒã ããªãŒãã³ã³ãŒã¹ã®åå è ãšä»ã®çã ç§ãã¡ã¯å€ãã®èå³æ·±ããã®ãåŸ ã£ãŠããŸãïŒ