March 2009
Intermediate to advanced
1051 pages
30h 33m
English
book
Professional Microsoft® SQL Server® Analysis Services 2008 with MDX
by Sivakumar Harinath, Matt Carroll, Sethu Meenakshisundaram, Robert Zare, Denny Guang-Yeu Lee
Content preview from Professional Microsoft® SQL Server® Analysis Services 2008 with MDX
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
15.2. Query Execution Architecture
Microsoft SQL Server Analysis Services 2008 consists of server and tools components that enable you to create databases and manage them. The server components are a set of binaries that comprise the Analysis Services service. BIDS, SQL Server Management Studio (SSMS), Profiler, and a few additional binaries constitute the tools components. The multidimensional databases are stored on the server, which is also referred to as the SSAS engine. SSAS clients communicate to the SSAS engine via XML for Analysis, a standardized application programming interface for online analytical processing (OLAP). The XMLA API has two main methods, Discover and Execute. Discover allows callers to request metadata and data from the databases. Execute lets callers send commands such as Create, Alter, and Process, which are used for creating/updating the multidimensional database or MultiDimensional Expressions (MDX) queries. MDX query results can be retrieved in multidimensional or tabular format by the client. The Create, Alter, Delete, and Process statements are part of the Data Definition Language (DDL). SSAS provides a set of object models that abstract XMLA and make it easy for developers to build applications that can communicate with the SSAS engine.
15.2.1. Analysis Services Engine Components
Figure 15-3 shows the Analysis Services query execution architecture. Five major components constitute the Analysis Services server: Infrastructure, Data Mining, Metadata ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.