商业智慧SSAS分析服务.ppt

* * * * * * * OLAP functionality Uses relational DB query tools Extensions to RDBMS Multidimensional data schema support Data access language and query performance optimized for multidimensional data Support for very large databases (VLDBs) Relational OLAP (ROLAP) * 第三十页，共四十四页。 * Typical ROLAP Client/Server Architecture *source: Database Systems: Design, Implementation, Management, 5th Edition, Rob Coronel * 第三十一页，共四十四页。 * OLAP functionality to multidimensional databases (MDBMS) Stored data in multidimensional data cube N-dimensional cubes called hypercubes Cube cache memory speeds processing Multidimensional OLAP (MOLAP) * 第三十二页，共四十四页。 * MOLAP Client/Server Architecture *source: Database Systems: Design, Implementation, Management, 5th Edition, Rob Coronel * 第三十三页，共四十四页。 * SQL Server 2000 SQL Server 2005 SQL Server 2000 Reporting Services BI High availability Scalability Ad hoc Reporting Enhanced Security Developer productivity First to include Enterprise ETL and Deep Data Mining First to include Enterprise Reporting solution Rich Report Design, Deployment Management Real-Time OLAP First RDBMS to include Data Mining Comprehensive Dimension Types 64Bit Support Lowest TCO Automatic Tuning Reliability and Security Integrated Business Intelligence Cross-release objectives SQL Server 7.0 First RDBMS to integrate OLAP and ETL Excel Integration Multi-vendor support Clustering out of the box “OLAP for Everyone” 1st Generation 2nd Generation 3rd Generation 微軟商業智慧 * 第三十四页，共四十四页。 硬體配置圖 NCR Oracle SQL DW OLAP Cube Web Server Source Data 1 2 3 * * 第三十五页，共四十四页。 * Unified Dimensional Model Pro-active caching Advanced Business Intelligence KPI/Perspectives Custom/Limited Aggregations and Semi-Additive Measures Web services Data Mining in the platform Integrated Developer Tools Failover Clustering Decision Trees Clustering Time Series Sequence Clustering Association Na?ve Bayes Neural Net Introduced in SQL Server 2000 SSAS特色 plus… Logistic Regression Linear Regression