Databases Reference
In-Depth Information
The database administrator is the primary user for the physical data model. We use XML-
based commands for manipulation of data on the physical layer.
Figure 1.1 shows relationships between three parts of multidimensional model.
Microsoft Office Excel 2007
Analysis Services
SQL Server Business Intelligence
Development Studio
Reporting Services
SQL Server Management Studio
Microsoft Office
Performance Point
2007
SQL Server Management Studio
Relational Database
FIGURE 1.1
Submodels of the multidimensional model.
You use SQL Server Business Intelligence Development Studio or SQL Server Management
Studio to define a conceptual data model, also known as a Unified Dimensional Model
(UDM) or cube. After the conceptual model is defined, you populate it with data by
loading/processing the data from the relational database. At this time, you define the
physical data model—partitioning scheme of the data, indexing scheme, and so on. The
application model of Analysis Services consists of standard data access interfaces. Client
applications use those interfaces: XML for Analysis and MDX to communicate with
Analysis Services. More than hundred applications available today support the application
model of Analysis Services and can work with any Analysis Services cubes.
Search WWH ::
Custom Search