文件名称:
Microsoft SQL Server 2008 Analysis Services Unleashed
开发工具:
文件大小: 13mb
下载次数: 0
上传时间: 2010-08-20
详细说明: Contents at a Glance Introduction....................................................................................................1 Part 1: Introduction to Analysis Services 1 Introduction to OLAP and Its Role in Business Intelligence.........................7 2 Multidimensional Space...............................................................................17 3 Client/Server Architecture and Multidimensional Databases: An Overview27 Part 2: Creating Multidimensional Models 4 Conceptual Data Model......................... .......................................................37 5 Dimensions in the Conceptual Model.........................................................43 6 Cubes and Multidimensional Analysis.........................................................63 7 Measures and Multidimensional Analysis....................................................75 8 Advanced Modeling......................................................................................91 9 Multidimensional Models and Business Intelligence Development Studio...................................................................................109 Part 3 Using MDX To Analyze Data 10 MDX Concepts............................................................................................139 11 Advanced MDX...........................................................................................161 12 Cube-Based MDX Calculations...................................................................189 13 Dimension-Based MDX Calculations.........................................................221 14 Extending MDX with Stored Procedures....................................................237 15 Key Performance Indicators, Actions, and the DRILLTHROUGH Statement.......................................................................261 16 Writing Data into Analysis Services...........................................................291 Part 4 Creating a Data Warehouse 17 Loading Data from a Relational Database..................................................307 18 DSVs and Object Bindings..........................................................................317 19 Multidimensional Models and Relational Database Schemas...................329Part 5 Bringing Data into Analysis Services 20 The Physical Data Model............................................................................345 21 Dimension and Partition Processing..........................................................377 22 Using SQL Server Integration Services to Load Data.................................407 23 Aggregation Design and Usage-Based Optimization..................................417 24 Proactive Caching and Real-Time Updates................................................435 25 Building Scalable Analysis Services Applications.......................................451 Part 6 Analysis Server Architecture 26 Server Architecture and Command Execution...........................................477 27 Memory Management................................................................................503 28 Thread Management...................................................................................521 29 Architecture of Query Execution—Calculating MDX Expressions............527 30 Architecture of Query Execution—Retrieving Data from Storage.............553 Part 7 Accessing Data in Analysis Services 31 Client/Server Architecture and Data Access...............................................569 32 XML for Analysis........................................................................................579 33 ADOMD.NET...............................................................................................599 34 Analysis Management Objects....................................................................669 Part 8 Security 35 Security Model for Analysis Services..........................................................713 36 Securing Dimension Data...........................................................................731 37 Securing Cell Values....................................................................................751 Part 9 Management 38 Using Trace to Monitor and Audit Analysis Services.................................763 39 Backup and Restore Operations..................................................................787 40 Deployment Strategies................................................................................805 41 Resource Monitoring...................................................................................815 Index...........................................................................................................823 ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台,提供交流渠道,下载内容来自于网络,除下载问题外,其它问题请自行百度。
- 本站已设置防盗链,请勿用迅雷、QQ旋风等多线程下载软件下载资源,下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载,请稍后再次尝试;或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎,请到消费记录里找到下载记录反馈给我们,经确认后退回积分.
- 如下载前有疑问,可以通过点击"提供者"的名字,查看对方的联系方式,联系对方咨询.