专业SQL服务器分析服务2005与MDX Professional SQL Server Analysis Services 2005 with MDX

分類: 图书,进口原版书,科学与技术 Science & Techology ,
作者: Sivakumar Harinath, Stephen R. Quinn 著
出 版 社: John Wiley & Sons
出版时间: 2006-12-1字数:版次: 1页数: 828印刷时间: 2006/12/01开本:印次:纸张: 胶版纸I S B N : 9780764579189包装: 平装编辑推荐
作者简介:Sivakumar Harinath was born in Chennai, India. Siva has a Ph.D. in Computer Science from the University of Illinois at Chicago. His thesis title was: “Data Management Support for Distributed Data Mining of Large Datasets over High Speed Wide Area Networks.” Siva has worked for Newgen Software Technologies (P) Ltd., IBM Toronto Labs, Canada, and has been at Microsoft since February of 2002. Siva started as a Software Design Engineer in Test (SDET) in the Analysis Services Performance Team and is currently an SDET Lead for Analysis Services 2005. Siva’s other interests include high performance computing, distributed systems and high speed networking. Siva is married to Shreepriya and had twins Praveen and Divya during the course of writing this book. His personal interests include travel, games/sports (in particular, Chess, Carrom, Racquet Ball, Board games) and Cooking. You can reach Siva at sivakumar.harinath@microsoft.com
内容简介
Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases
The authors then describe the development processes for building dimensions and cubes from various data sources
Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems
Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions
目录
Acknowledgments
Introduction
Part One: Introduction
Chapter 1: Introduction to Data Warehousing and Analysis Services 2005
Chapter 2: First Look at Analysis Services 2005
Chapter 3: Introduction to MDX
Chapter 4: Working with Data Sources and Data Source Views
Chapter 5: Dimension Design
Chapter 6: Cube Design
Part Two: Advanced Topics
Chapter 7: Advanced Topics in MDX
Chapter 8: Advanced Dimension Design
Chapter 9: Advanced Cube Design
Chapter 10: Extending MDX using External Functions
Part Three: Administration, Performance Tuning Integration
Chapter 11: Updating Your UDM Data
Chapter 12: Administering Analysis Services
Chapter 13: Performance Optimization
Chapter 14: Data Mining
Chapter 15: Analyzing Cubes using Office Client Components
Chapter 16: Integration Services
Part Four: Scenarios
Chapter 17: Reporting Services
Chapter 18: Designing Real-Time Cubes
Chapter 19: Securing Your Data in Analysis Services
Appendix: MDX Function and Operator Reference
Index