ããŒã¿ãã€ãã³ã°ã«é¢ããããã€ãã®èšäºã®å ¬éã¯ããã®ãããã¯ã«å¯Ÿããã³ãã¥ããã£ã®é«ãé¢å¿ã瀺ããŠããŸãã ãèªãå Žæãããå§ããå Žæããªã©ãå€ãã®è³ªåããããŸããã ãã®åéã§èªä¿¡ãæã£ãŠã¹ã¿ãŒãããããã®è³æããªãœãŒã¹ãã玹ä»ããŸãã
æ¬
A.A. ãã«ã»ã®ã£ã³ãM.Sã ã¯ããªã€ãããV.Vã ã¹ãããã³ã³ãI.Iã ã³ãŒã«ãã¡ãœãããšããŒã¿åæã¢ãã«ïŒOLAPããã³ããŒã¿ãã€ãã³ã°ïŒ+ CD-ROMïŒ
![ç»å](https://habrastorage.org/getpro/habr/post_images/781/3ac/ee1/7813acee1e2794f349af78a4eb2fcfbc.jpg)
ãã®æ¬ã¯ããšã³ã¿ãŒãã©ã€ãºã·ã¹ãã ã®éçºã§æãé¢é£æ§ã®é«ãé åã瀺ããŠããŸããããŒã¿ãŠã§ã¢ããŠã¹ã®æ§æãéçšïŒOLAPïŒãããŒã¿ãã€ãã³ã°ïŒããŒã¿ãã€ãã³ã°ïŒã§ãã 3ã€ã®é åã¯ãã¹ãŠãå®éã«ç解ããããã«äœ¿çšããã®ã«ååãªéãšèŠãªãããŸãã ããŒã¿åæã®æ¹æ³ãšã¢ã«ãŽãªãºã ã®èª¬æãšãäŸã䜿çšããäœæ¥ã®èª¬æã«ããããã¬ãŒãã³ã°ããã¥ã¢ã«ãšããŠã ãã§ãªãããœãããŠã§ã¢éçºã®å®çšçãªã¬ã€ããšããŠã䜿çšã§ããŸãã
ãªãŸã³ã®æ¬
ç§èªèº«ããïŒãã®æ¬ã¯é·ãéãããŒã¿ãã€ãã³ã°ã«é¢ããäž»èŠãªæ å ±æºã§ãã£ãããã匷ããå§ãããŸãã
A. A.ãã«ã»ã®ã£ã³ãMãS.ã¯ããªã€ãããVãV.ã¹ãããã³ã³ãIãI. KholodããŒã¿åææè¡ã ããŒã¿ãã€ãã³ã°ãããžã¥ã¢ã«ãã€ãã³ã°ãããã¹ããã€ãã³ã°ãOLAPïŒ+ CD-ROMïŒ
![ç»å](https://habrastorage.org/getpro/habr/post_images/b64/f1b/af5/b64f1baf5ce7e23a00099e081fd2119d.jpg)
ãã®æ¬ã¯ãããã¥ã¢ã«ãããŒã¿åæã®æ¹æ³ãšã¢ãã«ãã®ç¬¬2çã§ãããæŽæ°ããã³è£è¶³ãããŠããŸãã OLAPããã³ããŒã¿ãã€ãã³ã°ãã
ãšã³ã¿ãŒãã©ã€ãºã·ã¹ãã ã®éçºã«ãããäž»ãªæ¹åæ§ã«ã€ããŠèª¬æããŸããããŒã¿ãŠã§ã¢ããŠã¹ã®æ§æãåæ£ãéçšïŒOLAPïŒãã€ã³ããªãžã§ã³ãïŒããŒã¿ãã€ãã³ã°ïŒãèŠèŠïŒããžã¥ã¢ã«ãã€ãã³ã°ïŒããã³ããã¹ãïŒããã¹ããã€ãã³ã°ïŒããŒã¿åæã åæã®äž»ãªã¿ã¹ã¯ã解決ããããã®ã¡ãœãããšã¢ã«ãŽãªãºã ã®èª¬æïŒåé¡ãã¯ã©ã¹ã¿ãªã³ã°ãªã©ãåã¡ãœããã®ã¢ã€ãã¢ã®èª¬æã¯ããã®ã¢ããªã±ãŒã·ã§ã³ã®ç¹å®ã®äŸã«ãã£ãŠè£è¶³ãããŸãã æ·»ä»ãããŠããã®ã¯ãããŒã¿ãã€ãã³ã°æšæºãã¢ã«ãŽãªãºã ã®Xelopesã©ã€ãã©ãªãããŒã¿ãã€ãã³ã°ã©ãããã³é¢é£ãœãããŠã§ã¢ãå«ãCDã§ãã
ãªãŸã³ã§äºçŽãã
èªåããïŒä»¥åã®æ¬ã®èè ããã®æ¬ã®æ°ããããŒãžã§ã³ã§ã¯ãããã¹ããã€ãã³ã°ãªã©ã®æ°ããã»ã¯ã·ã§ã³ãè¿œå ãããŸããã
Paklin N.B.ãOreshkov V.I. ããžãã¹ã€ã³ããªãžã§ã³ã¹ïŒããŒã¿ããç¥èãžïŒ+ CDïŒ
![ç»å](http://www.basegroup.ru/files/image/library/books/bi/bibook.jpg)
ãã®æ¬ã¯ãäŒæ¥æ å ±ãšåæã·ã¹ãã ã®äœæãšå®è£ ã«äœ¿çšãããäž»ãªæè¡ããããžãã¹åæããšããçšèªãšçµã¿åãããŠãããŒã¿ãŠã§ã¢ããŠã¹ãšOLAPãããŒã¿å€æãETLãšã¯ãªãŒãã³ã°æ¹æ³ãåºæ¬çãªããŒã¿ãã€ãã³ã°ã¢ã«ãŽãªãºã ãæç³»ååæãã¢ãããŒãã¢ãã«ã®éåã®æ§ç¯ãšãã®æ¯èŒã 第2éšã§ã¯ãBaseGroup Labs Deductoråæãã©ãããã©ãŒã ã«åºã¥ããŠãçµ±åãåæã¬ããŒããã¹ã³ã¢ãªã³ã°ã販売ä¿é²ãéèŠäºæž¬ããã®ä»ã®ããžãã¹ã€ã³ããªãžã§ã³ã¹ããŒã«ãªã©ã®åé¡ã解決ããæ¹æ³ããã¢ã³ã¹ãã¬ãŒã·ã§ã³äŸã§ç€ºããŸãã
ãã®æ¬ã¯ãå°æ¥ããã³æ¢åã®ããžãã¹åæè ãããŒã¿åæã®åéã®å°é家ããªãã³ã«æ å ±ããã³åæã·ã¹ãã ãç 究ããåŠçã倧åŠã®ç¬¬äžããã³ç¬¬äºæè²ãé«åºŠãªèšç·Žã®ããã°ã©ã ã®äžã§åŠã¶åŠçã察象ãšããŠããŸãã
ãã®åºçç©ã«ã¯ãåæãã©ãããã©ãŒã Deductor Academicã®ç¡æé åžããŒãžã§ã³ã®é åžããããæ¬ã®ç¬¬2éšã®ãã¢äŸãããã³Deductorã«é¢ããè¿œå è³æãåé²ãããCDãä»å±ããŠããŸãã
æ¬ã®ããŒãž
åºç瀟ããŒã¿ãŒã®ãŠã§ããµã€ãã§äºçŽãã
ç§èªèº«ããïŒæšæ¥ãã®æ¬ãããã£ãŠããŸããããçŽ æã®éãšè³ªã®äž¡æ¹ã§è¯ãå°è±¡ãäžããŸãã 䜿çšããïŒãŸãã¯æ§é€ã䜿çšããïŒå Žåããã®æ¬ã¯ããªãã®ããã§ãïŒ2009幎ã®æ¬ïŒã
éå£ç²Ÿç¥ãããã°ã©ã ããŸã
![ç»å](https://habrastorage.org/getpro/habr/post_images/8a2/ed5/68d/8a2ed568d164a59406dd6ed23a832c53.jpg)
æ€çŽ¢çµæã®ã©ã³ãã³ã°ã補åã®æšå¥šããœãŒã·ã£ã«ããã¯ããŒã¯ããªã³ã©ã€ã³ãã¢ãªã³ã°ã®å®è£ æ¹æ³ãç¥ãããã§ããïŒ ãã®ãšããµã€ãã£ã³ã°ãªæ¬ã¯ãããŒãããŒã€ã³ã¿ãŒãããã¢ããªã±ãŒã·ã§ã³ã«ãã£ãŠçæãããèšå€§ãªããŒã¿ããæçšãªæ å ±ãæœåºããWeb 2.0ã¢ããªã±ãŒã·ã§ã³ã®æ§ç¯æ¹æ³ã説æããŠããŸãã ããã§èª¬æããæŽç·Žãããã¢ã«ãŽãªãºã ã䜿çšããŠãä»ã®ãµã€ããŸãã¯ã¢ããªã±ãŒã·ã§ã³ã®ãŠãŒã¶ãŒããèå³æ·±ãããŒã¿ã»ãããåãåããããããåæããŠãã¿ãŒã³ãèå¥ããã€ã³ããªãžã§ã³ãããã°ã©ã ãäœæã§ããŸãã
æ¬ãéåçãªå¿ã®ããã°ã©ãã³ã°ãã¯ãæ©æ¢°åŠç¿ãšçµ±èšã®äžçãžã®å ¥éæžã§ãã ãµãŒãããŒãã£ã®ã¢ããªã±ãŒã·ã§ã³ã«ãã£ãŠæ¯æ¥åéãããæ å ±ã«åºã¥ããŠããŠãŒã¶ãŒã®è¡åã奜ã¿ã«é¢ããããŒã±ãã£ã³ã°ã®æŽå¯ãäœæããæ¹æ³ã説æããŸãã åã¢ã«ãŽãªãºã ã¯æ確ãã€ç°¡æœã«èšè¿°ãããŠãããç¬èªã®Webãµã€ããããã°ãWikiããŸãã¯ç¹å®ã®ã¢ããªã±ãŒã·ã§ã³ã«ããã«å«ããããšãã§ããã³ãŒããä»å±ããŠããŸãã 次ã®ãããã¯ãå«ãŸããŸãã
*å°å£²æ¥è ã補åãŸãã¯ãã«ãã¡ãã£ã¢è£œåãæšå¥šã§ããå ±åãã£ã«ã¿ãªã³ã°æ¹æ³ã
*倧èŠæš¡ãªããŒã¿ã»ããã§é¡äŒŒãããµã³ãã«ã®ã°ã«ãŒããæ€åºããããã«äœ¿çšãããã¯ã©ã¹ã¿ãªã³ã°ææ³ã
*åé¡ã«å¯Ÿããæ°çŸäžã®å¯èœãªè§£æ±ºçãæ€èšãããããã®äžããæé©ãªãã®ãéžæã§ããæé©åã¢ã«ãŽãªãºã ã
*çºçããåèªããã®ä»ã®å åã«åºã¥ããŠããã¥ã¡ã³ããåé¡ããããã«ãã¹ãã 察çãã£ã«ã¿ãŒã§äœ¿çšããããã€ãžã¢ã³ãã£ã«ã¿ãªã³ã°ã
*åºäŒãç³»ãµã€ãã§ãã¢ãç §åããããã«äœ¿çšããããµããŒããã¯ã¿ãŒã®æ¹æ³ã
*ããŸããŸãªåé¡ã解決ããããã®é²åçææ³ã®é©çš-ã³ã³ãã¥ãŒã¿ãŒã¯ãåã²ãŒã ã®ãã¬ã€åŸã«ç¬èªã®ã³ãŒããæ¹åããããšã§åŠç¿ããŸãã
åç« ã«ã¯ããã®ç« ã§èª¬æãããŠããã¢ã«ãŽãªãºã ãç¿åŸããããšãç®çãšããå®çšçãªã¿ã¹ã¯ãä»éããŠããŸãã åçŽãªããŒã¿ããŒã¹ã¹ãã¬ãŒãžã¢ããªã±ãŒã·ã§ã³ãè¶ ããŠãã€ã³ã¿ãŒãããäžã§æãè±å¯ãªããŒã¿ã®ãããžãããæ©èœãããŸãã
books.ruã§äºçŽãã
ç§ããïŒãã®æ¬ã¯ã以åã®èšäºãžã®ã³ã¡ã³ãã®1ã€ã§åŒ·ãæšå¥šãããŸããã ç§ã¯èªåã§ãããèªãã§ããŸããã§ããããèªæžèšç»ã«ãããå ¥ããŸãã:)
ãã®ä»ã®æ¬
- ãã¿ãªã¢ã»ãšã«ããã¯ãã¢ã¬ã¯ã»ã€ã»ãã§ãããã Microsoft OLAPãã¯ãããžãŒã®æŠèŠ -ãã®æ¬ã¯ãMicrosoft Officeã®çµéšè±å¯ãªãŠãŒã¶ãŒãããžãã¹ã¢ããªã¹ããéçºè ãæ å ±ãµãŒãã¹ã®ãããŒãžã£ãŒãåæããŒã¿åŠçïŒOLAPïŒããã³ããŒã¿ãŠã§ã¢ããŠãžã³ã°ã®äœ¿çšã®åºæ¬ã«ç²Ÿéãããèªååéšéãå«ãå¹ åºãèªè ã察象ãšããŠããŸãææ°ã®OLAPããŒã«ãæäŸããæ©èœãåããŠããŸãã Microsoftã®OLAPããŒã«ã¯ãæ¬ã§èª¬æãããŠããåé¡ã説æããããã«äœ¿çšãããŸãã
- Berger A. Microsoft SQL Server 2005 Analysis Servicesã OLAPããã³å€æ¬¡å ããŒã¿åæ-Microsoft SQL Server 2005 Analysis Servicesã®éçºè ã«ãã£ãŠæžãããæ¬ã¯ãèªè ã«ãã®æ©èœãšããã€ã¹ã®å šäœåãæäŸããŸãã å€æ¬¡å ããŒã¿åæã®åºæ¬ãã«ããŒããå€æ¬¡å ããŒã¿ã¢ãã«ãšOLAPãµãŒããŒã®èšèšã«é¢ããæ·±ãæŽå¯ãæäŸããŸãã MDXå€æ¬¡å ããŒã¿ã¢ã¯ã»ã¹èšèªãšãã®é«åºŠãªæ©èœã®åºæ¬æŠå¿µãããã³ãµãŒããŒã¢ãŒããã¯ãã£ãããŒã¿åŠçæ¹æ³ãããŒã¿ã¢ã¯ã»ã¹ã¢ã«ãŽãªãºã ã«ã€ããŠèª¬æããŸãã XML / Aãããã³ã«ãå«ããå éšããã³å€éšã®ããŒã¿äº€æãããã³ã«ãæäŸãããŸãã ã¡ã¢ãªç®¡çã¢ã«ãŽãªãºã ãå«ãAnalysis ServicesãªãœãŒã¹ç®¡çã¢ã«ãŽãªãºã ãèæ ®ãããŸãã Analysis Servicesã䜿çšããŠå¹æçãªã¯ã©ã€ã¢ã³ãã¢ããªã±ãŒã·ã§ã³ãäœæããããã»ã¹ãå€æ¬¡å ããŒã¿ããŒã¹ãšãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ãçµ±åããã¡ã«ããºã ã«ã€ããŠèª¬æããŸãã ã»ãã¥ãªãã£ãšMicrosoft SOL Server 2005 Analysis Servicesã®ç®¡çã«éç¹ã眮ãããŠããŸãã
- D.ããã¯ã¬ãã³ãCãã¿ã³ãBãã¯ãªãããã Microsoft SQL Server 2008ïŒããŒã¿ãã€ãã³ã°-ããŒã¿ãã€ãã³ã° -Microsoft SQL ServerããŒã¿ãã€ãã³ã°ã®éçºè ã«ãã£ãŠæžãããæ¬ã¯ãèªè ã«ãã®æ©èœã®å šäœåã瀺ããSQL Server 2008ã®ããŸããŸãªåé¡ã解決ããéã®äœ¿çšã®æ©èœã瀺ããŸããããŒã¿ãã€ãã³ã°ãšèšèªã®æŠèŠãæ€èšããŸãDMX MS Office 2007ãBusiness Intelligence Development Studioãããã³SQL Server Management Studioã䜿çšãããœãªã¥ãŒã·ã§ã³ã®äœæã䜿çšããããŒã¿åæã瀺ããŠããŸãã ããŸããŸãªåæã¢ã«ãŽãªãºã ã®ã¢ããªã±ãŒã·ã§ã³ãããã³OLAPãã¥ãŒãã®ç¥çåæã«ã€ããŠè©³ãã説æããŸãã ã¢ãŒããã¯ãã£ã管çãªã©ãèæ ®ããŸããã è³æã«ã¯ãå®çšçãªäŸããã³ããèæ¯æ å ±ãä»å±ããŠããŸãã
- Microsoft SQL Server 2008ã«ããããŒã¿ãã€ãã³ã°
ãªã³ã©ã€ã³è³æ
Interface.ru
MS SQL 2005ãã©ãããã©ãŒã ã䜿çšããããŒã¿ãã€ãã³ã°ã³ãŒã¹ããŒã1
MS SQL 2005ãã©ãããã©ãŒã ã䜿çšããããŒã¿ãã€ãã³ã°ã³ãŒã¹ããŒã2
MS SQL 2005ãã©ãããã©ãŒã ã䜿çšããããŒã¿ãã€ãã³ã°ã³ãŒã¹ããŒã3
MS SQL 2005ãã©ãããã©ãŒã ã䜿çšããããŒã¿ãã€ãã³ã°ã³ãŒã¹ããŒã4
Intuit.ru
I.A.ã«ããã³ãŒã¹ãããŒã¿ãã€ãã³ã°ã äžéšã³ãã
ãã®ã³ãŒã¹ã§ã¯ãåŠçã«ããŒã¿ãã€ãã³ã°ãã¯ãããžãŒã玹ä»ããããŒã¿ãã€ãã³ã°ã®æ¹æ³ãããŒã«ãããã³ã¢ããªã±ãŒã·ã§ã³ã詳现ã«èª¿ã¹ãŸãã åæ¹æ³ã®èª¬æã«ã¯ããã®äœ¿çšæ¹æ³ã®å ·äœäŸãä»å±ããŠããŸãã
ããŒã¿ãã€ãã³ã°ãšåæããã³OLAPã·ã¹ãã ã®åŸæ¥ã®çµ±èšçææ³ã®éãã«ã€ããŠèª¬æããããŒã¿ãã€ãã³ã°ã«ãã£ãŠæããã«ããããã¿ãŒã³ã®çš®é¡ïŒé¢é£ä»ããåé¡ãã·ãŒã±ã³ã¹ãã¯ã©ã¹ã¿ãªã³ã°ãäºæž¬ïŒã調ã¹ãŸãã ããŒã¿ãã€ãã³ã°ã®ç¯å²ã«ã€ããŠèª¬æããŸãã Webãã€ãã³ã°ã®æŠå¿µãå°å ¥ãããŸããã ããŒã¿ãã€ãã³ã°ææ³ã¯ããã¥ãŒã©ã«ãããã¯ãŒã¯ã決å®æšãéå®åæææ³ãéºäŒçã¢ã«ãŽãªãºã ãé²åçããã°ã©ãã³ã°ãã¯ã©ã¹ã¿ãŒã¢ãã«ãçµåææ³ãªã©ã詳现ã«æ€èšãããŸãã ããŒã¿ãã€ãã³ã°ãã¯ãããžã䜿çšããããŒã«ã䜿çšããŠå®çšçãªåé¡ã解決ããããšã§ãåæ¹æ³ã«ç²ŸéããŠããããšã瀺ããããŒã¿ãŠã§ã¢ããŠã¹ã®åºæ¬æŠå¿µãšãã®ã¢ãŒããã¯ãã£ã«ãããããŒã¿ãã€ãã³ã°ã®å Žæã«ã€ããŠèª¬æããŸãã OLTPãOLAPãROLAPãMOLAPã®æŠå¿µã玹ä»ããããŒã¿ãã€ãã³ã°ãã¯ãããžã䜿çšããããŒã¿åæã®ããã»ã¹ã«ã€ããŠèª¬æããŸãã ãã®ããã»ã¹ã®æ®µéã¯è©³çŽ°ã«æ€èšãããŸãã åæãœãããŠã§ã¢ã®åžå ŽãåæããããŒã¿ãã€ãã³ã°ã®å€§æã¡ãŒã«ãŒã®è£œåã説æãããã®æ©èœã«ã€ããŠèª¬æããŸãã
ã³ãŒã¹ããŒãžã«è¡ã
Kdkeys.net
ããŒã¿ãã€ãã³ã°ããã° æã ãèå³æ·±ãè³æããããæãããŸãããããã§ã¯ãããŸããã åºæ¬çã«ããããã¯ãããã¯ã¯ãç§ã¯éåžžã«è¥ãã®ã§ãå©ããå¿ èŠã§ãã ç§ã®ããã«ä»äºãããŠãã ãããç§ã¯æè¬ããŸãã:)
kdkeys.net
ããŒã¹ã°ã«ãŒãã°ã«ãŒã
ããŒã¿ãã€ãã³ã°ã«é¢ããå€ãã®æçšãªæ å ±ãå«ãŸããŠããŸãã BaseGroup Labsã¯ãããŒã¿ãŠã§ã¢ããŠã¹ãETLãOLAPãããŒã¿ããŒã¹ã®ç¥èçºèŠãããŒã¿ãã€ãã³ã°ããµããŒãããåæãã©ãããã©ãŒã ã§ããDeductorã®éçºè ã§ãã
basegroup.ru
ãã®ä»ã®è³æ
- Microsoft SQL Server 2008ïŒããŒã¿ãã€ãã³ã°
- Oracle Data Miningã®ãµã³ãã«ã³ãŒã
- ããŒã¿ãã€ãã³ã°ã®IBM SQLã³ãŒãäŸ
- MSDNã®ããŒã¿ãã€ãã³ã°ãã©ãŒã©ã
- Microsoft Office 2007çšMicrosoft SQL Server 2005ããŒã¿ãã€ãã³ã°ã¢ãã€ã³ãããŠã³ããŒããã
ãããªè³æ
SQL Server 2008ã®ããŒã¿ãã€ãã³ã°ãšã¯-TechDays.com
ããžãã¹ã€ã³ããªãžã§ã³ã¹ãšMicrosoftããžãã¹ã€ã³ããªãžã§ã³ã¹ãã©ãããã©ãŒã ã®æŠèŠ-TechDays.com
ç§ã®ãããããªè²¢ç®:)
CodeplexããŒã¿ãã€ãã³ã°ãœãŒã¹ã³ãŒãã¯ãäžéšã®ããŒã¿ãã€ãã³ã°ã¢ã«ãŽãªãºã ãšã¡ãœãããåéããããªãŒãã³ãœãŒã¹ãããžã§ã¯ãã§ãïŒäžéšã¯ãããã¯ãŒã¯ããçµã¿ç«ãŠãããäžéšã¯ç¬ç«ããŠå®è£ ãããäžéšã¯ä»ã®èšèªãã移æ€ãããŸãïŒã
ãã€ããŒã¿ãã€ãã³ã°ããã°
ãã®èšäºã«ãã¹ãŠã®è³æãæ²èŒãããŠããããã§ã¯ãªãã®ã§ããªãã·ã§ã³ããªã¹ãã«è¿œå ã§ããŸãã
ãæž èŽããããšãããããŸããïŒ
PS Bookã®èª¬æã¯å ã®æ³šéã§ãã
æŽæ°ããŸããã ã³ã¡ã³ãã§Wekaã«ã€ããŠèšåããŠãããŠããããšã-å®éãä»æ¥ãããã¯ããŒã¿ãã€ãã³ã°ã«ãšã£ãŠæé«ã®ãªãŒãã³ãœãŒã¹ã©ã€ãã©ãªã§ãã
Javaã®ããŒã¿ãã€ãã³ã°ãœãããŠã§ã¢
Wekaããã°ã©ã ã®èª¬æ
æžç±ãããŒã¿ãã€ãã³ã°ïŒå®çšçãªæ©æ¢°åŠç¿ããŒã«ãšãã¯ããã¯ïŒç¬¬2çïŒã
Upd2ã ããŒã¿ãŠã§ã¢ããŠã¹ããŒã¿ãã€ãã³ã°Olap Technology Book Collection
Stataããã³SASããã°ã©ã ã§ã®äœæ¥ãšããã°ã©ãã³ã°ã«é¢ããããŒã¿ãã€ãã³ã°ã«é¢ããæžç±ã®ã©ã€ãã©ãª