Chapter 15. SQL Server Data Mining Architecture
This chapter discusses the architecture of Analysis Services, particularly the data mining side of things. It covers the communication mechanisms used between the client and the server, the server components and how they are used, server configuration, and how different options impact memory and disk usage. This chapter is intended for those who will be administering a data mining server, or programming against it. If you are interested only in performing analysis with SQL Server Data Mining, you can skip this chapter.
In this chapter, you will learn about the following:
The Analysis Services architecture
Using XML for Analysis (XMLA)
How data mining processing works
Prediction architecture
Server administration
Data mining security
Examples, datasets, and projects for this chapter are included in Chapter15.zip
, which you can download from this book's website (www.wiley.com/go/data_mining_SQL_2008/
). The archive contains the following:
A SQL Server 2008 database backup containing the data set used in this chapter
A set of files containing the DMX and XMLA scripts for this chapter
An Analysis Services project
In order to try out the DMX and XMLA examples for this chapter, you must first build and deploy, from BI Development Studio, the included Analysis Services project.
Introducing Analysis Services Architecture
Analysis Services works in a simple client/server architecture, allowing clients to connect either through a LAN TCP/IP connection, or ...
Get Data Mining with Microsoft® SQL Server® 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.