Microsoft SQL Server 2005 Analysis Services (SQL Server Series)


Publisher: Sams
Author: Array
ISBN: 0672327821
Release Date: 25 December 2006

eBook Description

Microsoft SQL Server Analysis Services provides fast access to data by means of multidimensional data structures and the multidimensional query languag MDX. Analysis Services provides the capability to design, create, and manage multidimensional cubes based on data warehouse tables, and it serves as the foundation for the Microsoft  Business Intelligence strategy.

 

Microsoft SQL Server 2005 Analysis Services gives the reader insight into the way Analysis Services functions. It not only explains ways to design and create multidimensional objects, databases, dimensions, and cubes, but also provides invaluable information about the reasons behind design decisions made by the development team. 

 

Here's what you will find inside:

  • Understand the key concepts of multidimensional modeling
  • Explore the multidimensional object model and its definition language
  • Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
  • Understand the mechanisms of integrating multidimensional and relational databases
  • Learn how to build client applications to access data in Analysis Services
  • Examine server architecture, including main data structures, data processing, and query resolution algorithms
  • Gain a deep understanding of the internal and external protocols for data transfer, including the XML/A protocol
  • Explore how Analysis Services manages memory
  • Explore the security model, including role-based security, code-access security, and data security
  • Discover how to monitor and manage Analysis Services

All the code for the sample database used in the book can be found at www.informit.com/title/0672327821.

Amazon.com

Microsoft SQL Server 2005 Analysis Services (SQL Server Series)

Related posts:

  1. MDX Solutions : with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase Publisher: John Wiley and SonsAuthor: Francesco CivardiISBN: 0471748080Release Date: 20...
  2. Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer) Publisher: Wrox PressAuthor: Stephen R. QuinnISBN: 0764579185Release Date: 30 May...
  3. Microsoft SQL Server(TM) 2005 Integration Services Step by Step Publisher: Microsoft PressAuthor: Hitachi ConsultingISBN: 0735624054Release Date: 20 June 2007...
  4. Microsoft SQL Server 2005 Reporting Services Publisher: SamsAuthor: Jim JosephISBN: 0672327996Release Date: 22 March 2006 eBook...
  5. Delivering Business Intelligence with Microsoft SQL Server 2005 Publisher: McGraw-Hill/OsborneAuthor: Brian LarsonISBN: 0072260904Release Date: 23 January 2006 eBook...
  6. Microsoft SQL Server 2005 Reporting Services For Dummies (For Dummies (Computer/Tech)) Publisher: For DummiesAuthor: Mark RobinsonISBN: 076458913XRelease Date: 19 December 2005...
  7. Designing Forms for Microsoft Office InfoPath and Forms Services 2007 (Microsoft .NET Development Series) Publisher: Addison-WesleyAuthor: Hagen GreenISBN: 0321410599Release Date: 05 February 2007 eBook...
  8. Microsoft SQL Server 2005 Notification Services Publisher: SamsAuthor: Shyam PatherISBN: 0672327791Release Date: 14 February 2006 eBook...
  9. Microsoft Access 2007 Data Analysis Publisher: John Wiley and SonsAuthor: Michael AlexanderISBN: 0470104856Release Date: 26...
  10. Microsoft SQL Server 2005 For Dummies Publisher: For DummiesAuthor: Andrew WattISBN: 0764577557Release Date: 06 February 2006...

Post a Comment | Trackback URI