Export (0) Print
Expand All

Readme for SQL Server Plug-In Algorithms

SQL Server 2005

Updated: 17 July 2006

Microsoft SQL Server 2005 Analysis Services (SSAS) provides a complete framework that enables third-party data mining providers to integrate the following data mining objects into Analysis Services:

  • Data mining algorithms, known as plug-in algorithms.
  • Data mining viewers, known as plug-in viewers.
  • Data Mining Web Controls Library, a library that extends data mining viewers to the Web. For more information, see Data Mining Web Controls Library in SQL Server 2005 Books Online.

To help you understand how to implement data mining algorithms and viewers into Analysis Services, this readme provides instructions for the following samples:

Data Mining Algorithm Plug-In

This sample allows data mining algorithm developers to concentrate on the algorithm instead of on the implementation issues.

Data Mining Viewer Plug-In

This sample allows third-party algorithm providers to use their own viewers to display their new discovered patterns.

The documents and source code associated with each of these samples are located in the C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\SQL Server Data Mining Plug-In Algorithms folder. Included in this folder are tutorials that describe how to implement and use each of these samples.

ms160948.note(en-US,SQL.90).gifNote:
By default, the samples are not installed. To install samples, run Setup and use the Advanced option as described in the topic Running Setup to Install AdventureWorks Sample Databases and Samples in SQL Server 2005 Books Online.

An updated version of AdventureWorks database is also available for download on the Web page.

An updated version of the SQL Server 2005 Database Engine samples is also available for download on the Web page.

ms160948.note(en-US,SQL.90).gifNote:
SQL Server 2005 Business Intelligence Development Studio is not supported on computers that run the Itanium-based platform; the 64-bit development environment is supported on x64-based platforms. SQL Server 2005 samples can be modified and run on computers that run either x86 or x64-based platforms when databases used by the samples are deployed on an Itanium-based platform.

A provider wants to integrate a new data mining algorithm, which is named Pair-wise Linear Regression, into Analysis Services. After integrating this new algorithm into Analysis Services, the provider wants add a new viewer for the Pair-wise Linear Regression algorithm.

  • C++, for the algorithms.
  • C#, for the viewer.

Algorithm Plug-In

Interface Explanation

IDMAlgorithm

Implements both a model-producing learning algorithm and the prediction operations of the resulting model.

IDMAlgorithmNavigation

Enables browsers to access the content of your model.

IDMPersist

Enables the models learned by your algorithm to be saved and loaded by Analysis Services.

IDMAlgorithmMetadata

Describes the capabilities and input parameters of your learning algorithm.

IDMAlgorithmFactory

Creates instances of the objects that implement the algorithm interface and provides Analysis Services access to the algorithm metadata interface.

Viewer Plug-In

Interface Explanation

IMiningModelViewerControl

Implements the viewer.

Before you run this sample, you should have the following software is installed:

  • Microsoft SQL Server 2005, which includes the following components:
    • SQL Server 2005 Database Engine
    • Analysis Services
    • SQL Server Management Studio
    • Business Intelligence Development Studio
    • Two sample databases—AdventureWorksDW (data warehouse) and AdventureWorks (OLTP)
    • Analysis Services Samples
    • Adventure Works DW sample Analysis Services project, deployed to an instance of Analysis Services

  • An updated version of AdventureWorks database is also available for download on the SQL Server Developer Center Web page.
  • An updated version of the SQL Server 2005 Database Engine samples is also available for download on the SQL Server Developer Center Web page.

Before building the plug-in samples, you must deploy both the AdventureWorksDW (data warehouse) and AdventureWorks (OLTP) databases.

  1. In Windows Explorer, open C:\Program Files\Microsoft SQL Server\90\Tools\Samples, and then double-click the SQLServerSamples.msi file.

  2. In Windows Explorer, open C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project, open the folder corresponding to the version of SQL Server that has been installed, and then double-click the Adventure Works.sln file.

    The Adventure Works DW project opens in Business Intelligence Development Studio.

  3. Press F5 to build and deploy the project.

    ms160948.note(en-US,SQL.90).gifNote:
    Building and deploying the AdventureWorksAS project deploys the mining model to the server.

After you deploy the databases, you can implement the algorithm and viewer plug-ins.

  1. In Windows Explorer, open C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\SQL Server Data Mining Plug-In Algorithms, and then double-click the SQL Server Data Mining Plug-In Algorithms Tutorial.doc file.

    ms160948.note(en-US,SQL.90).gifNote:
    Implementing the plug-in sample might be easier for you if you print the tutorial and then use the printout to complete the tutorial.

  2. To build the Pair-wise Linear Regression Algorithm plug-in, complete Chapter 6, "Building a Shell Plug-In Algorithm" in the tutorial.

  3. To customize the Pair-wise Linear Regression Algorithm plug-in, complete Chapter 7, "Customizing the Algorithm: Pair-wise Linear Regression" in the tutorial.

  4. To use the customized Pair-wise Linear Regression Algorithm plug-in, complete Chapter 8, "Using the Customized Plug-In Algorithm" in the tutorial.

  1. In Windows Explorer, locate C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\SQL Server Data Mining Plug-In Algorithms, and then double-click the SQL Server Data Mining Plug-In Viewers Tutorial.doc file.

    ms160948.note(en-US,SQL.90).gifNote:
    Implementing the plug-in sample might be easier for you if you print the tutorial and then use the printout to complete the tutorial.

  2. Complete all steps in the tutorial.

To obtain a better understanding about how to implement plug-in algorithms, read the file, SQL Server Data Mining Plug-In Algorithms Whitepaper.doc, which is included with the sample tutorials.

Release History

17 July 2006

New content:
  • Added note on availability for Itanium-based platform.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft