Home > Store > Databases > SQL Server
Microsoft SQL Server 2005 Analysis Services
- By Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
- Published Dec 15, 2006 by Sams. Part of the SQL Server Series series.
- Copyright 2007
- Dimensions: 7x9-1/8
- Pages: 864
- Edition: 1st
- Book
- ISBN-10: 0-672-32782-1
- ISBN-13: 978-0-672-32782-7
- eBook
- ISBN-10: 0-7686-6680-5
- ISBN-13: 978-0-7686-6680-9
Register your product to gain access to bonus material or receive a coupon.
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.

This book includes Instant Online Access with
and free shipping!
Instant Online Access with Safari Books Online
With your book purchase you are entitled to free, instant online access to that book on Safari Books Online for 45 days. After you've completed your purchase, you will receive instructions on how to log into Safari Books Online. If you do not want to receive online access to the book, simply uncheck the box for Instant Online Access in your cart.
This book includes Instant Online Access with
and free shipping!
Instant Online Access with Safari Books Online
With your book purchase you are entitled to free, instant online access to that book on Safari Books Online for 45 days. After you've completed your purchase, you will receive instructions on how to log into Safari Books Online. If you do not want to receive online access to the book, simply uncheck the box for Instant Online Access in your cart.

eBook
$47.99
$43.19
This PDF is DRM-free and requires the free Adobe® Reader® software. The PDF will be accessible from your Account page after purchase. Read our Non-DRM PDF FAQ.
- Save more by becoming a member.
- Request an Instructor or Media review copy.
- Corporate, Academic, and Employee Purchases
- International Buying Options
Online access to books, videos, and tutorials from Addison Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media and others - starting as low as $22.99. Learn more and start a free trial.


Account Sign In
View your cart