Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Microsoft SQL Server 2005 Analysis Services (SQL Server Series)

Buy
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.


About the Author


Edward Melomed is one of the original members of the Microsoft SQL Server Analysis Services team. He arrived in Redmond as a part of Microsoft's acquisition of Panorama Software Systems, Inc., which led to the technology that gave rise to Analysis Services 2005. He works as a program manager and plays a major role in the infrastructure design for the Analysis Services engine.

 

Irina Gorbach is a senior software designer on the Analysis Services team, which she joined soon after its creation nine years ago. During her time at Microsoft, Irina has designed and developed many features, was responsible for client subsystems OLEDB and ADOMD.NET, and was in the original group of architects that designed the XML for Analysis specification. Recently she has been working on the architecture and design of calculation algorithms.

 

Alexander Berger was one of the first developers to work on OLAP systems at Panorama. After it was acquired by Microsoft, he led the development of Microsoft OLAP Server through all its major releases. He is one of the architects of OLEDB for the OLAP standard and MDX language, and holds more than 30 patents in the area of multidimensional databases.

 

Py Bateman is a technical writer at Microsoft. She originally hails from Texas, which was considered a separate country on the multinational Analysis Services team.

(HTML tags aren't allowed.)

Theories of Development: Concepts and Applications
Theories of Development: Concepts and Applications

The result of extensive scholarship and consultation with leading scholars, this classic text introduces students to twenty-four theorists and compares and contrasts their theories on how we develop as individuals. Emphasizing the theories that build upon the developmental tradition established by Rousseau, this text also covers theories in...

jQuery Reference Guide
jQuery Reference Guide
This detailed reference guide to jQuery, an open-source JavaScript library that shields web developers from browser inconsistencies, simplifies adding dynamic, interactive elements, and reduces development time, covers the syntax of every jQuery method, function, and selector with detailed discussions to help readers get the most from jQuery. After...
The Everyday Language of White Racism (Blackwell Studies in Discourse and Culture)
The Everyday Language of White Racism (Blackwell Studies in Discourse and Culture)
In The Everyday Language of White Racism, Jane H. Hill explores the myth that White racism is fading in the western world. Instead she reveals it to be a pervasive and highly adaptive cultural system, one that has endured in various forms for hundreds of years. Hill’s incisive analysis of everyday talk and text shows how language...

Professional Penetration Testing: Creating and Operating a Formal Hacking Lab
Professional Penetration Testing: Creating and Operating a Formal Hacking Lab

Save yourself some money! This complete classroom-in-a-book on penetration testing provides material that can cost upwards of $1,000 for a fraction of the price!

Thomas Wilhelm has delivered pen testing training to countless security professionals and now through the pages of this book you can benefit from his years of experience as a...

FBML Essentials
FBML Essentials
When it initially launched, the Internet transformed the way humans connected. Soon enough we had access to unlimited content at our fingertips. Within a matter of years, people were changing the way they communicated, and by the late 1990s, social networks were beginning to make their transformative impact. You could say a lot of things about the...
Buying a Home: The Missing Manual
Buying a Home: The Missing Manual

Home ownership is a cornerstone of the American dream, but it's a complex process that, without the right guidance, can seem like a nightmare. This Missing Manual takes you through the process of buying a home, from start to finish. Along the way, you'll use the book's expert advice and fill-in forms to identify the house...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy