Microsoft SQL Server 2005

Data Mining Tutorial

        目     录
        Introduction
        Mining Model Algorithms
                Microsoft Decision Trees
                Microsoft Clustering
                Microsoft Naïve Bayes
                Microsoft Time Series
                Microsoft Association
                Microsoft Sequence Clustering
                Microsoft Neural Network
                Microsoft Linear Regression
                Microsoft Logistic Regression
        Working Through the Tutorial
                Preparing the SQL Server Database
                Preparing the Analysis Services Database
                        Creating an Analysis Services Project
                        Creating a Data Source
                        Creating a Data Source View
                        Editing the Data Source View
                Building and Working with the Mining Models
                        Targeted Mailing
                        Forecasting
                        Market Basket
                        Sequence Clustering

A Tutorial for Text Classification using SQL Server 2005 Beta2 Data Mining

        目     录
        Introduction
        Create a database
        Import News Group Articles to the database
        Build a dictionary
        Build term vectors
        Prepare train/test samples
        Build/Test/Refine data mining models
        Deployment data mining models

A Tutorial for Constructing a Plug-In Algorithm

        目     录
        Overview
        The Big Picture
        The Model: Pair-wise Linear Regression
        Important Supplied Files
        Important Preliminaries
        Building a Shell Plug-In Algorithm
                Step 1: Creating the project
                Step 2: Creating the ALGORITHM class
                Step 3: Creating the FACTORY class
                Step 4: Creating the NAVIGATOR class
                Step 5: Registering the algorithm with Analysis Services
                Step 6: Testing the shell algorithm
        Customizing the Algorithm: Pair-wise Linear Regression
                Step 1:  Customize IDMAlgorithmMetadata
                Step 2: Customize IDMAlgorithmFactory
                Step 3: Customize IDMAlgorithm
                Step 4: Customize IDMPersist
                Step 5: Customize IDMAlgorithmNavigation
        Using the Customized Plug-In Algorithm
                Building a Model
                Viewing a Model
                Making Predictions
                Setting Parameters

SQL Server Data Mining: Plug-In Algorithms

        目     录
        Overview
        Requirements
                Interfaces Implemented by Algorithm Providers
                        IDMAlgorithmFactory
                        IDMAlgorithmMetadata
                        IDMAlgorithm
                        IDMCaseProcessor
                        IDMAlgorithmNavigation : IDMDAGNavigation
                        IDMPullCaseSet
                        IDMPersist
                        IDMCaseIDIterator [optional]
                        IDMMarginalStat [optional]
                        IDMClusteringAlgorithm [optional]
                        IDMSequenceAlgorithm [optional]
                        IDMTimeSeriesAlgorithm [optional]
                        IDMCustomFunctionInfo [optional]
                        IDMDispatch [optional]
                        IDMTableResult [optional]
                Interfaces Consumed by Algorithm Providers
                        IDMPushCaseSet
                        IDMAttributeset
                        IDMAttributeGroup
                        IDMPersistenceWriter
                        IDMPersistenceReader
                        IDMServices
                        IDMContextServices
                        IDMModelServices
                        IDMMemoryAllocator
                        IDMStringHandler
                        IDMVariantPtrHandler
                        IDMContentMap
                Memory Management
                Access to Shared Data Types
                        DMString and DMVariantPtr
                DMContext Object
                        Service provider architecture
                Shared Definitions and Enumerations
                Algorithm Registration
                Algorithm Content Persistence
                Algorithm-Specific Modeling Flags
                Custom functions
                User-Updateable Algorithm Content
        Architecture
                Server Startup
                Mining Algorithm Information
                Mining Model Creation
                Mining Structure Processing
                Mining Model Training
                Mining Model Prediction
                Mining Model Browsing
                Mining Model Persistence
                Mining Model Drillthrough
                Mining Dimensions
                Sample Case Generation
                Importing and Generating PMML
                Error Handling

A Tutorial for Constructing a Plug-In Viewer

        目     录
        Overview
        Setting up the project
        Implementing IMiningModelViewerControl
        Assigning a Strong Name to the Assembly
        Mechanisms to discover Data Mining models
        Update the plug-in algorithm to use the plug-in viewer
        Adding UI code to the viewer