Now Australia's Biggest Toy Shop

Shop over 1.5 Million Toys in our Huge New Range

Microsoft SQL Server 2008 Analysis Services Unleashed
By

Rating
New or Used: $81.39
Hurry - Only 3 left in stock!
As the foundation of the Microsoft Business Intelligence Strategy, Microsoft SQL Server 2008 Analysis Services provides users with faster access to data and even more tools for managing and analyzing data across multidimensional objects (databases, dimensions, cubes). Microsoft SQL Server 2008 Analysis Services Unleashed is the ultimate guide for anyone who is planning to use the latest version of Analysis Services. It gives readers insight into the way Analysis Services functions, and explains practical methods for designing and creating multidimensional objects. It also provides valuable insight into the reasons behind the design decisions taken by the product development team. The authors have been involved with Analysis Services from its earliest days. They have documented in detail the internal features of Analysis Services 2008, explaining server architecture, main data structures, data processing, and query resolution algorithms. Discover the new functionality introduced in Analysis Services 2008 including MDX enhancements and new DMV (dynamic memory views) Work with the Business Intelligence Development Studio, the new Dimension Editor, and Aggregation Designer interfaces Enjoy complete coverage of new Shared Scalable Databases scale-out infrastructure Learn the key concepts of multidimensional modeling Explore the multidimensional object model and its definition language Integrate multidimensional and relational databases Build client applications to access data in Analysis Services Unravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithms Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts Gain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocol Discover how Analysis Services manages memory Explore the security model, including role-based security, code-access security, and data security Category: Microsoft SQL Server Covers: Microsoft SQL Server 2008 Analysis Services User Level: Intermediate-Advanced $59.99 USA / $65.99 CAN / GBP38.99 Net UK+/-
Product Details

Table of Contents

Introduction Part 1: Introduction to Analysis Services Chapter 1 OLAP and its role in Business Intelligence Chapter 2 The Multidimensional Data model Chapter 3 UDM: Linking Relational and Multidimensional Databases Chapter 4 Client/Server Architecture and Multidimensional Databases Part 2: Creating Multidimensional Models Chapter 5 The Conceptual Data Model Chapter 6 Dimensions in the Conceptual Model Chapter 7 Cubes and Multidimensional Analysis Chapter 8 Measures and Multidimensional Analysis Chapter 9 Multidimensional Models and the Business Intelligence Development Studio Part 3 Using MDX To Analyze Data Chapter 10 MDX Concepts Chapter 11 Advanced MDX Chapter 12 Cube-Based MDX Calculations Chapter 13 Dimension-Based MDX Calculations Chapter 14 Extending MDX with Stored Procedures Chapter 15 Block computations Chapter 16 Key Performance Indicators, Actions, and the DRILLTHROUGH Statement Chapter 17 Writing Data Into Analysis Services Part 4 Creating a Data Warehouse Chapter 18 Loading Data from a Relational Database Chapter 19 DSVs and Object Bindings Chapter 20 Multidimensional Models and Relational Database Schemas Part 5 Bringing Data into Analysis Services Chapter 21 The Physical Data Model Chapter 22 Dimension and partition processing Chapter 23 Using SQL Server Integration Services to Load Data Chapter 24 Aggregation Design and Usage-based Optimization Chapter 25 Proactive Caching and Real-time Updates Chapter 26 Building Scalable Analysis Services Applications. Part 6 Analysis Server Architecture Chapter 27 Server Architecture and Command Execution Chapter 28 Memory Management Chapter 29 Architecture of Query Execution[md]Calculating MDX Expressions Chapter 30 Architecture of Query Execution[md]Retrieving Data from Storage Part 7 Accessing Data in Analysis Services Chapter 31 Client/Server Architecture and Data Access Chapter 32 Client Components Shipped with Analysis Services Chapter 33 XML for Analysis Chapter 34 ADOMD.NET Chapter 35 Analysis Management Objects Part 8 Security Chapter 36 Security Model for Analysis Services Chapter 37 Object Security Model for Analysis Services Chapter 38 Securing Dimension Data Chapter 39 Securing Cell Values Part 9 Management Chapter 40 Using Trace to Monitor and Audit Analysis Services Chapter 41 Backup and Restore Operations Chapter 42 Deployment Strategies Chapter 43 Resource Management

About the Author

Irina Gorbach (Redmond, WA) spent nine years with the Microsoft Analysis Services Team. Now senior software designer, she has designed/developed features including OLEDB, ADOMD.NET, and the XML for Analysis specification. Edward Melomed (Redmond, WA), an original member of the SQL Server Analysis Services team, played a key role in designing programming interfaces for the newest version of Analysis Services. Alexander Berger (Redmond, WA) has led development of Microsoft OLAP Server through all major releases. A principal architect of the OLEDB for OLAP standard and MDX language, he holds 30+ patents in multidimensional database technology. All three live in the Seattle area.

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Microsoft SQL Server 2008 Analysis Services Unleashed on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond World Ltd.
Back to top