BigQuery gets big new features to make data analysis even easier - Google Developers Blog å¾ æã®æ°æ©è½ãBig JOINããå§ããBigQueryã«æ°ããæ©è½ã追å ããã¾ããã Big JOINã«ã¤ãã¦è©¦ããã®ã¨ãä»ã®æ©è½ãå°ãèªãã§ã¿ãã®ã§ããã°ã«æ¸ãã¦ã¿ã¾ãã â¯Big JOINã¨ã¯ Big Queryã§ã¯ããã¾ã§ããã¼ãã«ã®JOINããããã¨ã¯ã§ããã®ã§ããã JOINãããã¼ãã«ã®ãµã¤ãºã«å¶éãããã¾ããã (ã¯ã¨ãªã®ã¡ã¤ã³ã®ãã¼ãã«ã®ãµã¤ãºã«ã¯å ã å¶éã¯ç¡ãã®ã§ãJOINç¸æã®ãã¼ãã«ã«å¶éãããã¨ããæã) ãã¼ã¿éè¨ã«ããã¦JOINãå¿ è¦ã¨ããé »åº¦ã¯é«ãã ããã¾ã§ã¯BigQueryã使ãéã«ãã®å¶éãåé¿ããããã®å¯¾å¿ãå¿ è¦ã§ããã å ·ä½çã«ã¯ã 1.JOIN対象ã®ãã¼ãã«ããµãã¯ã¨ãª
ãã¯ãã°ã¼ã°ã«ãªãã§ã¯ä¸çãåããªã...ï¼ ãã§ã«1996å¹´ã®å§ã¾ãã®æç¹ã§ããã°ã¼ã°ã«ã¯ã¤ã³ã¿ã¼ãããä¸ã®2500ä¸ãã¼ã¸ãã®æ å ±ãã¤ã³ããã¯ã¹åãã¦æ¤ç´¢ãã¸ãã¹ãã¹ã¿ã¼ããããã§ããã©ããªãã¨2010å¹´ç¾å¨ã«ã°ã¼ã°ã«ãã«ãã¼ãã¦ããã¤ã³ããã¯ã¹ãã¼ã¸æ°ã¯åªã«400åãè¶ ãã¡ãã£ã¦ãã¿ããã§ããï¼ ãã®10å¹´ã»ã©ã§1600åã«ãæ å ±éãè¨ãä¸ãã£ã¦ãããã§ãã£ã¦ãã ãããã®ã°ã¼ã°ã«ãã¤ã³ããã¯ã¹åãã¦ããå ¨ãµã¤ãã1åã®ã¢ãã¿ã¼ç»é¢ã«è¡¨ç¤ºãããã¨æã£ããããªãã¨ç»é¢ãµã¤ãºã¯600ä¸ãã¤ã«ï¼ç´970ä¸kmï¼ã«ãéãã赤éã241å¨ã§ãã¡ãããããã®è¶ ããã°ãµã¤ãºã®ãã£ã¹ãã¬ã¤ãç¨æããªãã¨ãããªããã ã£ã¦ï¼ ã¡ãªã¿ã«ã¤ã³ã¿ã¼ãããä¸ã«ã¯ç¾å¨ã§ã100å åãã®åèªæ°ã«å¹æµããæ å ±ã並ãã§ããã1åéã«40èªã®ã¹ãã¼ãã§ã¿ã¤ããã¦ãããªãã°ãå ¨é¨ãæã¡è¾¼ãã®ã«475ä¸å¹´ãè¦ããããã§ããã
ãGoogle Public Data Explorerãã¯ãä¸çéè¡ãªã©ãå ¬éããçµ±è¨ãã¼ã¿ã§ããã«ãã£ã¼ããGoogle Mapsã使ã£ãåå¸å³ãªã©ã使ãããµã¤ãã«çµã¿è¾¼ããã¨ãã§ããGoogle Labsã®ãã¼ã«ã ã ç±³Googleã¯3æ8æ¥ãå ¬éããã¦ããçµ±è¨ãã¼ã¿ãªã©ãåæã»ã°ã©ãåã§ãããªã³ã©ã¤ã³ãã¼ã«ãGoogle Public Data ExplorerããGoogle Labsã§å ¬éããã Google Public Data Explorerã§ã¯ãä¸çéè¡ãçµæ¸ååéçºæ©æ§ï¼OECDï¼ãªã©ãå ¬éãã¦ãããã¼ã¿ã»ãããå©ç¨ãã¦ãã°ã©ããããã«ãã£ã¼ãã使ã§ãããç¾å¨å©ç¨ã§ãããã¼ã¿ã»ããã¯12ãããä»å¾è¿½å ãã¦ããè¨ç»ãã°ã©ãã¯ãæãç·ã°ã©ããæ£ã°ã©ããGoogle Mapsãå©ç¨ããåå¸å³ãããã«ãã£ã¼ãã®4種é¡ãç¨æããã¦ããã ã°ã©ãã«ã¯ã¿ã¤ã ã¹ã©ã¤ãã¼ãä»ãã
ã¡ã³ããã³ã¹
ã©ã³ãã³ã°
ãç¥ãã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}