|
|
|
File size |
|
|
Downloads |
0 |
|
Date |
Thu 12/06/2007 @ 12:54 |
|
|
|
|
Frequently asked questions about SQL Server 2000 Data Mining
|
|
|
|
|
|
| |
|
|
|
|
File size |
|
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:58 |
|
|
|
|
Access all of the SQL Server newsgroups here
|
|
http://www.microsoft.com/sql/community/newsgroups/default.mspx
|
|
|
| |
|
|
|
|
File size |
|
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:58 |
|
|
|
|
Ask SQL Server 2000 Data Mining Questions here
|
|
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.datamining
|
|
|
| |
|
|
|
|
File size |
52 K |
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:56 |
|
|
|
|
This download contains several examples of DMX statements for creating, training and querying SQL Server Data Mining models.
|
|
Each XML file in the download can be loaded into the DMSample query tool (available as a separate download) and contains the model creation, training and query statements. Note that these samples were originally written for SQL Server 2000 DM and therefore do not include SQL 2005 features.
|
|
|
| |
|
|
|
|
File size |
415 K |
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:57 |
|
|
|
|
This includes the executable and source code for DMSample, a simple graphical tool for sending DMX queries to Analysis Services and displaying hierarchical results.
|
|
Each XML file in the download can be loaded into the DMSample query tool (available as a separate download) and contains the model creation, training and query statements. Note that these samples were originally written for SQL Server 2000 DM and therefore do not include SQL 2005 features.
|
|
|
| |
|
|
|
|
File size |
|
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:55 |
|
|
|
|
This kit include three ActiveX controls developed by ANGOSS Software that are free for development and distribution. There is a decision tree viewer for visualizing a decision tree, a segment viewer for visualizing a cluster model and a lift chart for showing the accuracy of predictive models.
|
|
http://download.microsoft.com/download/8/b/7/8b70a093-55bc-4a96-86cf-c4a8159a9cda/oledbdmsdk.exe
|
|
|
| |
|
|
|
|
File size |
|
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:55 |
|
|
|
|
This book describes how to apply data mining to a real-world situation using SQL, Analysis Services and VB. It takes a real-world dataset and shows you how to: clean and prepare it for data mining; explore the data and build mining models; and compare them to choose the best fit for a given problem.
|
|
http://msdn.microsoft.com/library/default.asp?url=/servers/books/sqlserver/mining.asp
|
|
|
| |
|
|
|
|
File size |
|
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:55 |
|
|
|
|
MSDN takes the popular Duwamish Books bookstore sample and adds cross sell using Microsoft Decision Trees.
|
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnduwon/html/d52design.asp
|
|
|
| |
|
|
|
|
File size |
|
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:55 |
|
|
|
|
A closed-loop SQL Server 2000 Data Mining deployment done by Angry Koala and Microsoft Consulting Services
|
|
http://www.microsoft.com/resources/casestudies/CaseStudy.asp?CaseStudyID=14375
|
|
|
| |
|
|
|
|
File size |
272 K |
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:50 |
|
|
|
|
Data file used by SQL Server Data Mining samples
|
|
|
|
|
|
| |
|
|
|
|
File size |
|
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:54 |
|
|
|
|
An article by Gregory B. Meyer and Christine Mato in the January 2003 issue of SQL Server Magazine describing a geological application of data warehousing and data mining with SQL Server 2000.
|
|
http://www.windowsitpro.com/SQLServer/Article/ArticleID/27289/27289.html
|
|
|
| |
|
|
|
|
File size |
38 K |
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:54 |
|
|
|
|
Sample code for the point-of-sale MovieClerk VB.Net application that was demo'd at Microsoft's TechEd 2003 developer conference.
|
|
This app makes movie suggestions based on the purchase history of a customer and the current contents of their shopping cart. It uses a web service (written in C#) to query the mining model.
|
|
|
| |
|
|
|
|
File size |
126 K |
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:54 |
|
|
|
|
A 3-D viewer for models built using the Microsoft_Clustering algorithm in Analysis Services 2000. Source code is included.
|
|
The Cluster Viewer Add-In provides a 3-D view of the clusters in your model. The view of the clusters is created by arbitrarily laying out all the clusters' attribute-value pairs in a grid and assigning a height to those points by using the gain (alternatively the probability) for that a-v pair in the cluster. The luminosity of each point is determined by the probability (alternatively the gain) for the pair. You can change the layout by sorting the a-v pairs by their values within a cluster and thereby compare the surfaces generated by each cluster. Finally, the viewer can arrange clusters by relative distance to give you an idea of how close different clusters are.
The Cluster Viewer Add In works only with discrete variables. Also, while the Cluster Viewer works on models that have low dimensionality, you will receive better results with high-d models. The sample Customer Pattern Clusters model works well.
|
|
|
| |
|
|
|
|
File size |
34 K |
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:53 |
|
|
|
|
Use this Analysis Manager AddIn to easily edit the advanced parameters for SQL Server 2000 mining models. Source code is included.
|
|
The Data Mining Add In project contains an Analysis Manager AddIn for Analysis Services 2000 that allows you to easily edit the advanced parameters of mining models. To use the add-in:
- Shut down Analysis Manager.
- Register the DataMiningAddIns.dll and the DataMiningAddIn.reg files.
- Restart Analysis Manager.
- Right-click on a Mining Model and select "Advanced Model Properties".
- The model properties dialog will display showing all the appropriate parameters for the algorithm of the selected model.
- Clicking on a parameter will display the description for that parameter.
|
|
|
| |
|
|
|
|
File size |
27 K |
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:51 |
|
|
|
|
A sample XML for Analysis (1.1)web application for SQL Server Data Mining.
|
|
This SQL Server 2000 download for the XMLA SDK 1.1 includes
- the ThinMiner application,
- the XMLAHelper COM object helper DLL for reading XMLA flattened rowsets and
- a HOWTO document with installation instructions and troubleshooting tip
|
|
|
| |
|
|
|
|
File size |
329 K |
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:52 |
|
|
|
|
A collection of Excel Add-Ins that allow you to employ data mining techniques on your spreadsheet data.
|
|
This download includes the following SQL Server 2000 Data Mining Add-Ins for Excel:
- AutoFill
- Anomaly Detection
- Similarity Analysis
- Primary Indicator
Sample census data files are also included.
|
|
|
| |
|
|
|
|
File size |
3 K |
|
Downloads |
0 |
|
Date |
Tue 11/06/2007 @ 04:57 |
|
|
|
|
This download shows you how to use SQL Server Reporting Services to quickly disseminate the results of your data mining efforts.
|
|
This download includes an .rdl file and a readme that walks you through the process of designing a simple data mining report using SQL Server 2000 Reporting Services.
|
|
|
| |
|