What do you think?
Rate this book
Microsoft SQL Server 2005 Analysis Services
This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version. 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.
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.
865 pages, Kindle Edition
First published December 15, 2006
10 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
July 17, 2008
"riveting"...
..."a required romp!"
"this book will change the way business, education, and municipal planning will be done for the next two centuries"...
..."a life changing experience"
..."a required romp!"
"this book will change the way business, education, and municipal planning will be done for the next two centuries"...
..."a life changing experience"
Displaying 1 of 1 review