Microsoft SQL Server 2005 Analysis Services

Nonfiction, Computers, Database Management
Cover of the book Microsoft SQL Server 2005 Analysis Services by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman ISBN: 9780768689990
Publisher: Pearson Education Publication: December 15, 2006
Imprint: Sams Publishing Language: English
Author: Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
ISBN: 9780768689990
Publisher: Pearson Education
Publication: December 15, 2006
Imprint: Sams Publishing
Language: English

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.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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.

More books from Pearson Education

Cover of the book Swift for Beginners by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book OpenGL ES 2.0 Programming Guide by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book Node.js for .NET Developers by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book Cross-Platform GUI Programming with wxWidgets by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book PHP for the Web by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book Manage passwords, with 1Password by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book Networking for Home and Small Businesses, CCNA Discovery Learning Guide by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book Level 1: The Missing Coins by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book Easy Office 2016 by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book Editing with Avid Media Composer 5 by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book Adobe Illustrator CC Classroom in a Book (2017 release) by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book CCNP Voice CVoice 642-437 Quick Reference by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book The Enthusiastic Employee by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book Network Security with Netflow and IPFIX by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Cover of the book Unreal Engine 4 for Design Visualization by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy