OSS BIãã¼ã«ã触ã£ã¦ã¿ã
æ©éDiaryãæ¸ããªããªã£ã¦ãã¾ã£ãã¯ããã§ããããã«ã¡ãï¼ãã
ã¨ããããã§ããã®äºé±éã§OSSã®BIãã¼ã«ã触ã£ã¦ã¿ã¦ããã®ã§ããã®ã¡ã¢ãï½âã£ï¾Ð´ï¾)ã£Ïãï¾ï¾ï¾ï¾... ä¸å¿å¤§åæã¨ãã¦ããã®ã¯èª¿æ»æéäºé±éãç®çã¯ãµã¯ãã¨BIãæ§ç¯ã§ãããã¼ã«ãé¸å®ããäºã
OpenOLAP
ã¾ãã¯æ¥æ¬è£½OLAPãã¼ã«ã§ããOpenOLAPãããã£ã¦ã¿ã¾ããã ä»åBIã¨ããã«ãã´ãªã¼ã§èª¿æ»ããã¦ããããã§ããã触ã£ã¦ã¿ãæ触ã¨ãã¦ã¯ãå ¨ãç´ç²ãªOLAPãã¼ã«ã¨ããæãã§ããã ãããBIã ï¼ã¨è¨ã£ã¦ãã¾ãã®ã¯å°ã ãããã¾ããæ°ããã¾ãã»ã»ã»ã ã§ã»ã»ã»ãã®OpenOLAPããªãæªããã®ã§ãã»ã»ã» 2004å¹´é ã«ããã¸ã§ã¯ãå§åãã¦ããããã§ããã2006å¹´ã«Version2.1ããªãªã¼ã¹ãã¦ä»¥éå ¨ãé³æ²æ±°ç¡ãã»ã»ã» ããããã©ã¼ã©ã è¦ã¦ã¿ãã¨åã楽ããå±éãï¼ï¼ ããã¦ããã¦éçºããä¼ç¤¾ã®HPãè¦ã¦ã¿ãã¨ãã³ãã¼ã©ã¤ãã2006ï¼ï¼
ã¾ãããããªäºã¯ããã¨ãã¦ãå®éã«OpenOLAPãå ¥ãã¦åããã¦ã¿ãã¨ã»ã»ã»ãã°ããã°ããã°ã®ãªã³ãã¬ã¼ãã»ã»ã»ãããã²ã§ãï¼ ã¨æã£ã¦è²ã ã¨èª¿ã¹ã¦ã¿ãã¨ãNRIãMySQLç(åããã¦ã¿ãã®ã¯PostgreSQLç)ãåºãã¦ããã¨ã®äºãªã®ã§ããã¡ãã試ãã¦ã¿ãäºã«ã
ããã»ã»ã»ãã¡ããä¸åVersion1.0ãåºããã®ã¿ã§ããã®å¾ã®åãã¯ä¸åãªããæ©ããæªãã空æ°ãæ¼ãã»ã»ã»ãããããã¸ã§ã¯ãåãå人åã ãã»ã»ã»ã å®é使ã£ã¦ã¿ã¦ãããã¤ããã°ãçºè¦ããã¨ããã§ããªããããªãã ãã§ãããã¡ããã¨èª¿ã¹ã¦ã¿ãã¨ãNRIãOSSãè²ã éãã¦ã²ã£ãããã¦OpenStandiaã¨ãã¦æä¾ãã¦ããããã±ã¼ã¸ã®ä¸ã«OpenOLAPãåå¨ãã¦ããäºãçºè¦ããã©ãããããã¯ã¡ã³ããã³ã¹ããã¦ãæ§åãªã®ã§ããã¡ãã試ãã¦ã¿ãäºã«ãã¦MySQLçã®æ¤è¨¼ã¯çµäºã
ãã®OpenStandiaã«å«ã¾ãã¦ããOpenOLAPã¯ã¾ãã¾ãæ®éã«ã¯åãæãã è¥å¹²ãã°ã¯ãããã®ã®ãããããããªãç´ãæ°ãèµ·ããã¨ããã¬ãã«ã ã£ãã®ã§ãã¡ããã¡ããã¨æ¹ä¿®ããªããåãã¬ãã«ã¾ã§ã«ã¯ãªã£ãæãã åããã¦ã¿ã¦ã®ææ³ã¨ãã¦ã¯ãBIãã¼ã«ã¨ãã¦ã¿ãã¨ããªãå³ããããã©ãOLAPãç°¡åã«å®è£ ãããªãè¯ãããªï¼ã¨ããæãã§ããããã æ©è½çã«ã¯ä»¥ä¸ã®ãããªæãã
- ã¡ã¿ãã¼ã¿ä½æ
- ãã¥ã¼ã/ãã£ã¡ã³ã·ã§ã³ãªã©ã®ä½æ
- OLAP
BIã¨ãã¦å¿ è¦ã¨ãªã£ã¦ãããETLæ©è½ãã¬ãã¼ãã£ã³ã°æ©è½ããã¼ã¿ãã¤ãã³ã°ãªã©ã¨ãã£ãæ©è½ã¯åå¨ãã¦ããªãã ETLæ©è½ã«ã¤ãã¦ã¯OpenStagingã¨ãããOpenOLAPã®åæéçºä¼ç¤¾ãä½æãããã¼ã«ãããã®ã§ãããã§è£å®å¯è½ãã ãããã¯ãåæéçºä¼ç¤¾ããã¯ç¶ºéºãµãããªé¢ãã¦ãä»ã®OSSãæ´»ç¨ããæ¹ãè¯ãã®ãããããªãã ã¬ãã¼ãã£ã³ã°æ©è½ã«é¢ãã¦ã¯æ°æã¡ä»ãã¦ãããã®ã®ãã¯ã£ãããã£ã¦æ¥åã§ã¯ä½¿ãç©ã«ãªããªãã¨æãã®ã§ãããç¨åº¦ã®å¸³ç¥¨ãæ±ããããç¶æ³ã§ã¯ããªãããã®ã¬ãã¼ãã£ã³ã°ãã¼ã«ã使ã£ã¦ä½ã£ã¦ããå¿ è¦ãããæãã ãã¼ã¿ãã¤ãã³ã°ã«è³ã£ã¦ã¯ã©ããããããªãã£ã¦ããã¼ã¿ãã¤ãã³ã°ãã§ããªãã¨ï¼ãªãã¦è¨ãããæ¥ã«ã¯ãä½ãè¾¼ããä»ã®OSSã«ä¹ãæãããããªãã¨ãããªãæãã§ããã
ã¾ããä¸è¨ã¯ãããå人ã®ææ³ãªã®ã§ãå®éã«è§¦ã£ã¦ã¿ãã®ãè¯ãã¨æãã¾ããããã£ã±ãã ã¤ã³ã¹ãã¼ã«ãã¦ãµã³ãã«ãã¼ã¿ã§åãããã«ãªãã¾ã§ãã£ã¨ä¸æéä½ã ã¨æãã¾ãã®ã§ã (ä½ãããã©ã«ãã®ã½ã¼ã¹ã§ãã¥ã¼ãä½æãããã¨ããã¨ãã¡ããã£é ãããããã¾ããã»ã»ã») ä¸å¿ä»å触ã£ãç©ã®ãã¦ã³ãã¼ãã¯ä»¥ä¸ãªã³ã¯ããã
- OpenOLAP
- OpenOLAP for MySQL
- OpenOLAP(OpenStandia)
- ããæ®éã«DLãããã¨ããã¨ãNRIã®OpenStandiaãDLãã¦ãªããããããªããã®ã¾ã§è²ã ã¨ã¤ã³ã¹ãã¼ã«ããã¦ãã¾ãã®ã§ãこれãç´æ¥è½ã¨ãã¦ãã¾ãã®ãè¯ãã¨æãã¾ãã
- ä¸å¿ã¤ã³ã¹ãã¼ã«æé æ¸çãªãã®ãä»å±ãã¦ããã®ã§ãããOpenStandiaç°å¢ãåæã¨ãã¦ããçºãé©å®èªã¿æ¿ããå¿ è¦ãããã®ã§è¦æ³¨æã
Pentaho
OpenOLAPã¨æ¯è¼ããã¨ãPentahoã¯æ£çµ±ãªBIãã¼ã«ã¨ããæããPentahoèªä½ã¯è¤æ°ã®Projectããæãç«ã£ã¦ãã¦ãå ¨ä½ã¨ãã¦ã¯ä»¥ä¸ã®ãããªæ©è½ãããã
- ETLæ©è½
- ã¡ã¿ãã¼ã¿ä½æ
- ãã¥ã¼ã/ãã£ã¡ã³ã·ã§ã³ãªã©ã®ä½æ
- OLAP
- å®å帳票
- éå®å帳票
- ããã·ã¥ãã¼ã
- ãã¼ã¿ãã¤ãã³ã°
æ©è½ãè¦ãã ãã§ããªããè ¹ä¸æ¯ãªæãã«ãªãã¾ãããããä¸ã¤å¤§ããªãã¼ãã«ããã£ã¦ã»ã»ã»ãã¯ãæµ·å¤ç£ãªã®ã§å ¨ã¦ãè±èªãªãã§ãããã»ã»ã»ã©ãããå¤é¨ãã¡ã¤ã«ã§æã®æ°ç¨è¨å®ãã¦ããã°æ¥æ¬èªåã§ããæããªã®ã§ãããããã¼ãããä¿è¨¼ã§ãããã£ã¦è¨ãããã¨çµæ§å³ããæããä¸å¿Pentahoã®æ¥æ¬ä»£çåºã§10ä¸åå¼±ã§æ¥æ¬èªçã売ã£ã¦ããã¿ããã§ãããã©ããªãã§ãããããããããã«ãããè²·ã£ã¦ã¾ã§ã®æ¤è¨¼ã¨ããã¬ãã«ã§ã¯ãªãã£ãã®ã§ãä»åã¯è¡ã£ã¦ããªãã®ã§ä¸æã§ãããã¾ããããã¥ã¡ã³ããªã©ãå ¨ã¦è±èªã§ããçºããããããã¼ã«ãç¿çããã®ã大å¤ã£ã¦ã®ãããã¾ããã
ä»åã®æ¤è¨¼æéã§ã¯ãåå¥ã®ã¢ããªã±ã¼ã·ã§ã³ã«ã¤ãã¦ã®æ¤è¨¼ã¯è¡ããã®ã§ãããBIã·ã¹ãã å ¨ä½ãéãã¦ã®æ¤è¨¼ã¨ããç¹ã§ã¯æéåãã¨ããæãã§ããã æ©è½çã«ã¯ããªãè±å¯ã§ãç¾å¨ãã³ãã¥ããã£æ´»çºã¨ããäºããããæ¬æ ¼çã«OSSã§BIãèããã¨Pentahoãè¯ããããªæ°ããã¾ãããæéåãã¨ããäºãªã®ã§è´ãæ¹ãªãã»ã»ã»ã ããããããã¡ãã£ã¨è§¦ã£ã¦ã¿ããã£ããªï¼ã£ã¦ãã¨ã§ã触ã£ã¦ã¿ããã¨ããæ¹ã¯ä»¥ä¸ã®ãªã³ã¯ããã
ã¾ã¨ã
æ¬æ ¼çãªBIãèãã¦ãããªããã¯ãBIå ¨é¨å ¥ãã®ãã¼ã«ã§æ±ºã¾ãã§ãããã ä¸å¿SpagoãJasperã¨ãã£ããBIãã¼ã«ãããã®ã§ããã¡ãã«ã¤ãã¦ãæ¤è¨¼ããå¿ è¦ããããã¨æãã¾ãããBIã®ä¸é¨ãæ ããã¼ã«ã¨BIå ¨é¨å ¥ãã®ãã¼ã«ã§æ¯è¼ãã¦ãã¾ãã¨ããã¯ãæ©è½é¢ã§ã®ã®ã£ãããä¸çªã®çç±ããªã¨ã OLAPã¯ã§ãããã©ãã¼ã¿ãã¤ãã³ã°ã¯ã¡ãã£ã¨ã»ã»ã»ã¨ãªã£ã¦ãã¾ãã¨ãçµå±å ¨ã¦å¤æ´ã¨ãã話ã«ãªã£ã¦ãã¾ãã¾ããããã ã¨ã¯ããããã¼ã«ç¿çã«ãããå·¥æ°ã¨ããèãåºãã¨ãããªãæ©ã¾ããæãã§ããã ã¾ããä¸æ¦ãã®å ´ã§ã¯ã¢ã¤ãã¨ããæãã§çµãããã¦ããã¾ãï¼ã